query-561812bfd49af6b2199e9777784c2eaf

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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?identifier ?identifierLabel (COUNT(*) AS ?cnt) WHERE {
   {
  SELECT DISTINCT ?item WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 .
  }
}.
  ?identifier wikibase:propertyType wikibase:ExternalId; wikibase:directClaim ?directClaim .
  ?item ?directClaim ?identifierValue .
  FILTER(?identifier != wd:P2091) . # FISA rower ID
  FILTER(?identifier NOT IN (wd:P1447, wd:P3171, wd:P3520, wd:P5815, wd:P4391)) . # Sports-Reference.com ID, IOC ID, DatabaseOlympics.com, Olympic Channel, TheSports
  FILTER(?identifier NOT IN (wd:P2002, wd:P2003, wd:P2013, wd:P2397, wd:P3185, wd:P4015)) . # Twitter, instagram, Facebook, youtube channel, vKontakte, vimeo
  FILTER(?identifier NOT IN (wd:P3682, wd:P4060, wd:P4054, wd:P4053, wd:P2593, wd:P4056, wd:P2323, wd:P4062, wd:P4068, wd:P4069, wd:P4490, wd:P4067, wd:P4050, wd:P6071, wd:P4061, wd:P4547)) . # national olympic committees
  FILTER(?identifier != wd:P646) . # Freebase

  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} GROUP BY ?identifier ?identifierLabel ORDER BY DESC (?cnt)

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?cnt") v4("?directClaim") v2("?identifier"):::projected v5("?identifierValue") v3("?item") a1((" ")) a2((" ")) c38(["bd:serviceParam"]):::iri c33(["wd:Q26270618"]):::iri c40(["en"]):::literal c35(["wikibase:ExternalId"]):::iri f0[["?identifier != 'wd:P646'"]] f0 --> v2 f1[["?identifier != 'wd:P3682'?identifier != 'wd:P4060'?identifier != 'wd:P4054'?identifier != 'wd:P4053'?identifier != 'wd:P2593'?identifier != 'wd:P4056'?identifier != 'wd:P2323'?identifier != 'wd:P4062'?identifier != 'wd:P4068'?identifier != 'wd:P4069'?identifier != 'wd:P4490'?identifier != 'wd:P4067'?identifier != 'wd:P4050'?identifier != 'wd:P6071'?identifier != 'wd:P4061'?identifier != 'wd:P4547'"]] f1 --> v2 f2[["?identifier != 'wd:P2002'?identifier != 'wd:P2003'?identifier != 'wd:P2013'?identifier != 'wd:P2397'?identifier != 'wd:P3185'?identifier != 'wd:P4015'"]] f2 --> v2 f3[["?identifier != 'wd:P1447'?identifier != 'wd:P3171'?identifier != 'wd:P3520'?identifier != 'wd:P5815'?identifier != 'wd:P4391'"]] f3 --> v2 f4[["?identifier != 'wd:P2091'"]] f4 --> v2 v3 --"p:P106"--> a1 a1 --"p:statement/P106"--> a2 a2 --"p:direct/P279"--> c33 v2 --"wikibase:propertyType"--> c35 v2 --"wikibase:directClaim"--> v4 v3 -->v4--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c38 --"wikibase:language"--> c40 end bind6[/"count(*)"/] bind6 --as--o v6