mysql 统计分销商订单销售额及销售量排行

分销商表，分销订单表，主键user_id

分销订单表,涵盖first_user_id,second_user_id,third_user_id

需要统计分销商的销售业绩并做排行

SELECT
	dealer.*, dealer.money + dealer.freeze_money + dealer.total_money AS total_amount,
	IFNULL(
		sum(firstOrder.order_price),
		0
	) + IFNULL(
		sum(secondOrder.order_price),
		0
	) + IFNULL(
		sum(thirdOrder.order_price),
		0
	) AS total_order_amount,
	count(firstOrder.order_id) + count(secondOrder.order_id) + count(thirdOrder.order_id) AS total_order_nums
FROM
	`5f_dealer_user` `dealer`
LEFT JOIN `5f_dealer_order` `firstOrder` ON `firstOrder`.`first_user_id` = `dealer`.`user_id`
LEFT JOIN `5f_dealer_order` `secondOrder` ON `secondOrder`.`second_user_id` = `dealer`.`user_id`
LEFT JOIN `5f_dealer_order` `thirdOrder` ON `thirdOrder`.`third_user_id` = `dealer`.`user_id`
WHERE
	(
		`dealer`.`wxapp_id` = 10001
		AND `dealer`.`wxapp_id` = 10001
	)
AND `dealer`.`is_delete` = 0
GROUP BY
	`dealer`.`user_id`
ORDER BY
	`total_amount` DESC,
	`dealer`.`create_time` DESC