:(

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 '-20,20' at line 1 [ SQL语句 ] : SELECT distinct n.id,n.*,cart.name as cartname,reg.name as regname,ind.name as indname,caruser.causername,caruser.causer_phone,caruser.causer_qq,caruser.causer_careers,caruser.causer_goodat,caruser.careersage,caruser.lcareersage,caruser.causer_evaluate,caruser.headimg,caruser.causer_Personalprofile,n.node FROM `kl_successful` 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 left join kl_industry as ind on n.industry=ind.id left join kl_category as cart on n.categoryid=cart.id left join kl_careersadviser as caruser on n.careerid=caruser.id WHERE n.categoryid IN ('1','100','101','102','103','104','105','106','107','20','15','87','94','61','63','65','70','71','72','73','2','3','88','95','4','6','7','5','60','66','67','68','9','10','11','12','44','77','13','59','81','82','98','99','86','25','26','28','29','30','49','54','56','55','57','85','90','91','92','93') AND n.type = 0 AND n.city = '0' ORDER BY n.orderid desc,n.id desc LIMIT -20,20

错误位置

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(153): Think\Model->select()
#5 /usr/local/nginx/html/App/Yzs/Controller/CompletecaseController.class.php(41): Yzs\Service\YzssService->Successful(Array, '0', '-20,20')
#6 [internal function]: Yzs\Controller\CompletecaseController->Index()
#7 /usr/local/nginx/html/ThinkPHP/Library/Think/App.class.php(173): ReflectionMethod->invoke(Object(Yzs\Controller\CompletecaseController))
#8 /usr/local/nginx/html/ThinkPHP/Library/Think/App.class.php(110): Think\App::invokeAction(Object(Yzs\Controller\CompletecaseController), '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}