Cleanup of incoming links for RfD

SQL

/*
SELECT pl_title, COUNT(pl_from) AS links FROM pagelinks
WHERE pl_namespace = 0 AND pl_from_namespace in (0, 10)
AND pl_title IN (
  select page_title from page where page_title like '%\_(%)\_(disambiguation)' and page_namespace = 0
  and page_id in (select cl_from from categorylinks where cl_to = 'Temporary_maintenance_holdings' and cl_type = 'page')
)
GROUP BY pl_title
ORDER BY links DESC
*/

select page_title from page where page_title like '%\_(%)\_(disambiguation)' and page_namespace = 0
and page_id in (select cl_from from categorylinks where cl_to = 'Temporary_maintenance_holdings' and cl_type = 'page')
and page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title in ('R_from_modification') and lt_namespace = 10
  )
)
SQL

Checking query status...
