From 1acb8fbd2467e639b4020c9ec4317fb1cb1c8e03 Mon Sep 17 00:00:00 2001 From: James Bunton Date: Mon, 3 Apr 2017 09:31:37 +1000 Subject: [PATCH] check-guide-data: ignore advertising channels --- check-guide-data | 16 +++++++++++++++- 1 file changed, 15 insertions(+), 1 deletion(-) diff --git a/check-guide-data b/check-guide-data index 33d24bd..af84ee3 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') +group by + c.channum +having + max(p.endtime) < date_add(current_date(), interval 4 day) +;" | mysql mythconverg -- 2.39.2