Recent Tags'); } function widget($args, $instance) { extract( $args ); $title = apply_filters('widget_title', $instance['title']); global $post; global $wpdb; $query = "SELECT $wpdb->terms.term_id, $wpdb->terms.name, $wpdb->terms.slug FROM $wpdb->terms INNER JOIN $wpdb->term_taxonomy ON ($wpdb->terms.term_id = $wpdb->term_taxonomy.term_id) INNER JOIN $wpdb->term_relationships ON ($wpdb->terms.term_id = $wpdb->term_relationships.term_taxonomy_id) INNER JOIN $wpdb->posts ON ($wpdb->term_relationships.object_id = $wpdb->posts.ID) WHERE $wpdb->term_taxonomy.taxonomy = 'post_tag' ORDER BY $wpdb->posts.post_date DESC"; $tags = $wpdb->get_results($query); // $query being the above SQL foreach ($tags as $tag) { if (!isset($stack[$tag->term_id])) $stack[$tag->term_id] = $tag; } if($tags): echo $before_widget; ?>