$count = $store_shop->join('left join __SHOP__ ON __STORE_SHOP__.shop_id = __SHOP__.shop_id left join __MEMBER__ ON __SHOP__.member_id=__MEMBER__.member_id left join __BRAND_STORE__ ON __STORE_SHOP__.brand_store_id=__BRAND_STORE__.brand_store_id left join __BRAND__ ON __BRAND_STORE__.brand_id=__BRAND__.brand_id left join __SHOP_COMMISSION__ ON __SHOP_COMMISSION__.brand_id_or_brand_store_id=__BRAND_STORE__.brand_store_id and __SHOP_COMMISSION__.value_id=__MEMBER__.member_id and __SHOP_COMMISSION__.commission_type=2 left join __ORDER_INFO__ ON __ORDER_INFO__.brand_store_id=__STORE_SHOP__.brand_store_id')->where($where)->group(C('DB_PREFIX').'store_shop.brand_store_id')->count();//查询满足要求的总记录数
$Page = new \Think\Page($count,$limit);//实例化分页类 传入总记录数和每页显示的记录数(25)
$show = $Page->show();
=======================
如果是原生我可以这样:
mysql count(*) group by 之后再用count(*)的SQL语句
SELECT COUNT(*) FROM (SELECT COUNT(*) FROM table_test WHERE `status`= 1 GROUP BY user_id ) AS tmp
最佳答案
