Vote it up plugin WordPress

Agent Wordpress answers:

Use the code given here, http://wordpress.org/support/topic/plugin-vote-it-up-show-top-voted-post-in-index-page?replies=5

but change the query to this,

$querystr = "
SELECT *
FROM $wpdb->posts
WHERE post_status = 'publish'
AND post_type = 'post'
AND $wpdb->term_taxonomy.term_id IN (22)
AND $wpdb->term_taxonomy.taxonomy = 'category'
ORDER BY post_date DESC
";


also don't forget to replace the term_id (22 in code above) with your category id.

---

---

---

enodekciw answers:

$querystr = "
SELECT *
FROM $wpdb->posts
LEFT JOIN $wpdb->term_relationships
ON($wpdb->posts.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.term_id = YOUR_CAT_ID
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->posts.post_type = 'post'
ORDER BY post_date DESC
";

Try this query, just don't forget to replace YOUR_CAT_ID with your category ID. It should work.

---