#!/bin/bash
sqlite3 "${1}" <<!
.headers on
.mode csv
SELECT urls.url, urls.title, urls.visit_count, datetime(urls.last_visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch')
FROM urls, visits WHERE urls.id = visits.url;
!