select serie :You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') and s.id != '542' group by s.id order by nbtag Desc' at line 26 [select s.id as sid, s.nom as snom, s.type as stype, s.avis as savis, s.nomvo as snomvo, s.notevisiteur as snotevisiteur, s.annee_sortie as sannee_sortie, s.oneshot as soneshot, f.note as fnote, MAX(c.note) as cnote, count(distinct sg.id_genre) as nbtag, e.id as eid, e.nom as enom from serie s left outer join fiche f on s.id_fiche = f.id left outer join critique c on c.id_serie = s.id join editeur e on s.id_editeur = e.id join serie_genre sg on sg.id_serie = s.id where s.type IN ('manga','manhwa','autre') and id_genre IN ) and s.id != '542' group by s.id order by nbtag Desc]