Let's hear it!

[CrAz3D]

I so fucking dominate here.

[truste1]

losers nobody cares about your life.

[CrAz3D]

My cousin's new car ... oh snap

[iago]

Here, I changed up the query a bit:

mysql> select memberName, COUNT from (select ID_MEMBER, count(*) as COUNT from smf_messages where subject like "%Let's hear it!" group by ID_MEMBER) as a LEFT JOIN smf_members ON smf_members.ID_MEMBER = a.ID_MEMBER order by COUNT desc limit 0, 10;
+----------------+-------+
| memberName     | COUNT |
+----------------+-------+
| CrAz3D         |  1313 | 
| NULL           |   851 | 
| Newby          |   452 | 
| Sidoh          |   266 | 
| iago           |   216 | 
| R.a.B.B.i.T    |   201 | 
| BigAznDaddy    |   192 | 
| leet_muffin    |   186 | 
| InsaneJoey[e2] |   154 | 
| Rule           |   139 | 
+----------------+-------+
10 rows in set (1.32 sec)

NULL would be deleted users, almost certainly entirely Trust. :)

[BigAznDaddy]

k so as you guys know i am going to college next year and i have absolutly no money after tuition :( and i dont want to live at home so the solution: build a house. my dad owns a warehouse and it is like a 2 story building but is only used as one ( if that makes sense) anyways on top of the office i decided there was enough room to make 2 rooms one for me and one for my brother and it is going really good so far. i am almost completed. i just have a couple more walls to insulate and drywall and i still need to put in carpet or whatnot. but tomorrow i will post pictures.

[Ender]

The disparity between 1st and 2nd, and 2nd and 3rd, is pretty hilarious.

It's pretty obvious that Trust and CrAz3d are so far ahead because they post their life problems (and have all the more to post!) but what about the disparity between 1st and 2nd?

After a little thought, I have concluded that CrAzed pulls ahead because he not only posts about his life problems, but he also posts pictures of trucks, cars, and mexicans.

Also, I think alcohol is involved. The ratio 1313 : 851 : 452, approximately 13 : 8 : 4 is pretty much the ratio that Craz3d, Trust, and Newby drink in.

[Blaze]

I'm only 15th highest (in this thread).  Trust's second account is already 19th.   :D

Also, lower is better, I think.  :)

[Super_X]

I'm only 15th highest (in this thread).  Trust's second account is already 19th.   :D

Also, lower is better, I think.  :)

I must be one of the best. :D

[Krazed]

Now what's trust's new account at? That might bring him a little closer to crazed.

[iago]

Here, top 50:

mysql> select memberName, COUNT from (select ID_MEMBER, count(*) as COUNT from smf_messages where subject like "%Let's hear it!" group by ID_MEMBER) as a LEFT JOIN smf_members ON smf_members.ID_MEMBER = a.ID_MEMBER order by COUNT desc limit 0, 50;
+----------------+-------+
| memberName     | COUNT |
+----------------+-------+
| CrAz3D         |  1313 | 
| NULL           |   851 | 
| Newby          |   452 | 
| Sidoh          |   266 | 
| iago           |   217 | 
| R.a.B.B.i.T    |   201 | 
| BigAznDaddy    |   193 | 
| leet_muffin    |   186 | 
| InsaneJoey[e2] |   154 | 
| Rule           |   139 | 
| Towelie[x86]   |   135 | 
| deadly7        |   130 | 
| dark_drake     |   121 | 
| Hitmen         |   109 | 
| Blaze          |   101 | 
| Ender          |    97 | 
| zorm           |    90 | 
| Explicit[nK]   |    88 | 
| truste1        |    84 | 
| krazed         |    60 | 
| Warrior        |    58 | 
| DeuceNQuota    |    56 | 
| Quik           |    55 | 
| Killer360      |    52 | 
| Ergot          |    38 | 
| Camel          |    38 | 
| Super_X        |    35 | 
| DJO910         |    29 | 
| Kaleeko        |    27 | 
| Michael        |    21 | 
| CetniK         |    21 | 
| GameSnake      |    20 | 
| unTactical     |    20 | 
| TeHFoOoL       |    16 | 
| warz           |    11 | 
| igimo          |     9 | 
| chuck          |     7 | 
| Lobo           |     7 | 
| xir            |     7 | 
| MyndFyre       |     5 | 
| disco          |     4 | 
| Assault        |     4 | 
| Topaz          |     4 | 
| Brandon        |     3 | 
| dlStevens      |     3 | 
| SNiFFeR        |     3 | 
| nslay          |     2 | 
| Skywing        |     2 | 
| Islanti        |     2 | 
| ZeroX          |     2 | 
+----------------+-------+
50 rows in set (1.77 sec)

[warz]

make that 12.

[CrAz3D]

This is still my thread, bitches.

[Camel]

Here, top 50:

You should make a mod which puts that at the top of any thread with more than X posts.

[CrAz3D]

Date with Stacey on Saturday, probably poker on Wednesday with her & friends.  yay!

Dinner/drinks tonight with friend who is back in town for a little while.

[iago]

Here, top 50:

You should make a mod which puts that at the top of any thread with more than X posts.

Bad idea. First, because it's heavy on the database. And second, because it would encourage people to post even more crap in already bloated threads.