#!/bin/bash
sqlite3 /home/user/.rtcom-eventlogger/el-v1.db \
"SELECT service_id,event_type_id,free_text, \
remote_uid FROM Events order by start_time DESC"|\
grep ^3|head -n 50|cut -d\| -f3,4|\
sed 's/|/<\/h1>/g'|\
while read line
do
echo "$line
"
done >/tmp/msg.html;browser --url=/tmp/msg.html