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;