Test query - Quarry

SQL

SELECT CONCAT("* [[", REPLACE(page.page_title, "_", " "), "]]") AS pages
FROM templatelinks
JOIN page ON page.page_id=tl_from AND page.page_namespace=0
JOIN pagelinks ON pl_from=tl_from
JOIN page AS pl ON pl.page_namespace=pl_namespace AND pl.page_title=pl_title
LEFT JOIN redirect ON rd_from=pl.page_id
LEFT JOIN page AS rd ON rd.page_namespace=rd_namespace AND rd.page_title=rd_title
LEFT JOIN page_props ON pp_page=IFNULL(rd.page_id,pl.page_id) AND pp_propname="disambiguation"
WHERE tl_namespace=10 AND tl_title="Disambiguation_needed" AND pl_namespace=0 
GROUP BY tl_from
HAVING COUNT(*)=SUM(pp_page IS NULL);
SQL

Checking query status...
