query-906c76c01bebda3b88fc78769f619330

rq turtle/ttl

Número de obispos consagrados por un obispo:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:BubbleChart
SELECT ?consagrante ?consagranteLabel (COUNT(DISTINCT ?person) AS ?numeroConsagrados) (SAMPLE(?imagenConsagrante) AS ?imagen)
WHERE {
  {?person wdt:P31 wd:Q5;
          p:P793 ?eventoSignificativo.
  ?eventoSignificativo ps:P793 wd:Q125375;
                       pq:P1598 ?consagrante.
   }
  UNION
  {?person wdt:P31 wd:Q5;
           p:P1598 [
             ps:P1598 ?consagrante;
             pq:P3831 wd:Q18442817
             ].
   }
  ?person wdt:P140 ?religion.
  OPTIONAL{?consagrante wdt:P18 ?imagenConsagrante}
  FILTER(?religion = wd:Q1841 || ?religion = wd:Q9592).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
GROUP BY ?consagrante ?consagranteLabel
HAVING(?numeroConsagrados > 5)
ORDER BY DESC(?numeroConsagrados)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?consagrante"):::projected v4("?eventoSignificativo") v7("?imagen") v6("?imagenConsagrante"):::projected v7("?numeroConsagrados") v3("?person"):::projected v2("?religion") a1((" ")) c8(["wd:Q125375"]):::iri c17(["bd:serviceParam"]):::iri c5(["wd:Q5"]):::iri c19(["#91;AUTO_LANGUAGE#93;,en"]):::literal c12(["wd:Q18442817"]):::iri f0[["?numeroConsagrados > '5^^xsd:integer'"]] f0 --> v7 f1[["(?religion = 'wd:Q1841' || ?religion = 'wd:Q9592')"]] f1 --> v2 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v3 --"p:direct/P31"--> c5 a1 --"p:statement/P1598"--> v5 a1 --"p:qualifier/P3831"--> c12 v3 --"p:P1598"--> a1 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v3 --"p:direct/P31"--> c5 v3 --"p:P793"--> v4 v4 --"p:statement/P793"--> c8 v4 --"p:qualifier/P1598"--> v5 end union0r <== or ==> union0l end v3 --"p:direct/P140"--> v2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P18".-> v6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c17 --"wikibase:language"--> c19 end bind4[/"count(?person)"/] v3 --o bind4 bind4 --as--o v7 bind5[/"sample(?imagenConsagrante)"/] v6 --o bind5 bind5 --as--o v7