SELECT bal as pfx DATE_FORMAT FROM_UNIXTIME otime Y- as date COUNT id

(
	SELECT
		"bal" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_bal.bal_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"dom" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_dom_els.dom_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"egr" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_dom_els.egr_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"els" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_dom_els.els_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"juk" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_juk_ltk.juk_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"ltk" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_juk_ltk.ltk_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"kot" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_kot.kot_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"kol" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_lub_vos.kol_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"lub" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_lub_vos.lub_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"vos" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_lub_vos.vos_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"koj" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_zjd_koj.koj_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)
	UNION ALL
(
	SELECT
		"zjd" as pfx,
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m') as date,
		COUNT(id) as q,
		SUM(price) as sum,
		SUM(price) / COUNT(id) as "sum / q"
	FROM
		u230884_zjd_koj.zjd_orders
	WHERE
		1
	GROUP BY
		DATE_FORMAT(FROM_UNIXTIME(otime), '%Y-%m')
)