SQL query delete duplicate posts
To delete posts with the same post title via SQL I run the following query on the database:
SQL queries update WordPress URLs
Update site url in wp_options: Update guid: Update all urls in post content: Update all urls in meta fields: