select NewsId,NewsTitle,NewsSubTitle,NewsImg,NewsTopState,NewsCategory,NewsDate,NewsClicks from S_NewsContent where ( NewsChannel= or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=1  and NewsState=0 )  or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=11  and NewsState=0 )  or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=17  and NewsState=0 )  or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=33  and NewsState=0 )  or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=36  and NewsState=0 )  or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=42  and NewsState=0 )  or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=49  and NewsState=0 )  or NewsId in (select top 15 NewsId from S_NewsContent where NewsCategory=51  and NewsState=0 )  ) and NewsState=0 and CityId='253'  ORDER BY NewsDate,NewsTopState desc