Podcasts about right join

This show has been flagged as Clean by the host. SQL for find next available Episode Problem https://repo.anhonesthost.net/HPR/hpr_hub/issues/71 We need to get the next_free_slot, and this needs to take into account the Eps and reservations table. Eps table contain recorded and uploaded shows. reservations table reserve episodes that have not been recorded. There are existing queries to find the next free slot, but it does not include reservations. HPR SQL dump - https://hackerpublicradio.org/hpr.sql TLDR Create a list of all episode IDs from eps and reservations tables using SQL UNION Join the union list + 1 with the IDs from the eps and reservation tables WHERE clause to select rows in the union list +1 that are not in eps and not in reservations Order by and Limit to select the smallest Test Data Test data to make developing query easier. Simpler numbers so it is easier to spot patterns Same table and column names, and store them in a different database. Create the test data tables -- Create eps CREATE TABLE IF NOT EXISTS eps ( id INT, PRIMARY KEY (id) ); CREATE TABLE IF NOT EXISTS reservations ( ep_num INT, PRIMARY KEY (ep_num) ); Insert the test data -- Inserts INSERT INTO eps (id) VALUES (1001); INSERT INTO eps (id) VALUES (1002); INSERT INTO eps (id) VALUES (1003); INSERT INTO eps (id) VALUES (1004); INSERT INTO eps (id) VALUES (1011); INSERT INTO eps (id) VALUES (1021); INSERT INTO eps (id) VALUES (1031); INSERT INTO eps (id) VALUES (1041); INSERT INTO reservations (ep_num) VALUES (1004); INSERT INTO reservations (ep_num) VALUES (1005); INSERT INTO reservations (ep_num) VALUES (1006); INSERT INTO reservations (ep_num) VALUES (1010); INSERT INTO reservations (ep_num) VALUES (1016); Print the test data tables -- Episodes SELECT e.id as e_id FROM eps e order by e.id; +------+ | e_id | +------+ | 1001 | | 1002 | | 1003 | | 1004 | | 1011 | | 1021 | | 1031 | | 1041 | +------+ SELECT r.ep_num as r_id FROM reservations r; +------+ | r_id | +------+ | 1004 | | 1005 | | 1006 | | 1010 | | 1016 | +------+ Join Types UNION - combine results of 2 queries INNER - Only records that are in both tables LEFT - All the Results in the Left column and matching results in the Right Test data Join Examples In the test data, the ID 1004 is in both the episodes and reservations table. This will not occur in the real HPR database, but is useful to how different join types work Example queries with INNER , RIGHT , and LEFT joins. MariaDB [next_av]> SELECT e.id ,r.ep_num FROM eps e INNER JOIN reservations r ON e.id = r.ep_num; +------+--------+ | id | ep_num | +------+--------+ | 1004 | 1004 | +------+--------+ 1 row in set (0.001 sec) MariaDB [next_av]> SELECT e.id ,r.ep_num FROM eps e RIGHT JOIN reservations r ON e.id = r.ep_num; +------+--------+ | id | ep_num | +------+--------+ | 1004 | 1004 | | NULL | 1005 | | NULL | 1006 | | NULL | 1010 | | NULL | 1016 | +------+--------+ 5 rows in set (0.001 sec) MariaDB [next_av]> SELECT e.id ,r.ep_num FROM eps e LEFT JOIN reservations r ON e.id = r.ep_num; +------+--------+ | id | ep_num | +------+--------+ | 1001 | NULL | | 1002 | NULL | | 1003 | NULL | | 1004 | 1004 | | 1011 | NULL | | 1021 | NULL | | 1031 | NULL | | 1041 | NULL | +------+--------+ 8 rows in set (0.001 sec) Combine episode and reserved IDs Create a single list of IDs from both tables with UNION UNION combines the results of 2 queries SQL as keyword renames query results SELECT id as all_ids FROM eps UNION select ep_num FROM reservations ; +---------+ | all_ids | +---------+ | 1001 | | 1002 | | 1003 | | 1004 | | 1011 | | 1021 | | 1031 | | 1041 | | 1005 | | 1006 | | 1010 | | 1016 | +---------+ Join tables with the Union Left Joins Keep everything in the Left column Use the Union of all IDs and join with Eps and reservations The SQL will print a table of all the ids the eps and reservation columns will have the id if they match or NULL if there is not a match. select all_ids.id as all_ids ,eps.id as eps_ids , r.ep_num as reserved_ids FROM (SELECT id FROM eps UNION select ep_num FROM reservations) as all_ids LEFT JOIN eps ON all_ids.id = eps.id LEFT JOIN reservations r ON all_ids.id = r.ep_num ; +---------+---------+--------------+ | all_ids | eps_ids | reserved_ids | +---------+---------+--------------+ | 1001 | 1001 | NULL | | 1002 | 1002 | NULL | | 1003 | 1003 | NULL | | 1004 | 1004 | 1004 | | 1011 | 1011 | NULL | | 1021 | 1021 | NULL | | 1031 | 1031 | NULL | | 1041 | 1041 | NULL | | 1005 | NULL | 1005 | | 1006 | NULL | 1006 | | 1010 | NULL | 1010 | | 1016 | NULL | 1016 | +---------+---------+--------------+ Join with union plus 1 -- All Results Add an additional column of the union ids +1 Join the Union plus one list with the episodes and reservations Available episodes will have NULL in the eps and reservations column select all_ids.id as all_ids,all_ids.id+1 as all_ids_plus ,eps.id as eps_ids , r.ep_num as reserved_ids FROM (SELECT id FROM eps UNION select ep_num FROM reservations) as all_ids LEFT JOIN eps ON all_ids.id+1 = eps.id LEFT JOIN reservations r ON all_ids.id +1 = r.ep_num ORDER BY all_ids ; +---------+--------------+---------+--------------+ | all_ids | all_ids_plus | eps_ids | reserved_ids | +---------+--------------+---------+--------------+ | 1001 | 1002 | 1002 | NULL | | 1002 | 1003 | 1003 | NULL | | 1003 | 1004 | 1004 | 1004 | | 1004 | 1005 | NULL | 1005 | | 1005 | 1006 | NULL | 1006 | | 1006 | 1007 | NULL | NULL | | 1010 | 1011 | 1011 | NULL | | 1011 | 1012 | NULL | NULL | | 1016 | 1017 | NULL | NULL | | 1021 | 1022 | NULL | NULL | | 1031 | 1032 | NULL | NULL | | 1041 | 1042 | NULL | NULL | +---------+--------------+---------+--------------+ Add a WHERE clause Add a where clause to only print rows were eps and reservations are null The smallest number in the +1 column will be the next available select all_ids.id as all_ids,all_ids.id+1 as all_ids_plus ,eps.id as eps_ids , r.ep_num as reserved_ids FROM (SELECT id FROM eps UNION select ep_num FROM reservations) as all_ids LEFT JOIN eps ON all_ids.id+1 = eps.id LEFT JOIN reservations r ON all_ids.id +1 = r.ep_num WHERE eps.id is Null and r.ep_num is NULL ORDER BY all_ids ; +---------+--------------+---------+--------------+ | all_ids | all_ids_plus | eps_ids | reserved_ids | +---------+--------------+---------+--------------+ | 1006 | 1007 | NULL | NULL | | 1011 | 1012 | NULL | NULL | | 1016 | 1017 | NULL | NULL | | 1021 | 1022 | NULL | NULL | | 1031 | 1032 | NULL | NULL | | 1041 | 1042 | NULL | NULL | +---------+--------------+---------+--------------+ 6 rows in set (0.002 sec) Add a limit and only select the id Sort and select the 1st row select all_ids.id+1 as available_id FROM (SELECT id FROM eps UNION select ep_num FROM reservations) as all_ids LEFT JOIN eps ON all_ids.id+1 = eps.id LEFT JOIN reservations r ON all_ids.id +1 = r.ep_num WHERE eps.id is Null and r.ep_num is NULL ORDER BY available_id LIMIT 1 ; +--------------+ | available_id | +--------------+ | 1007 | +--------------+ Provide feedback on this episode.

