query-645bff21f5f4dff122eb2f9b1b801fc1
participants ... SELECT ?e (COUNT(DISTINCT ?event) as ?events) WHERE { SELECT ?e ?event ?date WHERE { VALUES (?e ?event ?date) { ("James" "Belgium" "70") ("Mary" "worldwide" "71") ("Mary" "worldwide" "72") ("Mary" "worldwide" "73") ("Mary" "France" "76") } } } GROUP BY ?e # with at least 2 different competitions HAVING(?events>1) # () are mandatory here too
Use at
- https://query.wikidata.org/sparql
# participants ...
SELECT ?e (COUNT(DISTINCT ?event) as ?events) WHERE
{
SELECT ?e ?event ?date WHERE {
VALUES (?e ?event ?date) {
("James" "Belgium" "70")
("Mary" "worldwide" "71")
("Mary" "worldwide" "72")
("Mary" "worldwide" "73")
("Mary" "France" "76")
}
}
}
GROUP BY ?e
# with at least 2 different competitions
HAVING(?events>1) # () are mandatory here too
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?date")
v2("?e"):::projected
v3("?event"):::projected
v5("?events")
f0[["?events > '1^^xsd:integer'"]]
f0 --> v5
bind1[/VALUES ?date ?e ?event/]
bind1-->v2
bind1-->v3
bind1-->v4
bind10(["James"])
bind10 --> bind1
bind11(["Belgium"])
bind11 --> bind1
bind12(["70"])
bind12 --> bind1
bind13(["Mary"])
bind13 --> bind1
bind14(["worldwide"])
bind14 --> bind1
bind15(["71"])
bind15 --> bind1
bind16(["Mary"])
bind16 --> bind1
bind17(["worldwide"])
bind17 --> bind1
bind18(["72"])
bind18 --> bind1
bind19(["Mary"])
bind19 --> bind1
bind110(["worldwide"])
bind110 --> bind1
bind111(["73"])
bind111 --> bind1
bind112(["Mary"])
bind112 --> bind1
bind113(["France"])
bind113 --> bind1
bind114(["76"])
bind114 --> bind1
bind3[/"count(?event)"/]
v3 --o bind3
bind3 --as--o v5