{{ Database report|sql =
--
SELECT CASE WHEN page_is_redirect = 1
THEN CONCAT(CHR(14853303), '{', '{!r', CHR(124), page_title, '}', '}')
ELSE CONCAT('[', '[', page_title, ']', ']')
END AS title,
CAST(MIN(rev_timestamp) AS DATETIME) AS creation
FROM page
JOIN revision ON rev_page = page_id
WHERE page_namespace = 0
AND page_title RLIKE '[^_]\\('
GROUP BY page_id
ORDER BY MIN(rev_timestamp) DESC;
--
|remove_underscores = 1|pagination = 1000}}
{{ Database report end}}
{{ Database report|sql =
--
SELECT CASE WHEN page_is_redirect = 1
THEN CONCAT(CHR(14853303), '{', '{!r', CHR(124), page_title, '}', '}')
ELSE CONCAT('[', '[', page_title, ']', ']')
END AS title,
CAST(MIN(rev_timestamp) AS DATETIME) AS creation
FROM page
JOIN revision ON rev_page = page_id
WHERE page_namespace = 0
AND page_title RLIKE '[^_]\\('
GROUP BY page_id
ORDER BY MIN(rev_timestamp) DESC;
--
|remove_underscores = 1|pagination = 1000}}
{{ Database report end}}