An Error Was Encountered

Error Number: 1064

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 'on AND medias.dispo = '+' AND medias_descriptions.nom LIKE '%%' ORDER BY gale' at line 1

SELECT * FROM medias LEFT JOIN galeries ON galeries.id_galerie = medias.galerie LEFT JOIN medias_descriptions ON medias_descriptions.media = id_media WHERE galeries.etat = 'on' AND medias.etat = 'on' AND medias_descriptions.langue = 1 AND medias.categorie = on AND medias.dispo = '+' AND medias_descriptions.nom LIKE '%%' ORDER BY galeries.position,medias.position LIMIT 0,100000