[Teri]

No utilizo MySQL, pero en SQL-Server con esto funciona

DELETE phpbb_posts_text
FROM phpbb_posts_text LEFT JOIN phpbb_posts ON phpbb_posts_text.post_id = phpbb_posts.post_id
WHERE (phpbb_posts.post_id) Is Null

Espero que te sirva