query-795c916bf04de7da76f57fd944b0cc3e
event management(Potenital) duplicates:
Use at
- https://query.wikidata.org/sparql
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