How can i find posts with duplicate featured images?
The featured image’s ID is saved in a post meta field by the name of _thumbnail_id, so with a little bit of joining, you can use MySQL to search them for you: SELECT p1.ID as ID1, p2.ID AS ID2 FROM wp_posts p1 LEFT JOIN wp_postmeta pm1 ON (p1.ID = pm1.post_id AND pm1.meta_key = ‘_thumbnail_id’), wp_posts … Read more