Fun Run

Come and join us for a hike to a city untouched by time and see some of the most unique sights in Czech Republic and Europe. The town became famous for producing the Prague Groschen coins, which were also used elsewhere in Europe at the time, and became the second most important town in the Kingdom of Bohemia. Distance : 10 Km (about 6 hours) Difficulty Rating : Easy to Moderate Tour Highlights: • Professional and friendly guide • Hassle-free day trip to Kutna Hora from Prague • Admission to the "Bone Chapel," a chapel decorated with human bones at the Ossuary of the Cemetery Church of All Saints • Admission to the Gothic Cathedral of Saint Barbora • Admission to the Cathedral of the Assumption of Our Lady OPTIONAL • Hrádek - Czech Museum of Silver (Medieval Silver Mine) More information at https://www.facebook.com/events/1173596144588293/

~~Because nothing says “midweek crisis” like screaming pop ballads with strangers~~ So you’ve survived Monday... congrats! Celebrate by joining us **every Tuesday** for the most *questionable life choices* you’ll never regret — Karaoke Night! **FREE ENTRY** – because we know you blew your paycheck on brunch last weekend. 🧍‍♀️👨‍🦯For the socially allergic (aka shy or introverted), we’ve got **ice-breaking games** that are only mildly awkward. You might actually meet someone who *also* sings off-key. Soulmates? Maybe. 🍸 Cocktails for **135 Kč** – dangerously tasty. 🍺 Beer for **49 Kč** – cheaper than therapy. 📍 **WHERE THE MAGIC HAPPENS** **TEQUILA TALES BAR & MUSIC CLUB** Újezd 409/19, Prague 1 (Tram stop: Hellichova or Újezd – don’t pretend you don’t use Google Maps) 📲 Stalk us or message your future karaoke group here: [https://www.instagram.com/tequilatales_prg/](https://www.instagram.com/tequilatales_prg/)

Join us for a fun craft event where you get to know new people and practice czech! We are more than excited to try out our newest concept: Czech Craft Club! This is not a Czech course but we will provide plenty of opportunities to pick up on new craft and related vocabulary. Low pressure, social and creative language exposure. Come listen to some czech and maybe even speaking some with your fellow crafters. This time we will be making paper animals with moving limbs. All levels welcome! The event is hosted by expat organisation something new and local Czech artist Alžběta Procházkova. A match made in heaven 💘 Curious? Sign up! Ticket: 300kc - (All inclusive, craft materials and prints provided) Reservations: [https://connect.boomevents.org/en/somethingnew-uqvwe/craft-while-learning-czech](https://connect.boomevents.org/en/somethingnew-uqvwe/craft-while-learning-czech-valentine-cards-lefnw)

\~FREE EVENT\~ Meet Locals & internationals People Every Tuesday & Make New Friends🙂 For introverts and shy people (we all are sometimes), we have ice-breaking games and more... so feel free to come by. Everyone is invited to enjoy amazing Cocktails in 135kc only🍸 Beer in 49 kc 🥂🍻 It is organized after our Biggest Event in Central Europe with 234 people in a single event. 🙂 📍LOCATION TEQUILA TALES BAR & MUSIC CLUB Újezd 409/19, 118 00 Malá Strana, 118 00 Prague, Czech Republic (Nearest tram stop- Hellichova & Ujezd) ❓Questions❓ Follow & write to https://www.instagram.com/tequilatales_prg/ *** \~AKCE ZDARMA\~ Každé úterý se seznamte s místními a mezinárodními lidmi a najděte si nové přátele🙂 Pro introverty a stydlivé lidi (všichni jsme někdy) máme hry na lámání ledu a další... tak neváhejte a přijďte. Všichni jsou zváni k vychutnání úžasných koktejlů jen za 135 kč🍸 Pivo za 49 kč 🥂🍻 Je pořádána po naší největší akci ve střední Evropě s 234 lidmi na jediné akci. 🙂 📍 POLOHA TEQUILA TALES BAR & MUSIC CLUB Újezd 409/19, 118 00 Malá Strana, 118 00 Praha, Česká republika (nejbližší tramvajová zastávka- Hellichova & Újezd) ❓Otázky❓ Sledujte a pište https://www.instagram.com/tequilatales_prg/

**3x3 Basketball** practice in **Gymnázium Na Pražačce** indoor basketball court. **Start at 19h00**. Everybody is welcome, no age, gender nor any restriction of any type to join. We got a full field, rotating with 3x3 matches on each side. Cost: **90 crowns**. Please send the money using the **QR Code** stored here: https://imgur.com/a/thtAJd0 In case of any Opt-out within 24h of the session, or no show, the payment will be due (you still can ask someone to come instead of you, as your spot will be booked)

Podařilo se nám na poslední chvíli sehnat výjimečného hosta – a bylo by škoda to nevyužít! Martin Urza, anarchokapitalista, youtuber a autor první české knihy o anarchokapitalismu, přijede osobně představit svou novou knihu **Anarchoagorismus**. Anarchoagorismus není jen teorie. Je to praktická cesta ke svobodě pomocí prostředků dostupných každému z nás, tady a teď. Urza nám vysvětlí, co za tímto pojmem stojí, proč ho považuje za logický vývoj svého myšlení a jak tyhle myšlenky aplikovat v každodenním životě – bez čekání na revoluci. Počítejte s živou diskusí, protože tohle téma málokdy nechává lidi lhostejnými. A samozřejmě – večer zakončíme kvalitním pokecem u piva a v atmosféře bublajících dýmek. Kapacita je omezená, takže neváhejte – kdo přijde, nezklame se!

Hello Beer Enthusiasts! 🍺 Indulge in a delightful beer tasting experience at the NuBeerBar, where they showcase the finest selection of Czech beers straight from their working pub with 11 Czech beers on tap. 📍 **Location:** NuBeerBar, Balbínova 1 📅 **Date:** Every Tuesday, from 27/02/2024 🕒 **Time:** 19:00-22:00 💸 **Event fee:** FREE 🍺 **Beers available**: https://www.nubeerbar.cz/en/#Ontap 💰 **Price**: 174 CZK (Set of 6 beers \* 0.12l at your choice from menu) **Event Details:** We have a table reserved at NuBeerBar, to explore the rich and diverse world of Czech beers through their tasting flights, the perfect way to sample a variety of Czech beers and discover your favorites. **What They Offer:** * **Tasting Flights**: Enjoy a flight of six different kinds of Czech beers carefully curated to highlight the unique flavors and characteristics of each brew. 🍻 * **Working Pub Atmosphere**: Immerse yourself in the lively ambiance of their working pub, where you can mingle with fellow beer lovers and enjoy the vibrant atmosphere. 🎶 * **Knowledgeable Staff**: Their friendly staff are always on hand to answer any questions you may have about the beers they offer and provide recommendations based on your preferences. 💬 *Whether you're a seasoned beer connoisseur or just starting to explore the world of Czech beers, the beer tasting event at the* NuBeerBar *promises to be a memorable experience for all.* We look forward to raising a glass with you and sharing our passion for Czech beer! Cheers! 🍻

Hi All, Come and join us for social running and a coffee! We meet at the main gate of Vystaviste - tram stop Vystaviste Holesovice. We will run in Stromovka. Usually we run around 50mins and it is up to everyone how many kilometres. We welcome all levels of runner. We can all run together or, if there is more of us, we can split into groups and at the end of the run we all meet close to the starting point to go for a coffee to a nice local coffee place (where they also sell cakes and great chocolate). If the weather is great, we can also just sit in one of the outside coffee placces in Stromovka and enjoy the sun. This is where we meet: http://photos2.meetupstatic.com/photos/event/7/7/3/1/600_447930513.jpeg

We are a group of runners who meet most weeks for a run around the beautiful Vltava River's edge. You can bring your running shoes straight from the office/home office if you don't have time to stop at home. There will be a place to put your bags in the Cafe. We will run about 9 km along the river and have a drink afterwards. Paces vary! We will meet in the square near Kavarna Liberal (Hermanova 6), near the Vltavska metro/tram stop at 6:30 on Wednesday. See you there!

⚠️ **IMPORTANT: You must sign up and buy a ticket here to attend:** [https://groupvibe.com/](https://groupvibe.com/) **This is a curated, small-group meetup make new friends in Prague.** Each meetup brings together 4–6 like-minded people for casual conversations over brunch. We use the Groupvibe platform to organize and ensure everyone’s a good fit. 👉 **To attend, you’ll need to complete registration via this link:** [https://groupvibe.com](https://groupvibe.com) Once you register, and **buy a ticket or become a Groupvibe member**, we’ll share the exact location and match you with your group. **Why this works:** \* Smaller groups make real conversations easier \* Matching helps avoid awkward dynamics **Note:** RSVPs here on Meetup don’t reflect total attendance. Many attendees register directly via our website. This meetup is organized by **Groupvibe**, a small team passionate about helping people form meaningful friendships offline.

Step into a real-life fairytale! Join us for a magical day trip to Český Krumlov — a UNESCO World Heritage town and one of the most picturesque places in Europe. With its cobbled streets, colourful houses, riverside views, and a castle perched above it all, this destination feels like stepping back in time. Český Krumlov dates back to the 13th century and grew around its stunning castle, which is one of the largest in Central Europe. The town is wrapped by the Vltava River, creating amazing viewpoints, hidden corners, and perfect photo spots. From medieval streets to lively cafés, it’s the kind of place where you just wander and discover something new at every turn. Expect history, great views, chill exploration, and lots of good memories — all in one day. Whether you’re into sightseeing, photography, or just soaking up the atmosphere, this trip has something for everyone. Distance : 10 km (aprox. 6 hours) Difficulty Rating : Easy to Moderate Tour Highlights: • Hassle-free day trip to Český Krumlov from Prague • Professional and friendly guide • Transportation by air-conditioned bus • Český Krumlov Castle & Castle Complex • Castle Tower (tour) • Old Town (Historic Center) • Latrán Street (One of the oldest streets in the city) • Cloak Bridge (Plášťový most) More information at : https://www.facebook.com/events/2035605153885492/

This time we are going to experience the world-famous spa town of Karlovy Vary, a spa town situated in western Bohemia. We will admire the grand 19th-century spa architecture, stroll along the impressive colonnades, and sip the presumably health-restoring sulphurous waters from 12 different springs in spouted ceramic drinking cups. One of the most famous attractions is the hot spring that spews out hot thermal waters to a height of 12 meters. Distance : 10 km (about 5 hours) Difficulty Rating : Easy Tour Highlights: • Professional and friendly guide • Transportation by air-conditioned bus • Visit the Mill & Market Colonnade • Entrance to the Church of St. Mary Magdalene • Visit and tour the Vrídelní Kolonáda underground spa’s inner workings) • Entrance to the Diana tower lookout • Entrance to St. Peter and Paul Cathedral • Visit the Japanese Garden • Moser glassworks tour OPTIONAL • Entrance to Jan Becher Museum (includes tasting of 4 different types of Becherovka) • Thun Porcelain Shop More information at : https://www.facebook.com/events/1425899982330883/

Dear Adventurers, Friday 13th is begging for a visit somewhere creepy. And since it's always nice to incorporate a couple of steep climbs into an innocent city walk, the Bohnice cemetery is an obvious pick. The place has painful history and is shrouded in spooky stories. And for the maximum effect, we'll get there after dark 👻 – It's a city walk, but there will be unpaved parts, so **wear shoes that you don't mind getting dusty/dirty** – The pace will be leisurely, about 4.5 km/h – If you're uncomfortable walking in the dark without a light, bring one 📍 **Trail** 10 km • ↑ 205 m • ↓ 123 m [MAP OF THE TRAIL](https://mapy.com/s/hezucuzofa) **👋 Meeting Point** 17:00 in front of Výstaviště, the fountain closest to the Stromovka park (leftmost if you're facing the Výstaviště grounds and the tram stop is behind you) [☎️](https://emojipedia.org/telephone/) **Contact** +420 732 570 684 (Elena) You join at your own risk. By joining our events, you accept our Terms and Conditions. Looking forward! 😊

🌙 **Nourishing Dance Session for Women** with **Loona Dance** ✨ Ready to reconnect with your feminine energy? Step into an embodied movement journey designed to awaken your vitality, radiance & passion. This is not about choreography. This is about coming home to your body. 💃 Move out of your head & into your heart 🌺 Reconnect with your inner source 🤍 Feel the power of sisterhood 🔥 Express yourself freely 🌸 Discover your unique gifts No dance experience needed. All women welcome — just bring yourself and comfortable clothes; you can also wear a comfy skirt. 💫 Donations are welcome. 📲 **Registration:** Martina +420 773 700 260 *** 📍 **Where:** Jankovcova 1587/8c The studio is located at the back of the building. 🚪 The entrance is opposite Marina Brewery (Pivovar). ✨ If you see the brewery, you’re in the right spot — just look across and head toward the back of the building. *** 👥 Organized by C.L.A.P. – Culture, Love, Art, People Hosted by Agora7 💬 Join our WhatsApp Community to stay updated on upcoming events: [https://chat.whatsapp.com/J40xOgmpbMxLL71dKblqYu](https://chat.whatsapp.com/J40xOgmpbMxLL71dKblqYu) 📸 Follow us on Instagram: [https://www.instagram.com/c.l.a.p.2](https://www.instagram.com/c.l.a.p.2)

**History** [Slate Run Metro Park](https://www.metroparks.net/parks-and-trails/slate-run/), located south of Canal Winchester in Pickaway County, has roots tracing back to the early planning efforts of the Columbus and Franklin County Metropolitan Park District. In 1963, Metro Parks officials identified the land along Slate Run as having strong potential for a large metropolitan park due to its expansive acreage, diverse habitats, and natural features like the stream that gave the area its name. The largest stream in the vicinity, Slate Run, flows south to northwest through a ridge, providing a logical basis for the park's designation. Between 1964 and 1968, Metro Parks acquired approximately 1,662 acres through multiple parcels, including a key 212-acre farmstead that had been continuously operated since 1805. This acquisition phase positioned Slate Run as a future major addition to the system, following the openings of other parks like Sharon Woods in 1968 and Highbanks in 1973. The park officially opened to the public in 1981, marking it as the sixth Metro Park in the district and, at the time, the largest with its substantial land holdings. From the outset, Metro Parks envisioned incorporating a living historical farm to educate visitors about 19th-century Ohio agriculture. The focal 212-acre parcel, purchased from the White family heirs in 1964, included historic structures that made it ideal for this purpose. The park's development preserved natural areas such as grasslands, wetlands, meadows, and forests while integrating interpretive elements. Upon opening, Slate Run quickly became a popular destination for nature enthusiasts and history buffs alike. Central to the park's identity is the Slate Run Living Historical Farm, which interprets life on a typical Ohio farm in the 1880s. The gothic revival farmhouse on the site was constructed in 1856 by owner Isaac Fridley and later restored by Metro Parks for historical accuracy. Visitors can explore interiors like the living room, parlor, and kitchen, where interpreters demonstrate period activities. The multi-bay barn, built in 1881 by Samuel Oman (the fourth owner), was meticulously restored with help from Amish carpenters. Heirloom animals such as Percheron horses, pigs, geese, and turkeys inhabit the farm, enhancing the immersive experience. The historical farmstead reflects a long lineage of ownership and agricultural use dating back to the early 19th century. Continuous farming on the land since 1805 made the site authentic for recreating late-19th-century practices, including grain harvesting and animal husbandry. Metro Parks focused on authenticity by restoring original buildings and introducing period-appropriate methods, such as horse-powered threshing machines from the late 1880s. The farm operates with volunteers and staff in period attire to portray daily rural life. This educational component has drawn school groups and families for decades. Today, Slate Run Metro Park spans about 1,705 acres and attracts roughly 250,000 visitors annually for its blend of natural preservation and historical interpretation. The park maintains diverse habitats supporting wildlife like nesting sandhill cranes and reintroduced northern bobwhite quail. Trails and open spaces offer opportunities for hiking and observation amid the preserved landscapes. The Living Historical Farm remains a crown jewel, continuing to teach about Ohio's agricultural heritage. Ongoing programs and restorations ensure the site's relevance for future generations. **Map of the Park** Here is a [map of Slate Run](https://www.metroparks.net/wp-content/uploads/2014/11/SLR-parkmap@2x.gif). **Summary** For this event, we will hike the Five Oaks, Sugar Maple, Covered Bridge, Shagbark, and Lake Trails. This will be around 4.5 to 5 miles. While Slate Run is moderately strenuous in a few places, it's generally a good place to hike and doesn't seem to wear people out. Some spots on the hike are unshaded, though, so be prepared for the possibility of some sun. I find Slate Run to be very underappreciated for the quality of its hiking. **Where We'll Meet** We'll meet at the [Shady Grove Picnic Area](https://www.google.com/maps/place/39%C2%B045'30.1%22N+82%C2%B050'13.2%22W/@39.758347,-82.83701,17z/data=!3m1!4b1!4m4!3m3!8m2!3d39.758347!4d-82.83701?entry=ttu&g_ep=EgoyMDI2MDIxMS4wIKXMDSoASAFQAw%3D%3D). You can use the map pin I've provided here; it's accurate. There's a latrine at Shady Grove, but there is no running water (no water fountains). We will pass a water fountain when we get to the Buzzard's Roost Picnic Area, although I can't guarantee this fountain won't be off for the winter. I'd recommend bringing some water just in case, at least for after the hike. I'd also recommend [hiking shoes](https://www.amazon.com/dp/B0D972KN3W) for this park. **After the Hike** Once we're finished at Slate Run, we'll head over to [Loose Rail Brewing](https://looserailbrewing.com/) for [drinks](https://looserailbrewing.com/canal-winchester-canal-winchester-loose-rail-brewing-drink-menu) and [food](https://looserailbrewing.com/canal-winchester-canal-winchester-loose-rail-brewing-food-menu). The brewery's actual address is [37 W Waterloo St, Canal Winchester, OH 43110](https://www.google.com/maps/place/37+W+Waterloo+St,+Canal+Winchester,+OH+43110/@39.8432511,-82.8071032,17z/data=!3m1!4b1!4m6!3m5!1s0x88387be3ac496d83:0x23e8ee9d9391dd6b!8m2!3d39.8432511!4d-82.8071032!16s%2Fg%2F11cp8n8x1j?entry=ttu&g_ep=EgoyMDI2MDIxMS4wIKXMDSoASAFQAw%3D%3D), and it's about 10-12 minutes from Slate Run. We should be there by 5 if you can't make the hike and just want to join us for drinks.

⚠️ **IMPORTANT: You must sign up and buy a ticket here to attend:** [https://groupvibe.com/](https://groupvibe.com/) **Join the Columbus City Brunch Club and make new friends!** Each meetup brings together 4–6 people for casual conversations over brunch. We use the Groupvibe platform to facilitate the meetup and ensure everyone’s a good fit. 👉 **To attend, you’ll need to complete registration via this link:** [https://groupvibe.com/](https://groupvibe.com/) We’ll share the exact location of the upcoming meetup the night before only if you have bought a ticket or membership plan. **Why this works:** \* Smaller groups make real conversations easier. \* Discover new restaurants in your city, together. \* Curated lunch venues with good food and vibe. \* If you hit it off with your group, there’s plenty of time to hang out afterwards. **Note:** RSVPs on Meetup don’t reflect total attendance. Many attendees register directly via our website. The event on [Meetup.com](http://meetup.com/) is only a placeholder. This meetup is organized by Groupvibe, a small team passionate about helping people form meaningful friendships offline.

Window functions have nothing to do with the Windows operating system but provide a “window” to a result set when used in SQL queries. They are powerful, set-based methods to view data in unexpected ways. Window functions provide easy, set-based solutions to solve some common problems: * Using running totals * Performing operations in intervals * Identifying data gaps and islands * Performing aggregates without losing detail Many people are confused by window functions and do not know how to use them properly. This session will explore window functions, how they work, and how to use them. Demonstrations with several examples will solidify how window functions can simplify queries and make them more powerful.