Mark
DELETE FROM t_schooltp_domain_url_area_copy WHERE domain_url IN (SELECT domain_url FROM (SELECT domain_url FROM t_schooltp_domain_url_area_copy GROUP BY domain_url HAVING COUNT(domain_url)>1) e)
AND id NOT IN (SELECT id FROM (SELECT MIN(id) AS id FROM t_schooltp_domain_url_area_copy GROUP BY domain_url HAVING COUNT(domain_url)>1) t)