SQL
x
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"
#)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.