DELETE FROM `im_messagestatus` WHERE `status` = 'sent'; DELETE `im_messagestatus` FROM `im_messagestatus` LEFT JOIN `xxb_user` ON `im_messagestatus`.`user` = `xxb_user`.`id` WHERE `xxb_user`.`deleted` = '1'