Błąd zapytania.
Query:
SELECT DISTINCT tvshow.* , rating.rating, rating.votes FROM files JOIN episode USING (idFile) JOIN tvshow USING (idShow) LEFT JOIN rating ON tvshow.c04=rating_id WHERE idMovie IN (1822,3431,3452,4399,4618,7488,7518,8447,8730,8996,9166,9264,9639,9926,10083,10747,10781,13043,13217,13222,13288,13298,13344,13442,13500,13502,13512,13520,13562,13587,13589,13671,13809,13888,13899,13923,13951,13999,14015,14518,14531,14578,14647,14663,14671,14908,14928,15005,15006,15033,15053,15111,15127,15130,15413,15651,15871,15925,15961,15978,16001,16026,16058,16091,16121,16177,16309,16322,16394,16464,16513,16608,16611,16822,16920,17014,17025,17295,17300,17306,17308,17309,17374,17395,17437,17610,17654,17660,17709,17722,17752,17829,17856,17936,17996,18120,18128,18213,18239,18324,18369,18370,18445,18726,18727,18757,18787,18841) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'