查询指定一级栏目下的所有内容 20070484261004是栏目ID

SQL语句加上这个 where verific=1 and tid in(select ID from KS_Class where TS like '%20070484261004%') order by adddate desc