Created
September 13, 2016 21:00
-
-
Save awojtczyk/2d0d31b1006f188896e9f34362686869 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELETE FROM wp_posts WHERE | |
ID IN | |
( | |
SELECT element_id FROM wp_icl_translations WHERE element_type = 'post_attachment' AND language_code != 'en' | |
) | |
DELETE FROM wp_postmeta WHERE | |
meta_key= '_thumbnail_id' AND meta_value IN | |
( | |
SELECT element_id FROM wp_icl_translations WHERE element_type = 'post_attachment' AND language_code != 'en' | |
) | |
DELETE FROM wp_icl_translations WHERE element_type = 'post_attachment' AND language_code != 'en'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment