query-8aa1a42ae74c128de071cf81dbbed829
All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50 All popes with number of children SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children) WHERE { ?subj wdt:P22 ?father . ?father wdt:P31 wd:Q5 . ?father wdt:P39 wd:Q19546 . OPTIONAL { ?father wdt:P18 ?picture . } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } GROUP BY ?fatherLabel ORDER BY DESC(?children) LIMIT 50
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# All popes with number of children
SELECT (SAMPLE(?father) as ?father) ?fatherLabel (SAMPLE(?picture) as ?picture) (COUNT(?father) as ?children)
WHERE
{
?subj wdt:P22 ?father .
?father wdt:P31 wd:Q5 .
?father wdt:P39 wd:Q19546 .
OPTIONAL {
?father wdt:P18 ?picture .
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" }
}
GROUP BY ?fatherLabel
ORDER BY DESC(?children)
LIMIT 50
Query found at
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ar
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/be-tarask
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ca
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/cs
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/da
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/de
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en-gb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eo
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eu
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/he
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/hy
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/id
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/it
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ko
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lt
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ms
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pt-br
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ro
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ru
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/si
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/th
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/tr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/uk
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/vec
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/zh