query-9885a951a075f0ed7c17605dadc1b3fe
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel ?source_qid ?source_label WHERE {
VALUES ?item {wd:Q46951799 wd:Q46975025 wd:Q46976206 wd:Q46976611 wd:Q46998339 wd:Q46998368 wd:Q46998374 wd:Q46998381 wd:Q46998397 wd:Q47004153 wd:Q47006402 wd:Q47008525 wd:Q47008705 wd:Q47008741 wd:Q47008958 wd:Q47010885 wd:Q47011175 wd:Q47011275 wd:Q47014250 wd:Q47038396 wd:Q47072983 wd:Q47073011 wd:Q47073013 wd:Q47073016 wd:Q47073021 wd:Q47089651 wd:Q47137276 wd:Q47159674 wd:Q47212035 wd:Q47212148 wd:Q47215384 wd:Q47216171 wd:Q47314015 wd:Q47326250 wd:Q47365265 wd:Q47415031 wd:Q47415676 wd:Q47424623 wd:Q47450958 wd:Q47450979 wd:Q47451002 wd:Q47451049 wd:Q47451078 wd:Q47460105 wd:Q47460122 wd:Q47460142 wd:Q47460174 wd:Q47463254 wd:Q47463331 wd:Q47463825 wd:Q47463828 wd:Q47463841 wd:Q47463849 wd:Q47468023 wd:Q47469120 wd:Q47481343 wd:Q47481513 wd:Q47482383}
?property wikibase:claim ?p; wikibase:statementProperty ?ps .
?item ?p [ ?ps ?value; prov:wasDerivedFrom [ pr:P248 ?source_qid ] ] .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en".}
?source_qid rdfs:label ?source_label . FILTER(LANG(?source_label) = 'en') .
FILTER(CONTAINS(str(?source_label), "Oxford") ) .
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v4("?p")
v3("?property"):::projected
v5("?ps")
v1("?source_label"):::projected
v7("?source_qid"):::projected
v6("?value"):::projected
a1((" "))
a2((" "))
c8(["bd:serviceParam"]):::iri
c2(["en"]):::literal
f0[["contains(str(?source_label),'Oxford')"]]
f0 --> v1
f1[["?source_label = 'en'"]]
f1 --> v1
bind2[/VALUES ?item/]
bind2-->v2
bind20(["wd:Q46951799"])
bind20 --> bind2
bind21(["wd:Q46975025"])
bind21 --> bind2
bind22(["wd:Q46976206"])
bind22 --> bind2
bind23(["wd:Q46976611"])
bind23 --> bind2
bind24(["wd:Q46998339"])
bind24 --> bind2
bind25(["wd:Q46998368"])
bind25 --> bind2
bind26(["wd:Q46998374"])
bind26 --> bind2
bind27(["wd:Q46998381"])
bind27 --> bind2
bind28(["wd:Q46998397"])
bind28 --> bind2
bind29(["wd:Q47004153"])
bind29 --> bind2
bind210(["wd:Q47006402"])
bind210 --> bind2
bind211(["wd:Q47008525"])
bind211 --> bind2
bind212(["wd:Q47008705"])
bind212 --> bind2
bind213(["wd:Q47008741"])
bind213 --> bind2
bind214(["wd:Q47008958"])
bind214 --> bind2
bind215(["wd:Q47010885"])
bind215 --> bind2
bind216(["wd:Q47011175"])
bind216 --> bind2
bind217(["wd:Q47011275"])
bind217 --> bind2
bind218(["wd:Q47014250"])
bind218 --> bind2
bind219(["wd:Q47038396"])
bind219 --> bind2
bind220(["wd:Q47072983"])
bind220 --> bind2
bind221(["wd:Q47073011"])
bind221 --> bind2
bind222(["wd:Q47073013"])
bind222 --> bind2
bind223(["wd:Q47073016"])
bind223 --> bind2
bind224(["wd:Q47073021"])
bind224 --> bind2
bind225(["wd:Q47089651"])
bind225 --> bind2
bind226(["wd:Q47137276"])
bind226 --> bind2
bind227(["wd:Q47159674"])
bind227 --> bind2
bind228(["wd:Q47212035"])
bind228 --> bind2
bind229(["wd:Q47212148"])
bind229 --> bind2
bind230(["wd:Q47215384"])
bind230 --> bind2
bind231(["wd:Q47216171"])
bind231 --> bind2
bind232(["wd:Q47314015"])
bind232 --> bind2
bind233(["wd:Q47326250"])
bind233 --> bind2
bind234(["wd:Q47365265"])
bind234 --> bind2
bind235(["wd:Q47415031"])
bind235 --> bind2
bind236(["wd:Q47415676"])
bind236 --> bind2
bind237(["wd:Q47424623"])
bind237 --> bind2
bind238(["wd:Q47450958"])
bind238 --> bind2
bind239(["wd:Q47450979"])
bind239 --> bind2
bind240(["wd:Q47451002"])
bind240 --> bind2
bind241(["wd:Q47451049"])
bind241 --> bind2
bind242(["wd:Q47451078"])
bind242 --> bind2
bind243(["wd:Q47460105"])
bind243 --> bind2
bind244(["wd:Q47460122"])
bind244 --> bind2
bind245(["wd:Q47460142"])
bind245 --> bind2
bind246(["wd:Q47460174"])
bind246 --> bind2
bind247(["wd:Q47463254"])
bind247 --> bind2
bind248(["wd:Q47463331"])
bind248 --> bind2
bind249(["wd:Q47463825"])
bind249 --> bind2
bind250(["wd:Q47463828"])
bind250 --> bind2
bind251(["wd:Q47463841"])
bind251 --> bind2
bind252(["wd:Q47463849"])
bind252 --> bind2
bind253(["wd:Q47468023"])
bind253 --> bind2
bind254(["wd:Q47469120"])
bind254 --> bind2
bind255(["wd:Q47481343"])
bind255 --> bind2
bind256(["wd:Q47481513"])
bind256 --> bind2
bind257(["wd:Q47482383"])
bind257 --> bind2
v3 --"wikibase:claim"--> v4
v3 --"wikibase:statementProperty"--> v5
a1 -->v5--> v6
a2 --"pr:P248"--> v7
a1 --"prov:wasDerivedFrom"--> a2
v2 -->v4--> a1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c2
end
v7 --"rdfs:label"--> v1