query-3e10e511af998327485abd9548c3d8a4
Propertiescollection (P195)depicts (P180)creator (P170)time period (P2348)movement (P135)genre (P136)inspired by (P941)made from material (P186)locality of creation (P1071)
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:ScatterChart
SELECT (?count1 AS ?in_Tate) (?count2 AS ?in_Smithsonian) (CONCAT(?propertyLabel,": ",?thingLabel)AS ?attribute) WHERE {
{ SELECT (COUNT(?obj1) AS ?count1) ?property ?thing WHERE {
?obj1 wdt:P195 wd:Q430682. #Tate
VALUES ?prop1 {wdt:P180 wdt:P170 wdt:P2348 wdt:P135 wdt:P136 wdt:P941 wdt:P186 wdt:P1071}
?obj1 ?prop1 ?thing.
?property ?ref ?prop1 ;
rdf:type wikibase:Property .
} GROUP BY ?property ?thing }
{ SELECT (COUNT(?obj2) AS ?count2) ?property ?thing WHERE {
?obj2 wdt:P195 wd:Q1192305. #Smithsonian
VALUES ?prop1 {wdt:P180 wdt:P170 wdt:P2348 wdt:P135 wdt:P136 wdt:P941 wdt:P186 wdt:P1071}
?obj2 ?prop1 ?thing.
?property ?ref ?prop1 ;
rdf:type wikibase:Property .
} GROUP BY ?property ?thing }
FILTER (?count2 >2 )
FILTER (?count1 >2 )
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?property rdfs:label ?propertyLabel .?thing rdfs:label ?thingLabel }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v13("?attribute")
v8("?count1"):::projected
v9("?count2"):::projected
v12("?in_Smithsonian")
v11("?in_Tate")
v3("?obj1")
v8("?obj2")
v9("?prop1")
v6("?property")
v9("?propertyLabel"):::projected
v7("?ref")
v5("?thing")
v10("?thingLabel"):::projected
c8(["bd:serviceParam"]):::iri
c5(["wikibase:Property"]):::iri
c3(["wd:Q430682"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c6(["wd:Q1192305"]):::iri
f0[["?count1 > '2^^xsd:integer'"]]
f0 --> v8
f1[["?count2 > '2^^xsd:integer'"]]
f1 --> v9
v3 --"wdt:P195"--> c3
bind2[/VALUES ?prop1/]
bind2-->v9
bind20(["wdt:P180"])
bind20 --> bind2
bind21(["wdt:P170"])
bind21 --> bind2
bind22(["wdt:P2348"])
bind22 --> bind2
bind23(["wdt:P135"])
bind23 --> bind2
bind24(["wdt:P136"])
bind24 --> bind2
bind25(["wdt:P941"])
bind25 --> bind2
bind26(["wdt:P186"])
bind26 --> bind2
bind27(["wdt:P1071"])
bind27 --> bind2
v3 -->v9--> v5
v6 -->v7--> v9
v6 --"a"--> c5
bind4[/"count(?obj1)"/]
v3 --o bind4
bind4 --as--o v8
v8 --"wdt:P195"--> c6
bind5[/VALUES ?prop1/]
bind5-->v9
bind50(["wdt:P180"])
bind50 --> bind5
bind51(["wdt:P170"])
bind51 --> bind5
bind52(["wdt:P2348"])
bind52 --> bind5
bind53(["wdt:P135"])
bind53 --> bind5
bind54(["wdt:P136"])
bind54 --> bind5
bind55(["wdt:P941"])
bind55 --> bind5
bind56(["wdt:P186"])
bind56 --> bind5
bind57(["wdt:P1071"])
bind57 --> bind5
v8 -->v9--> v5
v6 -->v7--> v9
v6 --"a"--> c5
bind7[/"count(?obj2)"/]
v8 --o bind7
bind7 --as--o v9
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
v6 --"rdfs:label"--> v9
v5 --"rdfs:label"--> v10
end
bind8[/"?count1"/]
v8 --o bind8
bind8 --as--o v11
bind9[/"?count2"/]
v9 --o bind9
bind9 --as--o v12
bind10[/"concat(?propertyLabel,': ',?thingLabel)"/]
v9 --o bind10
v10 --o bind10
bind10 --as--o v13