Skip to content

Instantly share code, notes, and snippets.

@dsimard

dsimard/ann.sql

Last active December 11, 2015 17:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dsimard/4637733 to your computer and use it in GitHub Desktop.
Save dsimard/4637733 to your computer and use it in GitHub Desktop.
Download ZIP
Kobo Glo Annotation
Raw
ann.sql
select book.contentid as bookid, book.title, b.bookmarkid, b.text, b.annotation
from bookmark b
inner join content c on b.contentid = c.contentid
inner join content book on c.bookid = book.contentid
order by book.datelastread desc, b.datecreated
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment