How to delete duplicates in the bookmarks of Firefox 32
August 13, 2015
sqlite3 ~/.mozilla/firefox/hcptd00g.default-1397806778756/places.sqlite
sqlite> delete from moz_bookmarks where id not in (select min(id) from moz_bookmarks where fk is not null group by fk) and fk is not null
moz_bookmarks has a fk field which is a foreign key to moz_places table.
moz_places holds the URLs.