left join program p
on c.chanid = p.chanid
where
- c.name not in ('TVSN', 'SpreeTV', '9Life', 'eXtra')
+ c.name not in ('TVSN', 'SpreeTV', '9Life', 'eXtra', '7food', 'NITV')
group by
c.channum
having
- max(p.endtime) < date_add(current_date(), interval 4 day)
+ max(p.endtime) < date_add(current_date(), interval 2 day)
;" | mysql mythconverg