Difference between revisions of "Q0.1"

From BITPlan cr Wiki
Jump to navigation Jump to search
Line 11: Line 11:
 
PREFIX p: <http://www.wikidata.org/prop/>
 
PREFIX p: <http://www.wikidata.org/prop/>
 
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
 
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
+
SELECT DISTINCT ?proceeding ?volumeNumber ?title  
SELECT DISTINCT ?proceeding ?volumeNumber ?title ?short_name ?pubDate  
+
  (SAMPLE(?short_name) as ?short_name)
#?language_of_work_or_name  
+
  (SAMPLE(?pubDate) as ?pubDate)
?fullWorkUrl ?urn  
+
  (SAMPLE(?ceurwsUrl) as ?ceurwsUrl)
 +
  (SAMPLE(?language_of_work_or_name) as ?language_of_work_or_name)
 +
  (SAMPLE(?fullWorkUrl) as ?fullWorkUrl)
 +
  (SAMPLE(?urn) as ?urn)
 +
  (SAMPLE(?dblpPublicationId) as ?dblpPublicationId)
 +
  (SAMPLE(?K10plus) as ?K10plus)
 
WHERE{
 
WHERE{
 
   ?proceeding wdt:P31 wd:Q1143604.
 
   ?proceeding wdt:P31 wd:Q1143604.
Line 23: Line 28:
 
   OPTIONAL{?proceeding wdt:P577 ?pubDate.}
 
   OPTIONAL{?proceeding wdt:P577 ?pubDate.}
 
   OPTIONAL{?proceeding wdt:P973 ?ceurwsUrl.}
 
   OPTIONAL{?proceeding wdt:P973 ?ceurwsUrl.}
   #OPTIONAL{?proceeding wdt:P407 ?language_of_work_or_name.}
+
   OPTIONAL{?proceeding wdt:P407 ?language_of_work_or_name.}
   OPTIONAL{?proceeding wdt:P953 ?fullWorkUrl.}
+
   OPTIONAL{?proceeding wdt:953 ?fullWorkUrl.}
 
   OPTIONAL{?proceeding wdt:P4109 ?urn.}
 
   OPTIONAL{?proceeding wdt:P4109 ?urn.}
 +
  OPTIONAL{?proceeding wdt:P8978 ?dblpPublicationId.}
 +
  OPTIONAL{?proceeding wdt:P6721 ?K10plus.}
 
}  
 
}  
ORDER BY DESC(?pubDate)
+
GROUP BY ?volumeNumber ?proceeding ?title
 +
ORDER BY DESC(xsd:integer(?volumeNumber))
 
|tryiturl=8lfRdW
 
|tryiturl=8lfRdW
|wdqsurl=6UC4
+
|wdqsurl=6UBW
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0

Revision as of 10:18, 21 March 2023

Query

Query
edit
id  1
name  
title  All proceedings
description  List all proceedings
sparql  
# Q0.1
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 ?proceeding ?volumeNumber ?title 
  (SAMPLE(?short_name) as ?short_name)
  (SAMPLE(?pubDate) as ?pubDate)
  (SAMPLE(?ceurwsUrl) as ?ceurwsUrl)
  (SAMPLE(?language_of_work_or_name) as ?language_of_work_or_name)
  (SAMPLE(?fullWorkUrl) as ?fullWorkUrl)
  (SAMPLE(?urn) as ?urn)
  (SAMPLE(?dblpPublicationId) as ?dblpPublicationId)
  (SAMPLE(?K10plus) as ?K10plus)
WHERE{
  ?proceeding wdt:P31 wd:Q1143604.
  ?proceeding wdt:P179 wd:Q27230297.
  ?proceeding p:P179/pq:P478 ?volumeNumber.
  ?proceeding wdt:P1476 ?title. Filter(lang(?title)="en")
  OPTIONAL{?proceeding wdt:P1813 ?short_name.}
  OPTIONAL{?proceeding wdt:P577 ?pubDate.}
  OPTIONAL{?proceeding wdt:P973 ?ceurwsUrl.}
  OPTIONAL{?proceeding wdt:P407 ?language_of_work_or_name.}
  OPTIONAL{?proceeding wdt:953 ?fullWorkUrl.}
  OPTIONAL{?proceeding wdt:P4109 ?urn.}
  OPTIONAL{?proceeding wdt:P8978 ?dblpPublicationId.}
  OPTIONAL{?proceeding wdt:P6721 ?K10plus.}
} 
GROUP BY ?volumeNumber ?proceeding ?title
ORDER BY DESC(xsd:integer(?volumeNumber))
tryiturl  8lfRdW→kfm8ib
wdqsurl  6UBW→6UCU
scholia  →
relevance  1
comment  
task  Task0→Task0

Freitext