select a.id,title from ks_article a where a.id in(select top 2 id from ks_article where id = a.id and tid in('栏目1','栏目2')) order by  a.id desc

试试以上语句