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 (1214,1363,1415,1846,9270,10076,10914,12248,12262,12263,12451,12489,13319,13414,13448,13450,13451,13452,13454,13455,13457,13460,13461,13466,13467,13468,13469,13470,13472,13642,13678,13679,13680,13896,13936,13946,14151,14780,14895,14907,14925,14935,14993,15145,15261,15268,15269,15270,15271,15276,15297,15304,15417,15462,15463,15465,15467,15470,15603,15668,15813,15865,16377,16380,16434,16703,16795,16799,17466,17473,18087,18122,18268,18312,18322,18329,18348,18686,18850,19054,19126,19148,19316,19414,19521) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'