SELECT
	IFNULL(bet.cash, 0) AS cash,
	IFNULL(bet.cash_winning, 0) AS cash_winning,
	IFNULL(bet.buyback, 0) AS buyback,
	IFNULL(feedback.feedback, 0) AS feedback,
	(IFNULL(manual_deposit_activity.manual_deposit_activity, 0) - n IFNULL(manual_withdraw_activity.manual_withdraw_activity, 0) + n IFNULL(cash_log_activity.cash_log_activity, 0)) AS activity,
	IFNULL(bet.platform_fee, 0) AS platform_fee,
	IFNULL(bet.winlost, 0) AS winlost,
	(IFNULL(bet.winlost, 0) + n IFNULL(feedback.feedback, 0) + n IFNULL(bet.platform_fee, 0) + n IFNULL(manual_deposit_activity.manual_deposit_activity, 0) - n IFNULL(manual_withdraw_activity.manual_withdraw_activity, 0) + n IFNULL(cash_log_activity.cash_log_activity, 0) + n IFNULL(manual_deposit_risk_adjustment.manual_deposit_risk_adjustment, 0) - n IFNULL(manual_withdraw_risk_adjustment.manual_withdraw_risk_adjustment, 0)) AS net_revenue,
	IFNULL(deposit.deposit, 0) AS deposit,
	IFNULL(withdraw.withdraw, 0) AS withdraw,
	IFNULL(flush.flush, 0) AS flush,
	(IFNULL(manual_deposit_other.manual_deposit_other, 0) - n IFNULL(manual_withdraw_other.manual_withdraw_other, 0)) AS other,
	(IFNULL(manual_deposit_risk_adjustment.manual_deposit_risk_adjustment, 0) - n IFNULL(manual_withdraw_risk_adjustment.manual_withdraw_risk_adjustment, 0)) AS risk_adjustment,
	IFNULL(donate.donate, 0) AS donate
FROM (
	SELECT
		0 AS id) AS `main`
	LEFT JOIN (
		SELECT
			0 AS id,
			SUM(bet_daily_records.cash) AS cash,
			SUM(bet_daily_records.cash_winning) AS cash_winning,
			SUM(bet_daily_records.buyback_amount) AS buyback,
			SUM(bet_daily_records.fee) AS platform_fee,
			SUM(bet_daily_records.revenue) AS winlost
		FROM
			`bet_daily_records`
		WHERE
			`set_key` IS NULL
			AND `date` BETWEEN '2020-04-20'
			AND '2020-04-21') AS `bet` ON `main`.`id` = `bet`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(bet_daily_records.feedback) AS feedback
		FROM
			`bet_daily_records`
		WHERE
			`set_key` IS NULL
			AND `date` BETWEEN '2020-04-20'
			AND '2020-04-21') AS `feedback` ON `main`.`id` = `feedback`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(deposits.cash) AS manual_deposit_activity
		FROM
			`deposits`
		WHERE
			`method` = 'manual_event'
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00') AS `manual_deposit_activity` ON `main`.`id` = `manual_deposit_activity`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(withdraws.cash) AS manual_withdraw_activity
		FROM
			`withdraws`
		WHERE
			`withdraws`.`type` = 2
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00'
			AND `withdraws`.`deleted_at` IS NULL) AS `manual_withdraw_activity` ON `main`.`id` = `manual_withdraw_activity`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(cash_logs.cash) AS cash_log_activity
		FROM
			`cash_logs`
		WHERE
			`cash_logs`.`type` = 'activity'
			AND `cash_logs`.`operated_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00') AS `cash_log_activity` ON `main`.`id` = `cash_log_activity`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(deposits.cash) AS manual_deposit_risk_adjustment
		FROM
			`deposits`
		WHERE
			`method` = 'manual_risk_adjustment'
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00') AS `manual_deposit_risk_adjustment` ON `main`.`id` = `manual_deposit_risk_adjustment`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(withdraws.cash) AS manual_withdraw_risk_adjustment
		FROM
			`withdraws`
		WHERE
			`withdraws`.`type` = 4
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00'
			AND `withdraws`.`deleted_at` IS NULL) AS `manual_withdraw_risk_adjustment` ON `main`.`id` = `manual_withdraw_risk_adjustment`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(deposits.cash) AS deposit
		FROM
			`deposits`
		WHERE
			`status` = 2
			AND `method` NOT in('manual_event', 'manual_other', 'manual_risk_adjustment')
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00') AS `deposit` ON `main`.`id` = `deposit`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(withdraws.cash) AS withdraw
		FROM
			`withdraws`
		WHERE
			`status` = 3
			and(`withdraws`.`type` in(1, 5, 6, 7))
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00'
			AND `withdraws`.`deleted_at` IS NULL) AS `withdraw` ON `main`.`id` = `withdraw`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(bet_daily_records.flush) AS flush
		FROM
			`bet_daily_records`
		WHERE
			`set_key` IS NULL
			AND `date` BETWEEN '2020-04-20'
			AND '2020-04-21') AS `flush` ON `main`.`id` = `flush`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(deposits.cash) AS manual_deposit_other
		FROM
			`deposits`
		WHERE
			`method` = 'manual_other'
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00') AS `manual_deposit_other` ON `main`.`id` = `manual_deposit_other`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(withdraws.cash) AS manual_withdraw_other
		FROM
			`withdraws`
		WHERE
			`withdraws`.`type` = 3
			AND `finished_at` BETWEEN '2020-04-20 00:00:00'
			AND '2020-04-21 00:00:00'
			AND `withdraws`.`deleted_at` IS NULL) AS `manual_withdraw_other` ON `main`.`id` = `manual_withdraw_other`.`id`
	LEFT JOIN (
		SELECT
			0 AS id, SUM(bet_daily_records.donate) AS donate
		FROM
			`bet_daily_records`
		WHERE
			`set_key` IS NULL
			AND `date` BETWEEN '2020-04-20'
			AND '2020-04-21') AS `donate` ON `main`.`id` = `donate`.`id`