most recommended post per category

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/