query-880382ad97ad15aad26b86416eebefa6
Commonswiki link and P935 Jklamo: Request date: 18 September 2017, byLink to discussions justifying the requestWikidata:Project_chat#Updated numbersTask description: (P935)Commons gallery In situation of item, that is not category item, has sitelink to commons gallery but has not
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT ?item ?sitelink {
?item ^schema:about [ schema:isPartOf <https://commons.wikimedia.org/>; schema:name ?sitelink ] .
MINUS { ?item wdt:P31 wd:4167836 } .
MINUS { FILTER(CONTAINS(STR(?sitelink), "Category:")) } .
MINUS { ?item wdt:P935 [] } .
} LIMIT 1000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?item"):::projected
v1("?sitelink"):::projected
a2((" "))
a1((" "))
c2([https://commons.wikimedia.org/]):::iri
c6(["wd:4167836"]):::iri
a1 --"schema:isPartOf"--> c2
a1 --"schema:name"--> v1
a1 --"schema:about"--> v2
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P31"--> c6
end
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
f2[["contains(str(?sitelink),'Category:')"]]
f2 --> v1
end
subgraph minus3["MINUS"]
style minus3 stroke-width:6px,fill:pink,stroke:red;
v2 --"wdt:P935"--> a2
end