Malplaced disambiguation pages

SQL

select page_namespace, page_title, rd_title from redirect
join page on rd_from = page_id and rd_namespace = page_namespace and rd_title = CONCAT(page_title, '_(disambiguation)')
where page_namespace in (0, 1)

/*
select p1.page_title, r1.rd_title, r2.rd_title from redirect r1
join page p1 on r1.rd_from = p1.page_id and p1.page_namespace = 1 and p1.page_is_redirect = 1
and r1.rd_title = CONCAT(p1.page_title, '_(disambiguation)') and r1.rd_namespace = 1
join page p2 on p2.page_namespace = 0 and p2.page_title = p1.page_title and p2.page_is_redirect = 1
join redirect r2 on r2.rd_from = p2.page_id
*/
SQL

Checking query status...
