Title: [Plugin: Easy Popular Posts] From specific category
Last modified: August 19, 2016

---

# [Plugin: Easy Popular Posts] From specific category

 *  [syru](https://wordpress.org/support/users/syru/)
 * (@syru)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/plugin-easy-popular-posts-from-specific-category/)
 * Is there a way to show popular posts from specific category?
 * Thank you

Viewing 1 replies (of 1 total)

 *  [zudie](https://wordpress.org/support/users/zudie/)
 * (@zudie)
 * [15 years, 2 months ago](https://wordpress.org/support/topic/plugin-easy-popular-posts-from-specific-category/#post-1996233)
 * Yes, modify the query in the plugin code:
 *     ```
       global $wpdb;
       $posts = $wpdb->get_results("
       SELECT comment_count, ID, post_title
       FROM $wpdb->posts wposts
       LEFT JOIN $wpdb->term_relationships ON (wposts.ID = $wpdb->term_relationships.object_id)
       LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
       WHERE $wpdb->term_taxonomy.taxonomy = 'category'
       AND $wpdb->term_taxonomy.term_id IN($my_category_id)
       AND post_type='post' AND post_status = 'publish' AND comment_count >= " . $ns_options['comments']."
       		" . $sqlorder . " LIMIT 0 , " . $ns_options['count']
       	);
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: Easy Popular Posts] From specific category’ is closed to new
replies.

 * ![](https://ps.w.org/easy-popular-posts/assets/icon-128x128.png?rev=1053584)
 * [Easy Popular Posts](https://wordpress.org/plugins/easy-popular-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/easy-popular-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/easy-popular-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/easy-popular-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/easy-popular-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/easy-popular-posts/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [zudie](https://wordpress.org/support/users/zudie/)
 * Last activity: [15 years, 2 months ago](https://wordpress.org/support/topic/plugin-easy-popular-posts-from-specific-category/#post-1996233)
 * Status: not resolved