query-be62114304afa957f3a2036ce1bcdc88
Esportistes per nombre de sitelinks SELECT DISTINCT ?person ?personLabel ?sitelinks WITH { SELECT * WHERE { ?person wdt:P31 wd:Q5. ?person wdt:P106/wdt:P279* wd:Q2066131. ?person wikibase:sitelinks ?sitelinks. #FILTER (?sitelinks > 110) } ORDER BY desc(?sitelinks) LIMIT 100 } AS %i WHERE { INCLUDE %i SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } } ORDER BY desc(?sitelinks)
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#>
# Esportistes per nombre de sitelinks
SELECT DISTINCT ?person ?personLabel ?sitelinks
WHERE {
{
SELECT *
WHERE {
?person wdt:P31 wd:Q5.
?person wdt:P106/wdt:P279* wd:Q2066131.
?person wikibase:sitelinks ?sitelinks.
#FILTER (?sitelinks > 110)
}
ORDER BY desc(?sitelinks)
LIMIT 100
} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY desc(?sitelinks)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?person"):::projected
v1("?sitelinks"):::projected
a1((" "))
c8(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c5(["wd:Q2066131"]):::iri
v2 --"wdt:P31"--> c2
v2 --"wdt:P106"--> a1
a1 --"wdt:P279"--> c5
v2 --"wikibase:sitelinks"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end