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 (1278,3035,3497,6178,8403,8408,8910,9095,9198,9771,9784,10633,10754,11255,11550,11609,11972,12546,12902,12903,12919,12982,12998,13637,13735,14036,14420,14485,14728,14747,14822,15249,15334,15541,15604,15839,15840,15952,16037,16055,16122,16294,16338,16385,16625,16735,16906,17026,17126,17127,17253,17266,17330,17433,17434,17496,17529,17587,17823,17886,17904,18077,18493,18928,19002,19022,19080,19184,19185,19186,19187,19188,19204) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'