SQL
AخA
use mediawikiwiki_p;
SELECT
COUNT(p.page_id) AS "pages",
GROUP_CONCAT(CAST(p.page_title AS CHAR(10000) CHARACTER SET utf8)) AS "page_title",
r.rev_comment AS "rev_comment",
r.rev_text_id AS "revision_id",
r.rev_user AS "rev_user",
r.rev_user_text AS "rev_user_text"
FROM
page p
INNER JOIN revision r
ON p.page_latest = r.rev_id
WHERE
p.page_namespace = 1198 AND r.rev_user = 0 AND r.rev_comment LIKE "Created page with%"
GROUP BY r.rev_comment
HAVING pages > 1
ORDER BY pages DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.