#!/bin/bash
-echo 'select c.channum, max(p.endtime) from channel c left join program p on c.chanid = p.chanid group by c.channum having max(p.endtime) < date_add(current_date(), interval 4 day);' | mysql mythconverg
\ No newline at end of file
+echo "
+select
+ c.channum,
+ max(p.endtime)
+from
+ channel c
+ left join program p
+ on c.chanid = p.chanid
+where
+ c.name not in ('TVSN', 'SpreeTV', '9Life', 'eXtra')
+group by
+ c.channum
+having
+ max(p.endtime) < date_add(current_date(), interval 4 day)
+;" | mysql mythconverg