Difference between revisions of "Q0.5"

From BITPlan cr Wiki
Jump to navigation Jump to search
Line 4: Line 4:
 
|id=4
 
|id=4
 
|title=All scholars
 
|title=All scholars
|description=List all scholars that have at least once (co-)authored a paper 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
 
SELECT DISTINCT ?scholar ?label
 
SELECT DISTINCT ?scholar ?label
 
   (GROUP_CONCAT(?_givenName) as ?givenName)  
 
   (GROUP_CONCAT(?_givenName) as ?givenName)  
   (GROUP_CONCAT(?_familyName) as ?familyName)
+
   (GROUP_CONCAT(?_familyName) as ?familyName)
  (GROUP_CONCAT(?paper) as ?_papers)  
 
 
WHERE{
 
WHERE{
 
   ?proceeding wdt:P31 wd:Q1143604.
 
   ?proceeding wdt:P31 wd:Q1143604.
 
   ?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.
+
    ?paper wdt:P1433 ?proceeding.
 +
    ?paper wdt:P50 ?scholar.
 +
   }UNION{
 +
    # editors
 +
    ?proceeding wdt:P98 ?scholar.  
 +
  }
 
    
 
    
 
   OPTIONAL{?scholar rdfs:label ?label. Filter(lang(?label)="en")}  
 
   OPTIONAL{?scholar rdfs:label ?label. Filter(lang(?label)="en")}  
Line 22: Line 26:
 
}
 
}
 
GROUP BY ?scholar ?label
 
GROUP BY ?scholar ?label
|wdqsurl=6UEH
+
|wdqsurl=6UFE
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0

Revision as of 13:18, 21 March 2023

Query

Query
edit
id  4
name  
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
SELECT DISTINCT ?scholar ?label
  (GROUP_CONCAT(?_givenName) as ?givenName) 
  (GROUP_CONCAT(?_familyName) as ?familyName)
WHERE{
  ?proceeding wdt:P31 wd:Q1143604.
  ?proceeding wdt:P179 wd:Q27230297.
  {
    # authors
    ?paper wdt:P1433 ?proceeding.
    ?paper wdt:P50 ?scholar.
  }UNION{
    # editors
    ?proceeding wdt:P98 ?scholar. 
  }
  
  OPTIONAL{?scholar rdfs:label ?label. Filter(lang(?label)="en")} 
  OPTIONAL{?scholar wdt:P735 ?_givenName.} 
  OPTIONAL{?scholar wdt:P734 ?_familyName.} 
}
GROUP BY ?scholar ?label
tryiturl  →3mUK8B
wdqsurl  6UFE→6UT6
scholia  →
relevance  1
comment  
task  Task0→Task0

Freitext