query-dea98287dcec900a5e3113f31747b6c7
TODO
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?identifier ?identifierValue WHERE {
?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
?identifier wikibase:propertyType wikibase:ExternalId; wikibase:directClaim ?directClaim .
?item ?directClaim ?identifierValue .
FILTER(?identifier != wd:P2091) . # FISA rower ID
FILTER(?identifier != wd:P1447 && ?identifier != wd:P3171 && ?identifier != wd:P3520) . # Sports-Reference.com ID, IOC ID, DatabaseOlympics.com
FILTER(?identifier != wd:P2002 && ?identifier != wd:P2003 && ?identifier != wd:P2013) . # Twitter, instagram, Facebook
FILTER(?identifier != wd:P3682 && ?identifier != wd:P4060 && ?identifier != wd:P4054 && ?identifier != wd:P4053 && ?identifier != wd:P2593 && ?identifier != wd:P4056 && ?identifier != wd:P2323) . # national olympic committees
FILTER(?identifier != wd:P646) . # Freebase
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?directClaim")
v1("?identifier"):::projected
v4("?identifierValue"):::projected
v2("?item"):::projected
a1((" "))
a2((" "))
c24(["bd:serviceParam"]):::iri
c19(["wd:Q26270618"]):::iri
c26(["en"]):::literal
c21(["wikibase:ExternalId"]):::iri
f0[["?identifier != 'wd:P646'"]]
f0 --> v1
f1[["?identifier != 'wd:P3682'?identifier != 'wd:P4060'?identifier != 'wd:P4054'?identifier != 'wd:P4053'?identifier != 'wd:P2593'?identifier != 'wd:P4056'?identifier != 'wd:P2323'"]]
f1 --> v1
f2[["?identifier != 'wd:P2002'?identifier != 'wd:P2003'?identifier != 'wd:P2013'"]]
f2 --> v1
f3[["?identifier != 'wd:P1447'?identifier != 'wd:P3171'?identifier != 'wd:P3520'"]]
f3 --> v1
f4[["?identifier != 'wd:P2091'"]]
f4 --> v1
v2 --"p:P106"--> a1
a1 --"p:statement/P106"--> a2
a2 --"p:direct/P279"--> c19
v1 --"wikibase:propertyType"--> c21
v1 --"wikibase:directClaim"--> v3
v2 -->v3--> v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c24 --"wikibase:language"--> c26
end