“yasr_most_or_highest_rated_posts” …custom query

  • Hello
    I want to show “yasr_most_or_highest_rated_posts” by category.
    How to call it??

    $wpdb->get_results(“SELECT post_id, number_of_votes, sum_votes
    FROM ” . YASR_VOTES_TABLE . “, $wpdb->posts AS p
    WHERE post_id = p.ID
    AND number_of_votes >= 1
    AND p.post_status = ‘publish’
    ORDER BY number_of_votes DESC, sum_votes DESC LIMIT 10”);

Viewing 1 replies (of 1 total)
  • Plugin Contributor dudo

    (@dudo)

    Hello,
    1) you’re using an old version of YASR (the query still have the constant YASR_VOTES_TABLE, that isn’t used in the new versions).

    2) This feature is available with a simple gui with the YASR Custom Ranking extension

Viewing 1 replies (of 1 total)
  • The topic ‘“yasr_most_or_highest_rated_posts” …custom query’ is closed to new replies.