OpenSimWorld is the directory of 3D Virtual Worlds based on OpenSimulator and connected through the HyperGrid. Learn More
New Members
Tiggytox, Lindatiger, LOLhappyDays, Aiden, FeloniousBarcelos, Lunarie, SeanDar, Austinwheeler, Viktoriya, RoxieRiot, CindyCincinnati, FabioBastos, Fenutzini, EmmyDemmie, XSvenx, BenzieBelmonte, ElisaPorter, TomWatson, JafarAlMalik, NinoRoLikes
|
FEATURED Samsara 0 Users 11 0 A Samsara has moved to the Twiztid Timez grid, rising again through the quiet turning of the eternal cycle. The stones align, the waters breathe, and the red sun lifts itself from the horizon as if answ... |
12-2 GRID: LOVELY IN EXILE:
DOUBLE HEADER: PIN AND ZEN; BAD GIRLS NIGHT AT DOCKLANDS
We're bad girls we're really nice
We're twice the fun at half the price
We put our handbags in a pile
And dance arouind them Essex style
Come and play with us tonight
Docklands will be outasight
IM Bobbi Fox Pin Deluca or Zen Reiko for Uber
dark-heaven.eu:8002:Club DOCKLANDS2
DOUBLE HEADER: PIN AND ZEN; BAD GIRLS NIGHT AT DOCKLANDS
We're bad girls we're really nice
We're twice the fun at half the price
We put our handbags in a pile
And dance arouind them Essex style
Come and play with us tonight
Docklands will be outasight
IM Bobbi Fox Pin Deluca or Zen Reiko for Uber
dark-heaven.eu:8002:Club DOCKLANDS2
 | Jerralyn Franzic: Poked around for a few moments. I may return... 1 years ago |
