Second Life’s Longest Last Names
August 3, 2008 9:22 am last names, research((
List of Second Life Last Names known to SLNameWatch that are 14 characters long or longer, excluding last names not in use, sorted by usage.
mysql> SELECT last_name, usage_count, status FROM last_names WHERE LENGTH(last_name) >= 14 AND usage_count > 0 ORDER BY usage_count DESC; +--------------------+-------------+--------+ | last_name | usage_count | status | +--------------------+-------------+--------+ | SunMicrosystems | 1159 | 2 | | Triskaidekaphobia | 1115 | 2 | | Federschneider | 312 | 2 | | DiorJoaillerie | 264 | 2 | | Rozenschtrauch | 244 | 2 | | Extraordinaire | 54 | 2 | | CokePremiereGuest | 44 | 2 | | RossiResidencial | 14 | 2 | | OurVirtualHolland | 13 | 2 | | INGRenaultF1Team | 12 | 2 | | ConnectedWomen | 11 | 2 | | AmericanCancer | 9 | 2 | | UnitTestOsborn | 1 | 2 | | UnitTestEcclesiast | 1 | 2 | +--------------------+-------------+--------+ 14 rows in set (0.02 sec)
Status 2 = Closed to new registrations.
Wait a sec… UnitTestWhat? I thought all of the accounts created under that bug had been deleted. Who is still using these names?
mysql> SELECT uuid, first_name, last_name
FROM last_names
JOIN agents ON (last_names.ln_id = agents.ln_id)
WHERE last_name IN ('UnitTestOsborn', 'UnitTestEcclesiast')\G
*************************** 1. row ***************************
uuid: dd7fe8e1849b439295762be1964ec197
first_name: My
last_name: UnitTestEcclesiast
*************************** 2. row ***************************
uuid: 5d2df7ee156d4c3e9e48c82e530cdd6b
first_name: eVo
last_name: UnitTestOsborn
2 rows in set (0.00 sec)
Alright, then. Congratulations to the two of you.
On a related note, the UnitTest* bug resurfaced last week. So I reopened the issue. No one appears to have registered under the two UnitTest* names that were released by mistake. That, or the ones that did were swiftly deleted. I closed the issue.
Enjoy.
-Big Adz
))
