Stub-class critically endangered species articles

SQL

SET @user = "Chlod";

SELECT
        DATE_FORMAT(rev_timestamp, "%Y-%m-%d %H:%i:%s") AS 'Date',
        rev_id AS 'ID',
        FORMAT(rev_len, 0) AS 'Length',
        CONCAT(CASE
            WHEN page_namespace = 0 THEN ''
            WHEN page_namespace = 1 THEN 'Talk:'
            WHEN page_namespace = 2 THEN 'User:'
            WHEN page_namespace = 3 THEN 'User talk:'
            WHEN page_namespace = 4 THEN 'Wikipedia:'
            WHEN page_namespace = 5 THEN 'Wikipedia talk:'
            WHEN page_namespace = 6 THEN 'File:'
            WHEN page_namespace = 7 THEN 'File talk:'
            WHEN page_namespace = 8 THEN 'MediaWiki:'
            WHEN page_namespace = 9 THEN 'MediaWiki talk:'
            WHEN page_namespace = 10 THEN 'Templat:'
            WHEN page_namespace = 11 THEN 'Template talk:'
            WHEN page_namespace = 12 THEN 'Help:'
            WHEN page_namespace = 13 THEN 'Help talk:'
            WHEN page_namespace = 14 THEN 'Category:'
            WHEN page_namespace = 15 THEN 'Category talk:'
            WHEN page_namespace = 100 THEN 'Portal:'
            WHEN page_namespace = 101 THEN 'Portal talk:'
            WHEN page_namespace = 828 THEN 'Module:'
            WHEN page_namespace = 829 THEN 'Module talk:'
        END, REPLACE(page_title, "_", " ")) AS 'Page',
        comment_text AS 'Comment',
        actor_name AS 'User'
FROM revision_userindex
JOIN comment_revision ON rev_comment_id = comment_id
JOIN actor_revision ON rev_actor = actor_id
JOIN page ON rev_page = page_id
WHERE
    actor_name = @user
    AND comment_text NOT LIKE "%Disambiguat%"  -- ignore disambiguations
    -- AND page_namespace != 3  -- avoid user talk pages
ORDER BY rev_len DESC
LIMIT 1000;
SQL

Checking query status...
