3,427
edits
Project:SPARQL/examples: Difference between revisions
From Beyond Notability
→Locations that don't have Wikidata links or their Wikidata pages lack geocoordinates
| Line 3,538: | Line 3,538: | ||
} | } | ||
ORDER BY ?wikidata ?locationLabel | ORDER BY ?wikidata ?locationLabel | ||
</sparql> | |||
=== Date of latest edit for every item, according to WQS === | |||
<sparql tryit="1"> | |||
#title:latest edits dates for wikibase items | |||
## because of WQS disappearing data bugs this may not always match the latest edit in the page history | |||
SELECT ?item ?date ?dateLabel | |||
WHERE { | |||
?item wikibase:timestamp ?date . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
order by ?date | |||
</sparql> | </sparql> | ||
