Q0.5: Difference between revisions

From BITPlan cr Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
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 11: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