MySQL删除重复数据

开发调优
1 
DELETE w FROM subscribe_msg_list w RIGHT JOIN ( SELECT *, count(1) AS cc FROM subscribe_msg_list GROUP BY type, user_id, time HAVING cc > 1 ) t ON w.id = t.id;
2

这么复杂是干嘛的啊？