SET
@@group_concat_max_len = 8192
;
SELECT
GROUP_CONCAT(
`line`
SEPARATOR
'\n'
)
AS
`wikitext`
FROM (
SELECT
CONCAT(
'|-\n| ',
`year`,
'-',
`month`,
' || ',
`size`,
' || ',
`count`,
' || ',
`avg`
)
AS
`line`
FROM (
SELECT
YEAR(
`rev_timestamp`
)
AS
`year`,
MONTH(
`rev_timestamp`
)
AS
`month`,
SUM(
`page_len`
)
AS
`size`,
COUNT(
*
)
AS
`count`,
SUM(
`page_len`
)
/
COUNT(
*
)
AS
`avg`
FROM (
SELECT
`mypage`.`page_len`,
`rev_timestamp`
FROM (
SELECT
`page_id`,
`page_len`
FROM
`page`
WHERE
`page_namespace` = 4
AND
`page_title` LIKE 'Requests_for_adminship/%'
)
AS
`mypage`
JOIN
`revision`
ON (
`mypage`.`page_id` = `rev_page`
)
GROUP BY `page_id`
)
AS
`mytable`
GROUP BY
`year`,
`month`
ORDER BY
`year`,
`month`
ASC
)
AS
`myothertable`
)
AS
`thelasttable`
;
1 row in set (0.92 sec)