Unnamed

UPDATE
        recorded
SET
        cutlist = 0,
        filesize = $(ls -l $VIDEODIR/$FILENAME | awk '{print $5}')
WHERE
        basename = '$FILENAME';


DELETE FROM
       recordedmarkup
WHERE
       CONCAT( chanid, starttime ) IN (
               SELECT
                       CONCAT( chanid, starttime )
               FROM
                       recorded
               WHERE
                       basename = '$FILENAME'
       );

commit;