get_queried_object(); if($cat_object->category_parent) $querycat = $cat_object->category_parent; else $querycat = $cat; $topposts = $wpdb->get_results("SELECT $wpdb->posts.* FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id LEFT JOIN $wpdb->post2cat ON $wpdb->post2cat.post_id = $wpdb->posts.ID WHERE $wpdb->post2cat.category_id = '$querycat' AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_date < NOW() ORDER BY $wpdb->postmeta.meta_value DESC LIMIT $limit"); ?>

Top Albums