哪位大哥 知道 block:sql 这个是怎么查询任意表调用输出的,包括前缀不同的表,谢谢
{block:sql sql="SELECT c.*,v.* FROM @#cms_game AS c INNER JOIN @#cms_game_views AS v ON c.id=v.id AND FIND_IN_SET(2, fids) ORDER BY views DESC LIMIT 10" life="300"} {php}global $run;$game_list = $data['list'];foreach($game_list as &$v){$run->cms_content->format($v, 3, 'Y-m-d', 28);}$rank = 1;{/php} <div class="toplist-box"> <div class="hd"><span>安卓手游排行榜</span></div> <ul class="toplist"> {loop:$game_list $v} <li class="games{$v[id]} {if:$rank==1}active{/if}"> <div class="tp-num">{$rank}</div> <div class="tp-cont"> <div class="tp-img"> <a href="{$v[url]}" title="{$v[title]}" target="_blank" rel="nofollow"> <img alt="{$v[title]}" class="lazyload" src="{$cfg[tpl]}images/lazyloadplaceholder.gif" data-src="{$v[pic]}"/> </a> </div> <div class="tp-intro"> <div class="tp-title"><a href="{$v[url]}" title="{$v[title]}" target="_blank">{$v[subject]}</a></div> </div> </div> </li> {php}$rank++;{/php} {/loop} </ul> </div> {/block}