Quote:
Originally Posted by CAMOKAT
yes, there is.
Douchebag just makes it sound like he re-invented the fucking wheel. Here?s free plugin called ?mysql query? to delete duplicate post.. That other stuff is part of wp-o-matic (sp?) plugin. I bet he just re-used (borrowed) the code from there.. After all its GPL. Cyber communism..
DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
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
|
LOL, what a stupid clown. Of course I have my own algorithm of duplicate posts searching (actually 3 various versions of it). Especially if syndicated posts were morphed previously. I know your know a shit about coding, but believe me - that's impossible to detect such sort of posts by running a simple MYSQL query
