michi bloggt!: Twoday's Top 10 Stories (according to the number of different commentators)

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

wow! 5 out of 10. little missy wins it all.

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