query-b7b15c187b54f4f3c8fbb5c4f28d7874

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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT 
  (ROUND(10000 * ?mean_acceptance_rate) / 100 AS ?mean_acceptance_percentage)
  ?track ?trackLabel
  ?event_series ?event_seriesLabel
  (CONCAT("#scientificeventseries/", SUBSTR(STR(?event_series), 32)) AS ?event_seriesUrl)
WHERE {
   {
  SELECT 
    (SUM(?acceptance_rate)/COUNT(?acceptance_rate) AS ?mean_acceptance_rate)
    ?event_series
    ?track
  WHERE {
    ?event_series wdt:P31 / wdt:P279* wd:Q125391566 .
    ?event wdt:P179 ?event_series ;
           p:P5822 ?acceptance_rate_statement .
    ?acceptance_rate_statement ps:P5822 ?acceptance_rate .
    OPTIONAL { ?acceptance_rate_statement pq:P518 ?track_ . }
    BIND(COALESCE(?track_, "-") AS ?track)
    BIND(STR(YEAR(?datetime)) AS ?year)
  }
  GROUP BY ?event_series ?track
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?mean_acceptance_rate

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v9("?_anon_d00291b7e9a143df8ec0be8c8ebd714c58616") v10("?_anon_d00291b7e9a143df8ec0be8c8ebd714c58617") v5("?acceptance_rate") v4("?acceptance_rate_statement") v3("?event") v2("?event_series"):::projected v12("?event_seriesUrl") v11("?mean_acceptance_percentage") v11("?mean_acceptance_rate"):::projected v7("?track"):::projected v6("?track_") v8("?year") a1((" ")) c3(["wd:Q125391566"]):::iri c9(["bd:serviceParam"]):::iri c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c3 v3 --"p:direct/P179"--> v2 v3 --"p:P5822"--> v4 v4 --"p:statement/P5822"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:qualifier/P518".-> v6 end bind0[/"?track_'-'"/] v6 --o bind0 bind0 --as--o v7 bind1[/"str(year-from-dateTime(?datetime))"/] null --o bind1 bind1 --as--o v8 bind4[/"sum(?acceptance_rate)"/] v5 --o bind4 bind4 --as--o v9 bind5[/"count(?acceptance_rate)"/] v5 --o bind5 bind5 --as--o v10 bind6[/" / "/] null --o bind6 null --o bind6 bind6 --as--o v11 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end bind7[/"numeric-round('10000^^xsd:integer' * ?mean_acceptance_rate) / '100^^xsd:integer'"/] v11 --o bind7 bind7 --as--o v11 bind8[/"concat('#scientificeventseries/',substring(str(?event_series),'32^^xsd:integer'))"/] v2 --o bind8 bind8 --as--o v12