{tryine:loopsql sql="SELECT top 4 * FROM dbo.Cy_news WHERE classid=247 AND audit=1 and n_type like '%1%' AND newmodel LIKE '%2%' order by writertime desc,rootID desc"}
{tryine:loopsql sql="SELECT top 5 *,subtitle = case when len(title) > 36 then substring(title,0,36)+'...'
else title end,subcon = case when len(newscontentsub)>80 then substring(newscontentsub,0,80)+'...'
else newscontentsub end,yy=datename(yyyy,writertime),mm=substring(convert(varchar(12),writertime,23),6,2),dd=datename(dd,writertime),time = substring(convert(varchar(12),writertime,23),6,5) FROM dbo.Cy_news WHERE classid=30 AND audit=1 and n_type like '%1%' AND newmodel LIKE '%2%' order by writertime desc,rootID desc"}
{tryine:loopsql sql="SELECT top 5 *,subtitle = case when len(title) > 36 then substring(title,0,36)+'...'
else title end,subcon = case when len(newscontentsub)>80 then substring(newscontentsub,0,80)+'...'
else newscontentsub end,yy=datename(yyyy,writertime),mm=substring(convert(varchar(12),writertime,23),6,2),dd=datename(dd,writertime),time = substring(convert(varchar(12),writertime,23),6,5) FROM dbo.Cy_news WHERE classid=31 AND audit=1 and n_type like '%1%' AND newmodel LIKE '%2%' order by writertime desc,rootID desc"}