code.delx.au - mediapc-tools/blob - check-guide-data

   1 #!/bin/bash
   2
   3 echo "
   4 select
   5     c.channum,
   6     max(p.endtime)
   7 from
   8     channel c
   9     left join program p
  10     on c.chanid = p.chanid
  11 where
  12     c.name not in ('TVSN', 'SpreeTV', '9Life', 'eXtra', '7food', 'NITV')
  13 group by
  14     c.channum
  15 having
  16     max(p.endtime) < date_add(current_date(), interval 2 day)
  17 ;" | mysql mythconverg