1) ratio of posts male/female per section, and for the entire site

if you wanna get crazy and look over at the site-wide ratio over the last X years that would be cool. i love some trend analysis

2) standard deviation of posts per week per section per user for the top 50 posters

3) something that shows the top posters per section would be cool

4) Top 100 users as ranked by (bytes posted/posts).

5) can you tell the percentage breakdown by board for each user?

x% in chit chat
x% in sports talk
etc

6) what day had the most posts

7) what day had the most threads created

8) which day had the highest number unique users post ever

9) top ten posters per section

10) which thread has had the most views

11) what is the oldest thread without a reply

add new ones/ones i may have missed with number for ease of answering

5/21/2008 5:42:01 PM

Quote :

"6) what day had the most posts"

egg hunt day

5/21/2008 5:42:57 PM

awesome, thanks nothing22

5/21/2008 5:46:07 PM

9 is a really good one...do that one first please

5/21/2008 5:47:44 PM

i'll be in that one for chit chat and that's probably it

5/21/2008 9:23:14 PM

How many times has qntmfred said DA you SOB?

5/21/2008 9:24:34 PM

not enough

5/21/2008 9:24:58 PM

11) /message_topic.aspx?topic=22161

i want to see who kills the most threads and who creates the most no-reply threads

[Edited on May 21, 2008 at 9:27 PM. Reason : ok thx]

5/21/2008 9:26:54 PM

Quote :

"there's an error there, sir. i'm certain i've called baonest a nigger enough times to be on that list"

haha

BTTT nigger
nigger
nigger

nigger
for 145

[Edited on May 21, 2008 at 9:28 PM. Reason : ]

5/21/2008 9:27:24 PM

that's not exactly a stat bigman

5/21/2008 9:33:27 PM

i was answering #11 ok

5/21/2008 9:37:37 PM

ah yes. my mistake. care on sir

[Edited on May 21, 2008 at 9:39 PM. Reason : AND GET YOUR OWN THREAD OK I MAKE THE ANSWERS HERE MISTER]

5/21/2008 9:39:00 PM

this is my thread

LOOK WHO CREATED IT

5/21/2008 9:42:50 PM

any more stats or do these take a while

5/21/2008 9:47:25 PM

as long as it takes to create the query and then create the corresponding graph if there is is one

5/21/2008 9:48:20 PM

who does tww hate the most?
love the most? joie prolly

5/21/2008 9:51:00 PM

Quote :

"any more stats or do these take a while"

they take as long as it takes for me to be bored enough to take the time to do it. i have other things i'm doing too. but since you asked, here's #9 (not including archived posts)

Lounge
David0603 3418
drunknloaded 2526
pilgrimshoes 2485
Str8BacardiL 2147
BobbyDigital 2123
OmarBadu 1775
ssjamind 1754
Smath74 1717
gunzz 1478
jackleg 1439

Chit Chat
drunknloaded 29106
ambrosia1231 13018
pilgrimshoes 10478
jackleg 9079
DiamondAce 8961
ReceiveDeath 8680
chembob 8602
blasphemour 7718
pwrstrkdf250 7548
FykalJpn 7024

Premium Palace
NCSUStinger 8263
mr_willis 4462
Tyler Durden 1575
Nerdchick 1322
EnderJRD 947
aaronburro 689
udorawala 672
puck_it 635
EMCE 605
zorthage 472

Old School
sumfoo1 387
David0603 317
AxlBonBach 298
Smath74 296
sober46an3 281
OmarBadu 275
BobbyDigital 263
theDuke866 239
Jaybee1200 238
roddy 238

Sports Talk
TreeTwista10 11914
Jaybee1200 10409
packboozie 7201
NyM410 6927
skokiaan 6885
Ernie 6812
pttyndal 6289
dweedle 6205
wolfAApack 5976
ncsuftw1 5802

Entertainment
Woodfoot 4215
CalledToArms 3937
spöokyjon 3891
vinylbandit 3192
TreeTwista10 3129
Josh8315 3107
statefan24 2931
cyrion 2652
CharlieEFH 2452
Wraith 2424

Tech Talk
Noen 2937
synapse 2736
quagmire02 2404
Prospero 2172
Charybdisjim 2059
agentlion 2023
Golovko 1824
dFshadow 1806
esgargs 1724
GraniteBalls 1567

The Garage
optmusprimer 7437
BigBlueRam 7113
69 4552
toyotafj40s 4127
zxappeal 4052
baonest 3426
sumfoo1 3248
JBaz 2977
Igor 2733
Jeepman 2125

The Soap Box
TreeTwista10 9463
salisburyboy 4576
LoneSnark 4473
hooksaw 4265
Mr. Joshua 4160
Gamecat 3969
sarijoul 3380
Josh8315 3357
joe_schmoe 3242
Woodfoot 3213

Classifieds
synapse 2869
ncemt_03 1823
drunknloaded 1798
quagmire02 1630
Ansonian 1463
Beckers 1282
Str8BacardiL 1125
XSMP 1055
tripleD4u 1041
jchill2 909

Study Hall
drunknloaded 973
SouthPaW12 528
ambrosia1231 400
Perlith 378
Supplanter 369
virga 333
Aficionado 331
Ernie 329
brianj320 329
Probasesteal 312

