query-8fae59a52bf33e90201b2bbeef24eda5
Query #1: Select academic journal articles by subject: (linked data)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?DOI_URI ?title (GROUP_CONCAT(DISTINCT ?authorLabel; SEPARATOR = ", ") AS ?authors) ?publishedInLabel ?publicationDate
WHERE
{
?item wdt:P31 wd:Q18918145 ; # instance of a academic journal article
wdt:P31 ?itemType ;
rdfs:label ?title .
?item wdt:P921 wd:Q515701 ; # has the term 'linked data' as main subject
wdt:P921 ?mainSubject .
?item wdt:P50 ?author .
?author rdfs:label ?authorLabel .
?item wdt:P1433 ?publishedIn ;
rdfs:label ?publication .
?item wdt:P577 ?publicationDate .
OPTIONAL {?item wdt:P356 ?DOI} .
BIND(URI(CONCAT("https://doi.org/", ?DOI)) AS ?DOI_URI)
FILTER (LANG(?authorLabel) = "en")
FILTER (LANG(?title) = "en")
FILTER (LANG(?publication) = "en")
FILTER(?mainSubject IN (wd:Q515701)) # Filter out 'main subject' values NOT in this list
FILTER(?itemType IN ( wd:Q18918145 )) # Filter out 'instance of' values NOT in this list
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
GROUP BY ?item ?DOI_URI ?title ?authors ?publishedInLabel ?publicationDate
ORDER by DESC (?publicationDate)