OpenSimWorld is the directory of 3D Virtual Worlds based on OpenSimulator and connected through the HyperGrid. Learn More
New Members
Cristinaricchi, MissNoodle, Moldres, Charliem, GrayFalcon, Is Buying an Airbnb Account Safe, Yorkyashaa, Du23gd, James0339Ochs, TienNguyen, Ianleigh, ELIS2711, Moonaha, Damanera, Honeybeehotz, KirmesCreations, OXOTHUK, Raver, Clyde, LunosLikes
|
FEATURED Dwell 0 Users 59 0 Freebie Mall shopping, mash clothes, furniture ,Great Hair ,
classics clothes ,Gift shop ,decoration need Help lets us know |
Do you like building and decorating ,are you a speedbuild lover ,,, then come on over for a game of White Wall Challenge ...Coming Tuesday April 15th @ 3pm, grid time @recreational park grid.escape2reality.org:8002:Recreational Park
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 |
Live Traffic
|
5 |
Xenotown A 23 0 |
|
5 |
inSilico A 16 2 |
|
7 |
Empire Of Art A 5 0 |
|
4 |
Jungle Welcome 6 0 |
|
4 |
ShoppingDance A 12 1 |
|
5 |
Playa de Wonderland A 10 0 |
|
5 |
Last_Romantics 4 0 |
|
4 |
I Love You A 19 3 |
|
4 |
MainLand04_X2000Y2004 4 0 |
|
5 |
Xtreme Surf A 8 0 |
|
3 |
Peaceful Spaces 6 0 |
|
9 |
Stark A 145 84 |
|
3 |
Welcome 10 0 |
|
6 |
OtherLife A 1 0 |
|
6 |
Lbsa Plaza 207 42 |
|
Regions Online:
2,077
Active: 284 avatars in 175 regions | |
Upcoming Events
| view all |
|
Started Fiona @ The Birdcage
53 minutes ago
Stark
2
|
|
Soon Fiona @ The Birdcage
in 7 minutes
Stark
1
|
| in 7 minutes Empire Of Art 0 |
| in 7 minutes OtherLife 1 |
| in 1 hours Stark 1 |
| in 2 hours Event Beach Club 0 |
| in 2 hours Alternate Metaverse 1 |
| in 2 hours Stark 0 |
| in 2 hours Lovely 0 |
| in 3 hours Stark 0 |
New Comments
Spax Orion✦ 6 hours ago
Dirty Helga gave me a CHORE list. The GRUGS have been moved and the RPG system is being installed... HAPPY HOUR at 5AM GRID TIME
context
MorningGlory 8 hours ago
So glad you’re back on this new page, Alba! I was honestly so bummed when I couldn’t find your clubs on the list lately because the welcoming vibe you and Jack River create for everyone is just unmatc...
context
Chelsea Louloudi 11 hours ago
will it need a rez zone?...since people cant rez on most other regions except theirs
context
NightshadeCeres 15 hours ago
what a cute idea! i had such as kid, but little metallic pieces for a hiking stick like described here: https://be-cause-blog.com/2011/10/15/hiking-sticks-stocknagel/
context
Kimm Starr 15 hours ago
I love this idea, I'm making a little vintage-looking customs booth for our landing zone with an animesh greeter!
context
Reviews
ALBA SEX CLUB
Hey, it’s great to see the page back up! ?
I was just wondering if you happened to know what caused it to go down. I did reach out to OpenSim World as well, though I may have just missed their repl...
JamieSmith 2 hours ago
ALBA SEX CLUB
So glad you’re back on this new page, Alba! I was honestly so bummed when I couldn’t find your clubs on the list lately because the welcoming vibe you and Jack River create for everyone is just unmatc...
MorningGlory 8 hours ago
Fianna Rua
Fianna Rua feels like a real coastal Irish town—rich in detail, atmosphere, and authenticity at every turn. Jamie Wright’s craftsmanship shines here, creating a place that’s not just seen, but experie...
Ⲙⲁꞅi✦✔ yesterday
Lbsa Plaza
The best thing about LBSA is that the OS vice president hangs around there 24/7. And he has secrets. Real secrets. So secret that he preemptively bans anyone who knows even the slightest bit about the...
EmmyDemmie 2 days ago
CCI Bikerworld
Biggest track in opensim (prove me wrong!) -friendly, helpful great place to visit and get your ride on!
HarperHeld 3 days ago