I'm trying to delete all comments from posts in a certain category in a Wordpress database.
The Wordpress database is rather complicated so this must be probably some join of
wp_term_relationships as the categories are not stored with neither posts nor comments.
How can I do this? I'm struggling to come up with a query.