Combine Inner Join and IN to query data from both the posts and postmeta tables.

inner-join-w-in.sql

SELECT post_id,meta_value
FROM db.wp_postmeta 
INNER JOIN db.wp_posts ON db.wp_postmeta.post_id = db.wp_posts.ID
WHERE post_type IN('post','page','custom_post_type')
AND meta_key = 'some_meta_key' 
AND meta_value 
IN(
'item1','item2','item3'
);