Title: Sorting posts
Last modified: May 30, 2018

---

# Sorting posts

 *  Resolved [chowix](https://wordpress.org/support/users/chowix/)
 * (@chowix)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/sorting-posts-12/)
 * Hello, I wanted to ask if there is a possibility to sort posts according to the
   star value of given posts?
 * Regards
    David

Viewing 1 replies (of 1 total)

 *  Plugin Author [Igor Yavych](https://wordpress.org/support/users/flyerua/)
 * (@flyerua)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/sorting-posts-12/#post-10347388)
 * Hello. Yes, that’s possible with a query like this for example (very basic):
 *     ```
       SELECT wp_posts.*, COALESCE(wp_spr_rating.points/wp_spr_rating.votes,0) as rating  FROM wp_posts 
       LEFT/INNER JOIN wp_spr_rating on wp_spr_rating.post_id = wp_posts.ID
       ORDER BY wp_spr_rating.points/wp_spr_rating.votes ASC/DESC
       ```
   
    -  This reply was modified 8 years, 2 months ago by [Igor Yavych](https://wordpress.org/support/users/flyerua/).
    -  This reply was modified 8 years, 2 months ago by [Igor Yavych](https://wordpress.org/support/users/flyerua/).

Viewing 1 replies (of 1 total)

The topic ‘Sorting posts’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/simple-rating_010101.svg)
 * [Simple Rating](https://wordpress.org/plugins/simple-rating/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/simple-rating/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/simple-rating/)
 * [Active Topics](https://wordpress.org/support/plugin/simple-rating/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/simple-rating/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/simple-rating/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Igor Yavych](https://wordpress.org/support/users/flyerua/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/sorting-posts-12/#post-10347388)
 * Status: resolved