SELECT hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`, hss.`position`, hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`, hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access` FROM horl5_iqitmegamenu_tabs_shop hs LEFT JOIN horl5_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab) LEFT JOIN horl5_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab) WHERE id_shop = 1 AND menu_type = 1 AND active = 1 AND hssl.id_lang = 4 ORDER BY hss.positionSELECT hs.`id_tab` as id_tab, hssl.`title`, hssl.`label`, hssl.`url`, hss.`position`, hss.`active_label`, hss.`url_type`, hss.`id_url`, hss.`icon_type`, hss.`icon_class`, hss.`icon`, hss.`legend_icon`, hss.`new_window`, hss.`float`, hss.`submenu_type`, hss.`submenu_content`, hss.`submenu_width`, hss.`group_access` FROM horl5_iqitmegamenu_tabs_shop hs LEFT JOIN horl5_iqitmegamenu_tabs hss ON (hs.id_tab = hss.id_tab) LEFT JOIN horl5_iqitmegamenu_tabs_lang hssl ON (hss.id_tab = hssl.id_tab) WHERE id_shop = 1 AND menu_type = 2 AND active = 1 AND hssl.id_lang = 4 ORDER BY hss.position