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 (14,19,27,41,43,68,141,241,250,295,409,528,553,599,665,680,849,868,1077,1085,1090,1172,1184,1187,1188,1413,1430,1484,1524,1613,1643,1927,1976,2087,2260,2368,2399,2412,2745,2863,2879,2934,2970,2977,2978,2984,3141,3147,3165,3282,3298,3389,3419,3426,3473,3502,3636,3758,3775,3780,3788,4028,4162,4275,4345,4409,4485,4488,4522,4572,4602,4764,4778,4832,4841,4848,5202,5221,5268,5348,5660,5772,5786,5787,6293,6356,6378,6389,6540,6650,7018,7043,7057,7367,7635,7641,7706,7756,7856,7906,7937,7966,7967,8033,8110,8207,8211,8358,8380,8434,8437,8616,8935,8958,8964,8969,8986,9085,9153,9466,9538,9640,10297,10569,10601,10919,10925,10926,11038,11072,11500,11761,11778,11944,11951,12015,12104,12237,12536,12543,13482,13792,13808,13992,14060,14242,14385,14436,14488,14564,14601,14809,15003,15108,15121,15173,15377,15755,16037,16068,16105,16112,16170,16199,16224,16437,16936,17091,17134,17135,17393,17557,17558,17568,17571,18090,18094,18301,18654,18954,18957,18968,19090,19165,19357,19399,19464,19465,19845,21867,21879,22041,22052,22161,22197,) and agatti_films.active=1