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 (c06 LIKE '%Prime Video%' OR c15 LIKE '%Prime Video%') ORDER BY files.dateAdded DESC LIMIT 0, 20

Error:
[1052] Column 'c06' in where clause is ambiguous