Untitled

                SELECT DISTINCT
                        terms2.term_id as tag_id,
                        terms2.name as tag_name,
                        null as tag_link,
                        terms2.slug as slug,
                        t2.taxonomy as taxonomy,
                        t2.count as count,
                        p2.*
                FROM

                wp_posts as p2
                LEFT JOIN wp_term_relationships as r2 ON p2.ID = r2.object_ID
                LEFT JOIN wp_term_taxonomy as t2 ON r2.term_taxonomy_id = t2.term_taxonomy_id
                LEFT JOIN wp_terms as terms2 ON t2.term_id = terms2.term_id
                WHERE
p2.post_date > DATE_SUB(NOW(), INTERVAL 30 DAY)
                GROUP by tag_id
                ORDER by count
                DESC
                limit 3