check-guide-data: ignore advertising channels

[mediapc-tools] / check-guide-data

diff --git a/check-guide-data b/check-guide-data
index 33d24bde6ceb392576ee4a2b6e8100981af56f30..af84ee3f1ddeee19552e1e4ce4d0a5befbc24ffd 100755 (executable)
--- 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')
+group by
+    c.channum
+having
+    max(p.endtime) < date_add(current_date(), interval 4 day)
+;" | mysql mythconverg