mysql数据库使用group by 统计数量后再进行排序
SELECT shop_id,count(id) as order_total FROM `qipa_member_order` where qipa_activity_id = 250 GROUP BY shop_id ORDER BY order_total desc
SELECT shop_id,count(id) as order_total FROM `qipa_member_order` where qipa_activity_id = 250 GROUP BY shop_id ORDER BY order_total desc