select t.tid,t.fid,t.typeid,t.subject,p.author,p.first,p.message from cdb_threads as t,cdb_posts as p where t.fid=2 and t.tid=p.tid and t.lastpost>=unix_timestamp('2010-02-01') and t.dateline<=unix_timestamp('2010-03-01') order by t.typeid,t.dateline
备份用 |