SELECT P.page_title, iwl_title FROM iwlinks

JOIN page P ON P.page_id=iwl_from

WHERE iwl_prefix='wiktionary' AND iwl_title != "" AND LOWER(iwl_title) != LOWER(P.page_title)

AND LOWER(iwl_title) != LOWER(CONCAT("Special:Search/", P.page_title))

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;