query-2f1b1dab73bb69674fcae53a0991dc86
Items needing URL match addingThis SPARQL needs refing so as to filter out troublesome URLs suchas those that need transformation (using something on toolforge) but it'll do for now
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?x ?xLabel ?fmt {
?x wikibase:propertyType wikibase:ExternalId.
?x wdt:P1630 ?fmt;
filter not exists {?x wdt:P8966 []}
FILTER (!regex(?fmt, "web.archive.org","i"))
FILTER (!regex(?fmt, "toolforge.org","i"))
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} limit 50
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?fmt"):::projected
v2("?x"):::projected
a1((" "))
c9(["bd:serviceParam"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c6(["wikibase:ExternalId"]):::iri
f0[["not regex(?fmt,'toolforge.org','i')"]]
f0 --> v1
f1[["not regex(?fmt,'web.archive.org','i')"]]
f1 --> v1
f2[["not "]]
subgraph f2e0["Exists Clause"]
e0v1 --"wdt:P8966"--> e0a1
e0v1("?x"):::projected
e0a1((" ")):::projected
end
f2--EXISTS--> f2e0
f2 --> v2
f2 --> c4
f2 --> a1
v2 --"wdt:P8966"--> a1
v2 --"wikibase:propertyType"--> c6
v2 --"wdt:P1630"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end