On My Magento 2 Site guest review was enabled, Someone spam review around several hundred thousand, I need to delete all pending reviews from the database. I am not interested to truncate reviews because there some real reviews approved. Also, delete from admin a few day's tasks.
I got below table:
email_review review review_detail review_entity review_entity_summary review_status review_store rating rating_entity rating_option rating_option_vote rating_option_vote_aggregated rating_store rating_title
Any suggestion DELETE FROM review; as relation table data.