帝国cms模板调用多个父栏目ID的信息SQL语句

以下代码就是调用多个父栏目信息的调用代码

select * from [!db.pre!]ecms_news where classid in (select classid from [!db.pre!]enewsclass where bclassid in (7,8,9))  order by onclick DESC limit 8