Witam,
Chciałbym wypisać produkty z bazy danych. Po 2 z każdej kategorii
Tak wygląda zapytanie :
$resultt = Db::GetInstance()->executeS("SELECT DISTINCT a.`id_product`, cl.`id_category`, b.`name` AS `name`, `reference`,`available_now`, a.`price` AS `price`, sa.`active` AS `active`, image_shop.`id_image` AS `id_image`, cl.`name` AS `name_category`,sav.`quantity` AS `sav_quantity`, sp.`reduction`
FROM `". _DB_PREFIX_ ."product` a LEFT JOIN `". _DB_PREFIX_ ."product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
LEFT JOIN `". _DB_PREFIX_ ."stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 )
JOIN `". _DB_PREFIX_ ."product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
LEFT JOIN `". _DB_PREFIX_ ."category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
LEFT JOIN `". _DB_PREFIX_ ."category` ca ON (cl.`id_category` = ca.`id_category`)
LEFT JOIN `". _DB_PREFIX_ ."image_shop` image_shop ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
LEFT JOIN `". _DB_PREFIX_ ."image` i ON (i.`id_image` = image_shop.`id_image`)
LEFT JOIN `". _DB_PREFIX_ ."feature_product` fp ON (fp.`id_product` = a.`id_product`)
LEFT JOIN `". _DB_PREFIX_ ."feature_value_lang` fvl ON (fvl.`id_feature_value` = fp.`id_feature_value`)
LEFT JOIN `". _DB_PREFIX_ ."specific_price` sp ON (sp.`id_product` = a.`id_product`)
LEFT JOIN `". _DB_PREFIX_ ."product_sale` ps ON (ps.`id_product` = a.`id_product`)
WHERE 2 AND sa.`active` = 1 AND ca.`id_parent` = '". $categoriaadjust ."' AND b.`name` NOT LIKE '". $nazwa_produktu ."%' AND cl.`id_category` NOT LIKE '". $product->id_category_default ."' AND sav.`quantity` > 0
ORDER BY cl.`id_category` ASC LIMIT 15");
Czy jest możliwość pogrupowania po id_category żeby pokazało po 2 produkty z jednej kategorii a nie jak teraz że wyświetlają się wszystkie.
Z góry dzięki za pomoc.