X-Git-Url: https://code.delx.au/mediapc-tools/blobdiff_plain/1acb8fbd2467e639b4020c9ec4317fb1cb1c8e03..1456f831f6f3f7958962f82556f7963658344d61:/check-guide-data diff --git a/check-guide-data b/check-guide-data index af84ee3..2dd2c37 100755 --- a/check-guide-data +++ b/check-guide-data @@ -9,9 +9,9 @@ from 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