太阳成游戏网站

dbprefix(SITE_ID.'_store');
$sql = 'select c.*,b.stime,b.etime,b.type as ptype,b.title as pname from `'.$pre.'_goods_promotion_item` as `a` left join `'.$pre.'_goods_promotion` as `b` on a.pid=b.id left join `'.$pre.'` as `c` on a.cid=c.id where b.status=1 and c.is_sale=1 and (b.stime < '.SYS_TIME.' and b.etime > '.SYS_TIME.') order by c.updatetime';
$query_sql = urlencode($sql);
?>
{sql sql='$query_sql' num=5 urlrule=$urlrule}
                {php $t.thumb=dr_string2array($t.thumb);$price_sku=dr_string2array($t.price_sku);}
     

      

      

       
{dr_strcut($t.title, 28)}
       
￥{if $price_sku}{dr_sku_price($price_sku, 2, ' ~ ')}{else}{number_format($t.price, 2)}{/if}
      
     
     {/sql}