Query php con join

[mr.click]

SELECT id_post FROM termine_articolo WHERE id_termine IN (

SELECT id_termine FROM tipo_termine WHERE post_tag = 'bello' AND category = 'ciao'

)