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 = 0
AND categorylinks.cl_to = "Living_people"
# AND page.page_title LIKE 'A%'
AND iwlinks.iwl_prefix IN ("imdbtitle", "imdbname")
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...
