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 ') and agatti_films.active=1' at line 1
select agatti_films.genre1,agatti_films.genre2,agatti_films.genre3,agatti_films.genre4,agatti_films.genre5,agatti_films.genre6,agatti_films.genre7,agatti_films.genre8,agatti_films.genre9,agatti_films.genre10 from agatti_films where id in (40,41,47,57,114,242,266,268,367,369,406,445,455,475,544,576,599,604,761,766,856,1057,1080,1081,1214,1365,1505,1519,1538,1641,2035,2214,2551,2612,2855,3015,3039,3118,3165,3391,3434,3501,3502,3650,3976,4033,4054,4082,4195,4262,4314,4354,4401,4420,4558,4831,5094,5095,5177,5236,5243,5323,5499,5596,5635,5660,5821,5912,6175,6388,6531,6541,6614,6615,6622,6847,6882,6975,7059,7634,7697,7907,7966,8052,8114,8124,8140,8184,8559,8750,8983,9105,9150,9165,9317,9987,9998,10242,10293,10345,10561,10586,10712,10948,11043,11072,11076,11297,11356,11367,12016,12104,12236,12843,12844,12858,13172,13449,13455,13623,14614,14648,14862,15001,15210,15546,15931,15939,16077,16403,16622,16817,16948,16952,16956,17022,17097,17474,17559,17722,18395,19141,19144,19165,19294,19619,19620,19631,21837,21904,21911,21939,22019,22043,22058,22310,22314,22315,22357,22382,22403,22405,22429,22477,22534,22632,22708,22734,22774,22991,23091,23123,23378,23470,23498,23523,23635,23638,23904,23934,23982,23988,24316,24408,24505,24513,24579,24592,24593,24601,24603,) and agatti_films.active=1