List Bookmarks from Command Line

The step of copying the file in the following code is necessary if conkeror is running. If you try to run sqlite3 on places.sqlite while conkeror is running, you will get an error that the database is locked.

cp ~/.conkeror.mozdev.org/conkeror/YOUR-PROFILE/places.sqlite /tmp/places.sqlite.tmp
sqlite3 /tmp/places.sqlite.tmp '
    SELECT b.id, p.url, p.title, b.title
    FROM moz_bookmarks
    b INNER JOIN moz_places p ON b.fk = p.id
    ORDER BY b.id DESC;'