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 (2647,12887,12977,13578,13664,13715,13979,14051,14399,14401,14402,14949,15036,15293,15294,15499,15525,15599,15619,15626,15628,15646,15738,15814,15827,15979,16037,16073,16087,16097,16099,16349,16357,16388,17009,17294,17310,17314,17330,17388,17545,17601,17670,17677,17683,17827,17965,17967,18080,18107,18130,18131,18197,18275,18337,18460,18516,18517,18525,18526,18551,18576,18618,18619,18620,18621,18673,18692,18703,18709,18746,18811,18814,18863,18880) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'