[REVIEWS] fix_review_state

[aurorahey]

What problem is this solving?

the previous fix about loading star causing infinite request, this PR fix both the infinite request and the PDP loading star problem. Also improved GetAverageRatingByProductId query.

How to test it?

1. Use Incognito mode to open link https://esika.tiendabelcorp.cl/vibranza-perfume-de-mujer-45-ml/p?workspace=aurora you should see all the stars showing

2. open any review page to see the requests

[vtex-io-ci-cd[bot]]

Hi! I'm VTEX IO CI/CD Bot and I'll be helping you to publish your app! 🤖

Please select which version do you want to release:

• [x] Patch (backwards-compatible bug fixes)

• [ ] Minor (backwards-compatible functionality)

• [ ] Major (incompatible API changes)

And then you just need to merge your PR when you are ready! There is no need to create a release commit/tag.

• [ ] No thanks, I would rather do it manually 😞

[vtex-io-docs-bot[bot]]

Beep boop :robot:

I noticed you didn't make any changes at the docs/ folder

• [ ] There's nothing new to document :thinking:
• [ ] I'll do it later :disappointed:

In order to keep track, I'll create an issue if you decide now is not a good time

• [x] I just updated :tada::tada:

[github-actions[bot]]

	Messages
:book:	:heart: Thanks!
:book:	:tada: PR additions = `34`, PR deletions = `35`

Generated by :no_entry_sign: dangerJS against 8d3b34098d4ae56f7c4921e2adfbd6302fa30ebd

[sonarcloud[bot]]

[vtex-apps_reviews-and-ratings-ts] Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

0.0% Coverage
0.0% Duplication

[sonarcloud[bot]]

[vtex-apps_reviews-and-ratings-dotnet] Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

0.0% Coverage
0.0% Duplication

[github-actions[bot]]

Cy-Runner

 [✓] Execution time
  -  initWorkspace................. 00:00:05
  -  installApps................... 00:00:00
  -  uninstallApps................. 00:00:00
  -  linkApp....................... 00:00:30
  -  strategy...................... 00:10:53
  -  teardown...................... 00:00:18
  -  total......................... 00:11:52

Cypress Dashboard

 [✓] https://cloud.cypress.io/projects/964exx/runs/298

Success

 [✓] The test ran successfully, well done!