How far is too far? Should people be at our "level" to associate with them? If people don't believe and act like we expect should we put them out? What is Jesus' examples with His disciples? Because some things people leave you scratching your head saying "Somethin' Ain't Right" Join this powerful conversation on patience, love, and discipleship from people who are in the trenches with people day in, day out and be reminded how far God has brought each of us in the process. To learn more about Worthy People visit: https://worthypeople.org/ Follow us on Facebook and Instagram! Don't forget to SUBSCRIBE!

Mock from COTR joins the show!See omnystudio.com/listener for privacy information.

Mock from COTR joins the show! See omnystudio.com/listener for privacy information.

Daisey from COTR joins to talk Hunter's pardoning, Thanksgiving, and more! See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk election results, media response, and more. See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show for Election Eve! See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk about Trump's rally at MSG and more! See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Mock from COTR join to talk latest P.Diddy update and more. See omnystudio.com/listener for privacy information.

Daisey from COTR join to talk about the second assassination attempt on President Trump over the weekend, Taylor Swift endorsing Harris, and more. Chicks On The Right (@chicksonright) / X (twitter.com)See omnystudio.com/listener for privacy information.

Mock from COTR joins the show to talk about Trump and Harris debate tomorrow and more. See omnystudio.com/listener for privacy information.

Daisey from COTR join to talk RFK Jr. endorsing Trump, the DNC, and more. See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show to talk Walz, Harris, and more.See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk about Trump's mistakes in the campaign so far and more. See omnystudio.com/listener for privacy information.

