Difference between revisions of "Q0.5"

From BITPlan cr Wiki
Jump to navigation Jump to search
(Created page with "=Query= {{Query |id=4 |title=All scholars |description=List all scholars that have at least once (co-)authored a paper that has been published through CEUR-WS. |sparql= |tryi...")
 
Line 5: Line 5:
 
|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 that has been published through CEUR-WS.
|sparql=
+
|sparql=# Q0.5 List all scholars
|tryiturl=
+
SELECT DISTINCT ?scholar ?label
|wdqsurl=
+
  (GROUP_CONCAT(?_givenName) as ?givenName)
 +
  (GROUP_CONCAT(?_familyName) as ?familyName)
 +
  (GROUP_CONCAT(?paper) as ?_papers)
 +
WHERE{
 +
  ?proceeding wdt:P31 wd:Q1143604.
 +
  ?proceeding wdt:P179 wd:Q27230297.
 +
  ?proceeding p:P179/pq:P478 ?volumeNumber.
 +
  ?paper wdt:P1433 ?proceeding.
 +
  ?paper wdt:P50 ?scholar.
 +
 
 +
  OPTIONAL{?scholar rdfs:label ?label. Filter(lang(?label)="en")}
 +
  OPTIONAL{?scholar wdt:P735 ?_givenName.}
 +
  OPTIONAL{?scholar wdt:P734 ?_familyName.}
 +
}
 +
GROUP BY ?scholar ?label
 +
|wdqsurl=6UEH
 
|relevance=1
 
|relevance=1
 
|task=Task0
 
|task=Task0

Revision as of 13:13, 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 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) 
  (GROUP_CONCAT(?paper) as ?_papers) 
WHERE{
  ?proceeding wdt:P31 wd:Q1143604.
  ?proceeding wdt:P179 wd:Q27230297.
  ?proceeding p:P179/pq:P478 ?volumeNumber.
  ?paper wdt:P1433 ?proceeding.
  ?paper wdt:P50 ?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  6UEH→6UT6
scholia  →
relevance  1
comment  
task  Task0→Task0

Freitext