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 = 'Playa Negra 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.