#!/bin/bash
sqlite3 http-okay.db 'SELECT cnx.id AS connection_id, cnx.ip, cnx.port, cnx.date AS connection_date, content.date AS content_date, content.epoch, content.method, content.host, content.path, content.version, content.user_agent, content.content FROM cnx JOIN content ON cnx.id = content.id;'