WikiData Pope and WikiTree

P39 Position held
Q19546 Pope

Query Popes and WikiTree link

SELECT ?pope ?popeLabel ?popeDescription ?start ?end ?replace ?replacedby ?WikiTree
WHERE
{
  ?pope wdt:P39 wd:Q19546;
         p:P39 [
           ps:P39 wd:Q19546;
           pq:P580 ?start;
           pq:P582 ?end;
           pq:P1365 ?replace;
           pq:P1366 ?replacedBy
         ].
  OPTIONAL{?pope wdt:P2949 ?WikiTreeID}.
  BIND (URI(CONCAT("http://www.wikitree.com/wiki/",?WikiTreeID)) AS ?WikiTree)

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?end)

Popes not with links to WikiTree = 252

  MINUS{?pope wdt:P2949 ?WikiTreeID}.

• Result

Misc

Three pops the same year query

SELECT ?year ?pope1Label ?pope2Label ?pope3Label

WHERE

{

  ?pope2 wdt:P39 wd:Q19546;

         p:P39 [

           ps:P39 wd:Q19546;

           pq:P580 ?p2s;

           pq:P582 ?p2e;

           pq:P1365 ?pope1;

           pq:P1366 ?pope3

         ].

  ?pope1 p:P39 [

           ps:P39 wd:Q19546;

           pq:P582 ?p1e

         ].

  ?pope3 p:P39 [

           ps:P39 wd:Q19546;

           pq:P580 ?p3s

         ].

  BIND(YEAR(?p2s) AS ?year).

  FILTER(YEAR(?p2e) = ?year && YEAR(?p1e) = ?year && YEAR(?p3s) = ?year).

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

ORDER BY ?year