Mysql 多表查询统计

 SELECT a.* FROM (select @rownum := @rownum + 1 AS ranking,t.* FROM
(SELECT @rowNum := 0) r,
(SELECT h.id,h.nickname,h.avatar_url,r.type,IFNULL(sum(r.price),0) AS consumption_price
FROM `kj_shared_bill` AS r  JOIN `kj_shared_user` AS h
ON r.form_id = h.id
AND r.status = -1 
AND r.acid = 1 
AND r.type  IN(1,2,4,6,7,8)
GROUP BY h.id
ORDER BY consumption_price DESC
) t) a WHERE  `type`  IN(1,2,4,6,7,8)