Untitled query #56761

SQL

# select * from page where page_namespace = 0 limit 5;

SELECt * FROM 
( select page_id AS `p1` from page_props join page on pp_page=page_id where page_namespace = 0 and pp_propname = 'disambiguation' ) X
OUTER JOIN
( select page_id as `p2` from templatelinks join page on tl_from=page_id where tl_title = 'Disambig' and page_namespace = 0 UNION
select page_id from templatelinks join page on tl_from=page_id where tl_title = 'DisambigT' and page_namespace = 0 ) Y
ON p1=p2 WHERE p1 is NULL or p2 IS NULL;
select * from page where page_title rlike 'Disambig';
SQL

Checking query status...
