In the news

^racist to newbs

It's got nothing to do with new or old. I thought this is a friendly forum, but obviously I thought wrong.

^^^newbist

Extra: This is a friendly place (generally), you just gotta take the rough with the smooth. Nowhere is perfect.

Friendliest forum on the internet!

extra - your membership digits really do belie your newbevetie

It's got nothing to do with new or old. I thought this is a friendly forum, but obviously I thought wrong.

It's not known as London's least friendly cycling forum for nothing.

I would love to see some stats for this thread from Velocio covering the last few days. It seemed to be posted on every few seconds for days.

Can someone please tell extra that MiD is not really calling people racist, and that it's just absurd satire, except when he is, when it isn't.

That^

Get off the Internet and get a life. Stop accusing people of being racist.

ExTra,

It's not that MiD is not really calling people racist, and that it's just absurd satire, except when he is, when it isn't.

Ta lad.

I would love to see some stats for this thread from Velocio covering the last few days. It seemed to be posted on every few seconds for days.

What do you want to see?

I can run queries against the database if you want to construct them, just image a thread table, a post table, and that post has a threadid column and post also has a created datetime.

Could we have a 3 days time line in terms of post/ activity on this thread?

Could you plot the loss of my productivity against posts in this thread?

I would love to see some stats for this thread from Velocio covering the last few days. It seemed to be posted on every few seconds for days.

I reckon I've done 200 on it. Maybe I should raise the bar for Riot Drinks to 100 posts or more since Saturday.

Who does that include apart from EEI, mankind is doomed and myself?

Could we have a 3 days time line in terms of post/ activity on this thread?

That's my inner geek speaking I apologise.

select * from posts where threadid=13146 order by postdate desc;DELETE FROM USERS WHERE USER like 'skylark'

outrageous...

Graph of last few days

• Active Users Viewing Thread - members - guests

• Posts per minute

Did the thread pop up in Google for people searching for the latest info? such as the Russian journalist finding out about the tiger on the loose.

Friendliest forum on the internet!

i thought we were 'ferociously snooty'.

Graph of last few days

• Active Users Viewing Thread - members - guests

• Posts per minute

Did the thread pop up in Google for people searching for the latest info? such as the Russian journalist finding out about the tiger on the loose.

Can't give you the active users viewing thread data... that's from session tables which are purged automatically, and I don't have server logs as I see no reason to turn them on (I like security by default and not storing anything that could identify anyone).

The latter report isn't meaningful either... barely 1 post per minute as it's counting the night time too.

Meaningful numbers:

An average weekday will see 2,500 posts per day.
9th August = 3,700 posts per day, with more than half of those being in this 1 thread.

Graph of last few days

• Active Users Viewing Thread - members - guests

• Posts per minute

Did the thread pop up in Google for people searching for the latest info? such as the Russian journalist finding out about the tiger on the loose.

Did the police use it and consequently turn up to arrest Graham Norton for setting fire to Waterloo?

Perfect. Satisfied my curiosity.

select
username,
count(*) as numposts
from
posts p
inner join
users u
on
p.userid = u.id
where
p.id = 123456 and p.created > '5-aug-2011'
group by
u.id
order by
numposts desc