Pages edited by Esoptr0n

SQL

SELECT DISTINCT CONCAT('[[', CASE page_namespace
                               WHEN -2 THEN 'Media:'               WHEN -1 THEN 'Special:'
                               WHEN 0 THEN ''                      WHEN 1 THEN 'Talk:'
                               WHEN 2 THEN 'User:'                 WHEN 3 THEN 'User talk:'
                               WHEN 4 THEN 'Wikipedia:'            WHEN 5 THEN 'Wikipedia talk:'
                               WHEN 6 THEN ':File:'                WHEN 7 THEN 'File talk:'
                               WHEN 8 THEN 'MediaWiki:'            WHEN 9 THEN 'MediaWiki talk:'
                               WHEN 10 THEN 'Template:'            WHEN 11 THEN 'Template talk:'
                               WHEN 12 THEN 'Help:'                WHEN 13 THEN 'Help talk:'
                               WHEN 14 THEN ':Category:'           WHEN 15 THEN 'Category talk:'
                               WHEN 100 THEN 'Portal:'             WHEN 101 THEN 'Portal talk:'
                               WHEN 118 THEN 'Draft:'              WHEN 119 THEN 'Draft talk:'
                               WHEN 710 THEN 'TimedText:'          WHEN 711 THEN 'TimedText talk:'
                               WHEN 828 THEN 'Module:'             WHEN 829 THEN 'Module talk:'
                               WHEN 2300 THEN 'Gadget:'            WHEN 2301 THEN 'Gadget talk:'
                               WHEN 2302 THEN 'Gadget definition:' WHEN 2303 THEN 'Gadget definition talk:'
                               ELSE CONCAT('{{ns:', page_namespace, '}}:')
                             END, page_title,']]') AS pagename
FROM page
JOIN revision_userindex ON rev_page = page_id
JOIN actor_revision ON actor_id = rev_actor
WHERE actor_name = 'Esoptr0n';
SQL

Checking query status...
