Sorting posts

  • Resolved chowix

    (@chowix)


    6 years, 5 months ago

    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

    (@flyerua)

    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 6 years, 5 months ago by Igor Yavych.
    • This reply was modified 6 years, 5 months ago by Igor Yavych.
Viewing 1 replies (of 1 total)
  • The topic ‘Sorting posts’ is closed to new replies.