SELECT c.*, cl.*, IFNULL(ufm.id_product, 0) as id_product, IFNULL(ufm.position, 0) as position, gr.value as generic_discount, IFNULL(ufm.display, 0) as display, IFNULL(ufm.first, 0) as first FROM `ps_category` c LEFT JOIN `ps_uebix_frontmanager` ufm ON c.`id_category` = ufm.`id_category` AND ufm.id_shop = 1 AND ufm.`id_section` = 2 INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) INNER JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 AND cl.`id_lang` = 1 AND ufm.`display` = 1 AND c.`id_category` IN (SELECT `id_category` FROM `ps_category_product` cp WHERE cp.`id_product` IN (SELECT `id_product` FROM `ps_category_product` cp2 WHERE cp2.`id_category` = 461)) AND ( c.`id_parent` = 2 OR c.`id_parent` = 531 ) LEFT JOIN ( SELECT * from `ps_gemulator_reductions` grfilter WHERE grfilter.`type` = 3 AND grfilter.`id` = ( SELECT ggr.`id` FROM `ps_gemulator_reductions` ggr WHERE ggr.`type` = 3 AND ggr.`id_category` = grfilter.`id_category` AND ( ( ggr.`begin` < now() ) OR ( ggr.`begin` = '0000-00-00 00:00:00' ) ) AND ( ( ggr.`end` > now() ) OR ( ggr.`end` = '0000-00-00 00:00:00' ) ) ORDER BY ggr.id DESC LIMIT 1 ) ) `gr` ON gr.`id_category` = ufm.`id_category` WHERE (SELECT SUM( quantity ) AS tot FROM `ps_stock_available` sa, `ps_category_product` cp WHERE sa.id_product = cp.id_product AND cp.id_category = ufm.`id_category`) > 0 ORDER BY c.`id_category` DESC
Categorie