Erreur générée dans le fichier /home/sites/preprod.thalgo.fr/website/framework/lib/framework/modules/fwDatabase/fwDatabase_Query.class.php, ligne 144 :
fwDatabase_QuerySelect
ERREUR SQL : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND m.menuitems_bd >= AND ISNULL(m.parents_id) AND m.menus_id = "" AND m.menuite' at line 1
QUERY : SELECT m.menuitems_id AS m__menuitems_id, m.menus_id AS m__menus_id, m.menuitems_active AS m__menuitems_active, m.menuitems_public AS m__menuitems_public, m.menuitems_profil AS m__menuitems_profil, m.agences_id AS m__agences_id, m.permaliens_id AS m__permaliens_id, m.menuitems_gabarit AS m__menuitems_gabarit, m.jeuxattributs_id AS m__jeuxattributs_id, m.menuitems_cle AS m__menuitems_cle, m.menuitems_code AS m__menuitems_code, m.menuitems_externe_code AS m__menuitems_externe_code, m.menuitems_catalogue AS m__menuitems_catalogue, m.menuitems_bg AS m__menuitems_bg, m.menuitems_bd AS m__menuitems_bd, m.menuitems_niveau AS m__menuitems_niveau, m.parents_id AS m__parents_id, m.menuitems_couleurmenu AS m__menuitems_couleurmenu, m.menuitems_couleurpage AS m__menuitems_couleurpage, m.menuitems_visible AS m__menuitems_visible, m.menuitems_cliquable AS m__menuitems_cliquable, m.menuitems_format AS m__menuitems_format, m.menuitems_ancre AS m__menuitems_ancre, m.menuitems_cadeau AS m__menuitems_cadeau, m.menuitems_datedebut AS m__menuitems_datedebut, m.menuitems_datefin AS m__menuitems_datefin, m.menuitems_nbjours AS m__menuitems_nbjours, m.menuitems_nbmois AS m__menuitems_nbmois, t.menuitems_id AS t__menuitems_id, t.lang AS t__lang, t.meta_title AS t__meta_title, t.meta_description AS t__meta_description, t.meta_keywords AS t__meta_keywords, t.alt_bandeau AS t__alt_bandeau, t.alt_image AS t__alt_image, t.menuitems_libellemenu AS t__menuitems_libellemenu, t.menuitems_libellepage AS t__menuitems_libellepage, t.menuitems_bandeau AS t__menuitems_bandeau, t.menuitems_image AS t__menuitems_image, t.menuitems_accroche AS t__menuitems_accroche, t.menuitems_complement1 AS t__menuitems_complement1, t.menuitems_complement2 AS t__menuitems_complement2, t.menuitems_complement3 AS t__menuitems_complement3, t.menuitems_footer AS t__menuitems_footer, t.menuitems_lien AS t__menuitems_lien, t.menuitems_target AS t__menuitems_target, pl.permaliens_id AS pl__permaliens_id, pl.permaliens_active AS pl__permaliens_active, pl.permaliens_type AS pl__permaliens_type, pl.permaliens_301 AS pl__permaliens_301, plt.permaliens_id AS plt__permaliens_id, plt.lang AS plt__lang, plt.permaliens_lien AS plt__permaliens_lien, me.menus_id AS me__menus_id, me.menus_active AS me__menus_active, me.menus_code AS me__menus_code, me.menus_accueil AS me__menus_accueil, me.menus_ordre AS me__menus_ordre, met.menus_id AS met__menus_id, met.lang AS met__lang, met.menus_libelle AS met__menus_libelle, diff.domaines_id AS diff__domaines_id, diff.instances_id AS diff__instances_id, diff.instances_type AS diff__instances_type, diff.domaines_diffusion_active AS diff__domaines_diffusion_active, t.menuitems_libellemenu AS menuitems_instance FROM menuitems m LEFT JOIN menuitems_translation t ON m.menuitems_id = t.menuitems_id LEFT JOIN permaliens pl ON m.permaliens_id = pl.permaliens_id LEFT JOIN permaliens_translation plt ON pl.permaliens_id = plt.permaliens_id LEFT JOIN menus me ON m.menus_id = me.menus_id LEFT JOIN menus_translation met ON me.menus_id = met.menus_id LEFT JOIN domaines_diffusion diff ON me.menus_id = diff.instances_id AND diff.instances_type = "menus" WHERE m.menuitems_bg <= AND m.menuitems_bd >= AND ISNULL(m.parents_id) AND m.menus_id = "" AND m.menuitems_active = "Y" AND diff.domaines_id = 5 AND diff.domaines_diffusion_active = "Y" AND IF( m.menuitems_gabarit = "produits-index" , ( SELECT COUNT(*) FROM produits pc LEFT JOIN produits_prix ppc ON pc.produits_id = ppc.produits_id LEFT JOIN domaines_diffusion ddc ON ppc.produits_prix_id = ddc.instances_id AND ddc.instances_type = "produits_prix" LEFT JOIN menuitems_attachs mac ON pc.produits_id = mac.instances_id AND mac.instances_type = "produits" LEFT JOIN menuitems mic ON mac.menuitems_id = mic.menuitems_id LEFT JOIN menus mc ON mic.menus_id = mc.menus_id WHERE ddc.domaines_id = 5 AND mac.domaines_id = 5 AND mic.menuitems_bg >= m.menuitems_bg AND mic.menuitems_bd <= m.menuitems_bd AND mic.menuitems_active = "Y" AND mic.menus_id = m.menus_id AND pc.produits_type IN ("simple", "multiple") AND pc.produits_active = "Y" AND ppc.produits_prix_public = "Y" AND ddc.domaines_diffusion_active = "Y" ) , 1 ) > 0 AND t.lang = "nz" AND plt.lang = "nz" AND met.lang = "nz" AND (FIND_IN_SET("public", m.menuitems_catalogue) OR ISNULL(m.menuitems_catalogue) OR m.menuitems_catalogue = "0") ORDER BY m.menus_id ASC, m.menuitems_bg ASC