DELETE FROM `review` WHERE `review_id` NOT IN (SELECT max(`review_id`) FROM `review_detail` GROUP BY `title`, `nickname` HAVING count(*) > 1)
DELETE t1
FROM review_detail t1
JOIN review_detail t2 USING (title, nickname)
WHERE t1.detail_id < t2.detail_id;