Support » Plugin: WTI Like Post » Order by value column with mysql query

  • Hi,

    Nice plugin I like it.
    However, I am trying to create a mysql query to get posts from the database which have and haven’t been liked. then order them from liked to not liked to disliked.
    How would I go about this?

    Cheers

Viewing 1 replies (of 1 total)
  • Plugin Author webtechideas

    (@webtechideas)

    The plugin’s vote entries are stored in wti_like_post table which has post id and the vote value. You can join (preferrably left) posts table to this table group by post id and order by descending order of sum of vote value.

Viewing 1 replies (of 1 total)
  • The topic ‘Order by value column with mysql query’ is closed to new replies.