query-179a0c5c9f3ff9ec5ef2358eeeba5444

Count of links from Jameel items to items that have a location

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT (COUNT(?loc) as ?count) WHERE {
?item wdt:P195 wd:Q636400; wdt:P973 ?url FILTER (STRSTARTS(STR(?url),"http://jameelcentre") ).
?item ?prop ?loc. ?loc wdt:P625 [] FILTER (?loc != wd:Q636400)
}

Query found at

https://www.wikidata.org/wiki/User:MartinPoulter/queries/collections

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count") v3("?item") v1("?loc"):::projected v4("?prop") v2("?url") a1((" ")) c1(["wd:Q636400"]):::iri f0[["?loc != 'wd:Q636400'"]] f0 --> v1 f1[["starts-with(str(?url),'http://jameelcentre')"]] f1 --> v2 v3 --"wdt:P195"--> c1 v3 --"wdt:P973"--> v2 v3 -->v4--> v1 v1 --"wdt:P625"--> a1 bind3[/"count(?loc)"/] v1 --o bind3 bind3 --as--o v5