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 (7439,7485,8951,9327,9478,9785,10017,10113,10417,10812,10901,11191,11443,11861,11906,12007,12371,12680,13044,13767,14426,14468,14748,14923,15155,15435,15609,15642,15855,15930,15935,15938,15950,16049,16050,16199,16251,16343,16355,16417,16500,16514,16639,16666,16843,16922,17121,17377,17727,17842,17880,17939,18069,18153,18267,18294,18358,18718,18831) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'