SQL
AخA
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);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.