Feedback Forum
drunknloaded 1661
gunzz 1519
Smath74 1136
jackleg 961
EMCE 838
Beardawg61 751
FroshKiller 734
Str8BacardiL 625
NCSUStinger 623
nutsmackr 584

Editor's Corner
EVroccck 544
CrazyBenni 476
Maugan 234
nasteeerr 205
Eulogist 204
scud 200
Satch 184
Joe 172
CrazyJ 150
mdbncsu 129

Mod Forum
marko 860
Beardawg61 713
gunzz 531
OmarBadu 331
CassTheSass 312
BobbyDigital 304
synapse 302
sparky 237
theDuke866 216
Maverick 205

Trash Bin
ReceiveDeath 16800
Airbag 3589
JTMONEYNCSU 3255
JEWS 2821
cynosural 2033
Ashes 1646
edistance 1495
GREEN JAY 1363
drunknloaded 1313
rtc407 1193

5/21/2008 9:55:13 PM

Quote :

"Editor's Corner"

WTF

5/21/2008 9:56:24 PM

lol @ trash bin

RD #1

5/21/2008 9:56:38 PM

I got 5th!

I plead tha fif! FIVE! FIF!

5/21/2008 9:57:33 PM

LOL

5/21/2008 9:58:35 PM

hell yeah i made some lists...most proud of study hall...dnl for study hall mod

5/21/2008 9:59:11 PM

here's #10, most viewed threads

EVERY TWW USER POST HERE AT LEAST ONCE : 1299037, 52840
What are you thinking about at this very moment? : 947990, 116428
Christina-Model.com : 619348, 2682
Put your name on the closings list..... : 393801, 1551
The Hottest Girl you have ever seen? : 376943, 2371
Papsmear's Continuous Titty Thread : 355874, 1587
World of Warcraft : 329581, 18802
Controversial TWW Pictures : 311619, 1730
post your favorite picture from the gallery above : 310317, 10178
Scarlett Johansson Finally Freed Dem Titties : 296297, 257

5/21/2008 9:59:34 PM

lol @ trash bin

RD #1

5/21/2008 9:59:51 PM

hahahaha

we did not cheat to do that I swear

5/21/2008 9:59:56 PM

Quote :

"Study Hall drunknloaded 973 SouthPaW12 528 ambrosia1231 400 Perlith 378 Supplanter 369 virga 333 Aficionado 331 Ernie 329 brianj320 329 Probasesteal 312"

That's surprising

5/21/2008 10:00:12 PM

This thread just proves how awesome I think I am.

5/21/2008 10:00:30 PM

how long would it take to get the stats with archieved posts?

5/21/2008 10:00:43 PM

longer than i'm interested in spending tonight. i gotta do some other stuff soon

5/21/2008 10:04:01 PM

message_topic.aspx?topic=302903

LAWL

EUPHALO FTW

5/21/2008 10:04:06 PM

Quote :

"Trash Bin ReceiveDeath 16800"

hahahahaha

Quote :

"Scarlett Johansson Finally Freed Dem Titties : 296297, 257"

hahahahaha

5/21/2008 10:06:01 PM

reply doesnt work




[Edited on May 21, 2008 at 10:21 PM. Reason : ok, it works now]

5/21/2008 10:21:05 PM

Glad we have a transcript of you working through that problem.

5/21/2008 10:24:18 PM

most 's

!!

5/21/2008 10:24:21 PM

stillfursha has the most 's ever i imagine

5/21/2008 10:27:07 PM

WOOOOOOOOOOOOOOO i made a list

5/21/2008 11:30:50 PM

^^hooksaw

5/21/2008 11:38:20 PM

Quote :

"Classifieds synapse 2869 ncemt_03 1823 drunknloaded 1798 quagmire02 1630 Ansonian 1463 Beckers 1282 Str8BacardiL 1125 XSMP 1055 tripleD4u 1041 jchill2 909"

I HATE BEING SECOND BEST




I'm going to go on a buying/selling rampage starting tomorrow am to rectify this situation

5/22/2008 12:20:26 AM

wow, I'm ranked in FF

I must be a bitching mother fucker

5/22/2008 12:23:57 AM

Quote :

"6) what day had the most posts"

4/6/2004 had 11034 posts

Quote :

"7) what day had the most threads created"

4/6/2004 with 607 new threads

[Edited on May 22, 2008 at 11:12 AM. Reason : .]

5/22/2008 10:56:38 AM

^ Coach search.

How did that work out for us?

5/22/2008 10:58:58 AM

Quote :

"8) which day had the highest number unique users post ever"

on 2/18/2004 there were 1010 unique users that posted

5/22/2008 11:02:58 AM

damn 4/6/05 was like a year after the 1 thread per hour rule was started

5/22/2008 11:05:38 AM

oops, my bad. it was 2004, same day as the most posts

[Edited on May 22, 2008 at 11:13 AM. Reason : the 3rd egg hunt /story.aspx?story=565]

5/22/2008 11:12:31 AM

i thought for sure i'd be in the top 10 for chit chat

guess all my post were pre-purge

5/22/2008 11:15:21 AM

it was all downhill after that

5/22/2008 11:16:00 AM

pilgrimshoes for lounge mode replacement for Cass!

5/22/2008 11:43:46 AM

lol dnl for lounge mean, median, mode, range

5/22/2008 11:45:51 AM

that's pretty clever dnl

5/22/2008 11:51:57 AM

somebody took st311

5/22/2008 11:53:19 AM