Difference between revisions of "Q1.7"

From BITPlan cr Wiki
Jump to navigation Jump to search
Line 37: Line 37:
 
HAVING (?number_of_events = COUNT(?programm_commitee))
 
HAVING (?number_of_events = COUNT(?programm_commitee))
 
|tryiturl=ngbkiD
 
|tryiturl=ngbkiD
|since=2015-08-25
+
|wdqsurl=6UAu
 +
|relevance=4
 
|task=Task1
 
|task=Task1
 
|storemode=property
 
|storemode=property
 +
|since=2015-08-25
 
}}
 
}}
 
=Freitext=
 
=Freitext=

Revision as of 08:11, 21 March 2023

Query

Query
edit
id  7
name  
title  chairs over the history of a workshop
description  Identify the full names of those chairs of the workshop series titled T that have so far been a chair in every edition of the workshop published with CEUR-WS.org.
sparql  
SELECT DISTINCT ?programm_commitee ?programm_commiteeLabel
WHERE{
  VALUES ?series_title {"Wikidata Workshop"@en}
  VALUES ?series_type{ wd:Q47459256 wd:Q47258130 }
  ?series wdt:P31 ?series_type;
          wdt:P1476|rdfs:label ?series_title.
  ?event p:P179 [
            ps:P179 ?series;
            pq:P1545 ?ordinal
          ];
         wdt:P5804 ?programm_commitee;
         ^wdt:P4745/wdt:P179 wd:Q27230297.
  {
    SELECT (COUNT(DISTINCT ?event) as ?number_of_events)
    WHERE{
      VALUES ?series_title {"Wikidata Workshop"@en}
      VALUES ?series_type{ wd:Q47459256 wd:Q47258130 }
      ?series wdt:P31 ?series_type;
          wdt:P1476|rdfs:label ?series_title.
      ?event p:P179 [
            ps:P179 ?series;
            pq:P1545 ?ordinal
          ];
           wdt:P5804 ?programm_commitee;
           ^wdt:P4745/wdt:P179 wd:Q27230297.
      }
    }

  ?programm_commitee rdfs:label ?programm_commiteeLabel. FILTER(lang(?programm_commiteeLabel)="en")
}GROUP BY ?programm_commitee ?number_of_events ?programm_commiteeLabel
HAVING (?number_of_events = COUNT(?programm_commitee))
tryiturl  ngbkiD→ngbkiD
wdqsurl  6UAu→6UAu
scholia  →
relevance  4
comment  
task  Task1→Task1

Freitext