Delete posts based on post meta data

Question

I'm looking for a simple SQL script that will delete posts where the post meta of that post id has some value ['x'].

DELETE FROM wp_posts WHERE post_id == wp_post_meta->post_id WHERE meta_value = ['x']

Answer 1

DELETE wp_posts
FROM wp_posts
INNER JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID
WHERE (wp_postmeta.meta_key = 'InternalOnly' AND wp_postmeta.meta_value IS NOT NULL);