根据某个字段统计数量并排序（DISTINCT函数会自动排序）

SELECT DISTINCT
	( object_id ) 
FROM
	(
	SELECT TOP
		100 PERCENT a.*,
		b.cnt 
	FROM
		weChat_share a
		LEFT JOIN ( SELECT object_id, COUNT ( object_id ) cnt FROM weChat_share WHERE type = 4 GROUP BY object_id ) b ON a.object_id = b.object_id 
	WHERE
	a.type = 4 
	) c