SET @tagid = 'congressedits';

​

SELECT CONCAT('[[Special:Diff/',ct_rev_id,']]') AS diff,

       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 108 THEN 'Book:'               WHEN 109 THEN 'Book 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 page,

       rev_timestamp,

       actor_name,

       comment_text

FROM change_tag

LEFT JOIN revision ON rev_id = ct_rev_id

LEFT JOIN actor_revision ON actor_id = rev_actor

LEFT JOIN comment_revision ON comment_id = rev_comment_id

LEFT JOIN page ON page_id = rev_page

WHERE ct_tag_id = (SELECT ctd_id FROM change_tag_def WHERE ctd_name = @tagid);

​