query-e400d200b9df903e063984e330efcec6
title:Count all external identifiers excluding P214
SELECT (COUNT(*) as ?count) ?n
WHERE
{
?p wikibase:propertyType wikibase:ExternalId .
?p wikibase:directClaim ?wdt .
FILTER( ?wdt != wdt:P214 )
wd:Q11922067 ?wdt [] .
wd:Q11922067 wikibase:identifiers ?n .
}
GROUP BY ?n
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#title:Count all external identifiers excluding P214
SELECT (COUNT(*) as ?count) ?n
WHERE
{
?p wikibase:propertyType wikibase:ExternalId .
?p wikibase:directClaim ?wdt .
FILTER( ?wdt != wdt:P214 )
wd:Q11922067 ?wdt [] .
wd:Q11922067 wikibase:identifiers ?n .
}
GROUP BY ?n
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?count")
v3("?n"):::projected
v2("?p")
v1("?wdt")
a1((" "))
c5(["wd:Q11922067"]):::iri
c3(["wikibase:ExternalId"]):::iri
f0[["?wdt != 'wdt:P214'"]]
f0 --> v1
v2 --"wikibase:propertyType"--> c3
v2 --"wikibase:directClaim"--> v1
c5 -->v1--> a1
c5 --"wikibase:identifiers"--> v3
bind2[/"count(*)"/]
bind2 --as--o v4