Intentional disambiguation links

SQL

-- select page_title, rd_title from redirect
-- join page on rd_from = page_id
-- where page_title not like '%_(disambiguation)'
-- and page_id in (select tl_from from templatelinks where tl_target_id = 432);

select page_title, rd_title from redirect
join page on rd_from = page_id
where page_title like '%_(disambiguation)'
and page_id in (select tl_from from templatelinks where tl_target_id in (3525, 55));

-- select * from linktarget where lt_title in ('R_from_ambiguous_term', 'R_from_incomplete_disambiguation', 'R_to_disambiguation_page') and lt_namespace = 10;
SQL

Checking query status...
