SELECT IFNULL(id_product_pack,1) as pack,IF(p.qty_brie>0,1,0) as enstock, p.`id_product`
FROM `ps_product` p
LEFT JOIN `ps_manufacturer` as m ON (m.`id_manufacturer`= p.`id_manufacturer`)
LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = p.`id_product`)
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE ( ctg.`id_group` = 1)
AND m.`id_manufacturer` = 68
GROUP BY p.`id_product`
