(
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')
)