LTG's Biggest Threads (and other fun reports)

GAD

GAD

Reverential Morlock
Über-Morlock
Joined
Feb 11, 2009
Messages
23,285
Reaction score
19,112
Location
NJ (The nice part)
Guild Total
112
The merging of the Song Title threads made me wonder what the longest threads have been, so I wrote a quick script to list all threads over 500 replies:

Code: 
+-------------+--------------------------------------------------------+
| reply_count | title                                                  |
+-------------+--------------------------------------------------------+
|       11441 | The Song Title Game                                    |
|        5754 | Song Title Thread Part Two                             |
|        1960 | BGUF - Beautiful Guitar, Ugly Feet                     |
|        1137 | Your favorite picture(s) of an artist playing a Guild? |
|        1028 | This is a thread about nothing                         |
|         925 | Groundbreaking Day At The Lazy B                       |
|         884 | Covid-19 Lock-Down and General 2020 Humor              |
|         776 | Highly evolved S-100 owners roster                     |
|         640 | General Music Humor                                    |
|         633 | Time for some guitarist jokes...                       |
|         587 | Gibson Raid Redux                                      |
|         548 | Post Count                                             |
|         536 | Guild count thread!                                    |
|         510 | ok then, what song are you perfecting right now?       |
+-------------+--------------------------------------------------------+

The #2 item on the list kind of doesn't count since it's also included in #1, but that just shows how ridiculous #1 has become. :)

It also amuses me that the #12 entry is a thread about post counts and how few of the top threads have anything to do with Guilds.
 
GGJaguar

GGJaguar

Reverential Member
Joined
Jan 17, 2011
Messages
22,132
Reaction score
32,600
Location
Skylands
Guild Total
50
I think I'll revive the "Guilds in the Great Outdoors" thread to see if it can crack the top 12. :geek:
 
dreadnut

dreadnut

Gone But Not Forgotten
Gone But Not Forgotten
Joined
Jun 15, 2005
Messages
16,082
Reaction score
6,443
Location
Grand Rapids, MI
Guild Total
2
maybe we could do a sort by join date if the records are complete...
 
GAD

GAD

Reverential Morlock
Über-Morlock
Joined
Feb 11, 2009
Messages
23,285
Reaction score
19,112
Location
NJ (The nice part)
Guild Total
112
dreadnut said:
maybe we could do a sort by join date if the records are complete...
Click to expand...
Code: 
+-----------------+----------------+---------------+------------------------------+------------------------------+
| user-id         | username       | message_count | register_date                | last_activity)               |
+-----------------+----------------+---------------+------------------------------+------------------------------+
|               2 | letsdcom       |             3 | 2005-06-09 23:34:00          | 2019-10-30 07:56:00          |
|               3 | hansmoust      |          8480 | 2005-06-10 02:51:39          | 2022-03-23 17:53:30          |
|               4 | Walter Broes   |          5094 | 2005-06-13 17:22:00          | 2022-03-23 18:09:19          |
|               5 | Mo             |            45 | 2005-06-13 20:58:57          | 2009-12-15 19:28:03          |
|               6 | dreadnut       |         14468 | 2005-06-15 18:20:00          | 2022-03-23 20:23:17          |
|               7 | Smiert Spionam |           224 | 2005-06-18 12:38:45          | 2022-03-22 15:34:37          |
|               8 | Pike           |           834 | 2005-06-18 13:35:46          | 2022-03-23 10:32:33          |
|               9 | refret         |           301 | 2005-06-18 14:30:54          | 2018-11-10 11:05:46          |
|              10 | strings        |            44 | 2005-06-18 15:08:09          | 2011-09-16 15:38:07          |
|              12 | x-180          |             9 | 2005-06-18 16:55:28          | 2008-01-19 10:19:26          |
|              13 | X170           |             7 | 2005-06-18 17:53:05          | 2012-10-20 18:37:07          |
|              14 | Mister Whiz    |             5 | 2005-06-18 20:27:30          | 2005-07-28 12:11:55          |
|              15 | LHR            |             2 | 2005-06-18 20:35:54          | 2010-07-11 07:50:32          |
|              16 | cmsjr          |            12 | 2005-06-18 21:02:06          | 2008-11-24 13:11:48          |
|              17 | bobgoblin      |            56 | 2005-06-18 21:26:18          | 2008-04-17 17:52:01          |
|              18 | rocket88       |            44 | 2005-06-18 22:07:23          | 2018-01-29 14:35:51          |
|              19 | jpilzer        |            46 | 2005-06-18 23:31:15          | 2016-12-03 17:57:28          |
|              20 | oilcandelay    |             4 | 2005-06-19 11:33:32          | 2005-10-07 13:13:04          |
|              21 | Bluelizzard    |            73 | 2005-06-19 13:50:12          | 2013-04-26 03:23:20          |
|              22 | davidv         |            20 | 2005-06-19 15:48:41          | 2012-03-02 18:00:21          |
|              23 | Jim W          |            55 | 2005-06-19 19:31:43          | 2022-02-12 19:47:44          |
|              24 | sunpowder      |           133 | 2005-06-20 11:48:57          | 2022-03-19 22:06:06          |
|              25 | GuildGuru      |            28 | 2005-06-20 12:00:06          | 2012-07-01 03:11:51          |
|              26 | billydlight    |           384 | 2005-06-20 12:48:00          | 2019-11-26 09:39:42          |
|              27 | gbrand         |             6 | 2005-06-20 12:52:25          | 2010-01-13 09:26:37          |
|              28 | hideglue       |          1018 | 2005-06-20 13:15:47          | 2022-03-17 12:12:38          |
|              29 | 4-strings      |             3 | 2005-06-20 16:54:58          | 2006-01-02 15:00:32          |
|              30 | john_kidder    |          3103 | 2005-06-21 00:38:00          | 2022-03-22 03:44:34          |
|              31 | matsickma      |          3592 | 2005-06-21 11:15:10          | 2022-03-23 20:23:48          |
+-----------------+----------------+---------------+------------------------------+------------------------------+

