{php $query=' select * from ((select title,id,catid,url,thumb,hits from dr_1_photo order by hits desc) union all (select title,id,catid,url,thumb,hits from dr_1_news order by hits desc)) as temp order by hits desc limit 5 ';}{list action=sql sql='$query'}{/list}{$error}{loop $return $key $t}{if $key==0}
{loop $return $key $t}
{/loop}
{$t.title}
{loop $return $key $t} {if $key>0}{$t.title}