:(

1064: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 '-10,10' at line 1 [ SQL语句 ] : SELECT distinct npd.id,n.*,reg.name as regname FROM `kl_products` as n left join kl_position_data as npd on npd.id=n.id left join kl_region as reg on n.city=reg.id WHERE n.tid = '6' AND n.state = 1 AND n.city = '0' ORDER BY n.orderid desc,n.addtime desc LIMIT -10,10

错误位置

FILE: /usr/local/nginx/html/ThinkPHP/Library/Think/Db/Driver.class.php  LINE: 353

TRACE

#0 /usr/local/nginx/html/ThinkPHP/Library/Think/Db/Driver.class.php(353): E('1064:You have a...')
#1 /usr/local/nginx/html/ThinkPHP/Library/Think/Db/Driver.class.php(183): Think\Db\Driver->error()
#2 /usr/local/nginx/html/ThinkPHP/Library/Think/Db/Driver.class.php(949): Think\Db\Driver->query('SELECT distinct...', false)
#3 /usr/local/nginx/html/ThinkPHP/Library/Think/Model.class.php(579): Think\Db\Driver->select(Array)
#4 /usr/local/nginx/html/App/Yzs/Service/YzssService.class.php(124): Think\Model->select()
#5 /usr/local/nginx/html/App/Yzs/Controller/ProductsController.class.php(41): Yzs\Service\YzssService->productHot1(Array, '0', '-10,10')
#6 [internal function]: Yzs\Controller\ProductsController->Index()
#7 /usr/local/nginx/html/ThinkPHP/Library/Think/App.class.php(173): ReflectionMethod->invoke(Object(Yzs\Controller\ProductsController))
#8 /usr/local/nginx/html/ThinkPHP/Library/Think/App.class.php(110): Think\App::invokeAction(Object(Yzs\Controller\ProductsController), 'Index')
#9 /usr/local/nginx/html/ThinkPHP/Library/Think/App.class.php(204): Think\App::exec()
#10 /usr/local/nginx/html/ThinkPHP/Library/Think/Think.class.php(120): Think\App::run()
#11 /usr/local/nginx/html/ThinkPHP/ThinkPHP.php(97): Think\Think::start()
#12 /usr/local/nginx/html/index.php(33): require('/usr/local/ngin...')
#13 {main}