[jams@chrome backup]$ cat sql
select basename from recorded where recgroup="LiveTV" ;


[jams@chrome backup]$ cat removelive.sh 
mkdir /data/media/video/crap
mysql -D mythconverg < sql > filelist
for i in `cat filelist`
do
        mv  /data/media/video/recordings/$i  /data/media/video/crap
done