在应使用条件的上下文(在 'id' 附近)中指定了非布尔类型的表达式。

Question

"select top "+pagesize+" m.id,m.content,u.username from message m left join users u on m.userid = u.id where newsid =? and m.id not in (select top "+((pageIndex-1)*pagesize)+" m.id from news order by m.id desc) order by m.id desc

Answer 1

http://blog.csdn.net/thc1987/article/details/24018609