Sorry, hadn't read this. Do you want posts just in 2007 ? If so it goes like this...
Code:
select username,count(*) as total from post where dateline between 1167627600 and 1199163600 group by username having total > 20 order by total desc;
Code:
| LAURENU2 | 1058 |
| Bok | 739 |
| IronBits | 463 |
| em99010pepe | 447 |
| Fozzie | 392 |
| Darkness Productions | 360 |
| jasong | 318 |
| Paratima | 266 |
| alpha | 241 |
| the-mk | 236 |
| gopher_yarrowzoo | 164 |
| birdman2584 | 163 |
| Digital Parasite | 125 |
| JustEmazing | 114 |
| Amaroque | 97 |
| Jeff | 95 |
| Helix_Von_Smelix | 86 |
| Death | 84 |
| Joe O | 82 |
| vjs | 82 |
| BlisteringSheep | 77 |
| cwhyl | 70 |
| Shish | 61 |
| PCZ | 60 |
| n7vxj | 57 |
| Angus | 54 |
| magnav0x | 52 |
| paleseptember | 46 |
| tiosuper | 42 |
| wirthi | 41 |
| engracio | 40 |
| ronbo54 | 39 |
| caferace | 37 |
| Merlin45 | 37 |
| glennpat | 36 |
| Sleepsalot | 34 |
| umccullough | 31 |
| Matt | 30 |
| Jkusuda | 29 |
| riptide | 29 |
| Moogie | 29 |
| hhh | 28 |
| BlackMountainCow | 28 |
| Guilherme | 28 |
| Chinasaur | 28 |
| maefly | 26 |
| Chuck | 25 |
| IJump | 25 |
| Brucifer | 23 |
| Tallbill | 22 |
| Adywebb | 21 |
| GHOST | 21 |
| philmoore | 21 |
| KAMCOBILL | 21 |
On a personal note I'm getting pretty close to 5000 posts