query-7fcd5698caea0bab4b89232993492ae0

rq turtle/ttl

Edition IDs in non-edition items SELECT ?p ?site WHERE { ?p p:P648 [ps:P648 ?site]. filter(contains(str(?site),"M")) MINUS { ?p wdt:P31 wd:Q3331189 . } }

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
#Edition IDs in non-edition items
SELECT ?p ?site WHERE {
  ?p p:P648 [ps:P648 ?site].
  filter(contains(str(?site),"M"))
  MINUS { ?p wdt:P31 wd:Q3331189 . }
}

Query found at

https://www.wikidata.org/wiki/Property_talk:P648

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?p"):::projected v1("?site"):::projected a1((" ")) c5(["wd:Q3331189"]):::iri f0[["contains(str(?site),'M')"]] f0 --> v1 a1 --"p:statement/P648"--> v1 v2 --"p:P648"--> a1 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"p:direct/P31"--> c5 end