Q0.5: Difference between revisions

From BITPlan cr Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(5 intermediate revisions by 2 users not shown)
Line 2: Line 2:


{{Query
{{Query
|id=4
|id=5
|title=All scholars
|name=AllScholars
|description=List all scholars that have at least once (co-)authored a paper that has been published through CEUR-WS.
|title=All [[Concept:Scholar|scholars]]
|sparql=# Q0.5 List all scholars
|description=List all scholars that have at least once (co-)authored a paper or proceeding that has been published through CEUR-WS.
SELECT DISTINCT ?scholar ?label
|sparql=# Q0.5 List all scholars (authors and editors) of CEUR-Workshop proceedings
   (GROUP_CONCAT(?_givenName) as ?givenName)  
SELECT DISTINCT  
   (GROUP_CONCAT(?_familyName) as ?familyName)
  ?scholar  
  (GROUP_CONCAT(?paper) as ?_papers)  
  ?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.
   ?proceeding p:P179/pq:P478 ?volumeNumber.
   {
  ?paper wdt:P1433 ?proceeding.
    # authors
   ?paper wdt:P50 ?scholar.
    # published in
    ?paper wdt:P1433 ?proceeding.
    # author
    ?paper wdt:P50 ?scholar.
   }UNION{
    # editors
    ?proceeding wdt:P98 ?scholar.  
  }
    
    
   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
|wdqsurl=6UEH
|tryiturl=3mUK8B
|wdqsurl=6UT6
|relevance=1
|relevance=1
|task=Task0
|task=Task0

Latest revision as of 05: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