Difference between revisions of "Q1.11"

From BITPlan cr Wiki
Jump to navigation Jump to search
(Created page with "=Query= {{Query |id=11 |title=Number of Editions of workshop series |description=Determine the number of editions that the workshop series titled T has had, regardless of whe...")
 
Line 5: Line 5:
 
|title=Number of Editions of workshop series
 
|title=Number of Editions of workshop series
 
|description=Determine the number of editions that the workshop series titled T has had, regardless of whether published with CEUR-WS.org.
 
|description=Determine the number of editions that the workshop series titled T has had, regardless of whether published with CEUR-WS.org.
|sparql=SELECT DISTINCT ?series ?seriesLabel (Count(DISTINCT ?event2)as ?number_of_events)
+
|sparql=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 ?series ?seriesLabel (Count(DISTINCT ?event2)as ?number_of_events)
 
WHERE{
 
WHERE{
 
   ?proceedings wdt:P31 wd:Q1143604;
 
   ?proceedings wdt:P31 wd:Q1143604;
Line 16: Line 21:
 
}
 
}
 
GROUP BY ?series ?seriesLabel
 
GROUP BY ?series ?seriesLabel
 +
ORDER BY DESC(?number_of_events)
 +
|tryiturl=uVEk8R
 
|since=2015-08-25
 
|since=2015-08-25
 
|task=Task1
 
|task=Task1

Revision as of 12:06, 19 March 2023

Query

Query
edit
id  11
name  
title  Number of Editions of workshop series
description  Determine the number of editions that the workshop series titled T has had, regardless of whether published with CEUR-WS.org.
sparql  
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 ?series ?seriesLabel (Count(DISTINCT ?event2)as ?number_of_events)
WHERE{
  ?proceedings wdt:P31 wd:Q1143604;
               wdt:P179 wd:Q27230297;
               p:P179/pq:P478 ?volume_number;
               wdt:P4745 ?event.
  ?event wdt:P179 ?series.
  ?event2 wdt:P179 ?series.
  ?series rdfs:label ?seriesLabel. FILTER(lang(?seriesLabel)="en")
}
GROUP BY ?series ?seriesLabel
ORDER BY DESC(?number_of_events)
tryiturl  uVEk8R→uVEk8R
wdqsurl  →6UB4
scholia  →
relevance  
comment  
task  Task1→Task1

Freitext