SELECT SQL_CALC_FOUND_ROWS
r.nom AS nomRoom,
ro.code_url,
t.nom,
t.date,
tt.nom AS typetournoi,
lt.limite
FROM tournois t
INNER JOIN room r ON t.id_salle = r.id
INNER JOIN rooms_options ro ON t.id_salle = ro.id_room AND ro.LCID='1036' AND ro.visible='1' AND ro.rooms_fiches='1'
INNER JOIN rooms_liens rl ON rl.id_room=r.id AND rl.country_code3='FR' AND rl.etat='1' INNER JOIN rooms_pays rp ON rp.pays=rl.country_code3 AND rp.room=r.id AND rp.licence='1'
INNER JOIN rooms_fiches rf ON rf.id_room=r.id AND rf.LCID=ro.LCID AND rf.redirection='0' AND rf.etat='1'
LEFT JOIN limite_tournoi lt ON lt.id = t.limite
LEFT JOIN type_tournoi tt ON tt.id = t.typetournoi
WHERE t.date>=NOW() AND buyin+t.entryfee='0' AND id_salle IN() ORDER BY date ASC LIMIT 0,20
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 ') ORDER BY date ASC LIMIT 0,20' at line 15