Tagging SIAs in WikiProject Anthroponymy

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 tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title in ('Given_name', 'Surname', 'Nickname') and lt_namespace = 10
  )
)
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_Anthroponymy' and lt_namespace = 10
  )
)
*/
/*
AND Pa.page_id IN (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Ship_index' and lt_namespace = 10
  )
)
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_Ships' and lt_namespace = 10
  )
)
*/
/*
AND Pa.page_id IN (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Lake_index' and lt_namespace = 10
  )
)
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_Lakes' and lt_namespace = 10
  )
)
*/
/*
AND Pa.page_id IN (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Sport_index' and lt_namespace = 10
  )
)
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_Sports' and lt_namespace = 10
  )
)
*/
/*
AND Pa.page_id IN (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Chemistry_index' and lt_namespace = 10
  )
)
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_Chemicals' and lt_namespace = 10
  )
)
*/
AND Pa.page_id IN (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Storm_index' and lt_namespace = 10
  )
)
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_Weather' and lt_namespace = 10
  )
)
SQL

Checking query status...
