Miscellany

<?php$limit = 10;$meta_key = 'ratings_score';$cat_object = $wp_query->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");?><div id="top10_list"><h2>Top <?php echo $limit; ?> <?php single_cat_title(); ?> Albums</h2><?php foreach($topposts as $post) : setup_postdata($post); ?><!--content--><?php endforeach; ?></div>