query-795c916bf04de7da76f57fd944b0cc3e

rq turtle/ttl

event management(Potenital) duplicates:

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?tournament ?cclabel (GROUP_CONCAT(SUBSTR(STR(?event), 32); separator=', ') AS ?events) (COUNT(*) AS ?cnt) WHERE {
  ?event wdt:P31 wd:Q46190676; wdt:P361 ?tournament; wdt:P2094 ?cc . ?cc p:P2094 [ ps:P2094 wd:Q2735683; pq:P1013 wd:Q185836 ]; rdfs:label ?cclabel .
  FILTER(LANG(?cclabel) = 'en') .
  ?tournament wdt:P31 wd:Q47345468 .
} GROUP BY ?tournament ?cclabel HAVING (?cnt > 1 )

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?cc") v2("?cclabel"):::projected v7("?cnt") v3("?event"):::projected v6("?events") v4("?tournament"):::projected a1((" ")) c10(["wd:Q185836"]):::iri c8(["wd:Q2735683"]):::iri c4(["wd:Q46190676"]):::iri c13(["wd:Q47345468"]):::iri f0[["?cnt > '1^^xsd:integer'"]] f0 --> v7 f1[["?cclabel = 'en'"]] f1 --> v2 v3 --"p:direct/P31"--> c4 v3 --"p:direct/P361"--> v4 v3 --"p:direct/P2094"--> v5 a1 --"p:statement/P2094"--> c8 a1 --"p:qualifier/P1013"--> c10 v5 --"p:P2094"--> a1 v5 --"rdfs:label"--> v2 v4 --"p:direct/P31"--> c13 bind4[/"substring(str(?event),'32^^xsd:integer')"/] v3 --o bind4 bind4 --as--o v6 bind5[/"count(*)"/] bind5 --as--o v7