Up until matsickma just because. :)

Some things to note:

  • User number 1 is reserved by the system (sort of)
  • User numbers are not strictly accurate as I modified them to make the report show the order of registration
  • User numbers would have been accurate with the 2005 version of the software in use at the time
  • 'letsdcom' is the original user that dklsplace used as a test user
Also, if you're at all curious, I would be #1435 on that list with a join date of 2009-02-11.

​

 
Last edited:
fronobulax

fronobulax

Bassist, GAD and the Hot Mess Mods
Joined
May 3, 2007
Messages
24,792
Reaction score
8,923
Location
Central Virginia, USA
Guild Total
5
Parkinson's Law of Triviality clearly applies.

To put a positive spin on things, people want to contribute and most of those threads, when they remain on topic, require little or no specialized knowledge. Those are the treads that make LTG a community and not just a place to "ask the experts".
 
GAD

GAD

Reverential Morlock
Über-Morlock
Joined
Feb 11, 2009
Messages
23,285
Reaction score
19,112
Location
NJ (The nice part)
Guild Total
112
merlin6666 said:
I don't know if I participated in any of these, but for those who get hooked on song titles it's also a way to boost personal post count.
Click to expand...

Indeed.

Here are the top 10 posters in the Song Title Thread:

Code: 
+---------------+----------+
| username      |    Posts |
+---------------+----------+
| walrus        |     1589 |
| dreadnut      |     1526 |
| Nuuska        |     1362 |
| Brucebubs     |     1278 |
| adorshki      |      916 |
| Zelja         |      873 |
| GGJaguar      |      822 |
| Westerly Wood |      452 |
| gjmalcyon     |      394 |
| coastie99     |      378 |
+---------------+----------+
10 rows in set (0.06 sec)

There are currently ~11400 posts in that thread.

84% of the posts are from the top ten posters
60% of the posts are from the top five posters

21 people posted only once
6 people posted twice
2 people posted three times
3 people posted four times
5 people posted five times
1 person posted six times
1 person posted seven times
14 people posted in the double digits
13 people posted in the triple digits
4 people posted in the quadruple digits

I like data. :)
 
Last edited:
walrus

walrus

Reverential Member
Gold Supporting
Joined
Dec 23, 2006
Messages
24,082
Reaction score
8,168
Location
Massachusetts
The "concern" over the Song Title Thread always amuses me! When I started it, I thought it was fun, and never thought it would become the divisive monster that it is.

If anyone cares, here's the two reasons I personally like it. When I do visit it, I like the challenge of quickly thinking of a song off the top of my head that "matches". What's the point of having a brain full of songs and never use them?

More importantly, occasionally someone will post a song by an artist I don't know, or just a song I don't know. It gives me a song or an artist to investigate. I'm going to give some props to Zelja in particular for leading me down some interesting musical paths.

Oh, and Tom - you're a stick in the mud! But that's why I like you...

walrus
 
fronobulax

fronobulax

Bassist, GAD and the Hot Mess Mods
Joined
May 3, 2007
Messages
24,792
Reaction score
8,923
Location
Central Virginia, USA
Guild Total
5
davismanLV said:
Yeah, it got so big so quickly and I tried at first, then soon realized that there were really no rules and tons of repeats and I lost interest big time. Call me a stick in the mud. Go ahead, you know you want to.....
Click to expand...

@davismanLV - You are a stick in the mud.


I have no idea what difference that makes and do not consider saying so a personal attack, which would require Moderation if it were so considered.

:)
 
Nuuska

Nuuska

Enlightened Member
Joined
Jan 18, 2016
Messages
7,739
Reaction score
6,125
Location
Finland
Guild Total
9
I think I have found more interesting - to me new - songs in that thread than anywhere else in last few decades.

One more post . . .
 
You must log in or register to reply here.
Top