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