User:NaomiAmethyst/RfA Stats MySQL

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)