select a.msg_id,a.msg_parentid,a.msg_baseid,a.msg_title,a.msg_author,a.msg_readtimes,a.msg_time,a.msg_content_words,a.msg_content,a.msg_image from main_data a left join (select msg_baseid, msg_id from main_data where msg_boradid = 'emotion.programmer' group by msg_baseid order by msg_id desc limit 100,10) b on a.msg_baseid=b.msg_baseid where b.msg_baseid is not null order by a.msg_baseid desc, b.msg_baseid asc

使用sqliteadmin（v0.8.3.2 好像也是delphi写的，数据记录里的汉字是乱码，估计是utf8没转过来）