SELECT P.page_title, iwl_title FROM iwlinks

JOIN page P ON P.page_id=iwl_page

WHERE iwl_prefix='wiktionary'

AND 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;