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 (25478,24373,32631,24768,19608,31672,24193,715,26374,38691,18645,22595,16725,13800,4798,31706,36524,38895,35990,4506,37518,33900,25906,31030,25902,9148,29499,14381,4041,346,24301,33839,25691,11223,8529,6276,30924,17934,33450,29564,38208,32100,34452,38166,27042,6588,32358,26724,35089,19836,20740,7132,9714,20402,15459,31499,19573,4992,15471,27299,30259,2789,26140,17343,35908,37966,8496,34889,18877,33910,33868,35440,17342,21853,37626,33491,37170,37396,37708,16236,14128,27783,38881,35576,36866,23096,5492,17273,6652,33426,9095,16117,39181,35734,14329,20998,24189,30281,19321,23291,25576,14989,30450,39828,29281,28845,26392,18519,27763,29452,39871,1844,21855,7552,23591,27501,18171,27587,21751,20528,20016,36998,28699,15901,5485,39003,24347,31787,23026,29543,14552,29539,36904,8376,9242,31155,20429,17111,27578,34960,24093,14909,25665,26184,15961,20068,28375,1517) 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