Auflösbare interwikilinks

SQL

SELECT p.page_title, CONCAT(iwl_prefix, ':', iwl_title) AS "Iw-Link", t.page_title AS "Ziel"
  FROM iwlinks, langlinks, (page AS t, page AS p) LEFT JOIN (pagelinks, linktarget)
                                                  ON p.page_id = pl_from
                                                 AND pl_target_id = lt_id
                                                 AND lt_namespace = 0
                                                 AND lt_title = t.page_title
 WHERE p.page_namespace = 0
   AND iwl_from = p.page_id
   AND ll_lang = iwl_prefix
   AND iwl_title = REPLACE(ll_title, ' ', '_')
   AND t.page_id = ll_from
   AND t.page_namespace = 0
   AND p.page_title NOT IN ('Liste_der_Sternbilder_in_verschiedenen_Sprachen', 'Liste_der_ehemaligen_Gemeinden_in_Island')
   AND p.page_title != t.page_title
   AND pl_from IS NULL
 ORDER BY p.page_title
SQL

Checking query status...
