联系官方销售客服
1835022288
028-61286886
我没二开,我的MYSQL版本是8.0.32
SELECT `dr_1_news`.*,`dr_1_news_hits`.`hits`,`dr_1_news_hits`.`day_hits`,`dr_1_news_hits`.`week_hits`,`dr_1_news_hits`.`month_hits`,`dr_1_news_hits`.`year_hits`,`dr_1_news_hits`.`day_time`,`dr_1_news_hits`.`week_time`,`dr_1_news_hits`.`month_time`,`dr_1_news_hits`.`year_time` FROM `dr_1_news` LEFT JOIN `dr_1_news_hits` ON `dr_1_news`.`id`=`dr_1_news_hits`.`id` WHERE (`dr_1_news`.`catid` IN () OR (`dr_1_news`.`catids` <>'' AND JSON_CONTAINS (`dr_1_news`.`catids`->'$[*]', '"0"', '$'))) ORDER BY `dr_1_news_hits`.`day_hits` DESC LIMIT 12
但是程序运行时报这个错误,其他分类都不会,只有其中一个分类报这个错误,我通过这个语句看不到错误在哪里。
我在phpmyadmin中直接运行这段代码