assistance with a DELETE query using an IN subquery

[Adam Evanovich]

hey guys,

I'm not necessarily a new mysql user, but I'm coming from another database platform. I just need a push here regarding my use of a subquery. Here's what I'm trying to execute:

DELETE FROM wp_posts WHERE post_title <> "Sample Page" AND post_date NOT IN 

(SELECT post_title, MAX(post_date) FROM wp_posts WHERE post_type = "revision" GROUP BY post_title);

I'm getting an error thrown that says: "#1241 - Operand should contain 1 column(s)". Can you guys help me here? I looked it up on google but I didn't find anyone else with this specific problem.

thanks!