SQL
AخA
USE enwiki_p;
SELECT page.page_title, page_props.pp_value
FROM categorylinks
INNER JOIN page ON page.page_id = categorylinks.cl_from
INNER JOIN page_props ON page_props.pp_page = categorylinks.cl_from
WHERE cl_to = "Popes"
AND page_props.pp_propname = "wikibase-shortdesc"
AND page.page_title NOT IN (
"History_of_the_papacy"
"Pope"
"List_of_popes"
"List_of_popes_(graphical)"
"List_of_popes_who_died_violently"
"List_of_canonised_popes"
)
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.