Hi, please can you help me with this error when I’m filtering in log?
SELECT COUNT(DISTINCT genre.genre_id) FROM genre JOIN genre_link ON genre.genre_id = genre_link.genre_id JOIN movie_view ON genre_link.media_id = movie_view.idMovie AND genre_link.media_type=’movie’ JOIN files ON files.idFile = movie_view.idFile JOIN genre_link ON genre_link.media_id=movie_view.idMovie AND genre_link.media_type=’movie’ WHERE ((CAST(movie_view.c05 as DECIMAL(5,1)) BETWEEN 8.90588 AND 10)) AND (genre_link.genre_id = 27);
ERROR 1066 (42000): Not unique table/alias: ‘genre_link’
Mysql 5.6.31-77.0 Percona Server
Windows
Thanks Pavel