Moritz Bappert moritzbappert

## functions.php
<?php

add_action('admin_init', function() {
    global $wpdb, $sitepress;

    $langs = 3; // set how many languages site has

    $query = "SELECT ID, post_title, count(ID) AS cnt FROM {$wpdb->prefix}posts WHERE post_type LIKE 'attachment' GROUP BY post_title HAVING cnt > " .  $langs;
    $duplicated = $wpdb->get_results($query);

## wpml-set-product-url-slug-translations-to-original-slug.sql
UPDATE
	wp_posts posts
	INNER JOIN (
		SELECT
			original_id.id,
			p_original_slug.post_name
		FROM (
			SELECT
				p.id,
				tr.language_code,

## clean-wpml-media-duplicates.sql
DELETE FROM
	wp_posts
WHERE
	post_type = 'attachment'
	AND ID NOT IN(
		SELECT
			MIN(ID)
			FROM (
				SELECT
					ID, post_type, post_name FROM wp_posts) AS r1
	<?php

	add_action('admin_init', function() {
	global $wpdb, $sitepress;

	$langs = 3; // set how many languages site has

	$query = "SELECT ID, post_title, count(ID) AS cnt FROM {$wpdb->prefix}posts WHERE post_type LIKE 'attachment' GROUP BY post_title HAVING cnt > " . $langs;
	$duplicated = $wpdb->get_results($query);
	UPDATE
	wp_posts posts
	INNER JOIN (
	SELECT
	original_id.id,
	p_original_slug.post_name
	FROM (
	SELECT
	p.id,
	tr.language_code,
	DELETE FROM
	wp_posts
	WHERE
	post_type = 'attachment'
	AND ID NOT IN(
	SELECT
	MIN(ID)
	FROM (
	SELECT
	ID, post_type, post_name FROM wp_posts) AS r1