Daisey from COTR joins to talk JD Vance, Kamala Harris, and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk Biden's announcement and more. See omnystudio.com/listener for privacy information.

Daisey from COTR joins to talk this past weekend and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins the show! See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk See omnystudio.com/listener for privacy information.

Daisey from COTR talks Trump conviction, Fauci on the stand, and Caitlin Clark. See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk about the chaos on college campuses and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins the show! See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Mock from COTR join to talk about "The Rock" regretting endorsing Biden, transwomen in women's sports, and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins the show! See omnystudio.com/listener for privacy information.

Daisey from COTR join to talk Oscars, SOTU, and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins the show! See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Mock from COTR joins! See omnystudio.com/listener for privacy information.

Daisey from COTR joins to talk Super Bowl, border control, and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk new border 'control' bill and the Grammy's. See omnystudio.com/listener for privacy information.

Daisey from COTR joins to talk about border crisis in Texas, and more. See omnystudio.com/listener for privacy information.

Mock from COTR join to talk DeSantis dropping out of presidential race. See omnystudio.com/listener for privacy information.

Daisey from COTR calls in to talk Iowa Caucus and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk Jan 6th and more. See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk GOP debate and more! See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk about the DeSantis vs Newsome debate and more. See omnystudio.com/listener for privacy information.

Daisey from COTR talks celebrities endorsing candidates and more. See omnystudio.com/listener for privacy information.

Mock from COTR join to talk Hamas, pro-Palestine protest on college campuses, and more. See omnystudio.com/listener for privacy information.

Daisy from COTR joins to talk about Biden giving more money to Ukraine, and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk latest protests with Israel, possible new GOP Speaker of the House, and more! See omnystudio.com/listener for privacy information.

Daisey from COTR joins to talk latest in Israel, the border, and more. See omnystudio.com/listener for privacy information.

Mock from COTR talks fire alarm diversion during government shutdown vote and more. See omnystudio.com/listener for privacy information.

Daisey from COTR talks border crisis, upcoming GOP debate, and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins to talk Lauren Boebert, the Biden's, and more. See omnystudio.com/listener for privacy information.

Daisy from COTR joins the show to talk Biden's embarrassing speech in Vietnam and more. See omnystudio.com/listener for privacy information.

The Morning Coffee Crew is starting your weekend off with a bang! Jazzy G and Cheryl Starr have an in-depth conversation about past Housekeeping subjects and past episodes and events and the fun they had. O Power Me Up Radio Talk 24/7 on iHeart radio. Contact us at: info@morningcoffee.chat --- Send in a voice message: https://podcasters.spotify.com/pod/show/guy-rainey/message

The Morning Coffee Crew is starting your weekend off with a bang! Jazzy G and Cheryl Starr have an in-depth conversation about past Housekeeping subjects and past episodes and events and the fun they had. O Power Me Up Radio Talk 24/7 on iHeart radio. Contact us at: info@morningcoffee.chat --- Send in a voice message: https://podcasters.spotify.com/pod/show/guy-rainey/message

Mock from COTR joined the show to talk the passing of Carmel lacrosse coach, Trump's mugshot, and more. See omnystudio.com/listener for privacy information.

Daisy from COTR talks border in Texas, new viral country song, and more. See omnystudio.com/listener for privacy information.

Mock from COTR joins! See omnystudio.com/listener for privacy information.

Daisy from Chicks on The Right, talks Trump strategies and more. See omnystudio.com/listener for privacy information.

Mock from COTR talks Democrat polls and more. See omnystudio.com/listener for privacy information.

Daisey from Chicks on the Right joins to talk cocaine in the White House, Pence's mistakes with Tucker Carlson, and more. See omnystudio.com/listener for privacy information.

See omny.fm/listener for privacy information.

