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 (8509,11620,13814,14228,14231,14482,14483,14784,14944,15028,15048,15128,15495,15536,15734,16044,16073,16088,16444,16951,17449,17535,17925,17950,18242,18308,18311,18363,18374,18460,18498,18639,18701,18710,18999,19150,19232,19278,19291) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'