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 '-25, 25' at line 9
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=22 or agatti_films.genre2 =22 or agatti_films.genre3 =22 or agatti_films.genre4 =22 or agatti_films.genre5 =22 or agatti_films.genre6 =22 or agatti_films.genre7 =22 or agatti_films.genre8 =22 or agatti_films.genre9 =22 or agatti_films.genre10= 22) 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 -25, 25