Anfrage fehlgeschlagen: (select
movie_id,
tag,
count(tag) as z,
tv_movies.id,
tv_movies.category_id,
tv_movies.name,
tv_movies.pic_thumb,
tv_movies.pagename,
tv_movies.duration,
tv_movies.vote,
tv_movies.vote_sum,
tv_movies.views,
tv_movies.is_hd,
tv_movies.create_date,
tv_movies.sort_date,
tv_categories.name as cat_name,
tv_categories.pagename as cat_page
from
tv_tags,
tv_movies,
tv_categories
where
tv_tags.tag in () and
tv_movies.id=tv_tags.movie_id and
tv_tags.movie_id not in (30684,17305,10045,35209,17506,13585,13650,21147,900,24291,31302,17106,22376,25327,20634,23239,17059,4448,39207,33442,19563,29097,33222,26383,31857,28193,9676,19911,28558,4184,24161,11542,3279,28790,27909,20022,27183,27274,33021,21239,25371,37014,33313,7717,24406,19154,4018,25706,20126,142,26720,6631,20900,1734,36046,33231,26608,23484,16730,702,21314,19782,33173,17373,32124,38665,3839,21432,28241,19908,9946,32826,36254,1674) and
tv_movies.display=1 and
tv_movies.category_id=tv_categories.id
group by tv_tags.movie_id
order by z desc limit 3) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') and
tv_movies.id=tv_tags.movie_id and
tv_tags.movie_id not in...' at line 28