diaspora/diaspora — Issue #2928: New Feature Popular Tags
Author: diasp
Created: 2012-02-24 14:21:30+00:00
State: open

What do you think about popular tags like https://diasp.eu/popular_tags?

With this query?

select t.name, count(*) as c from tag_followings as tf, tags as t
where t.id = tf.tag_id
group by tag_id
order by c desc
limit 100

Other ideas or solutions?