Duplicates of scheduled posts SQL

Instead of using plugins I want to use an SQL cron to complete this task.

I want to delete duplicates out of the database but I want it to compare scheduled or “future” wp_post.post_status to “published” posts. If it’s a future post I want it to be deleted and leave the published post alone.

This is what I was using which is slightly modified but it does not just limit to “future” or scheduled posts.

SELECT bad_rows. *
FROM wp_posts AS bad_rows
INNER JOIN (

SELECT post_title, post_status, post_content, MIN( id ) AS min_id
FROM wp_posts WHERE post_status = “future”
GROUP BY post_title, post_content
HAVING count( * ) >1) AS good_rows ON good_rows.post_title = bad_rows.post_title
AND good_rows.post_content = bad_rows.post_content
AND good_rows.min_id <> bad_rows.id