LL has 3000 threads

[PT]

I think you're right Luis, I have to have posted in more than 201 threads. I think I've done that within a weekend.

 

[fury]

It means how many threads you've started.

Here's how many threads you've posted in

+--------------------+---------+
| user               | threads |
+--------------------+---------+
| Luis G             |    3514 |
| Shadowfax          |    2972 |
| PuterTutor         |    2743 |
| unclehobart        |    2630 |
| ris                |    2556 |
| Jeslek             |    2498 |
| Justintime         |    2465 |
| Gonz               |    2391 |
| Leslie             |    2345 |
| fury               |    2078 |
| Professur          |    1797 |
| Squiggy            |    1775 |
| kuulani            |    1684 |
| greenfreak         |    1593 |
| freako104          |    1493 |
| Nixy               |    1477 |
| HeXp£Øi±           |    1440 |
| Gato_Solo          |    1408 |
| Scanty             |    1157 |
| nalani             |    1117 |
| Aunty Em           |    1044 |
| Q                  |    1040 |
| Ardsgaine          |    1028 |
| outside looking in |     992 |
| HomeLAN            |     911 |
+--------------------+---------+

(Note: This was a really long query, 4 seconds, so try not to get too attached to it )

 

[Shadowfax]

i want to see it real-time

 

[fury]

For future reference (for me)

query 1 (average replies per person): select postusername,avg(thread.replycount) AS average_replies,count(postusername) AS threads from thread group by postusername HAVING threads > 10 order by average_replies desc limit 25;

query 2 (total threads per person): select postusername AS user,count(*) AS threads from thread group by thread.postusername order by threads desc limit 25;

query 3 (total polls per person): select postusername AS user,count(*) AS polls from thread WHERE pollid AND open!=10 group by thread.postuserid order by polls desc limit 25;

query 4 (threads each person has posted in): select username AS user,count(distinct(threadid)) AS threads from post group by post.username order by threads desc limit 25;