Moritz Bappert moritzbappert

🚀

Building WordPress Websites for Growing Companies.

Co-Founder and Developer at dreiQBIK GmbH

moritzbappert / functions.php

Last active March 18, 2022 08:44

WPML script to remove unnecessary media duplicates

	<?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);

moritzbappert / wpml-set-product-url-slug-translations-to-original-slug.sql

Created March 18, 2022 08:16

WPML: copy / duplicate product url slugs from original language to other languages #woocommerce #wpml

moritzbappert / clean-wpml-media-duplicates.sql

Last active March 18, 2022 08:11

Delete unnecessary media duplicates created by WPML (with EN as source language)

	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