SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM psnsg_product p LEFT JOIN psnsg_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN psnsg_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN psnsg_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 2  AND sa.id_shop_group = 0 ) LEFT JOIN psnsg_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN psnsg_category_product cp ON (p.id_product = cp.id_product) INNER JOIN psnsg_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 2 AND ps.active = TRUE) INNER JOIN psnsg_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN psnsg_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='2' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=871 AND c.nright<=872 GROUP BY p.id_product