First post count on 1ns3rt comments (SLOW)

select count(*) as firstPostCount, name from linkcomment where id in ( select min(id) as i from linkcomment group by linkref order by i) group by name order by firstPostCount desc;

firstPostCount name
371 Jonn
272 t
257 Rich
206 Sam
170 Mr. Happy
125 Ashley
43 Ant
16 Jo
10 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