delete from product_code_relate_titletext where id not in (select * from (select min(id) from product_code_relate_titletext group by product_code,raw_title having count(*) > 1) as b);

delete from product_code_relate_titletext where id in 
(
    select a.id from 
    (select * from product_code_relate_titletext where id not in (select min(id) from product_code_relate_titletext group by product_code,raw_title)
    ) a
)

没有您的数据，我这里给一段代码供您参考：

删除相同Name除ID最小的记录外的其他记录

-- ----------------------------
-- Table structure for t_team
-- ----------------------------
DROP TABLE IF EXISTS `t_team`;
CREATE TABLE `t_team` (
  `id` int(11) NOT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_team
-- ----------------------------
INSERT INTO `t_team` VALUES ('1', 'A');
INSERT INTO `t_team` VALUES ('2', 'B');
INSERT INTO `t_team` VALUES ('3', 'B');
INSERT INTO `t_team` VALUES ('4', 'A');
INSERT INTO `t_team` VALUES ('5', 'C');
INSERT INTO `t_team` VALUES ('6', 'C');

-- ----------------------------
-- 删除NAME重复的记录，保留ID最小的记录
-- ----------------------------
DELETE FROM t_team WHERE id NOT IN ( 
    SELECT min_id FROM (
            SELECT MIN(id) AS min_id FROM t_team GROUP BY user_name 
        ) B
    )