X-Git-Url: https://code.delx.au/mediapc-tools/blobdiff_plain/bf1f280eddd862a3882b9473383a297c37759b24..1456f831f6f3f7958962f82556f7963658344d61:/check-guide-data

diff --git a/check-guide-data b/check-guide-data
index 33d24bd..2dd2c37 100755
--- a/check-guide-data
+++ b/check-guide-data
@@ -1,3 +1,17 @@
 #!/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', '7food', 'NITV')
+group by
+    c.channum
+having
+    max(p.endtime) < date_add(current_date(), interval 2 day)
+;" | mysql mythconverg