Difference between revisions of "Q0.3"

From BITPlan cr Wiki
Jump to navigation Jump to search
Line 51: Line 51:
 
|storemode=property
 
|storemode=property
 
}}
 
}}
=Freitext=
 

Revision as of 14:01, 21 March 2023

Query

Query
edit
id  3
name  AllEvents
title  All events
description  List all proceeding events for proceedings published via CEUR-WS
sparql  
# Q0.3 List of all events
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT DISTINCT ?event 
  (SAMPLE(?_title) as ?title)  
  (SAMPLE(?_acronym) as ?acronym) 
  (SAMPLE(?_startTime) as ?startTime) 
  (SAMPLE(?_endTime) as ?endTime)
  (SAMPLE(?_country) as ?country) 
  (SAMPLE(?_location) as ?location) 
  (SAMPLE(?_officialWebsite) as ?officialWebsite) 
  (GROUP_CONCAT(?_instanceOf) as ?instanceOf) 
  (SAMPLE(?_colocatedWith) as ?colocatedWith) 
  (SAMPLE(?_dblpEventId) as ?dblpEventId) 
  (SAMPLE(?_series) as ?series) 
  (SAMPLE(?_ordinal) as ?ordinal)
WHERE{
  ?proceeding wdt:P31 wd:Q1143604.
  ?proceeding wdt:P179 wd:Q27230297.
  ?proceeding p:P179/pq:P478 ?volumeNumber.
  ?proceeding wdt:P4745 ?event.
  OPTIONAL{?event wdt:P1476 ?_title. Filter(lang(?_title)="en")} 
  OPTIONAL{?event wdt:P580 ?_startTime.} 
  OPTIONAL{?event wdt:P582 ?_endTime.} 
  OPTIONAL{?event wdt:P17 ?_country.} 
  OPTIONAL{?event wdt:location ?_location.} 
  OPTIONAL{?event wdt:P856 ?_officialWebsite.} 
  OPTIONAL{?event wdt:P31 ?_instanceOf.} 
  OPTIONAL{?event wdt:P1813 ?_acronym.} 
  OPTIONAL{?event wdt:P11633 ?_colocatedWith.} 
  OPTIONAL{?event wdt:P10692 ?_dblpEventId.} 
  OPTIONAL{?event wdt:P179 ?_series.} 
  OPTIONAL{?event p:P179/pq:P1545 ?_ordinal.} 
}
GROUP BY ?event
ORDER BY DESC(?startTime)
tryiturl  hdZ426→Bww8ip
wdqsurl  6UDZ→6UKq
scholia  →
relevance  1
comment  
task  Task0→Task0