SQL: select a.movid as movid,a.title as title,a.actor as actor,a.director as director, a.pic as pic,a.otherpic as otherpic,a.classid as classid,a.server as server, a.player as player,a.recommend as recommend,a.letter as letter,a.content as content, a.area as area,a.lookpoint as lookpoint,a.downpoint as downpoint,a.lookgid as lookgid, a.downgid as downgid,a.look as look,a.down as down,a.addtime as addtime,a.publish as publish, a.special as special,a.click as click,a.language as language,a.serialise as serialise, a.author as author,a.total as urlnum from cqstars_newmovieonline.vodcms_movie as a where a.locked=0 and publish<=1999 and a.locked<>1 and a.lookgid<>3 AND a.downgid<>3 order by case WHEN a.`lookpoint` = '0' then 0 else 1 end ,a.addtime desc LIMIT -10,10
Info: 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 17
File: