Interlanguage links in templates

SQL

use enwiki_p;

SELECT DISTINCT page.page_title, iwlinks.iwl_prefix, iwlinks.iwl_title
FROM page
# INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from
# INNER JOIN templatelinks ON page.page_id = templatelinks.tl_from
INNER JOIN iwlinks ON page.page_id = iwlinks.iwl_from
WHERE page.page_namespace = 10
# AND categorylinks.cl_to = "Living_people"
# AND page.page_title LIKE 'A%'
AND iwlinks.iwl_prefix IN ("de", "fr", "es")
# AND iwlinks.iwl_title NOT IN ("Wikidata:Scholia", "Q23892012")
# AND iwlinks.iwl_title LIKE "Q%"
AND page.page_title NOT LIKE "%/%"
AND page.page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = "Interlanguage link")
ORDER BY page.page_title
# AND iwlinks.iwl_prefix NOT IN (
#  "commons", "c", "meta", "wikt", "foundation", "wmf", "wikimedia", "m", "d", "q", "s", "wiktionary", "wikinews", "b",
#  "wikisource", "wikiquote", "toolforge", "n"
#)
SQL

Checking query status...
