#!/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 "<h1>$line<hr>"

done >/tmp/msg.html;browser --url=/tmp/msg.html