query-64f2653f5dc5668ce68f678c48a9c69a

rq turtle/ttl

People (including mythical/legendary) connected to multiple objects in the Collections

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT (COUNT(?i1) AS ?count_of_objects) ?topic ?topicLabel WHERE {
?i1 wdt:P195/wdt:P361 wd:Q63160499. # Object from Khalili Collections
VALUES ?type {wd:Q5 wd:Q95074 wd:Q64520857 wd:Q4271324 wd:Q13002315 wd:Q178885}
  # human, fictional character, fictional char thought historical mythical character, legendary figure, deity
  ?i1 ?rel1 ?topic . ?topic wdt:P31 ?type . # Object has some sort of connection to the topic
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
} GROUP BY ?topic ?topicLabel
ORDER BY DESC(?count_of_objects)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?count_of_objects") v2("?i1"):::projected v4("?rel1") v5("?topic"):::projected v3("?type") a1((" ")) c6(["bd:serviceParam"]):::iri c3(["wd:Q63160499"]):::iri c8(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 --"wdt:P195"--> a1 a1 --"wdt:P361"--> c3 bind0[/VALUES ?type/] bind0-->v3 bind00(["wd:Q5"]) bind00 --> bind0 bind01(["wd:Q95074"]) bind01 --> bind0 bind02(["wd:Q64520857"]) bind02 --> bind0 bind03(["wd:Q4271324"]) bind03 --> bind0 bind04(["wd:Q13002315"]) bind04 --> bind0 bind05(["wd:Q178885"]) bind05 --> bind0 v2 -->v4--> v5 v5 --"wdt:P31"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c6 --"wikibase:language"--> c8 end bind2[/"count(?i1)"/] v2 --o bind2 bind2 --as--o v6