#!/bin/bash

sqlite3 "$HOME/notes/metadata.db" <<SQL
.mode list
.separator ' - '
SELECT '~/notes/vimwiki/' || page, title FROM pages
  -- WHERE page LIKE 'log/%'
  WHERE datetime IS NOT NULL
  ORDER BY datetime DESC
SQL