#!/bin/bash

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', '7food', 'NITV')
group by
    c.channum
having
    max(p.endtime) < date_add(current_date(), interval 2 day)
;" | mysql mythconverg