2 PM to 4 PM grid time - Today 5th April Saturday. Rock Music with guest DJ Lavia at the ABYSS Club, Pangea-Grid
Come and join us for 2 hours of Fun, Dancing and Entertainment.
https://opensimworld.com/hop/93343
Come and join us for 2 hours of Fun, Dancing and Entertainment.
https://opensimworld.com/hop/93343
Next visit, the stand of insanely talented @lunalunaria 's stand at @HIExpo ! There's is even a Free Gift :O Come grab it! hop://grid.hgsafari.org:58002/HIE/129/121/23
Hey folks! This coming Saturday, April 5th, join us at the Abyss Club with my dear friends Alchy and Andremus as I bring some of the greatest hits in the past decades with artists like Huey Lewis, Robert Palmer, A-Ha, Kenny Loggins, Rolling Stones and AC/DC and many others for 2 hours of great fun and dancing to high powered rock and roll. I look forward to seeing you there at 2pm grid time. The grid address is - pangeagrid.de:8002:The Abyss - I look forward to seeing you there!! 2pm grid time
Khiron Ametza Live
Thursday, April 3rd, 2025
Join us for a great hour listening to good music among nice people!
FORMAL ATTIRE
1 pm @ TRIANON COMPLEX BALLROOM
http://hg.trianon-world.com:18002/
Region: Trianon Complex
Location: 395, 384,33
hop://hg.trianon-world.com:18002/Trianon%20Complex/395/384...
Thursday, April 3rd, 2025
Join us for a great hour listening to good music among nice people!
FORMAL ATTIRE
1 pm @ TRIANON COMPLEX BALLROOM
http://hg.trianon-world.com:18002/
Region: Trianon Complex
Location: 395, 384,33
hop://hg.trianon-world.com:18002/Trianon%20Complex/395/384...
| | Franklin Dubratt: You can't miss this show!!!! 1 years ago |
Clerville Beach
Not enough coffee for my brain yet so...
"I think the hardest part of making skimmed milk must be throwing the cows across the lake. "
........Gary Delaney
| | Xuna: Throwing cows? but... maybe Pagane weighs too much to pick her up and throw her :/ 1 years ago |
Freitag 4.4.2025
Rock-House
mit DJ Anachron
Beginn 20:00 Uhr
Die Deutsche Hitparade
More #1 Hits
1975 - 1980
Ende wie immer um Mitternacht
Hypergrid : dorenas-world.de:8002:Nihilon.
Friday, April 4, 2025
Rock-House
with DJ Anachron
Starts at 8:00 PM
The German Hit Parade
More #1 Hits
1975 - 1980
Ends as always at midnight
Hypergrid: dorenas-world.de:8002:Nihilon.
Rock-House
mit DJ Anachron
Beginn 20:00 Uhr
Die Deutsche Hitparade
More #1 Hits
1975 - 1980
Ende wie immer um Mitternacht
Hypergrid : dorenas-world.de:8002:Nihilon.
Friday, April 4, 2025
Rock-House
with DJ Anachron
Starts at 8:00 PM
The German Hit Parade
More #1 Hits
1975 - 1980
Ends as always at midnight
Hypergrid: dorenas-world.de:8002:Nihilon.
Bla Bla Bla Magazine is now accepting articles for the MAY edition!
We’re looking for stories, features, and highlights from around the Alternate Metaverse – including region showcases, upcoming events, special happenings, and community projects.
Want to contribute? Send your article on a notecard to Sofee Supermarine INWORLD or via DISCORD.
Let’s make this issue exceptional together!
***Deadline for Articles and Adverts is 22nd APRIL***
The Latest Edition of Bla Bla Bla Magazine is Out Now!
HUD Version can be got in the Bla Bla Bla Group on AMV or at in the Main Landing Point at the Alternate Metaverse Region.
ALSO... Check it out online at: https://alternatemetaverse.com/main/index.php?ccat=bla
We’re looking for stories, features, and highlights from around the Alternate Metaverse – including region showcases, upcoming events, special happenings, and community projects.
Want to contribute? Send your article on a notecard to Sofee Supermarine INWORLD or via DISCORD.
Let’s make this issue exceptional together!
***Deadline for Articles and Adverts is 22nd APRIL***
The Latest Edition of Bla Bla Bla Magazine is Out Now!
HUD Version can be got in the Bla Bla Bla Group on AMV or at in the Main Landing Point at the Alternate Metaverse Region.
ALSO... Check it out online at: https://alternatemetaverse.com/main/index.php?ccat=bla
Last Call for Fun at the Fair!
Join us Sunday, March 30th, at 6:00 PM Grid Time for a Brazilian Pool Party with none other than our amazing OSWF Entertainment Coordinator, DJ Rosa Alekseev who will be spinning all of the Latin hits!
Let’s celebrate the final show of the Fair with music, fun, and good vibes under the Brazilian sun! 🏖️ Optional: Show up in your best swimwear!
Don’t miss this unforgettable finale! We hope to see you there!
Stage 2: hop://grid.wolfterritories.org:8002/OpenSim Worlds Fair/1278/1251/36
IM me inworld for a teleport if you have trouble with the hop. :)
Join us Sunday, March 30th, at 6:00 PM Grid Time for a Brazilian Pool Party with none other than our amazing OSWF Entertainment Coordinator, DJ Rosa Alekseev who will be spinning all of the Latin hits!
Let’s celebrate the final show of the Fair with music, fun, and good vibes under the Brazilian sun! 🏖️ Optional: Show up in your best swimwear!
Don’t miss this unforgettable finale! We hope to see you there!
Stage 2: hop://grid.wolfterritories.org:8002/OpenSim Worlds Fair/1278/1251/36
IM me inworld for a teleport if you have trouble with the hop. :)
almost Half time Don't miss out on DJ Eagle! He's bringing the vibes and delivering nothing but amazing sound. Be sure to catch Dj Eagle at this gig—it's an event you don't want to miss!
hop://gentlefire.opensim.fun:8002/Radio%20DJ%20Club/230/11...
hop://gentlefire.opensim.fun:8002/Radio%20DJ%20Club/230/11...
"Rise and Shine with the AMV Morning Breakfast Show! today"
Friday, 6am - 8am (Grid Time) with DeeJay Sofee giving you the Morning Vibes.
(Chill, Dance & Pop) to kickstart your morning, Engaging conversations and A great way to connect with the AMV community!
Join us for music, laughter, and a great start to your day so... Grab your breakfast, sip your coffee, and tune in for an interesting morning!
Located at: alternatemetaverse.com:8002:Alternate Metaverse
Friday, 6am - 8am (Grid Time) with DeeJay Sofee giving you the Morning Vibes.
(Chill, Dance & Pop) to kickstart your morning, Engaging conversations and A great way to connect with the AMV community!
Join us for music, laughter, and a great start to your day so... Grab your breakfast, sip your coffee, and tune in for an interesting morning!
Located at: alternatemetaverse.com:8002:Alternate Metaverse
Water Race Jet Ski
die Vorbereitungen für das Rennen sind sind so gut wie fertig , also üben üben üben
the preparations for the race are almost finished, so practice practice practice
hop://pangeagrid.de:8002/Water%20Race/110/113/21
die Vorbereitungen für das Rennen sind sind so gut wie fertig , also üben üben üben
the preparations for the race are almost finished, so practice practice practice
hop://pangeagrid.de:8002/Water%20Race/110/113/21
Khiron Ametza Live
Thursday, March 27th, 2025
Join us for a great hour listening to good music among nice people!
1 pm @ Starfleet Infinity
http://login.zetaworlds.com/
Region: Infinity
Location: 880, 887,2001
Thursday, March 27th, 2025
Join us for a great hour listening to good music among nice people!
1 pm @ Starfleet Infinity
http://login.zetaworlds.com/
Region: Infinity
Location: 880, 887,2001
| | Khiron Ametza: I'm about to start! Come on over here! ♥ 1 years ago |
Coming Soon:
One of the most famous racetracks in the world.
The “Nürburgring with the Nordschleife”, also known as the “Green Hell”.
Rebuilt on a VAR 12 x 12 for a real racing feeling.
Racing cars and racing bikes as well as matching outfits are available in the pit lane near the start and finish.
You can also race your own car or bike if it is suitable for “bullet physics”.
There is also a lot to see outside the race track that is also available on the original race track.
Paddock, Rock am Ring, Camping am Ring and much more.
The track at the F1-Ring has a real length of 5.2 km and the Nordschleife 20.8 km.
Races have been held there since the beginning of the 19th century.
In 1951, the Nürburgring was one of the first race tracks in the world to be converted for F1.
One of the most famous racetracks in the world.
The “Nürburgring with the Nordschleife”, also known as the “Green Hell”.
Rebuilt on a VAR 12 x 12 for a real racing feeling.
Racing cars and racing bikes as well as matching outfits are available in the pit lane near the start and finish.
You can also race your own car or bike if it is suitable for “bullet physics”.
There is also a lot to see outside the race track that is also available on the original race track.
Paddock, Rock am Ring, Camping am Ring and much more.
The track at the F1-Ring has a real length of 5.2 km and the Nordschleife 20.8 km.
Races have been held there since the beginning of the 19th century.
In 1951, the Nürburgring was one of the first race tracks in the world to be converted for F1.
Khiron Ametza Live
Wednesday, March 11th, 2025
"A Place To Greet and Meet Friendly People"
4 pm @Majestic Waltz Venue
grid.wolfterritories.org:8002
Region: Abraham Entertainment Venues
Location:1432,199, 22
Wednesday, March 11th, 2025
"A Place To Greet and Meet Friendly People"
4 pm @Majestic Waltz Venue
grid.wolfterritories.org:8002
Region: Abraham Entertainment Venues
Location:1432,199, 22
Liverpool John Lennon Airport now open, free stores available inside
Khiron Ametza Live Debuting
Monday, March 24th, 2025
Join us for a great hour listening to good music among nice people.
2 pm @ GYPSYCAMP
http://pangeagrid.de:8002/
Region: GypsyCamp
Location: 299,373,22
Monday, March 24th, 2025
Join us for a great hour listening to good music among nice people.
2 pm @ GYPSYCAMP
http://pangeagrid.de:8002/
Region: GypsyCamp
Location: 299,373,22
| | Khiron Ametza: 5 mins to go, the place is gorgeous!!! 1 years ago |
“Somewhere over the rainbow, skies are blue, and the dreams that you dare to dream really do come true.” – Dorothy
three.hills.grid.outworldz.net:8002:Emerald City
Scarecrow created by @FerdFrederix Thank you Ferd! 🌈
three.hills.grid.outworldz.net:8002:Emerald City
three.hills.grid.outworldz.net:8002:Emerald City
Scarecrow created by @FerdFrederix Thank you Ferd! 🌈
three.hills.grid.outworldz.net:8002:Emerald City
| | Marianna : Ferd has created a Toto follower and Toto Avatar free at the Kansas House on the porch. At the witch castle you will find gifts on the table. I had a request this morning to check the ring as it wasn... 1 years ago |
Airport under construction
Prepare to be enchanted on an extraordinary tour through the mesmerizing heartlands owned by the visionary Howie Mandingo! This breathtaking destination boasts an exquisite blend of natural beauty and imaginative wonder, featuring lush, towering trees, sprawling farmland, and enchanting fairylands that feel like they leapt straight out of a storybook. The experience is nothing short of magical, with an incredible array of sights to behold—each more awe-inspiring than the last. The masterful design showcases not only a realistic cityscape and meticulously crafted streets but also an undeniable artistic brilliance that brings the entire place to life. A huge thanks to Howie for sharing this remarkable masterpiece with the open Sim world —it’s a gift for dreamers and adventurers alike! Even though the tourism is Done you're still very welcome to come and see the heartlands By Howie
Gypsies just love to party
Montag 24 März
21 Uhr / 1PM PDT Putri Solo Live Singer
22 Uhr / 2PM PDT Khiron Ametza
hop://pangeagrid.de:8002/GypsyCamp/299/373/22
Happening Now!
Join us on Saturday, March 22nd, at 12:00 PM grid time for an unforgettable show with Austin and Eva Fae, also known as Fusion of Two! Their set is always full of surprises—one moment, you’ll be hearing Country, the next, Pop, followed by Rock, Swing, and maybe even some smooth Crooning. Don’t miss out!
Stage 2 hop://grid.wolfterritories.org:8002/OpenSim Worlds Fair/1279/1175/22
Join us on Saturday, March 22nd, at 12:00 PM grid time for an unforgettable show with Austin and Eva Fae, also known as Fusion of Two! Their set is always full of surprises—one moment, you’ll be hearing Country, the next, Pop, followed by Rock, Swing, and maybe even some smooth Crooning. Don’t miss out!
Stage 2 hop://grid.wolfterritories.org:8002/OpenSim Worlds Fair/1279/1175/22
Ferd took a model with over 800 parts then used Blender modifiers to clean edges, and a script that helped to reduce the level of detail. He made it six layers of over a hundred parts each then stacked it on top of the mountain.
three.hills.grid.outworldz.net:8002:SkyRealm Thank you Ferd, for more info about the script: https://www.reddit.com/r/DreamGrid/comments/1jhd3aa/tips_f...
three.hills.grid.outworldz.net:8002:SkyRealm Thank you Ferd, for more info about the script: https://www.reddit.com/r/DreamGrid/comments/1jhd3aa/tips_f...
Grab some food at the underground station before catching the cyber train
Welcome Spring-Captured at Virtual_HG HQ Photo Studio-3(H)(G) three.hills.grid.outworldz.net:8002:Virtual_HG Second Floor
Another view
22 Freebie Stores
Water Race
neue Informationen zum Water Race Jetski rennen
keine Anmeldung jeder kann mitmachen
die Zeiten auf der Anzeigetafel zählen ab sofort und die ersten zehn werden am Rennen teilnehmen
das Datum für das Rennen wird noch bekannt gegeben
ihr habt noch genügend Zeit zum trainieren
New information about the Water Race Jet Ski race
No registration required; anyone can participate
Times on the scoreboard start counting now, and the first ten will participate in the race
Race date to be announced
You still have plenty of time to train
hop://pangeagrid.de:8002/Water%20Race/110/113/21
neue Informationen zum Water Race Jetski rennen
keine Anmeldung jeder kann mitmachen
die Zeiten auf der Anzeigetafel zählen ab sofort und die ersten zehn werden am Rennen teilnehmen
das Datum für das Rennen wird noch bekannt gegeben
ihr habt noch genügend Zeit zum trainieren
New information about the Water Race Jet Ski race
No registration required; anyone can participate
Times on the scoreboard start counting now, and the first ten will participate in the race
Race date to be announced
You still have plenty of time to train
hop://pangeagrid.de:8002/Water%20Race/110/113/21
Cunard Building
HALF-TIME with an Amazing MrMikie String
Live Performance Aboard the Aurora II Cruise Ship!
Set sail for an unforgettable of music on the SevenSeas!
Join MrMikie String as he performs live aboard the Aurora II Cruise Ship, bringing you an incredible mix of Old to New & New Country, Classic Rock, Oldies, Standards, and Love Songs—from Sinatra to Steppenwolf!
A little something for everyone to enjoy this Lunch time..
hop://alternatemetaverse.com:8002/SevenSeas/1030/901/37
Live Performance Aboard the Aurora II Cruise Ship!
Set sail for an unforgettable of music on the SevenSeas!
Join MrMikie String as he performs live aboard the Aurora II Cruise Ship, bringing you an incredible mix of Old to New & New Country, Classic Rock, Oldies, Standards, and Love Songs—from Sinatra to Steppenwolf!
A little something for everyone to enjoy this Lunch time..
hop://alternatemetaverse.com:8002/SevenSeas/1030/901/37
Every 3rd Tuesday of the month: DJane Sylvia's wild ride through her record box.
From 11.00SLT
Taxi: moonrose-grid.de:8002:Moonrose Club
HEY FOLKS! SAVE THE DATE!
LITTLEFIELD SPRING FLING FEST!
VENUE: LITTLEFIELD EVENT CENTER
CONTEST: BEST IN SPRING WEAR!
SUNDAY APRIL 20th
9:00AM - 7:00PM
9am - SPECIAL GUEST DJ Walter
10:am - MOONSTAR
11:am - JOHN ROCKY
12pm - ZOREE
1pm - EVANEA
2pm - EVEE
3pm - ROGUE
4pm - MARIBOL
5pm - VEO VOOM
6pm - AIMEE LESHELLE
LITTLEFIELD SPRING FLING FEST!
VENUE: LITTLEFIELD EVENT CENTER
CONTEST: BEST IN SPRING WEAR!
SUNDAY APRIL 20th
9:00AM - 7:00PM
9am - SPECIAL GUEST DJ Walter
10:am - MOONSTAR
11:am - JOHN ROCKY
12pm - ZOREE
1pm - EVANEA
2pm - EVEE
3pm - ROGUE
4pm - MARIBOL
5pm - VEO VOOM
6pm - AIMEE LESHELLE
Khiron Ametza Live
Sunday, March 16th, 2025
Join us for a great hour listening to good music among nice people!
5pm @ Nefertari Resort Ballroom
Attire: Formal
http://login.digiworldz.com:8002/Nefertari
Region: Beach Resort
Location: 418,150, 7004
Sunday, March 16th, 2025
Join us for a great hour listening to good music among nice people!
5pm @ Nefertari Resort Ballroom
Attire: Formal
http://login.digiworldz.com:8002/Nefertari
Region: Beach Resort
Location: 418,150, 7004
Khiron Ametza Live
Friday, March 14th, 2025
Join us for a great hour listening to good music among nice people, in a beautiful place!
Formal Dress Code
3 pm @ ROSIES BALLROOM
hop://pangeagrid.de:8002/Cartier/227/45/25
Friday, March 14th, 2025
Join us for a great hour listening to good music among nice people, in a beautiful place!
Formal Dress Code
3 pm @ ROSIES BALLROOM
hop://pangeagrid.de:8002/Cartier/227/45/25
| | Khiron Ametza: I just started to sing ! Dress up and join us!!!! ♥♥♥ 1 years ago |
"Rise and Shine with the AMV Morning Breakfast Show! today"
Friday, 6am - 8am (Grid Time) with DeeJay Sofee giving you the Morning Vibes.
(Country & Dance) to kickstart your morning, Engaging conversations and A great way to connect with the AMV community!
Join us for music, laughter, and a great start to your day so... Grab your breakfast, sip your coffee, and tune in for an interesting morning!
Located at: alternatemetaverse.com:8002:Alternate Metaverse
Friday, 6am - 8am (Grid Time) with DeeJay Sofee giving you the Morning Vibes.
(Country & Dance) to kickstart your morning, Engaging conversations and A great way to connect with the AMV community!
Join us for music, laughter, and a great start to your day so... Grab your breakfast, sip your coffee, and tune in for an interesting morning!
Located at: alternatemetaverse.com:8002:Alternate Metaverse
Happy PI day everyone.
Especially to everyone that seem to like endlessly circling rants.
💗💗thank you for the great party💗💗
Freitag14.3.2025
Rock-House
mit DJ Anachron
Beginn 20:00 Uhr
3-14 is Pi-Day
Ende wie immer um Mitternacht
Friday 114.3.2025
Rock house
With DJ Anachron
Beginning 8:00 p.m.
3-14 is pi-day
End as always at midnight
Rock-House
mit DJ Anachron
Beginn 20:00 Uhr
3-14 is Pi-Day
Ende wie immer um Mitternacht
Friday 114.3.2025
Rock house
With DJ Anachron
Beginning 8:00 p.m.
3-14 is pi-day
End as always at midnight
| | Dorena Verne: It starts in 30 minutes. 1 years ago |
Hey Everyone 🙂 I'm performing at Stark Islands at 11:AM
Come join me, request a few tunes and have some fun!
Time: 11:00am/1100hr Grid Time
Place: Stark Islands
Dress: Seasonal/Casual/Club Wear/Nakie
MAP: hop://login.zetaworlds.com/Stark/90/95/46
Come join me, request a few tunes and have some fun!
Time: 11:00am/1100hr Grid Time
Place: Stark Islands
Dress: Seasonal/Casual/Club Wear/Nakie
MAP: hop://login.zetaworlds.com/Stark/90/95/46
| | niki stuart: yay rogue blastin out a great set, come join us!!!!!!!!!!!!!!!!!!!! 1 years ago |
🎉 Party Alert! 🎉
🔥 Rhythm Room Energetic Party at Bare Lilies 3! 🔥
🕛 Today at 12 Noon
🎶 Featuring: DeeJay Sofee!
💃 Dance | 🎧 Club | 🔥 Epic Mixes
Get ready to bounce, dance, and feel the beats as DJ Sofee takes over the Rhythm Room! Don't miss this high-energy party where the music never stops!
📍 Location:
hop://alternatemetaverse.com:8002/Bare%20Lilies%203/128/12...
💥 Come join the fun and light up the dancefloor! See you there! 💥
🔥 Rhythm Room Energetic Party at Bare Lilies 3! 🔥
🕛 Today at 12 Noon
🎶 Featuring: DeeJay Sofee!
💃 Dance | 🎧 Club | 🔥 Epic Mixes
Get ready to bounce, dance, and feel the beats as DJ Sofee takes over the Rhythm Room! Don't miss this high-energy party where the music never stops!
📍 Location:
hop://alternatemetaverse.com:8002/Bare%20Lilies%203/128/12...
💥 Come join the fun and light up the dancefloor! See you there! 💥
Lynnestra Parker and On The Rocks present "As Different as Day and Night"
Sunday Mar 9th, 5:00 PM to 7:00 PM Pacific
DJ Maldrul will be playing songs about Day and Night along with his signature selection of SOMETHING COMPLETELY DIFFERENT!
hop://alternatemetaverse.com:8002/Airmid/478/97/23
Sunday Mar 9th, 5:00 PM to 7:00 PM Pacific
DJ Maldrul will be playing songs about Day and Night along with his signature selection of SOMETHING COMPLETELY DIFFERENT!
hop://alternatemetaverse.com:8002/Airmid/478/97/23
The lights are on, and the music is about to take you on a journey! Give it up for the incredible Tuna Oddfellow with his psychedelic DJ show on Sun., March 9th at 12:00PM Grid Time at the OpenSim Worlds Fair.
hop://grid.wolfterritories.org:8002/OpenSim Worlds Fair/1016/1023/1004
hop://grid.wolfterritories.org:8002/OpenSim Worlds Fair/1016/1023/1004
| | Xenon Darrow: Peeps, ya gotta get to the FAIR! It's AMAZING! 1 years ago |
With over 500 free parcels for Neverworld residents, we are a builders paradise for content creators who wish to own generous parcels to develop their virtual lives. Our parcels are not "free housing" but free homesteads with sizes of 10,000 kilometers and up. Check out our destination guide or our website for information to start your free land journey in Neverworld. https://neverworldgrid.com/.../free-land/public-use-parcel...
.
.
| | JamieWright: Do we have mugs now? :) 1 years ago |
Remove objects from your inventory that have the same name, keeping the object with the last date.
Delete Duplicates in opensim database
DELETE ii1
FROM
inventoryitems ii1
INNER JOIN (
SELECT
inventoryName,
MAX(creationDate) AS max_creation_date
FROM
inventoryitems
GROUP BY
inventoryName
) ii2 ON ii1.inventoryName = ii2.inventoryName AND ii1.creationDate < ii2.max_creation_date;
Please backup your inventory first!!! Just in case you are not happy with the results. It really will do what it says. However, there is a case where a person has merged their inventory multiple times and duplicates have the same creation date. In that case the script would leave those duplicates. Be sure to write down the size of your inventory when you start, and note the size after you run the script.
Delete Duplicates in opensim database
DELETE ii1
FROM
inventoryitems ii1
INNER JOIN (
SELECT
inventoryName,
MAX(creationDate) AS max_creation_date
FROM
inventoryitems
GROUP BY
inventoryName
) ii2 ON ii1.inventoryName = ii2.inventoryName AND ii1.creationDate < ii2.max_creation_date;
Please backup your inventory first!!! Just in case you are not happy with the results. It really will do what it says. However, there is a case where a person has merged their inventory multiple times and duplicates have the same creation date. In that case the script would leave those duplicates. Be sure to write down the size of your inventory when you start, and note the size after you run the script.
| | Pagane: yes, i read how fsassets also wash baby's and create bread and ....... Tables in OpenSIM SQL data base is extreme stupid cross-linked from SL dev.team and next milion times patched from all who tr... 1 years ago |
Littlefield Grid's monthly State of the Grid meeting. All Residents and HG Visitors are welcome!
This month's topics:
12th year Anniversary celebration, Rogue Galaxy's LFGrid Spring Fling Fest, Rogue Galaxy's new Parson's Creek music region, WLFG Adverstising promotion, OSGrid state, Additional free land plots for new users, New BDSM scripts.
Friday 03/07/2025 1:30PM Pacific
This month's topics:
12th year Anniversary celebration, Rogue Galaxy's LFGrid Spring Fling Fest, Rogue Galaxy's new Parson's Creek music region, WLFG Adverstising promotion, OSGrid state, Additional free land plots for new users, New BDSM scripts.
Friday 03/07/2025 1:30PM Pacific
Live Traffic
|
11 |
Rock City 70 17 Happy Hour! |
|
3 |
Hypergrid Games 12 6 |
|
5 |
Xtreme Surf A 6 0 |
|
2 |
ARV Music Club 13 4 |
|
6 |
Aruba 7 1 |
|
2 |
HellasSandbox 17 0 |
|
4 |
inSilico A 16 2 |
|
2 |
SciattiShopClothes A 161 9 |
|
10 |
Lbsa Plaza 206 42 |
|
3 |
ShoppingDance A 12 1 |
|
4 |
The Meepz A 3 0 |
|
3 |
Trianon Complex A 104 21 |
|
5 |
Shopping FUN A 9 0 |
|
6 |
Peaceful Spaces 5 0 |
|
2 |
SciattiShopAnimation 46 3 |
|
Regions Online:
2,009
Active: 209 avatars in 136 regions | |
Upcoming Events
| view all |
| in 10 hours Alternate Metaverse 1 |
| in 11 hours Alternate Metaverse 1 |
| in 13 hours Stark 1 |
| in 14 hours Stark 1 |
| in 15 hours Stark 1 |
| in 16 hours Event Beach Club 0 |
| in 16 hours Stark 1 |
| in 17 hours Stark 1 |
| in 18 hours Abraham Entertainment Venues 1 |
| in 19 hours Abraham Entertainment Venues 1 |
New Comments
JamieWright✦ 3 hours ago
OK so obviously everyone on this thread. Even the quiet likers...lol I'm looking at you Jerralyn and Faith. And Falene! You are eternal and delightfully ecclectic. Jupiter (seriously hard core respect...
context
Spax Orion✦ 4 hours ago
Nothing is SAFE! Wait till you see a NEW sideshow which was not chosen (due to terrible cinema reviews and death threats from some fictitious movie exec) to appear on The Lamenticon stage:
Cats: T...
context
Nico Kalani 4 hours ago
You know those stories you see..."I was in trouble and someone I didn't even know stopped to help me, and I was never able to thank them." That's how it was in OS when I first joined 16 years ago. I h...
context
Jerralyn Franzic 6 hours ago
Yay, more BS for me to enjoy! But seriously, I too love the rides and crazy NPC barbs. *smirk*
context
Xenon Darrow✦ 6 hours ago
Jimmy, Max, and I were there for quite a while the other night! Your roller coasters are AMAZING! The best I have ever seen anywhere, including "the other place."
context
Silken Nakita. 8 hours ago
Thank you everyone, for your kindness and warmth. You are very appreciated, and welcome to the gathering on Thursday if you are able to be there.
context
Reviews
The Sun Club
This is a great place to party and Tomi's a great DJ. He's also very friendly. Check this place out.
TheFerret 12 hours ago
Old School
Old School is something special.
Walking through it feels like stepping back into the roots of OpenSim—pieces of history that could have easily been lost, now thoughtfully preserved and shared. The...
Ⲙⲁꞅi✦✔ 14 hours ago
Peaceful Spaces
This is a really nice place, the owners are really nice and they have FREE HOMES!!!
TheFerret yesterday
Friends
I am very honored to say friends grid does not support those involved in activities involving children. Friends Grid has always been Adults only I consider getting a 0 star review from people who ...
Safinemahoe2✦ yesterday
Friends
Ja da sage ich besser nicht mehr viel zu. Aber kann dir nur Recht geben.
Germangrid yesterday
Corazon del Mar
This build feel warm and vibrant. The architechture, the lighting and the ambience are fantastic.
JamieWright✦ 3 days ago
Azul Isles
Definitely a five gold star region. If you enjoy the peace and calm of a beautiful island scene, then visit the Azule Islands often.
Victor DeAngelo 5 days ago