Duplicates and odd rows


min read

My profile

Share this:

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
Share this:

Leave a Reply

Your email address will not be published. Required fields are marked *