Skip to content

Instantly share code, notes, and snippets.

@wadouk

wadouk/places.sql

Created December 21, 2017 15:09
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 wadouk/d042f5cd6d81ca48be699b814beb9e5b to your computer and use it in GitHub Desktop.
Save wadouk/d042f5cd6d81ca48be699b814beb9e5b to your computer and use it in GitHub Desktop.
Download ZIP
Retrouver le dossier parent d'un bookmark avec keyword
Raw
places.sql
# @see https://web.archive.org/web/20170407025318/https://people-mozilla.org/~dietrich/places-erd.png
select * from moz_bookmarks
where id in (
select r.parent from moz_keywords k, moz_places p, moz_bookmarks b, moz_bookmarks r
where k.place_id = p.id
and b.fk = p.id
and r.id = b.parent)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment