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 (1411,3618,7845,7912,9388,9405,9840,10094,10231,10408,10434,10443,10556,10564,10816,10939,11121,11153,11171,11198,11199,11447,11715,11839,11840,11967,11973,12218,12245,12894,13117,13137,13269,13292,13409,13479,13574,13590,13648,13693,13734,13752,13766,13779,13902,13969,14280,14377,14547,14634,14692,14702,14704,14918,14945,15108,15206,15441,15665,15677,15688,15757,15763,15793,15873,15912,15935,16043,16070,16092,16102,16117,16628,16716,16923,16933,17074,17098,17237,17292,17325,17413,17581,17626,17705,17894,17990,18007,18018,18079,18101,18102,18103,18205,18274,18377,18396,18551,18587,18625,18680,18703,18708,18713,18818,18865,18880) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'