Tagging SIAs/Lists without 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 Pa.page_id IN (
  SELECT cl_from FROM categorylinks WHERE cl_to = "All_set_index_articles"
)
/*
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...