Mock, half of COTR, joins! See omnystudio.com/listener for privacy information.

Daisey from COTR joins the show! See omnystudio.com/listener for privacy information.

Daisey from Chicks on the Right joins to talk about the border crisis in Texas. See omnystudio.com/listener for privacy information.

Mock, one-half of Chicks on the Right joins! See omnystudio.com/listener for privacy information.

Daisy from COTR joins the Hammer and Nigel Show. See omnystudio.com/listener for privacy information.

Daisy and Mock talk DeSanits pudding attack ad and the CRT scandal with Plainfield schools. See omnystudio.com/listener for privacy information.

Daisy from COTR joins Hammer and Nigel See omnystudio.com/listener for privacy information.

Mock and Daisy talk AI, TikTok, DeSantis, and more. See omnystudio.com/listener for privacy information.

Mock and Daisy from Chicks on the Right talk Trump's potential indictment.See omnystudio.com/listener for privacy information.

Mock and Daisy talk CPAC experience See omnystudio.com/listener for privacy information.

See omnystudio.com/listener for privacy information.

Mock and Daisy talk Buttigieg visiting Ohio and more! See omnystudio.com/listener for privacy information.

Mock and Daisy return to talk about Tiger Woods tampon joke and more!See omnystudio.com/listener for privacy information.

Mock and Daisy from CHICKS ON THE RIGHT has a WIBC reunion with Hammer and Nigel, they cover Superbowl and if the balloons really are ALIENS?! See omnystudio.com/listener for privacy information.

In SQL können JOINs verwendet werden, um Daten aus verschiedenen Tabellen zusammenzuführen und zu analysieren. Es gibt verschiedene Arten von JOINs, die je nachdem, wie die Tabellen miteinander verbunden werden sollen, verwendet werden können. Ein INNER JOIN gibt nur die Zeilen zurück, die in beiden Tabellen vorhanden sind. Ein LEFT JOIN gibt alle Zeilen aus der linken Tabelle und die zugehörigen Zeilen aus der rechten Tabelle zurück (falls vorhanden), während ein RIGHT JOIN alle Zeilen aus der rechten Tabelle und die zugehörigen Zeilen aus der linken Tabelle zurückgibt. Es gibt auch FULL OUTER JOINs, die alle Zeilen aus beiden Tabellen zurückgeben, auch wenn sie in keiner der beiden Tabellen einen Treffer haben.

One of the main features of the UK lockdowns has been the near-uniform consensus around them. As each one has gone by, cross-party support for lockdowns has only strengthened while fewer voices have been willing to offer anything in the way of dissent. There have been exceptions on both sides of the aisle: Lord (David) Blunkett, a famous figure of the New Labour era and former Home Secretary, and Sir Charles Walker, a prominent Conservative Party backbencher and vice chairman of the 1922 Committee, the all-important backbencher group.Coming from two very different political backgrounds, these unlikely bedfellows have joined forces to draw attention to the pitfalls of the UK's ongoing lockdown policy:They agree that a different solution could have been found, with a greater emphasis on personal agencyThey are particularly worried about the impact on mental health and the economyThey would like a faster timetable out of lockdownThey call for a public enquiry, and for people to be held to accountThey share strong messages for each of their party leadersI'm very strongly in favour of both free speech and defending the newspapers when it was unpopular, including the fact that they'd been extremely unpleasant to me 15 years ago. And in favour of free thought and free expression. But I'm not a libertarian. In other words, I'm not someone I'm not a hedonist. I don't believe that anything goes so I'm a bit of a contradiction in small C, conservative social attitudes, but a very strong commitment to a democracy being participative. Not taking the word from the top down. And I think that when we get out of this in the summer… we'll need to reset the the political dialogue, because otherwise we'll become used to being told what to do from above. That's bad for all of us, but it's particularly bad for democracy. People are frightened. The political class and the media and the scientists on stage have been very, very good at frightening people. We've had these amazing television campaigns, which basically say, you're going to kill people if you leave your home because the government wanted to keep infection rates down and it wanted to keep deaths down. I'm afraid the legacy of that, as I said in Parliament yesterday, is going to be a very long tale of mental health problems… We've got people who were so terrified, they won't leave their homes. We've got children who won't go outside because they're frightened, if they catch something and bring it back they'll kill their parents, we've got adolescents self harming. We have just done in my view, a terrible, terrible thing, and we will regret it for a long time to come. On returning to normality:Readjusting to any kind of normality is going to be a massive challenge, it will have an impact on productivity on our life and wellbeing for some time to come. There should be a recovery programme geared to that the psychology. In terms of those daily press conferences, they should be turned into something positive, if we're going to recover, not just economically in terms of restoring growth, and getting people into meaningful jobs. But also getting back the kind of life that we want to lead and the way in which people can get up in the morning and get themselves to work. On SAGE:I think you can be a SAGE scientist and advise the government, or you can be a scientist that goes on the airwaves, TV and radio, but it has been so damaging to have these various scientists from SAGE beating each other up on the airwaves, creating huge concern. It is pretty disgraceful when they're introduced as X, Y and Z, and Professor X, Y and Z is a SAGE scientist, but is here in his or her own capacity. They're not there in their own capacity. They are there as a SAGE scientist, and of course, they've never been more in demand. They've never been more intellectually engaged. But having these various scientists on our airwaves and in our newspapers day after day after day after day, beating each other up IS scaring constituents. Some of my constituents have just been debilitated. Again, I'm sorry, if I sound emotional but this has been utterly disgraceful. I hope there's a public inquiry and I help hope people are held to account I'll be held to account at the ballot box. On China:I went to China first in 1983. I wouldn't want to live in China, I wouldn't like to live under that particular regime, and particularly the one that's in place at the moment. And I wouldn't want anybody to actually have to transfer that particular command and control both socially and economically, to this country. I would fight very hard against that. So the answer is that the Chinese have developed an understanding of the way in which they comply, not just the communist era from 1949, but long, long before that. We wouldn't want to put up with it for one moment. We should be very wary of everything we do. On the economic front, we should be extremely robust, not just as a nation, but internationally with the Chinese. But they are the second largest economy now in the world. And we need to learn how to deal with them. And dealing with them needs a bit of good statecraft and clever political operation, and not just a head in the wall. Read The Post here See acast.com/privacy for privacy and opt-out information.

