From Wikipedia, the free encyclopedia
{{
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 }}
Unsorted
Sorted
/deletable - likely to be deleted with this criterion (when a redirect)
/chemical - names of chemicals and chemical processes. This is a proper subset of proper names, below, but is by far the most common case of it.
/proper name - proper names of the subject, mostly songs, bands, and military designations
/suffix - parenthetical letters, mostly suffixes
/misc - mathematical formulae, emoticons, and other clearly non-disambiguator-like typography
/section - section names, typically of legal documents. This is a proper subset of proper names, above; I've kept it separate because it was one of the earliest counterexamples raised.