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 (1275,1386,1786,1788,1826,2617,3457,4625,8913,8935,9456,9943,10126,10232,10633,10711,10857,11089,12343,13015,13087,13239,13274,13281,13282,13502,13578,13589,13625,13650,13671,13749,13776,13923,14164,14170,14399,14401,14402,14439,14578,14604,14908,14947,14973,14981,14988,15005,15006,15130,15302,15444,15665,15683,15812,15871,15925,15938,15941,15967,15978,15982,15983,15986,15999,16001,16024,16058,16082,16091,16281,16306,16322,16394,16464,16479,16920,17012,17025,17047,17078,17125,17287,17295,17308,17309,17315,17374,17461,17490,17542,17610,17694,17709,17714,17968,17996,18137,18233,18290,18353,18364,18611,18787,18841,18843,18878,19037,19091) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'