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 '-5, 5' at line 23
Impossible d'effectuer la requĂȘte SELECT p.*, pc.*, fc.lib_foyer, fc.desc_foyer, f.pvht AS pvht_foyer, f.pvht_solde AS pvht_solde_foyer, f.pvht_promo AS pvht_promo_foyer, p.pvht_foyer_bon_aff, f.actif AS actif_foyer, f.ref_foyer, (IF(p.pvht_solde IS NOT NULL, p.pvht_solde, ( IF(p.pvht_promo IS NOT NULL, p.pvht_promo, ( p.pvht )) )) + IF(p.id_foyer_base IS NULL, 0, (IF(f.pvht_solde IS NOT NULL, f.pvht_solde, ( IF(f.pvht_promo IS NOT NULL, f.pvht_promo, ( f.pvht )) ))) )) AS prix_base FROM produit p INNER JOIN produit_content pc ON pc.id_produit = p.id_produit LEFT JOIN foyer f ON f.id_foyer = p.id_foyer_base LEFT JOIN foyer_content fc ON fc.id_foyer=f.id_foyer AND fc.id_langue='1' WHERE p.actif = '1' AND p.is_produit_associe IS NULL AND p.id_concession IS NULL AND p.id_asso_gamme_style = '1|3' AND pc.id_langue = '1' ORDER BY p.tri ASC LIMIT -5, 5