OpenSimWorld is the directory of 3D Virtual Worlds based on OpenSimulator and connected through the HyperGrid. Learn More
New Members
PamellaSim, Prentice, Annaennett, Junction, Aranza, Yeelinda, Dinho, Viviannv, RufusRippley, MaraWindsong, KalebDonovan, Leighlah, Mryork, Katiiis, Austin, JettZax, Ashen, EmmaLewis, Monluc2259 lucmon, DaisyLikes
|
FEATURED Friends 0 Users 41 13 A Friends-grid offers approximate sim size islands with 10,000 prim to active people who want to be part of this growing multicultural community!
Contact @safinemahoe2 or @zuzubahro for details
h... |
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
|
5 |
Trianon Complex A 102 21 |
|
4 |
Vanaheim A 16 4 |
|
15 |
Misty Isles 19 0 |
|
4 |
ShoppingDance A 12 1 |
|
5 |
Shopping FUN A 9 0 |
|
4 |
Ignis 32 2 |
|
6 |
Xenotown A 23 0 |
|
7 |
ALBA SEX CLUB A 51 4 |
|
13 |
August-Euler-Flughafen 9 0 |
|
7 |
Gentle Fire Grid 78 7 |
|
11 |
Trinacria 8 2 |
|
18 |
PalmBeach 22 0 |
|
8 |
Stark A 145 84 |
|
6 |
Event Plaza 137 18 |
|
11 |
Bluewave 6 2 |
|
Regions Online:
1,998
Active: 337 avatars in 169 regions | |
Upcoming Events
| view all |
|
Started HG Safari
50 minutes ago
HG Safari
2
|
|
Started REMIX FOLK
50 minutes ago
Trinacria
0
|
|
Started Wednesday Event Plaza Osgrid
50 minutes ago
Event Plaza
0
|
| in 10 minutes Event Plaza 0 |
| in 1 hours Event Plaza 0 |
| in 2 hours Event Plaza 0 |
| in 2 hours Manderley 1 |
| in 3 hours Event Plaza 0 |
| in 4 hours Rock City 2 |
| in 4 hours Event Plaza 0 |
New Comments
Dorena Verne✦ 15 minutes ago
Apparently, the poor man doesn't even know how to copy and paste; he inserted two of my sentences twice when quoting my private messages.
context
Dorena Verne✦ 1 hour ago
So hilflos, ja du hast mein Mitleid. Zudem was das Zitieren von Privatnachrichten betrifft, das wird dir noch Ärger einhandeln, aber du Idiot hast mich letzenendes provoziert...
So helpless, yes, you ...
context
Jupiter Rowland 2 hours ago
One more thing: Remember that Austrian with the Charlie Chaplin 'stache? The guy who was pretty much single-handedly responsible for the extermination of 3.5% of all human life on the plant, including...
context
Dorena Verne✦ 2 hours ago
I'm really looking forward to presenting my pictures, especially the political ones, at Jimmy's; you guys are great. :-)
context
Reviews
Bodies & Clothing
This is a really nice shop to give your AV (and YOURSELF!) a TREAT!! There seems to be a NICE selection of clothes though, sadly, nothing here for ME (Petite X)!! All other major bodies appear to be w...
Allie Dawson 16 hours ago
ALBA SEX CLUB
Alba Sex club is a great place to hang out , meet people and also to sadisfy your sexual desires and fantasly's
definatly recommend to check it out sometime.
Keiko_Yubari yesterday
ALBA SEX CLUB
it’s a huge club with a lot of interesting themed areas and beautifully designed skyboxes that really make the space feel unique. What stood out to me most is that it’s not just a sex club, but also a...
FoxxyFawkes yesterday
Adventure Land
this is fun! went there for the turtle: it is a beautiful big turtle, that leads you (even as couple) through a turquoise sea. the whole sim is a paradise of prim art & architecture, cutest wood horse...
NightshadeCeres 3 days ago
Mexico Lindo Shopping
Thank you for your comment. I will take your suggestion to create slimmer avatars into account, and I will keep you updated in the Facebook group and here. https://www.facebook.com/groups/251480078248...
Lina Kahlo 6 days ago
This region is a must visit beautiful makes you want to live there as soon as you land. Great build and so Homey love it I miss this Region so much I don't know what happened to it but I sure hope it...
Angel Dreams 6 days ago
Broceliande
Very well done, a Beautiful region!!
... made me wish I brought my fishing gear. ;)
Yinni Benelli 6 days ago