Panier |
Erreur SQL !
SELECT a.id, b.nom AS nom_marque, SUBSTR(a.modele, 1, 50) AS modele, a.prix_catalogue, f.url_photo, MIN( IF( (e.categorie_prix <= AND e.date_debut <= '2010-09-05' AND e.date_fin >= '2010-09-05'), (IF (e.prix > 0 AND e.prix < (a.prix_catalogue - a.prix_catalogue * e.pourcentage / 100), e.prix, (a.prix_catalogue - a.prix_catalogue * e.pourcentage / 100))), IF( = 2, a.prix_professionnel, IF( = 1, a.prix_musique_plus, a.prix_catalogue)))) AS prix_obtenu, IF( (e.categorie_prix <= AND e.date_debut <= '2010-09-05' AND e.date_fin >= '2010-09-05'), 1, 0) AS promotion_presente FROM tbl_article AS a INNER JOIN tbl_marque AS b ON (a.id_marque = b.id) INNER JOIN tbl_mn_article_sous_classe AS c ON (a.id = c.id_article) INNER JOIN tbl_sous_classe_detail AS d ON (c.id_sous_classe = d.id) INNER JOIN tbl_1n_article_photo AS f ON (a.id = f.id_article) LEFT JOIN tbl_promotion AS e ON (a.id = e.id_article OR e.id_sous_classe = c.id_sous_classe OR e.id_classe = d.id_classe) WHERE f.url_photo REGEXP '_1.jpg$' AND a.top_selection = 1 GROUP BY a.id LIMIT 40, 30
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 e.date_debut <= '2010-09-05' AND e.date_fin >= '2010-09-05'), (IF (e.prix > ' at line 1