Twoday's Top 10 Stories (according to the number of different commentators)
- 57 http://fsarch.twoday.net/stories/97355
- 43 http://missunderstood.twoday.net/stories/485393
- 41 http://humanarystew.twoday.net/stories/1618003
- 40 http://missunderstood.twoday.net/stories/476093
- 38 http://aurisa.twoday.net/stories/1343238
- 37 http://missunderstood.twoday.net/stories/184513
- 37 http://gluecklich.twoday.net/stories/285501
- 35 http://derbaron.twoday.net/stories/1655343
- 34 http://missunderstood.twoday.net/stories/250233
- 34 http://missunderstood.twoday.net/stories/595975
Until today i didn't know that there is a "select count(distinct value) from..", which comes in very handy in order to generate such a list.
mysql> select t1.TEXT_ID, t1.TEXT_F_SITE, count(distinct t2.TEXT_F_USER_CREATOR) as cnt from AV_TEXT t1, AV_TEXT t2 where t2.TEXT_F_TEXT_STORY = t1.TEXT_ID group by t1.TEXT_ID order by cnt desc limit 10;
michi - 29.Mar 2006 18:13 - blogosphaerisches