DELETE FROM org WHERE org_id NOT IN (SELECT rep_org_id FROM rptd WHERE concat(rptd.rep_date, rptd.rep_time) = (SELECT MAX(concat(rptd.rep_date,rptd.rep_time)) FROM rptd)