volg equivox op


erreur select : SELECT annonce.titre as letitre, annonce.p_annonce, categories.titreNL AS cat, categories.parent_id, annonce.prix, regions.titreNL AS region, pays.titreNL AS pays, annonce.optTop, annonce.optVid FROM annonce left Join categories ON categories.p_categories = annonce.f_categories left Join regions ON regions.p_regions = annonce.f_regions left Join pays ON pays.p_pays = annonce.f_pays where annonce.f_categories = 25 and dtvalid >= now() and deleted = 0 order by (select count(*) p_photos from photos where photos.f_annonce = annonce.p_annonce) desc limit -10,10
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 '-10,10' at line 14