NSC's most promiscuous (biggest wasters) 2009

[simon195]

WHAT ABOUT THESE POSTERS ?

 

[maffew]

SELECT saddos.username, count(b_llocks.post)
FROM
users saddos,
posts b_llocks
WHERE
saddos.username = b_llocks.username
AND
Year(b_llocks.datetime) = 2009
AND
saddos.teamsupported='BRIGHTON'
GROUP BY saddos.name
HAVING count(b_llocks.post)>to_do
ORDER BY has_a_life DESC

old school, I do believe your joins do not meet ANSI standards

 

[strings]

strings?

Number 30!

 

[Simster]

My dependency on this site is waning. Down from 23rd to 39th place!

 

[Giraffe]

Full list of posters / posts made in 2009 can be viewed here...

NSC 2009 posters - Google Docs

Ooh I just scrape into 50th!! Best keep that quiet with the Mrs, she thinks I'm on it all the time, a charge I deny.

 

[Mr Banana]

25. clippedgull 3152
28. Notters 2943
35. Twinkle Toes 2698

Losers

 

[clapham_gull]

old school, I do believe your joins do not meet ANSI standards

The SQL standards are full of contradictions. So much for the relational model.

I prefer the so called "old" approach which is much closer to the relational algebra that it was originally based on.

You don't need an "inner join", which will be converted to the same query tree anyway underneath the hood.

 

[El Presidente]

How many of those in the list were subject to bans and/or flounces in 2009?

 

[Bevendean Hillbilly]

Not even in the top 70...but still I need to re-evaluate my life.

 

[clippedgull]

Losers

 

[Taybha]

sorry

 

[murraymints4brighton]

Bloody hell I am in the top 40 with 2603, I thought I didn't post that much! I have also had the same profile picture for most of those, time for a change I think...

 

[simon195]

Bloody hell I am in the top 40 with 2603, I thought I didn't post that much! I have also had the same profile picture for most of those, time for a change I think...

how about this one ....

 

[Ninja Elephant]

#14... not that bad to be fair.

 

[Napper]

Gimps

 

[Kinky Gerbil]

Better than last year.....

Still #1

 

[hans kraay fan club]

Good.

 

[Uncle Buck]

Blimey, not having time to get on here much during the day really have impacted on my posting.

 

[Ninja Elephant]

Just a reminder of last years.

 

[Tim Over Whelmed]

Phew!