SQL
AخA
SELECT * FROM iwlinks WHERE iwl_prefix='wiktionary'
JOIN page P ON P.page_namespace=0 AND P.page_title=iwl_title
WHERE NOT EXISTS (SELECT * from page_props WHERE pp_page=P.page_id AND pp_propname='disambiguation')
AND NOT EXISTS (SELECT * from redirect, page Pr, page_props
WHERE rd_from=P.page_id AND rd_namespace=0 AND Pr.page_namespace=0 AND Pr.page_title=rd_title
AND pp_page=Pr.page_id AND pp_propname='disambiguation')
LIMIT 10;
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.