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 (9,12,19,38,40,87,180,248,261,265,280,282,301,305,336,340,343,352,416,454,475,594,707,772,779,787,789,1076,1090,1141,1169,1177,1216,1451,1476,1477,1480,1492,1496,1501,1518,1641,1743,1964,1972,2174,2217,2263,2316,2369,2389,2547,2674,2839,2922,2965,2985,3013,3159,3165,3166,3273,3287,3764,3772,3975,4071,4207,4211,4343,4377,4427,4436,4562,4599,4638,4832,4860,5081,5255,5264,5485,5551,5597,6013,6014,6079,6163,6310,6379,6508,6647,6765,6816,6934,7006,7043,7074,7081,7404,7627,7688,7690,7858,7907,7956,7961,8041,8052,8188,8205,8363,8379,8437,8559,8598,8614,8633,8728,9002,9150,9165,9200,9203,9317,9463,9668,9671,9990,9999,10001,10111,10269,10923,10946,11036,11103,11398,11405,11761,11978,12016,12571,12858,12932,13313,13623,13726,13744,14146,14371,14808,14811,14995,14998,15002,15073,15767,15926,16229,16349,17016,17029,17031,17032,17095,17209,17570,17584,19136,19149,19389,19399,19400,19428,20527,20606,21765,21803,21875,21878,22315,22492,22556,22659,22679,22732,22906,23113,23260,23346,23520,23595,23929,23959,23969,24044,24347,) and agatti_films.active=1