query-293230efa1cf3f71d177cb61db42bc43

rq turtle/ttl

Number of accepted contributions

Use at

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 
  ?accepted

  ?track ?trackLabel

  ?event ?eventLabel
  (CONCAT("#scientificevent/", SUBSTR(STR(?event), 32)) AS ?eventUrl)
  ?eventDescription
WHERE {
  ?event wdt:P31 / wdt:P279* wd:Q52260246 ;
         p:P12649 ?accepted_statement .
  ?accepted_statement ps:P12649 ?accepted .
  OPTIONAL { ?accepted_statement pq:P518 ?track_ }
  BIND(COALESCE(?track_, "-") AS ?track)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?accepted)
LIMIT 500

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?accepted"):::projected v3("?accepted_statement") v2("?event"):::projected v6("?eventUrl") v5("?track"):::projected v4("?track_") a1((" ")) c8(["bd:serviceParam"]):::iri c3(["wd:Q52260246"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c3 v2 --"p:P12649"--> v3 v3 --"p:statement/P12649"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P518".-> v4 end bind0[/"?track_'-'"/] v4 --o bind0 bind0 --as--o v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end bind1[/"concat('#scientificevent/',substring(str(?event),'32^^xsd:integer'))"/] v2 --o bind1 bind1 --as--o v6