recent-hashtags.sql

Select distinct ht.ht_text, ht.ht_update_timestamp
FROM recentchanges AS rc
JOIN hashtag_recentchanges AS htrc
ON htrc.htrc_id = rc.htrc_id
JOIN hashtags AS ht
ON ht.ht_id = htrc.ht_id
WHERE rc.rc_type = 0
AND rc.htrc_lang LIKE 'en'
AND ht.ht_text NOT IN('redirect', 'ifexist', 'switch', 'ifexpr')
AND ht.ht_text REGEXP '[[:alpha:]]+'
AND CHAR_LENGTH(ht.ht_text) > 1
ORDER BY ht.ht_update_timestamp DESC
LIMIT 25;

Some possible hashtag charts:

• Most recent tags
• Tags used on the most revisions
• Tags sorted by language
• A few promoted tags (like #editathon)