Echec : 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 (description_critere_produit = 1)) AND id_secteur IN (1, 2, 10, 17, 22, 30,' at line 4
SELECT SQL_CALC_FOUND_ROWS table_produit.*, table_type_bien.nom_type_bien FROM table_produit INNER JOIN table_type_bien ON table_produit.id_type_bien = table_type_bien.id_type_bien WHERE actif_produit='1' AND prix_vente_produit > 0 AND table_produit.id_type_bien=2 AND id_produit IN ( SELECT id_produit FROM lien_critere_produit WHERE id_critere= AND (description_critere_produit = 1)) AND id_secteur IN (1, 2, 10, 17, 22, 30, 2, 10, 17, 22, 30, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13, 14, 15, 16, 18, 19, 20, 21, 23, 24, 25, 26, 27, 28, 29, 31, 32, 33, 34, 35, 36, 37) AND id_type_produit=1 ORDER BY CASE WHEN id_agence=2 THEN 0 ELSE 1 END LIMIT 0, 6