SELECT a.`mitem_id` FROM ps_jmsmegamenu AS a INNER JOIN ps_jmsmegamenu_lang AS b ON a.`mitem_id` = b.`mitem_id` WHERE a.`active` = 1 AND `parent_id` = 0 AND (a.`id_shop` = 1) AND a.mitem_id != 95 AND b.`id_lang` = 2 ORDER BY a.`ordering`