Skip to content

Instantly share code, notes, and snippets.

@audiodude

audiodude/query.sql

Created October 10, 2018 04:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save audiodude/28ea35e9657b5ff4d5f7c6e887d9f345 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save audiodude/28ea35e9657b5ff4d5f7c6e887d9f345 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
select rev_id
from enwiki_p.revision join enwiki_p.page
on page_namespace = ? and page_title = ?
and rev_page = page_id
where rev_timestamp <= ?
order by rev_timestamp desc limit 1'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment