Q3.6: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| 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 05: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 |