Title: Rate all posts
Last modified: May 14, 2020

---

# Rate all posts

 *  Resolved [Pedro A.](https://wordpress.org/support/users/phcaraujo/)
 * (@phcaraujo)
 * [6 years ago](https://wordpress.org/support/topic/rate-all-posts/)
 * Could you provide me with an SQL command to put voting on all my posts?
 * Random number of votes between 1 ~ 5
    And stars between 3 ~ 5
 * Post type = downloads
    -  This topic was modified 6 years ago by [Pedro A.](https://wordpress.org/support/users/phcaraujo/).

Viewing 1 replies (of 1 total)

 *  Plugin Support [Blaz K.](https://wordpress.org/support/users/blazk/)
 * (@blazk)
 * [5 years, 12 months ago](https://wordpress.org/support/topic/rate-all-posts/#post-12850370)
 * Hi [@phcaraujo](https://wordpress.org/support/users/phcaraujo/),
 * that is a relatively complicated SQL command, but I can guide you in the right
   direction. So, the plugin stores votes in post meta. There are 3 fields that 
   are relevant: rmp_vote_count, rmp_rating_val_sum and rmp_avg_rating. rmp_rating_val_sum/
   rmp_vote_count should equal rmp_avg_rating with a max one decimal. I hope this
   will help you.
 * Regards,
    Blaz

Viewing 1 replies (of 1 total)

The topic ‘Rate all posts’ is closed to new replies.

 * ![](https://ps.w.org/rate-my-post/assets/icon-128x128.png?rev=2045796)
 * [Rate My Post - Star Rating Plugin by FeedbackWP](https://wordpress.org/plugins/rate-my-post/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rate-my-post/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rate-my-post/)
 * [Active Topics](https://wordpress.org/support/plugin/rate-my-post/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rate-my-post/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rate-my-post/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Blaz K.](https://wordpress.org/support/users/blazk/)
 * Last activity: [5 years, 12 months ago](https://wordpress.org/support/topic/rate-all-posts/#post-12850370)
 * Status: resolved