Q0.1: Difference between revisions

From BITPlan cr Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
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 09: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