MySQL Query Error: SELECT pid,subject,picture,thumb,price,promote,promote_start,promote_end FROM [dbpre]product WHERE status=1 AND is_on_sale=1 AND gcatid IN (67,86,87,88) AND city_id IN (0,) ORDER BY sales 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 ') ORDER BY sales DESC LIMIT 0,10' at line 1
Error number: 1064
Date: 2026-06-21 @ 11:16
Script: http://www.liyuanwu.com/index.php/product-list-catid-67-orderby-sales.html
| File | Line | Function |
|---|---|---|
| core\lib\mysql.php | 115 | ms_mysql->_halt() |
| ms_mysql->query() | ||
| core\lib\activerecord.php | 37 | call_user_func_array() |
| core\helper\query.php | 16 | ms_activerecord->__call() |
| core\helper\query.php | 16 | ms_activerecord->query() |
| query->sql() | ||
| core\model\datacall_class.php | 185 | call_user_func() |
| core\function.php | 2122 | msm_datacall->datacall_get() |
| data\templates\main\mogujie_product_list.htm.php | 33 | datacall_get() |
| core\modules\product\list.php | 78 | include() |
| core\modules\product\common.php | 26 | include() |
| index.php | 57 | include() |
