SELECT DISTINCT(clubs.id), clubs.nom, clubs.departement, ville FROM clubs LEFT JOIN clubs_sports ON clubs.id = clubs_sports.id_clubs WHERE clubs_sports.id_sports IN () AND CONCAT(clubs.type,clubs.departement) = 'ufolep11' ORDER BY RAND() LIMIT 5 : You have an error in your SQL syntax near ') AND CONCAT(clubs.type,clubs.departement) = 'ufolep11' ORDER BY RAND() ' at line 3