query-799a4a3b37a027d6e377c686faa27508

rq turtle/ttl

Non-single identifiers

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/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?identifier (COUNT(?value) AS ?cnt) (GROUP_CONCAT(?value; separator=', ') AS ?values) WHERE {
   {
  SELECT DISTINCT ?item WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  }
}
  ?identifier wikibase:propertyType wikibase:ExternalId; wikibase:claim ?identifierClaim; wikibase:statementProperty ?identifierStatementProperty; wikibase:reference ?ref .
  ?item ?identifierClaim [ ?identifierStatementProperty ?value ] .
} GROUP BY ?item ?identifier HAVING(?cnt > 1) ORDER BY DESC(?cnt)

Query found at

• https://www.wikidata.org/wiki/User:MisterSynergy/rowing/queries