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 (4188,6798,12877,12998,13128,13136,13339,13393,13434,13448,13452,13454,13457,13466,13470,13472,13478,13592,13678,13896,13921,13936,14013,14078,14380,14407,14513,14514,14523,14534,14535,14702,15002,15141,15239,15338,15370,15440,15462,15467,15470,15494,15668,15823,16128,16302,16377,16431,16541,16655,16680,16772,16795,16859,16886,16970,16995,17073,17104,17113,17154,17176,17204,17364,17402,17422,17426,17450,17478,17484,17488,17495,17620,17722,17747,17803,17806,17809,17817,17884,17901,17909,18039,18195,18240,18274,18322,18339,18345,18431,18437,18445,18565,18625,18719) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'