#!/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