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