SIAs tagged with Disambig-Class WikiProject banners

SQL

/*
select page_title, page_is_redirect from page
join revision_userindex on rev_page = page_id
join actor_revision on actor_id = rev_actor and actor_name = 'NmWTfs85lXusaybq'
join change_tag on ct_rev_id = rev_id
join change_tag_def on ctd_id = ct_tag_id and ctd_name = 'mw-removed-redirect'
where page_namespace = 1 and rev_timestamp > 20231220000000 and rev_timestamp < 20231221000000
*/

SELECT Pa.page_title FROM page Pa
JOIN page Pt on Pt.page_title = Pa.page_title and Pt.page_namespace = 1
WHERE Pa.page_namespace = 0 AND Pa.page_is_redirect = 0 AND Pt.page_is_redirect = 0
AND Pa.page_id IN (
  SELECT cl_from FROM categorylinks
  WHERE cl_to = "All_set_index_articles" -- "All_disambiguation_pages"
)
AND Pt.page_id IN (
  select cl_from from category
  join categorylinks on cl_to = cat_title and cl_type = 'page'
  where cat_title like 'Disambig-Class_%' -- and cat_title != 'Disambig-Class_AfC_articles'
)

/*
SELECT count(Pa.page_title) FROM page Pa
JOIN page Pt on Pt.page_title = Pa.page_title and Pt.page_namespace = 1
WHERE Pa.page_namespace = 0 AND Pa.page_is_redirect = 0 AND Pt.page_is_redirect = 0
AND Pt.page_id IN (
  select cl_from from category
  join categorylinks on cl_to = cat_title and cl_type = 'page'
  where cat_title like 'Redirect-Class_%' and cat_title != 'Redirect-Class_AfC_articles'
)
*/
SQL

Checking query status...
