Based on https://wpindexfixer.tools.managedwphosting.nl/ as sometimes all that is missing is the posts ID (PK)
SELECT ID, post_modified FROM wp_posts WHERE ID in ( SELECT ID FROM wp_posts
GROUP by ID having count(ID) > 1 ) ORDER BY wp_posts
.ID
ASC, post_modified DESC;
Extract the even rows from the file
awk 'NR % 2 == 0' wp_posts.csv > remove.csv
Leave a Reply