query-3e10e511af998327485abd9548c3d8a4

rq turtle/ttl

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

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