SIAs tagged with Disambig-Class WikiProject banners

SQL

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 category
  join categorylinks on cl_to = cat_title and cl_type = 'page'
  where cat_title rlike '^list|[^a-z]list' collate utf8_general_ci
)
AND Pt.page_id NOT IN (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'WikiProject_banner' and lt_namespace = 828
  )
)

SQL

Checking query status...