Fast but slightly innaccurate first post count for 1ns3rt comments

select count(*) as firstPostCount, n as Name from (select name as n from (select linkcomment.name, links.id from links, linkcomment where links.id = linkcomment.linkref order by links.id) t group by id) tmp group by n order by firstPostCount desc;

firstPostCount Name
370 Jonn
273 t
255 Rich
205 Sam
171 Mr. Happy
126 Ashley
43 Ant
16 Jo
11 rob
7 Owen
3 Michael
3 Student Porter
2 Annie
1 jenny
1 Erik Estrada
1 Larry
1 really Rich
1 Balls
1 Tom
1 Jonn: Rated 12A
1 Clare
1 michelle