MySQL Query Error: SELECT catid,count(catid) as total,avg(price) as avgprice FROM `[dbpre]diary` WHERE status=1 AND catid in () group by catid ORDER BY total DESC LIMIT 0,10
Error description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by catid ORDER BY total DESC LIMIT 0,10' at line 1
Error number: 1064
Date: 2024-03-29 @ 07:21
Script: http://www.236z.com/diary/index-catid-246
File | Line | Function |
---|---|---|
core/lib/mysql.php | 188 | ms_mysql->_halt() |
core/modules/diary/index.php | 377 | ms_mysql->query() |
core/modules/diary/common.php | 51 | include() |
index.php | 82 | include() |