Difference between revisions of "Q3.6"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
|id=6 | |id=6 | ||
|title=Overall activity in a year | |title=Overall activity in a year | ||
| − | |description=Identify | + | |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(?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) | ||
| + | (CONCAT("../authors/", GROUP_CONCAT(DISTINCT SUBSTR(STR(?author), 32); separator=",")) AS ?authorsUrl) | ||
| + | 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) | ||
| + | OPTIONAL { ?work wdt:P1104 ?pages_ } | ||
| + | OPTIONAL { ?work wdt:P1433 ?venue } | ||
| + | SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,no,ru,sv,zh". } | ||
| + | } | ||
| + | GROUP BY ?work ?workLabel ?venue ?venueLabel | ||
| + | ORDER BY DESC(?date) | ||
| + | |scholia=author_list-of-publications.sparql | ||
| + | |relevance=3 | ||
|task=Task3 | |task=Task3 | ||
|storemode=property | |storemode=property | ||
}} | }} | ||
| + | =Freitext= | ||
Revision as of 06:42, 22 March 2023
Query
| Query | |
|---|---|
 edit
| |
| id | 6 |
| name | |
| 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(?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)
(CONCAT("../authors/", GROUP_CONCAT(DISTINCT SUBSTR(STR(?author), 32); separator=",")) AS ?authorsUrl)
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)
OPTIONAL { ?work wdt:P1104 ?pages_ }
OPTIONAL { ?work wdt:P1433 ?venue }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,no,ru,sv,zh". }
}
GROUP BY ?work ?workLabel ?venue ?venueLabel
ORDER BY DESC(?date)
|
| tryiturl | → |
| wdqsurl | →6UTP |
| scholia | author_list-of-publications.sparql→author_list-of-publications.sparql |
| relevance | 3 |
| comment | |
| task | Task3→Task3 |