query-0ec76aeebdc0a245f13840320c55ca44
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT
?person ?personLabel ?sexgenderLabel ?sportLabel ?citizenshipLabel
WHERE
{
{ SELECT DISTINCT ?person ?sexgender (GROUP_CONCAT(DISTINCT STR(?sportLabel_);separator="; ") as ?sportLabel) (GROUP_CONCAT(DISTINCT STR(?citizenshipLabel_);separator="; ") as ?citizenshipLabel)
WHERE {
{ SELECT DISTINCT ?person
WHERE { ?person wdt:P3171 ?value .
?person wikibase:statements ?statements .
FILTER (?statements > 50) . }
}
{ ?person wdt:P21 ?sexgender . }
{ ?person wdt:P2416 ?sport . ?sport rdfs:label ?sportLabel_ . filter(lang(?sportLabel_)="en") }
{ ?person wdt:P27 ?citizenship . ?citizenship rdfs:label ?citizenshipLabel_ . filter(lang(?citizenshipLabel_)="en") }
} GROUP BY ?person ?sexgender } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .
?person rdfs:label ?personLabel .
?sexgender rdfs:label ?sexgenderLabel . }
} GROUP BY ?person ?personLabel ?sexgenderLabel ?sportLabel ?citizenshipLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v8("?citizenship")
v10("?citizenshipLabel"):::projected
v7("?citizenshipLabel_")
v2("?person"):::projected
v11("?personLabel"):::projected
v4("?sexgender")
v12("?sexgenderLabel"):::projected
v6("?sport")
v9("?sportLabel"):::projected
v5("?sportLabel_")
v1("?statements")
v3("?value")
c10(["bd:serviceParam"]):::iri
c5(["en"]):::literal
f0[["?statements > '50^^xsd:integer'"]]
f0 --> v1
v2 --"wdt:P3171"--> v3
v2 --"wikibase:statements"--> v1
v2 --"wdt:P21"--> v4
f1[["?sportLabel_ = 'en'"]]
f1 --> v5
v2 --"wdt:P2416"--> v6
v6 --"rdfs:label"--> v5
f2[["?citizenshipLabel_ = 'en'"]]
f2 --> v7
v2 --"wdt:P27"--> v8
v8 --"rdfs:label"--> v7
bind5[/"str(?sportLabel_)"/]
v5 --o bind5
bind5 --as--o v9
bind6[/"str(?citizenshipLabel_)"/]
v7 --o bind6
bind6 --as--o v10
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c5
v2 --"rdfs:label"--> v11
v4 --"rdfs:label"--> v12
end