Protected pages by talk page category

Pages that are currently protected and which have a talk page in [[Category:All WikiProject Medicine articles]].

This will miss the (likely minimal) corner case where a protected page has a talk page that redirects to a talk page in that category.

For [[WP:RAQ#Medicine pages by protection level]] circa 23 November 2020.

SQL

SELECT CONCAT('[[', CASE a.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 446 THEN 'Education Program:'  WHEN 447 THEN 'Education Program 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:', a.page_namespace, '}}:')
                    END, a.page_title,']]'),
       a.page_is_redirect,
       pr_type,
       pr_level,
       pr_cascade,
       pr_expiry
FROM page_restrictions
JOIN page AS a
  ON a.page_id = pr_page
JOIN page AS t
  ON t.page_namespace = (a.page_namespace + 1) AND t.page_title = a.page_title
JOIN categorylinks
  ON cl_from = t.page_id
WHERE cl_to = 'All_WikiProject_Medicine_articles'
  AND t.page_namespace % 2 = 1;

SQL

Checking query status...