Should you marry someone with debt? Should you walk around your house naked? Should you masturbate to pictures of your partner's cousins? These are all easy questions for all of us to answer right? Right? Join us and this week's returning guest E.A. to see what others thought and what paths these questions took us down.

Should you marry someone with debt? Should you walk around your house naked? Should you masturbate to pictures of your partner's cousins? These are all easy questions for all of us to answer right? Right? Join us and this week's returning guest E.A. to see what others thought and what paths these questions took us down.

Protect your online privacy today at http://expressvpn.com/inside. TAKE A KNEE! The US Military has hit a new low while attempting to use Twitch as an armed services recruitment platform. In the COOLEST of fashions, they ran a fake contest on their own Twitch channel! Neat! It featured a clickable link to win an Xbox Elite 2 controller which aaactually just sent participants to a recruitment page, whoopsies! In response to the dubious act, U.S. Representative Alexandria Ocasio-Cortez said recently that she plans to file a measure to stop the military from using games and esports to recruit people. Sure, some might be willing to give the military the benefit of the doubt... I mean, not like this is the first weird scammy thing the army’s ever done, RIGHT? Join us today on Inside Gaming and read between the lines to learn everything the government doesn’t want you to know!  Listen to our podcast! https://link.chtbl.com/IGPodcast   Or buy our shirt! https://is.gd/u3xCtA OR follow us on Twitter! http://twitter.com/doplextv https://twitter.com/briangaar http://twitter.com/darthburrit0 http://twitter.com/handsomemaster2 http://twitter.com/mc_lotta http://twitter.com/InsideGaming SOURCES [The Nation] The US Military Is Using Online Gaming to Recruit Teens https://bit.ly/30M3PhN [Kotaku] Twitch Forces U.S. Army To Stop Tricking Viewers With Fake Giveaways https://bit.ly/30IGEov [Twitter] @Slasher https://bit.ly/30MXtPj [Vice] U.S. Army Esports Team May Have Violated the First Amendment on Twitch https://bit.ly/3fXYxG5 [The Washington Post] Army ban on war crime comments during Twitch stream may have violated First Amendment, lawyers say https://wapo.st/3jG0AkK [Streamlabs]  State of the Stream June/Q2 2020: Livestreaming is getting much larger and more global, non-gaming content is on the rise, and nature channels are a thing https://bit.ly/2OVnFS2 [Twitch] Easy mode for your next influencer campaign https://bit.ly/2CYeP3j [The Guardian] Drone wars: the gamers recruited to kill – video https://bit.ly/39qrZCh [CBS News]  Army turns to video gamers for new recruits https://cbsn.ws/2D3feBw [Vice]  AOC Introduces Measure to Stop the Military from Recruiting on Twitch https://bit.ly/32RQ2ss [Twitch] USArmyEsports https://bit.ly/30N2mI9 [Twitch] AmericasNavy https://bit.ly/3hv0udC [Twitch] AirForceGG https://bit.ly/2OVa4uc

