corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Three meeeeeeeeeeeelion posts


New Topic
New Poll 		  <<  1    2    3    4    5  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Three meeeeeeeeeeeelion posts
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd May 06 at 23:11   View Garage View User's Profile U2U Member Reply With Quote
I'm curious now, might run some big queries.
loo_goblin
Member
Registered: 14th Jul 04
Location: Horsham, West Sussex
User status: Offline
2nd May 06 at 23:12   View User's Profile U2U Member Reply With Quote
sounds fun
Robin
Premium Member

Avatar

Registered: 7th Jan 04
Location: Northants Drives: Clio 182 Cup
User status: Offline
2nd May 06 at 23:12   View Garage View User's Profile U2U Member Reply With Quote
queries on what?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd May 06 at 23:14   View Garage View User's Profile U2U Member Reply With Quote
mysql> select count(author) as postnum, count(author)/(select count(*) from posts)*100 as percent from posts group by author order by postnum desc limit 10;

+---------+---------+
| postnum | percent |
+---------+---------+
| 44939 | 1.5235 |
| 39161 | 1.3276 |
| 37937 | 1.2861 |
| 30916 | 1.0481 |
| 30034 | 1.0182 |
| 29859 | 1.0123 |
| 27492 | 0.9320 |
| 26276 | 0.8908 |
| 26239 | 0.8895 |
| 26008 | 0.8817 |
+---------+---------+
10 rows in set (3.96 sec)


There's the top 10 people.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd May 06 at 23:15   View Garage View User's Profile U2U Member Reply With Quote
And there's Matts post count
Robin
Premium Member

Avatar

Registered: 7th Jan 04
Location: Northants Drives: Clio 182 Cup
User status: Offline
2nd May 06 at 23:16   View Garage View User's Profile U2U Member Reply With Quote
matt is on 27492 then
CorsAsh
Member
Registered: 19th Apr 02
Location: Munich
User status: Offline
2nd May 06 at 23:19   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
mysql> select count(author) as postnum, count(author)/(select count(*) from posts)*100 as percent from posts group by author order by postnum desc limit 10;

+---------+---------+
| postnum | percent |
+---------+---------+
| 44939 | 1.5235 |
| 39161 | 1.3276 |
| 37937 | 1.2861 |
| 30916 | 1.0481 |
| 30034 | 1.0182 |
| 29859 | 1.0123 |
| 27492 | 0.9320 |
| 26276 | 0.8908 |
| 26239 | 0.8895 |
| 26008 | 0.8817 |
+---------+---------+
10 rows in set (3.96 sec)

=username:Ian/status/geek





Were you referring to me in your first post btw?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd May 06 at 23:20   View Garage View User's Profile U2U Member Reply With Quote
Yeah I though we could have the little finger thing going on with 'Three meeeeeellion posts' in a speech bubble or something. Probably a bit late now its all gone letters and numbers.
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
2nd May 06 at 23:20   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by robmarriott
matt is on 27492 then



?
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
2nd May 06 at 23:21   View User's Profile U2U Member Reply With Quote
Put names to posts Ian
Robin
Premium Member

Avatar

Registered: 7th Jan 04
Location: Northants Drives: Clio 182 Cup
User status: Offline
2nd May 06 at 23:22   View Garage View User's Profile U2U Member Reply With Quote
if you make up the 0.93% Matt, you have 27492 + whatever since the query was raised. i assume so anyway
John
Member
Registered: 30th Jun 03
User status: Offline
2nd May 06 at 23:23   View User's Profile U2U Member Reply With Quote
Can I ask what i'm on before this thread gets filled up with that exact question?
Sam
Moderator
Premium Member

Registered: 24th Dec 99
Location: West Midlands
User status: Offline
2nd May 06 at 23:23   View User's Profile U2U Member Reply With Quote
How much do I make up?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd May 06 at 23:24   View Garage View User's Profile U2U Member Reply With Quote
About that Sam, you're not far behind Matt.
Sam
Moderator
Premium Member

Registered: 24th Dec 99
Location: West Midlands
User status: Offline
2nd May 06 at 23:26   View User's Profile U2U Member Reply With Quote
CorsAsh
Member
Registered: 19th Apr 02
Location: Munich
User status: Offline
2nd May 06 at 23:28   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
Yeah I though we could have the little finger thing going on with 'Three meeeeeellion posts' in a speech bubble or something. Probably a bit late now its all gone letters and numbers.


I'm sorry My computer is being a bastard at the moment and I'm a little preoccupied
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
2nd May 06 at 23:29   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Sam


Take me from behind
Sam
Moderator
Premium Member

Registered: 24th Dec 99
Location: West Midlands
User status: Offline
2nd May 06 at 23:31   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Matt H
quote:
Originally posted by Sam


Take me from behind


Dry?
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
2nd May 06 at 23:33   View User's Profile U2U Member Reply With Quote
Twice
Sam
Moderator
Premium Member

Registered: 24th Dec 99
Location: West Midlands
User status: Offline
2nd May 06 at 23:37   View User's Profile U2U Member Reply With Quote
Only if Keith takes pics and vids?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
2nd May 06 at 23:37   View Garage View User's Profile U2U Member Reply With Quote
Thats about as predictable as 'get your rat out'
Sam
Moderator
Premium Member

Registered: 24th Dec 99
Location: West Midlands
User status: Offline
2nd May 06 at 23:39   View User's Profile U2U Member Reply With Quote
Stop picking on me.
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
2nd May 06 at 23:39   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
Thats about as predictable as 'get your rat out'


Laffin
Nismo
Member
Registered: 12th Sep 02
User status: Offline
2nd May 06 at 23:40   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Ian
mysql> select count(author) as postnum, count(author)/(select count(*) from posts)*100 as percent from posts group by author order by postnum desc limit 10;

+---------+---------+
| postnum | percent |
+---------+---------+
| 44939 | 1.5235 |
| 39161 | 1.3276 |
| 37937 | 1.2861 |
| 30916 | 1.0481 |
| 30034 | 1.0182 |
| 29859 | 1.0123 |
| 27492 | 0.9320 |
| 26276 | 0.8908 |
| 26239 | 0.8895 |
| 26008 | 0.8817 |
+---------+---------+
10 rows in set (3.96 sec)


There's the top 10 people.


I am in there , i feel 4th maybe?
Matt H
Member
Registered: 11th Sep 01
Location: South Yorkshire
User status: Offline
2nd May 06 at 23:42   View User's Profile U2U Member Reply With Quote
It'll be

Pablo
Icy
Vibs
Daimo
Nismo
Mav
Me
Sam

Close?

  <<  1    2    3    4    5  >>
New Topic
New Poll

Corsa Sport » Message Board » Off Day » Three meeeeeeeeeeeelion posts 22 database queries in 0.0114560 seconds