Q3.6
Jump to navigation
Jump to search
Query
| Query | |
|---|---|
 edit
| |
| id | 6 |
| name | AuthorActivityInYear |
| title | Overall activity in a year |
| description | Identify for an author A of a CEUR-WS.org paper P all his/her activity in year Y . |
| sparql | #defaultView:Table
PREFIX target: <http://www.wikidata.org/entity/Q27942628>
SELECT
(MIN(?_year) as ?year)
(MIN(?dates) AS ?date)
?work ?workLabel
(GROUP_CONCAT(DISTINCT ?type_label; separator=", ") AS ?type)
(SAMPLE(?pages_) AS ?pages)
?venue ?venueLabel
(GROUP_CONCAT(DISTINCT ?author_label; separator=", ") AS ?authors)
WHERE {
?work wdt:P50 target: .
?work wdt:P50 ?author .
OPTIONAL {
?author rdfs:label ?author_label_ . FILTER (LANG(?author_label_) = 'en')
}
BIND(COALESCE(?author_label_, SUBSTR(STR(?author), 32)) AS ?author_label)
OPTIONAL { ?work wdt:P31 ?type_ . ?type_ rdfs:label ?type_label . FILTER (LANG(?type_label) = 'en') }
?work wdt:P577 ?datetimes .
BIND(xsd:date(?datetimes) AS ?dates)
BIND(year(?dates) as ?_year)
OPTIONAL { ?work wdt:P1104 ?pages_ }
OPTIONAL { ?work wdt:P1433 ?venue }
?work rdfs:label ?workLabel
FILTER(LANG(?workLabel)="en")
}
GROUP BY ?work ?workLabel ?venue ?venueLabel
ORDER BY DESC(?date)
|
| tryiturl | → |
| wdqsurl | 6UTP→6UTP |
| scholia | author_list-of-publications.sparql→author_list-of-publications.sparql |
| relevance | 3 |
| comment | |
| task | Task3→Task3 |