query-1a3044524db6e2bebbdc7ffc56832def
I would like to ask you if the two following improvements are possible: , e.g. excluding all the values of P214 and P1871 from countexcept one or more specific properties, all the external identifiers (Q11922067)Philumenus obtain a query asking to count, in (i.e. counting P8034 one time instead of three times, P227 one time instead of two times etc.)only once, all the external identifiers (Q11922067)Philumenus obtain a query asking to count, in 07:23, 1 April 2021 (UTC) dosisEpìThank you very much! -- ?n GROUP BY } . ?n identifiers:wikibase Q11922067:wd . [] ?wdt Q11922067:wd . ?wdt directClaim:wikibase ?p . ExternalId:wikibase propertyType:wikibase ?p { WHERE ?n )?count as )?wdt DISTINCT(COUNT( SELECT
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/>
SELECT (COUNT(*) as ?count) ?n
WHERE
{
?p wikibase:propertyType wikibase:ExternalId .
?p wikibase:directClaim ?wdt .
FILTER( ?wdt != wdt:P214 )
FILTER( ?wdt != wdt:P1871 )
wd:Q11922067 ?wdt [] .
wd:Q11922067 wikibase:identifiers ?n .
}
GROUP BY ?n
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?count")
v3("?n"):::projected
v2("?p")
v1("?wdt")
a1((" "))
c6(["wd:Q11922067"]):::iri
c4(["wikibase:ExternalId"]):::iri
f0[["?wdt != 'wdt:P1871'"]]
f0 --> v1
f1[["?wdt != 'wdt:P214'"]]
f1 --> v1
v2 --"wikibase:propertyType"--> c4
v2 --"wikibase:directClaim"--> v1
c6 -->v1--> a1
c6 --"wikibase:identifiers"--> v3
bind3[/"count(*)"/]
bind3 --as--o v4