query-ca3fcca464ac7dfcec828bd3c27266f7
All the articles published in Zookeys within the year 2018 and showing potential categories in Wikimedia Commons Scholarly articles with images on Commons 18:21, 19 September 2020 (UTC)) talk (Christian Ferrer. (P373)Commons category within the year 2018, and to see if the items has (or not) a value for (P577)publication date (Q219980)ZooKeys (P1433)published in (Q13442814)scholarly article Hello, I would want a request to see all the
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 schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?date ?commonscat ?commonssitelink WHERE {
?item wdt:P1433 wd:Q219980; wdt:P577 ?date; wdt:P31 wd:Q13442814 .
FILTER(YEAR(?date) = 2018) .
OPTIONAL { ?item wdt:P373 ?commonscat }
OPTIONAL { ?commonssitelink schema:about ?item; schema:isPartOf <https://commons.wikimedia.org/> }
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
} ORDER BY ASC(?date)
Query found at
- https://www.wikidata.org/wiki/User:Christian_Ferrer
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/09
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?commonscat"):::projected
v4("?commonssitelink"):::projected
v1("?date"):::projected
v2("?item"):::projected
c10([https://commons.wikimedia.org/]):::iri
c14(["en"]):::literal
c3(["wd:Q219980"]):::iri
c6(["wd:Q13442814"]):::iri
c12(["bd:serviceParam"]):::iri
f0[["year-from-dateTime(?date) = '2018^^xsd:integer'"]]
f0 --> v1
v2 --"wdt:P1433"--> c3
v2 --"wdt:P577"--> v1
v2 --"wdt:P31"--> c6
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P373".-> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v4 -."schema:about".-> v2
v4 --"schema:isPartOf"--> c10
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c12 --"wikibase:language"--> c14
end