Reviews that are moderated, do not keep their ratings

[dd32]

Currently when a review is moderated, the original review is moved to an 'archived' status and a new 'public' status review it put into it's place.

Sometimes this can be for something as trivial as removing a link to the reviewers site.

When that happens, the ratings data stays attached to the post_id of the archived post, and the new public review doesn't have an attached ratings record.

The public view of the rating will still show the rating (as ratings there are queried by user_id) but a plugin directory review view won't as it'll skip over the rating record for the archive'd review.

There's two options here, of which only the first seems like a real fix

• Keep the ratings record linked to the correct post_id of the review
• Change the plugin directory to query the Support forum threads, and then look up the ratings for each by user_id, instead of the current 'Query all ratings, and pull their associated posts' which is far more performant given the number of reviews vs support posts.

[dd32]

An example of where this happened (I've corrected the underlying data) was here: ​https://wordpress.slack.com/archives/C02QB8GMM/p1552596311241700