我試圖顯示與許多表相關(guān)的表的結(jié)果，但我的問題是查詢只返回一個特殊的產(chǎn)品我想返回的產(chǎn)品既是特殊的產(chǎn)品，也是非特殊產(chǎn)品。我的 PHP 查詢是：$query = "SELECT DISTINCT p.product_id, p.price ,sp.date_end, f.percentage AS special_percentage , p.model, pd.name AS title, pd.description AS text, cd.name AS section, p.image, pd.tag, p.date_added AS created "                ."FROM #__mijoshop_product AS p "                ."JOIN #__mijoshop_product_special AS sp ON  p.product_id = sp.product_id "                ."JOIN #__mijoshop_flordeco_product_special_percentage AS f ON sp.product_id = f.product_id "                ."INNER JOIN #__mijoshop_product_description AS pd ON p.product_id = pd.product_id "                ."LEFT JOIN #__mijoshop_product_to_store AS ps ON p.product_id = ps.product_id "                ."LEFT JOIN #__mijoshop_product_to_category AS pc ON p.product_id = pc.product_id "                ."LEFT JOIN #__mijoshop_category_description AS cd ON (pc.category_id = cd.category_id AND cd.language_id = {$language_id}) "                ."LEFT JOIN #__mijoshop_category_to_store AS cs ON (pc.category_id = cs.category_id AND cs.store_id = {$store_id}) "                ."WHERE (LOWER(pd.name) LIKE '%" . $search_text . "%' OR                        LOWER(pd.description) LIKE '%" . $search_text . "%' OR                         LOWER(p.sku) LIKE '%" . $search_text . "%' OR ";                        if( $model ) {                            $query .= "LOWER(p.model) LIKE '%" . $search_text . "%' OR ";                        }                        $query .= "LOWER(pd.tag) LIKE '%" . $search_text . "%') "                ."AND p.status = '1' "                ."AND date(sp.date_end) >= date(NOW()) "                ."AND p.date_available <= NOW() "                ."AND ps.store_id = {$store_id} "                ."AND pd.language_id = '" . $language_id . "' "                ."GROUP BY p.product_id "                ."ORDER BY {$order_by} "                ."LIMIT ".$limit;        $db->setQuery($query);        $results = $db->loadObjectList();