Delete duplicate rows in mysql keep only id smallest

DELETE c1 FROM wp_profile_list c1 INNER JOIN wp_profile_list c2 WHERE c1.id > c2.id AND c1.profile_id = c2.profile_id;
DELETE c1 FROM wp_profile_premium c1 INNER JOIN wp_profile_premium c2 WHERE c1.id > c2.id AND c1.profile_id = c2.profile_id;
DELETE c1 FROM wp_profiles_rating c1 INNER JOIN wp_profiles_rating c2 WHERE c1.id > c2.id AND c1.profile_id = c2.profile_id;
DELETE c1 FROM wp_profiles_stats c1 INNER JOIN wp_profiles_stats c2 WHERE c1.id > c2.id AND c1.profile_id = c2.profile_id;