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 (1254,4491,4728,9266,9394,9937,9938,10204,10450,10832,10947,11376,11625,11748,11972,12426,12427,12916,13044,13157,13177,13190,13512,13513,13674,13939,14078,14142,14427,14429,14430,14547,14668,14833,14923,14924,14937,14948,15033,15098,15103,15176,15322,15354,15357,15544,15551,15560,15566,15568,15575,15600,15665,15683,15691,15817,15871,15927,15928,15929,15930,15931,15975,15986,15996,16001,16033,16043,16088,16091,16101,16129,16154,16186,16200,16211,16309,16329,16487,16513,16541,16623,16645,16656,16705,16748,16825,16840,17059,17093,17131,17170,17315,17373,17386,17434,17525,17585,17596,17653,17709,17744,17860,17996,18002,18019,18111,18120,18140,18156,18248,18270,18313,18431,18432,18482,18564,18644,18710,18774,18787,18818,18869) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'