Find duplicated attachment titles in wordpress and remove

find_duplicate_titles.php

<?php
$duplicate_titles = $wpdb->get_col("SELECT post_title FROM {$wpdb->posts} WHERE post_type = 'attachment' GROUP BY post_title HAVING COUNT(*) > 1");
echo "Find ".count($duplicate_titles)." duplicated titles \n";

foreach( $duplicate_titles as $title ) {
	echo "find images with ".$title." \n";
	$post_ids = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb->posts} WHERE post_type = 'attachment' and post_title=%s", $title ) );
	// Iterate over the second ID with this post title till the last
	foreach( array_slice( $post_ids, 1 ) as $post_id ) {
		$status = (wp_delete_attachment( $post_id,1 )) ? 'Deleted' : 'Not deleted';
		echo "Deleting media ".$post_id." ".$status." \n";
	}
}