Links to Wiktionary matching Wikipedia articles or redirects

SQL

SELECT Pf.page_title, iwl_title FROM iwlinks
JOIN page Pf ON P.page_id=iwl_from
JOIN page Pt ON P.page_namespace=0 AND P.page_title=CONCAT(UPPER(SUBSTR(iwl_title,1,1)), SUBSTR(iwl_title,2))
WHERE iwl_prefix='wiktionary' AND iwl_title != "" AND LOWER(CONVERT(iwl_title USING latin1)) != LOWER(CONVERT(Pf.page_title USING latin1))
AND LOWER(CONVERT(iwl_title USING latin1)) != LOWER(CONCAT("Special:Search/", CONVERT(Pf.page_title USING latin1)))
AND NOT EXISTS (SELECT * from page_props WHERE pp_page=Pf.page_id AND pp_propname='disambiguation')
AND NOT EXISTS (SELECT * from redirect, page Pr, page_props
                WHERE rd_from=Pf.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;

SQL

Checking query status...