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 (336,366,598,778,845,1081,1365,1408,1437,1538,2191,2359,2660,2873,2874,2875,2876,2877,2992,3003,3080,3128,3581,3762,3914,3944,3947,3951,3960,3964,3965,3968,4593,4633,4647,4672,4679,4710,4711,4718,4720,4722,4724,4726,4728,4810,4812,5167,6168,6683,6764,7013,7074,7090,7362,8087,8406,8606,8733,8801,8900,9104,9205,9238,9240,9243,9244,9245,9246,9249,9250,9251,9252,9253,9254,9255,9256,9257,9258,9259,9260,9261,9262,9263,9264,9265,9267,9268,9269,9270,9271,9272,9273,9274,9275,9276,9277,9278,9279,9280,9281,9282,9290,9677,9947,10108,10928,12586,13637,13762,14993,15334,15457,15565,15568,16200,16359,16942,17570,18130,18534,19137,19769,22248,22313,22360,22370,22661,23261,23302,23474,23475,23482,23483,23484,23486,23490,23494,23495,23529,23538,23542,23544,23545,23546,23548,23551,23552,23554,23555,23556,23559,23988,24348,24505,24513,24518,24581,24614,24636,24913,25375,26136,26139,26140,26145,26146,26153,26156,26160,26161,26455,26461,26462,26707,27177,28125,28872,28874,28877,28880,28883,28887,28891,28895,30454,32992,33434,34689,) and agatti_films.active=1