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 (1386,1387,1763,1818,7476,8280,10914,11591,11596,13130,13199,13272,13285,13288,13355,13528,13590,13803,13903,13936,13969,14002,14673,14817,14931,14973,14990,15041,15113,15308,15511,15544,15559,15625,15668,15982,16051,16058,16088,16233,16399,16500,16513,16566,16617,16632,16633,16634,16639,16768,17088,17181,17295,17309,17367,17393,17478,17501,17592,17628,17633,17682,17758,17765,17822,17901,17971,18077,18280,18290,18348,18376,18476,18485,18710,18995,19043,19087,19185) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'