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 (1185,1293,1307,1798,3367,6422,7422,7850,7913,7914,8235,8655,8714,8715,8716,8717,8756,8844,8976,9592,9794,10196,10212,10239,10315,10589,10590,10634,10651,10686,11165,11400,11494,11505,11509,11588,11603,11620,11861,11963,11973,12021,12503,12774,13021,13135,13308,13498,13761,13813,13986,13999,14143,14344,14729,14994,14997,15248,15398,15403,15435,15515,15571,15664,15997,16018,16086,16177,16249,16309,16343,16517,16538,16573,16601,16913,16914,16941,16942,16943,16944,16989,16992,17039,17169,17276,17336,17588,17631,17716,17800,17870,17950,18069,18097,18304,18521,18589,18673,18721,18829) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'