nlwiki Anomalous talk page redirects

SQL

USE nlwiki_p;
SELECT 
	t.page_namespace AS talk_ns, 	t.page_title AS talk_title, 
    s.page_namespace AS subject_ns, s.page_title AS subject_title, 
    pp_propname<=>'disambiguation' AS disambig
FROM 
	`page` t 
	INNER JOIN `page` s ON (s.page_namespace=(t.page_namespace-1) AND s.page_title=t.page_title) 
	LEFT JOIN page_props ON (s.page_id=pp_page AND pp_propname='disambiguation')
WHERE
	t.page_namespace != 3 AND	# exclude user talk
    t.page_title NOT REGEXP '^[0-9]+(-[0-9]+)?$' AND	# exclude year talk pages redirected to decade pages
    t.page_is_redirect=1 AND
    (t.page_namespace MOD 2)=1 AND
    s.page_is_redirect=0
ORDER BY s.page_namespace, s.page_title
SQL

Checking query status...
