日期:2014-05-17 浏览次数:20744 次
select id from (select id,pubtime from qa union all select bbsid id,max(pubtime) pubtime from qa_answer group by bbsid) group by id order by max(pubtime) desc