Pope shortdescs, for those who already have them

SQL

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"
)

AخA
 
SELECT page.page_title, page_props.pp_valueFROM categorylinksINNER JOIN page ON page.page_id = categorylinks.cl_fromINNER JOIN page_props ON page_props.pp_page = categorylinks.cl_fromWHERE 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")

SQL

Checking query status...