{get sql="select a.contentid,a.title,a.description,a.url,b.tag,c.hits from phpcms_content a,phpcms_content_tag b,phpcms_content_count c where a.contentid=b.contentid and a.contentid=c.contentid and a.catid=48 and status=99 group by b.contentid order by a.inputtime desc limit 0,15 "} <a href="{$r[url]}" target="_blank" {if ($r[contentid]%7==0)} style="color:green" {elseif ($r[hits]>60)} style="color:red" {/if}>{str_cut($r[tag], 14,'')}</a>