most recommended post per category

  • Resolved pictwee

    (@pictwee)


    11 years, 10 months ago

    Hello!

    This plugin is great – I use it at https://www.pictwee.com – would it be possible to get the most recommended post of a specific category?

    I think I have to change this?!

    $request = "SELECT * FROM $wpdb->posts, $wpdb->postmeta";
$request .= " WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id";
$request .= " AND post_status='publish' AND post_type='$post_type' AND meta_key='_recommended'";
$request .= " ORDER BY $wpdb->postmeta.meta_value+0 DESC LIMIT $numberOf";
$posts = $wpdb->get_results($request);

    THANKS FOR YOUR HELP!!!

    https://www.ads-software.com/extend/plugins/i-recommend-this/

Viewing 1 replies (of 1 total)
  • Plugin Author Harish Chouhan

    (@hchouhan)

    Hello,

    yes you would need to write your own query. Are you planning to modify directly the source code of the plugin? If you do so, I hope you understand updates will break it.

Viewing 1 replies (of 1 total)
  • The topic ‘most recommended post per category’ is closed to new replies.