Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $currentcatobj = get_category(get_query_var('cat'),false);
- $currentcat = $currentcatobj->term_id;
- $includecats = " AND $wpdb->posts.ID IN (
- SELECT object_id
- FROM $wpdb->term_relationships AS r
- JOIN $wpdb->term_taxonomy AS x ON x.term_taxonomy_id = r.term_taxonomy_id
- JOIN $wpdb->terms AS t ON t.term_id = x.term_id
- WHERE x.taxonomy = 'category'
- AND object_id IN
- (
- SELECT object_id
- FROM $wpdb->term_relationships AS r
- JOIN $wpdb->term_taxonomy AS x ON x.term_taxonomy_id = r.term_taxonomy_id
- JOIN $wpdb->terms AS t ON t.term_id = x.term_id
- WHERE x.taxonomy = 'category'
- AND t.term_id IN (".$currentcat.")))";
- $mostpopular = $wpdb->get_results("SELECT $wpdb->posts.ID, $wpdb->posts.post_title $fields FROM $wpdb->posts $join WHERE $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_password = '' AND $range $force_pv $nopages $exclude $includecats GROUP BY $wpdb->posts.ID ORDER BY $sortby DESC LIMIT " . $instance['limit'] . "");
- $cat_name = get_cat_name($currentcat);
- $content = "$cat_name";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement