Difference between revisions of "Q0.3"

From BITPlan cr Wiki
Jump to navigation Jump to search
(Created page with "=Query= {{Query |id=3 |title=All events |description=List all proceeding events for proceedings published via CEUR-WS |sparql= |tryiturl= |wdqsurl= |relevance=1 |task=Task0 |...")
 
Line 5: Line 5:
 
|title=All events
 
|title=All events
 
|description=List all proceeding events for proceedings published via CEUR-WS
 
|description=List all proceeding events for proceedings published via CEUR-WS
|sparql=
+
|sparql=# Q0.3 List of all events
|tryiturl=
+
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
|wdqsurl=
+
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)
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0

Revision as of 11:22, 21 March 2023

Query

Query
edit
id  3
name  
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  →Bww8ip
wdqsurl  →6UKq
scholia  →
relevance  1
comment  
task  Task0→Task0

Freitext