query-67a9eecf411696cd12d9ea532237b7b6

rq turtle/ttl

Find works with a public domain date (P3893) in the calendar year in which the query is run SELECT ?work ?workLabel ?type ?typeLabel ?date ?articles ?now ?then WHERE { ?work p:P3893/psv:P3893 ?date_node . ?date_node wikibase:timeValue ?date . BIND(xsd:dateTime(concat(str(year(now())),"-01-01T00:00:00Z")) as ?now) BIND(xsd:dateTime(concat(str(year(now()+"P1Y"^^xsd:duration)),"-01-01T00:00:00Z")) as ?then)

FILTER( ?date >= "2021-01-01T00:00:00"^^xsd:dateTime && ?date < "2022-01-01T00:00:00"^^xsd:dateTime )

FILTER( ?date >= ?now && ?date < ?then ) ?work wdt:P31 ?type ; wikibase:sitelinks ?articles . SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en,de,it,es,nl" . } }

Order by number or articles on Wikimedia sites

ORDER BY DESC(?articles)

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Find works with a public domain date (P3893) in the calendar year in which the query is run
SELECT ?work ?workLabel ?type ?typeLabel ?date ?articles ?now ?then WHERE {
  ?work p:P3893/psv:P3893 ?date_node .
  ?date_node wikibase:timeValue ?date .
  BIND(xsd:dateTime(concat(str(year(now())),"-01-01T00:00:00Z")) as ?now) 
  BIND(xsd:dateTime(concat(str(year(now()+"P1Y"^^xsd:duration)),"-01-01T00:00:00Z")) as ?then) 
#  FILTER( ?date >= "2021-01-01T00:00:00"^^xsd:dateTime && ?date < "2022-01-01T00:00:00"^^xsd:dateTime )
  FILTER( ?date >= ?now && ?date < ?then )
  ?work wdt:P31 ?type ;
           wikibase:sitelinks ?articles .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en,de,it,es,nl" . }
}
# Order by number or articles on Wikimedia sites
ORDER BY DESC(?articles)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2021/01