From: James Bunton <jamesbunton@delx.net.au>
Date: Mon, 13 Mar 2017 11:07:52 +0000 (+1100)
Subject: check-guide-data
X-Git-Url: https://code.delx.au/mediapc-tools/commitdiff_plain/bf1f280eddd862a3882b9473383a297c37759b24

check-guide-data
---

diff --git a/check-guide-data b/check-guide-data
new file mode 100755
index 0000000..33d24bd
--- /dev/null
+++ b/check-guide-data
@@ -0,0 +1,3 @@
+#!/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