A set of SPARQL examples that are used in different TGX resources
License: https://www.gnu.org/licenses/gpl-3.0
Uses method in: https://github.com/WDscholia/scholia/tree/master/scholia/app/templates/venue_recently-published-works.sparql
Venue aspect: recently published works
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
#title: Recent works published in venue
PREFIX target: <http://www.wikidata.org/entity/Q6294930>
SELECT
?publication_date
?work ?workLabel
(GROUP_CONCAT(DISTINCT ?author_label; separator=", ") AS ?authors)
(CONCAT("../authors/", GROUP_CONCAT(DISTINCT SUBSTR(STR(?author), 32); separator=",")) AS ?authorsUrl)
WITH {
SELECT DISTINCT ?work (MIN(?publication_date_) AS ?publication_date) WHERE {
?work wdt:P1433 target: .
OPTIONAL {
?work wdt:P577 ?publication_datetime .
BIND(xsd:date(?publication_datetime) AS ?publication_date_)
}
} GROUP BY ?work
ORDER BY DESC(?publication_date)
LIMIT 1000
} AS %ARTICLES WHERE {
INCLUDE %ARTICLES
OPTIONAL {
?work wdt:P50 ?author .
?author rdfs:label ?author_label .
FILTER (LANG(?author_label) = 'en')
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . }
} GROUP BY ?publication_date ?work ?workLabel
ORDER BY DESC(?publication_date)
graph TD