Difference between revisions of "Q0.1"

From BITPlan cr Wiki
Jump to navigation Jump to search
Line 12: Line 12:
 
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
 
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
 
SELECT DISTINCT ?proceeding ?volumeNumber ?title  
 
SELECT DISTINCT ?proceeding ?volumeNumber ?title  
   (SAMPLE(?short_name) as ?short_name)
+
   (SAMPLE(?_short_name) as ?short_name)
   (SAMPLE(?pubDate) as ?pubDate)
+
   (SAMPLE(?_pubDate) as ?pubDate)
   (SAMPLE(?ceurwsUrl) as ?ceurwsUrl)
+
   (SAMPLE(?_ceurwsUrl) as ?ceurwsUrl)
   (SAMPLE(?language_of_work_or_name) as ?language_of_work_or_name)
+
   (SAMPLE(?_language_of_work_or_name) as ?language_of_work_or_name)
   (SAMPLE(?fullWorkUrl) as ?fullWorkUrl)
+
   (SAMPLE(?_fullWorkUrl) as ?fullWorkUrl)
   (SAMPLE(?urn) as ?urn)
+
   (SAMPLE(?_urn) as ?urn)
   (SAMPLE(?dblpPublicationId) as ?dblpPublicationId)
+
   (SAMPLE(?_dblpPublicationId) as ?dblpPublicationId)
   (SAMPLE(?K10plus) as ?K10plus)
+
   (SAMPLE(?_K10plus) as ?K10plus)
 
WHERE{
 
WHERE{
 
   ?proceeding wdt:P31 wd:Q1143604.
 
   ?proceeding wdt:P31 wd:Q1143604.
Line 25: Line 25:
 
   ?proceeding p:P179/pq:P478 ?volumeNumber.
 
   ?proceeding p:P179/pq:P478 ?volumeNumber.
 
   ?proceeding wdt:P1476 ?title. Filter(lang(?title)="en")
 
   ?proceeding wdt:P1476 ?title. Filter(lang(?title)="en")
   OPTIONAL{?proceeding wdt:P1813 ?short_name.}
+
   OPTIONAL{?proceeding wdt:P1813 ?_short_name.}
   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:953 ?fullWorkUrl.}
+
   OPTIONAL{?proceeding wdt:953 ?_fullWorkUrl.}
   OPTIONAL{?proceeding wdt:P4109 ?urn.}
+
   OPTIONAL{?proceeding wdt:P4109 ?_urn.}
   OPTIONAL{?proceeding wdt:P8978 ?dblpPublicationId.}
+
   OPTIONAL{?proceeding wdt:P8978 ?_dblpPublicationId.}
   OPTIONAL{?proceeding wdt:P6721 ?K10plus.}
+
   OPTIONAL{?proceeding wdt:P6721 ?_K10plus.}
 
}  
 
}  
 
GROUP BY ?volumeNumber ?proceeding ?title
 
GROUP BY ?volumeNumber ?proceeding ?title
 
ORDER BY DESC(xsd:integer(?volumeNumber))
 
ORDER BY DESC(xsd:integer(?volumeNumber))
|tryiturl=8lfRdW
+
|tryiturl=kfm8ib
|wdqsurl=6UBW
+
|wdqsurl=6UCU
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0

Revision as of 11:22, 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  kfm8ib→kfm8ib
wdqsurl  6UCU→6UCU
scholia  →
relevance  1
comment  
task  Task0→Task0

Freitext