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.