xyzshop/admin/control/stat_collection.php

<?php

defined('InShopNC') or exit('Access Invalid!');

class stat_collectionControl extends SystemControl
{

    public function __construct(){
        parent::__construct();
    }

    public function indexOp()
    {

        $mod_favorites = Model('favorites');

        $cond = array('fv_type=goods');
        $on = 'goods.goods_id=favorites.fav_id';
        $mod_goods = Model();
        $result = $mod_goods->table('goods,favorites')->join('inner')->on($on)->field('goods_name,goods_id,count(*) as nc_count')->group('fav_id')->where($cond)->select();
        Tpl::showpage('stat.collection.list');

    }
}