awojtczyk

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'