Difference between revisions of "Q0.5"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
{{Query | {{Query | ||
|id=5 | |id=5 | ||
| − | |title=All scholars | + | |name=AllScholars |
| + | |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(? | + | ?scholar |
| − | (GROUP_CONCAT(? | + | ?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 21: | Line 28: | ||
} | } | ||
| − | + | ?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= | + | |tryiturl=3mUK8B |
| − | |wdqsurl= | + | |wdqsurl=6UT6 |
|relevance=1 | |relevance=1 | ||
|task=Task0 | |task=Task0 | ||
Latest revision as of 06: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 |