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='57' 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-01-19 @ 18:46
Script: http://www.tsczu58.com/index.php/product-list-catid-57-orderby-last_update.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\default_product_list.htm.php | 28 | datacall_get() |
| core\modules\product\list.php | 78 | include() |
| core\modules\product\common.php | 26 | include() |
| index.php | 56 | include() |
娱乐休闲