Home » Labs » Display most popular tags of WordPress blog  

Display most popular tags of WordPress blog

Filed under Labs

Below code will return most used tags on the last 30 days from your WordPress blog. Use jQuery and CSS to customize it according to your theme design.

<ul id="footer-tags">
    <?php $wpdb->show_errors(); ?> 
        global $wpdb;
        $term_ids = $wpdb->get_col("
            SELECT term_id FROM $wpdb->term_taxonomy
            INNER JOIN $wpdb->term_relationships ON $wpdb->term_taxonomy.term_taxonomy_id=$wpdb->term_relationships.term_taxonomy_id
            INNER JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->term_relationships.object_id
            WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= $wpdb->posts.post_date");
if(count($term_ids) > 0){
  $tags = get_tags(array(
    'orderby' => 'count',
    'order'   => 'DESC',
    'number'  => 28,
    'include' => $term_ids,
foreach ( (array) $tags as $tag ) {
    echo '<li><a href="' . get_tag_link ($tag->term_id) . '" rel="tag">' . $tag->name . '</a></li>';


It's only fair to share...Share on Google+Tweet about this on TwitterShare on Facebook

Posts you may like: