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 (8228,8265,8532,9100,9101,11634,11635,11636,11655,12010,12011,12012,12449,12450,12752,12935,13012,13161,13173,13257,13259,13268,13298,13412,13429,13442,13465,13503,13509,13529,13530,13547,13599,13625,13646,13691,13731,13847,13853,13950,14028,14044,14053,14155,14160,14381,14477,14479,14534,14540,14663,14671,14821,14911,14922,14924,14930,14932,14933,14986,15005,15006,15056,15091,15206,15265,15266,15267,15280,15353,15360,15370,15446,15471,15564,15572,15598,15600,15610,15680,15688,15735,15748,15759,15761,15855,15906,15941,15975,15981,16012,16024,16059,16089,16090,16129,16172,16177,16181,16279,16391,16394,16414,16430,16574,16609,16650,16764,16788,16862,17067,17071,17210,17261,17287,17298,17312,17333,17347,17383,17431,17437,17448,17470,17504,17552,17582,17696,17697,17700,17713,17726,17729,17765,17893,17921,17989,18017,18039,18090,18120,18128,18314,18315,18356,18394,18445,18456,18651,18720,18735,18761,18818,18820,18877,18900,18905,18915,18918,18942,19022,19059,19065,19066,19144,19205,19241) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'