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 '-9,9' at line 6 : SELECT p.*, pf.file, pf.title_fr AS img_title, urls.url_fr, urls.title_link_fr FROM products as p JOIN urls ON urls.id_type = p.id JOIN products_files AS pf ON p.id = pf.id_product WHERE p.status=1 AND urls.type=6 AND pf.ordre=1 AND p.status_bien IN (0, 2, 3) AND p.localite_fr = 'Junquillal et environs' GROUP BY pf.id_product ORDER BY if (p.price=0,1,0),p.price ASC LIMIT -9,9

Recherche

Aucun bien ne correspond à ce jour aux critères demandés. Nous vous invitons à élargir votre recherche ou à nous contacter.