All us counterculture 90's kids grew up with the subversive superhero in white makeup that went around murdering Detroit thugs on a revenge mission from the other side of the grave. But chances are you knew The Crow from the movie. Did you know it was based on a comic book? Because I'm that dude that will repeatedly interject that kind of information into a conversation any chance I can get and in no way is that something annoying that should have ceased long before I was in my thirties! Right?Join me today as I do something a little different. This episode marks a new direction for the show, as I deviate from the structure of narrative retelling and dive more into peripheral and personal information about the comic book, its creator, and the influences that run through the soul of the story.

Join us as we discuss the release of Just Rey (we officially take credit for naming her) and Supreme Leader Buddy Boi! By all accounts the last 4 months of SWGOH have been a boring misstep culminating with a lackluster event and unbalanced toons. So in an era where nobody wants to test positive, we present our most negative episode ever! But don't worry, there is always hope. Right?? Join us on our Discord server to keep the conversation going! https://discord.gg/dWAeMww

The gang recover from a deadly encounter, using glitter to help patch fresh wounds. Nothing, can go wrong with that right? RIGHT? Join them as they explore the cave and go impromptu fishing using a sorcerer as bait. Somehow, through copious amounts of nonsense they stumble upon some new mysteries before heading back into the mire. Y’all ready for some lore!?

Today on the podcast we explore how to meet our kids where they are. To respect them as unique individuals, to open our communication, to embrace our vulnerability and to examine our expectations. This episode helped us set our sights on becoming more aware, more able to seek acceptance, and ultimately, more able to trust. Which feels fucking impossible most of the time. Right? Join us to deep dive a bit into our beliefs, expectations and tough interactions with our kids. We laugh, we cry, we lean in. Join us! Relevant links: - Upbringing's Empowerment Episodes - Out of Control by Dr. Shefali Tsabary - Alfie Kohn - RIE Parenting - Magda Gerber, Respectful Parenting Pioneer - Upbringing's RESIST Approach - We Play In The Gray Upbringing Episode - Janet Lansbury - Dr. Ross Greene of Collaborative and Proactive Solutions - Parenthood, 1989 movie - Perfect Harmony tv show This episode is supported by Revival Rugs, a direct-to-consumer rug company that ethically sources beautiful, one-of-a-kind vintage rugs from Turkey. Support Upbringing by visiting our website’s Partners page to learn more! Visit our website, www.upbringing.co to learn more about us and sign up for our newsletter! We want to hear your thoughts. We care deeply about what you think and how you’re doin’, so get in touch -- we’re better together. Email us: info@upbringing.co Follow UpBringing on: Instagram: @up_bringing Facebook: @jointheupbringing

Episode 4 is here!Your heroes have retrieved the telescope, and escaped the Sunken City, but now their next challenge looms in front of them; jail. How are they going to escape? And what exactly does the telescope do, or more specifically, foretell? Having seen images and prophecies that have left our heroes shooketh, they must now make sense of it all, and the answers they seek may lay aboard Captain Fal'kjun's ship. But if Captain Fal'kjun asked specifically for the telescope, he must know its importance and what it is capable of...Right?Join in on this installment of your favorite long-distance friends as they brainstorm a daring and castrating escape, captivate victims with magical stories of Benjamin the Bold, and eat a really good salami sandwich!

The next Lego Movie is here, and everything is definitely still awesome right?? Right?? Join us for our full review of “The Second Part” as well as our reactions to the ‘Shaft’ reboot and Will Smith’s attempt at the Genie/Papa Smurf.

What to do on a night off from the Whispers groups....Well our competitors in the Whispers games tried to match their idol numbers this season so it only feels right to play the Whispers Match Game!!! What zany answers will be given to the questions asked tonight? Who will show their superior matching skills? Who will be the Charles Nelson Reilly of this bunch? Brett Somers? What about Richard Dawson? In the match game any answer can be given and with this group we have, anything can be said at any time! Could we have a PG night? Maybe PG-13? Certainly not R! Right? Join us tonight as our host Jim Early will be asking the questions! But watch out! You may have the answers and he may change the questions! Join us for a night of fun and laughs! Call in at 657 383-1308