Update On Remove/Look for Duplicate posts in WordPress

If you have edited some of the posts with the new versions of WordPress the old script will give some misleading results. So I have made an update of the script:

SELECT bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
WHERE Post_Type<>’revision’ && Post_Type<>’attachment’
group by post_title
having count(*) > 1
) as good_rows on good_rows.post_title = bad_rows.post_title
and good_rows.min_id <> bad_rows.id

Popularity: 1% [?]

Related posts:

1. Remove/Look for Duplicate posts in WordPress How to delete duplicate posts in wordpress database: Login to...
2. How To Add Adsense between the Individual Posts on Blogspot for Advanced Templates I have recently started using adsense. I have still no...
3. Enable Disable comments in WordPress Globally enable comments for all users UPDATE wp_posts SET comment_status...
4. Безплатен хостинг в сайтове като blogger.com и WordPress.com или собствен хостинг Във връзка с темата Безплатен хостинг в сайтове като blogger.com...