LL has 3000 threads
- Thread starter fury
- Start date
It means how many threads you've started.
Here's how many threads you've posted in
(Note: This was a really long query, 4 seconds, so try not to get too attached to it
)
Here's how many threads you've posted in
Code:
+--------------------+---------+
| 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
)
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;
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;