query-799b2d93a5d7ad8943ac6d193165f464
title:Wikidata properties excluding external IDs SELECT ?id ?idLabel ?idDescription ?new{ ?id wikibase:directClaim ?pid . minus{?id wikibase:propertyType wikibase:ExternalId} BIND(Replace(STR(?id),"http://www.wikidata.org/entity/P"," ") as ?new) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } ORDER BY DESC(xsd:integer(?new))
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Wikidata properties excluding external IDs
SELECT ?id ?idLabel ?idDescription ?new{
?id wikibase:directClaim ?pid .
minus{?id wikibase:propertyType wikibase:ExternalId}
BIND(Replace(STR(?id),"http://www.wikidata.org/entity/P"," ") as ?new)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY DESC(xsd:integer(?new))
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?id"):::projected
v4("?new"):::projected
v3("?pid")
c5(["bd:serviceParam"]):::iri
c7(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c3(["wikibase:ExternalId"]):::iri
v2 --"wikibase:directClaim"--> v3
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v2 --"wikibase:propertyType"--> c3
end
bind1[/"replace(str(?id),'http://www.wikidata.org/entity/P',' ')"/]
v2 --o bind1
bind1 --as--o v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end