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 (1316,2036,9541,9542,9543,9544,9545,11467,12546,13089,13090,13091,13092,13201,13344,13464,13466,13559,13642,13667,13677,13838,13863,13864,13865,13896,13962,13978,14061,14148,14188,14540,14709,14857,14906,14966,14993,15091,15345,15417,15461,15538,15544,15700,15839,15840,15865,15867,15976,15977,16163,16250,16296,16470,16502,16632,16647,16650,16703,16788,16854,17048,17284,17485,17587,17637,17717,17736,17737,17789,17796,17945,17984,18077,18195,18394,18445,18525,18755,18765,18766,18807,18808,18821,18850) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'