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 (1149,1378,1814,4530,5410,5411,8577,9013,9508,9562,9631,10353,10733,12410,12570,12802,12829,13572,13726,14279,14684,14740,14794,14860,14896,14897,14963,14981,15059,15092,15103,15117,15187,15252,15520,15696,15790,15910,16002,16018,16092,16105,16106,16128,16169,16383,16384,16385,16693,16699,16886,16894,16895,17118,17140,17230,17304,17306,17409,17641,17666,17687,17715,17828,17831,17863,17874,17936,17991,18240,18385,18569,18606) ORDER BY files.dateAdded DESC LIMIT 0, 20
Error:
[1054] Unknown column 'idMovie' in 'where clause'