Difference between revisions of "Q0.5"

From BITPlan cr Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
 
|id=5
 
|id=5
 
|name=AllScholars
 
|name=AllScholars
|title=All scholars
+
|title=All [[Concept:Scholar|scholars]]
 
|description=List all scholars that have at least once (co-)authored a paper or proceeding that has been published through CEUR-WS.
 
|description=List all scholars that have at least once (co-)authored a paper or proceeding that has been published through CEUR-WS.
|sparql=# Q0.5 List all scholars
+
|sparql=# Q0.5 List all scholars (authors and editors) of CEUR-Workshop proceedings
SELECT DISTINCT ?scholar ?label
+
SELECT DISTINCT  
   (GROUP_CONCAT(?_givenName) as ?givenName)  
+
  ?scholar  
   (GROUP_CONCAT(?_familyName) as ?familyName)
+
  ?label
 +
   #(GROUP_CONCAT(?_givenNameLabel) as ?givenName)  
 +
   #(GROUP_CONCAT(?_familyNameLabel) as ?familyName)
 
WHERE{
 
WHERE{
 +
  # Proceeding
 
   ?proceeding wdt:P31 wd:Q1143604.
 
   ?proceeding wdt:P31 wd:Q1143604.
 +
  # CEUR-WS
 
   ?proceeding wdt:P179 wd:Q27230297.
 
   ?proceeding wdt:P179 wd:Q27230297.
 
   {
 
   {
 
     # authors
 
     # authors
 +
    # published in
 
     ?paper wdt:P1433 ?proceeding.
 
     ?paper wdt:P1433 ?proceeding.
 +
    # author
 
     ?paper wdt:P50 ?scholar.
 
     ?paper wdt:P50 ?scholar.
 
   }UNION{
 
   }UNION{
Line 22: Line 28:
 
   }
 
   }
 
    
 
    
   OPTIONAL{?scholar rdfs:label ?label. Filter(lang(?label)="en")}
+
   ?scholar rdfs:label ?label.  
   OPTIONAL{?scholar wdt:P735 ?_givenName.}  
+
  FILTER(LANG(?label)="en").
   OPTIONAL{?scholar wdt:P734 ?_familyName.}  
+
   #OPTIONAL{
 +
  #  ?scholar wdt:P735 ?_givenName.
 +
  #  ?_givenName rdfs:label ?_givenNameLabel.
 +
  #  FILTER(LANG(?_givenNameLabel)="en").
 +
  #}  
 +
    
 +
  #OPTIONAL{
 +
  #  ?scholar wdt:P734 ?_familyName.
 +
  #  ?_familyName rdfs:label ?_familyNameLabel.
 +
  #  FILTER(LANG(?_familyNameLabel)="en").
 +
  #}  
 
}
 
}
 
GROUP BY ?scholar ?label
 
GROUP BY ?scholar ?label
|tryiturl=cgMeix
+
|tryiturl=3mUK8B
|wdqsurl=6UFE
+
|wdqsurl=6UT6
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0

Latest revision as of 07:16, 22 March 2023

Query

Query
edit
id  5
name  AllScholars
title  All scholars
description  List all scholars that have at least once (co-)authored a paper or proceeding that has been published through CEUR-WS.
sparql  
# Q0.5 List all scholars (authors and editors) of CEUR-Workshop proceedings
SELECT DISTINCT 
  ?scholar 
  ?label
  #(GROUP_CONCAT(?_givenNameLabel) as ?givenName) 
  #(GROUP_CONCAT(?_familyNameLabel) as ?familyName)
WHERE{
  # Proceeding
  ?proceeding wdt:P31 wd:Q1143604.
  # CEUR-WS
  ?proceeding wdt:P179 wd:Q27230297.
  {
    # authors
    # published in 
    ?paper wdt:P1433 ?proceeding.
    # author
    ?paper wdt:P50 ?scholar.
  }UNION{
    # editors
    ?proceeding wdt:P98 ?scholar. 
  }
  
  ?scholar rdfs:label ?label. 
  FILTER(LANG(?label)="en").
  #OPTIONAL{
  #  ?scholar wdt:P735 ?_givenName.
  #  ?_givenName rdfs:label ?_givenNameLabel.
  #   FILTER(LANG(?_givenNameLabel)="en").
  #} 
  
  #OPTIONAL{
  #  ?scholar wdt:P734 ?_familyName.
  #  ?_familyName rdfs:label ?_familyNameLabel.
  #  FILTER(LANG(?_familyNameLabel)="en").
  #} 
}
GROUP BY ?scholar ?label
tryiturl  3mUK8B→3mUK8B
wdqsurl  6UT6→6UT6
scholia  →
relevance  1
comment  
task  Task0→Task0

Freitext