check-guide-data

diff --git a/check-guide-data b/check-guide-data
new file mode 100755 (executable)
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