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 'or agatti_films.genre2 = or agatti_films.genre3 = or agatti_films.genre4 = or ag' at line 4
select agatti_films.id, agatti_films.name, agatti_films.u_name as f_u_name, agatti_films.year, agatti_people.name as the_person, agatti_people.id as the_person_id, agatti_people.u_name as the_person_u_name from agatti_films, agatti_people where (agatti_films.genre1= or agatti_films.genre2 = or agatti_films.genre3 = or agatti_films.genre4 = or agatti_films.genre5 = or agatti_films.genre6 = or agatti_films.genre7 = or agatti_films.genre8 = or agatti_films.genre9 = or agatti_films.genre10= ) and agatti_people.id = agatti_films.co_director0 and agatti_films.active=1 group by agatti_films.id order by agatti_films.alpha_name asc limit 0, 25