Skip to content

Instantly share code, notes, and snippets.

@u1i
Created May 16, 2023 03:29
Show Gist options
  • Select an option

  • Save u1i/58c6f20bfa24004b83a2f626824f5a2a to your computer and use it in GitHub Desktop.

Select an option

Save u1i/58c6f20bfa24004b83a2f626824f5a2a to your computer and use it in GitHub Desktop.
Firefox: History
SELECT moz_places.url, datetime(moz_historyvisits.visit_date / 1000000,'unixepoch', 'localtime') AS visit_time FROM moz_places JOIN moz_historyvisits ON moz_historyvisits.place_id = moz_places.id ORDER BY moz_historyvisits.visit_date DESC LIMIT 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment