exhaustive-firefox-bookmark-exporter.sqlite

--understand what we are looking at
.tables
PRAGMA table_info(moz_bookmarks);
-- now take a look at the diagram connecting bookmarks and places @ http://www.forensicswiki.org/wiki/Mozilla_Firefox_3_History_File_Format

.headers on
.mode csv
.output exported-bookmarks
SELECT
    bm.id, bm.type, bm.parent, bm.position, bm.title, pl.url,
    bm.keyword_id, bm.folder_type, bm.dateAdded, bm.lastModified,
    bm.guid, bm.syncStatus, bm.syncChangeCounter
FROM moz_bookmarks AS bm
JOIN moz_places    AS pl
ON
    bm.fk=pl.id;

/*
the following code also worked--
SELECT
    bm.id, bm.type, bm.parent, bm.position, bm.title, pl.url,
    bm.keyword_id, bm.folder_type, bm.dateAdded, bm.lastModified,
    bm.guid, bm.syncStatus, bm.syncChangeCounter
FROM moz_bookmarks AS bm
JOIN moz_places    AS pl
WHERE
    bm.fk=pl.id;
*/