Hello friends, today we will see the next operations in relational algebra. So, learning outcome for this session is students will be able to write relational algebra expression using natural join, outer join, assignment operation and extended relational algebra operations. We will start with natural join. So, when we want to combine some certain selections and Cartesian product into one operation using this natural join. So, what are the steps in this natural join? We will first form a Cartesian product of its two arguments or two relations that we have passed. Then we will perform some selection criteria based on the attributes which are common or which are appearing in both the relations and then finally, we will remove duplicates. So, here if r and s are two relations. So, r natural join s is equal to project the attributes of r and s. So, that is nothing, but r union s perform the selection criteria on the attributes which are common in r and s on Cartesian product. Let us see with example. So, again courses taught relation and courses relation. So, look at the attributes here class ID, course ID and teacher ID, whereas in courses it is course ID and course name. Now, find the courses taught by teacher along with the course name. So, we require courses taught and courses. These are the two relations will perform the Cartesian product. Then the we will perform the selection on basis of the equality of the attributes. Now, here the common attribute is course ID and then we will be selecting the attributes removing the duplicates. So, courses taught Cartesian product courses, selection on course ID which is common attribute and then the attributes which we are interested which is equivalent to all these are equivalent to this performing courses taught natural join courses. So, Cartesian product and selection is equivalent to natural join. So, now how it will be performed? So, again we have seen in the previous lecture that there are 10 records here and 10 records in this courses. So, total 100 records will be obtained in Cartesian product. So, first record of this courses taught. Now, the common attribute is course ID. So, DMS is not equal to AM1 then DMS is not equal to C. In that way this record will be combined and will be checked for common attributes or value for the attribute. So, only this DMS and this DMS is same. Second record this will be checked again with against all the attributes. So, only AM1 and AM1 will be equal. So, in that way we are getting this result as in 10 records where we are getting teacher ID course ID which is common. So, either of them can be used as a relation and then course name. This is the result of natural join. Now, consider these two relations here employee and department. So, perform the natural join of employee and department. So, pause the video and write down the result. So, common attribute is department ID. So, I hope you have written the result. So, here if we look at this again departments and employees. Now, here are there are one, two, three, five departments and whereas, the departments in employee all the departments are not having employee remember that. So, mechanical and civil are the departments where there are no employees in employee tables we are not got that departments here. So, sometimes we want the complete information without any loss in that case we can use outer join. So, outer join is the extension of this natural join and which will be used to avoid the loss of information. There are three forms of outer join left outer join right outer join and fully outer join. Now, first we will see left outer join. So, it takes all the tuples of the left relation which are not matching with the tuple in the right relation. Now, it will pair the tuples with null values for all the attributes in the right side relation and add the result to the natural join. So, obviously now consider this department relation and employee relation. So, department left outer join employee. So, natural join will be performed and the remaining record where there is no record on the right hand side it will be padded with the null. So, all the records of the natural join are already written over here which is the result which we have seen in the previous slide. Now, mechanical and civil does not have employee. So, these two values will be written or the padded with null. So, this is the result of left outer join. Right outer join is again the reverse of the left one. So, it takes all the tuples of the right relation that did not match with any tuple in the left relation. So, obviously again it will be padding the value null for all the attributes from the left relation and then add the result to the natural join. Now, consider the example of the loan relation and account relation. There are some accounts out of that some accounts or some customers are having loan also. So, we want to get the information of accounts along with their loan. So, loan right join account. So, obviously it will give you what the result. So, pause the video and try to get the result. So, right join is for account. So, all the records will be account will be obtained. Whereas, the records which are not matching will be padded with null. So, here there are two records or the two accounts which doesn't have loan account. So, these values are null here. The full outer join. So, it does both left outer join and right outer join. So, the it will pad the tuples of the left relation that does not match with the right relation and it will pad the right relation that does not match with the left relation and the result will be added to the join operation obviously. So, consider again the same relations that we have seen employee relation. So, here ENTC is the department for the employee which is not listed in this department relation. Whereas, mechanical and civil are the departments for which there is no employee. So, what will be the result? Write down the result. So, here this ENTC department is not listed in the department relation. So, department name will be null. Whereas, for mechanical and civil there are no employees. So, result of employee ID and employee name will be null and this is the complete result of full outer join. So, if you want only the common records you can perform natural join. If you want the complete information of the left relation or right relation then you can use left outer join or right outer join or if you want the complete information of both the relations along with the matching record then you can go for full outer join. The next operation is assignment operation. Sometimes we want to store the result of this relational algebra expression temporarily. So, then in that case we can use this assignment operation. It's the same as as we use it in programming languages. Now, it is denoted by this backward arrow. So, here consider again the natural join how it is performed. So, first perform the Cartesian product assign the result to the temporary variable. So, here it is ten point for example. Now, the selection should be applied on this particular result of the Cartesian product. So, select with the common attributes which are present in both the relations and then again the result will be stored in ten two. So, if you remember our example this will contain 100 records of Cartesian product. After applying the select criteria it will take only the records matching records that are the ten records and after that we are projecting what we are interested in that many attributes. So, we can use here assignment operation. Now, sometimes we want to write a relational algebra expression which will require some additional or we can say that we are using the relational algebra expression that will provide the facility which is not able to express using basic operations. So, these are generalized projection and aggregation. So, it is an extension of relational algebra operations. So, first see generalized projection operation we have already seen projection where we are projecting attributes.  Look at this form here F1, F2, Fn are the arithmetic expressions which will calculate some value based on constants or attributes from the schema of E where is any relational algebra expression. Let us look at the example. Now, consider this is a loan relation where there is loan amount and paid amount. For example, we want to see the outstanding amount then what we can do is that project loan ID account ID and loan amount minus paid amount as outstanding from loan relation. So, this is going to be the result of generalized projection. So, loan ID account ID and outstanding or consider that we are having the employee relation where there are salaries. We want to calculate the salary of average salary or monthly salary then what we can do is that we are having the complete salary. So, salary divided by 12 can be the expression used in this project operation. So, we can use arithmetic expressions for the projection in generalized projection. Next operation is aggregation operation. Now, what is aggregate functions? It takes the collection of values and return a single value. So, some average min, max, count are the aggregation functions. How to use it in relational algebra? So, general form of this aggregation function is that G. Now, this F1 of A1, F2 of A2 and so on are all the aggregate functions where on this left hand side G1, G2, Gn are the grouping attributes if these are optional. So, if you want to group that result by some attributes you can use group by as same in skill statements and number of operations that you are interested in on this relational algebra expression or the relation. So, look at this example, select some of the salary from employee. So, if you want to calculate for example, how much salary is paid monthly by the organization in that case we can use some aggregate function. So, equivalent relational algebra is G, sum of salary from employee. So, this is the sum aggregate function this is the attribute G is for generalized aggregation and then relation is employee. So, result is obviously the sum of all the salaries. Now, second we want department wise how many we want to see that how many how much salary is spent department wise. So, what will be the skill statement select department ID comma sum of salary from employee group by a department ID. So, equivalent relational algebra expression will be department ID is a group by attribute group by attribute G then sum of salary from employee and the result will be it will show you department wise salary. Now, this look at this query and pause the video and try to write down the relational algebra expression. Here we are interested in department wise salary and the number of persons or employees in that department. So, select department ID sum of salary count of star from employee group by department ID. So, again department ID G sum of salary is the first function count of star is a second function from employee and what will be the result? This is a salary department wise and number of persons in that particular department this will be the result. So, thus we can use any aggregation function in this relational algebra expression. Thank you.


The most important leadership skill I have picked up is being able to manage time very well and meetings. Be a leader by example. Being persistent in the face of adversities and challenges. Critical thinking. Managing diversity. Being independent. Activism, lobbying, fundraising, teamwork, collaboration, that's very important. You can change the world by yourself. Planning, organizing and setting objectives.


Everybody forced here rip in 2022 Chronicles draft picks football hobby eight bucks number five random team style I'll leave the results on screen. There's a also a link in chat. You can check For the results and you can always find them on the website late and sports cards calm Let's see what we got everybody my first look at Chronicles draft At times are gonna be a little slow here. I might have to search some guys Totally not familiar with all the guys and their teams currently so Do our best That's not bad drew Not bad at all Honestly, all right. This is what four autos or mem per box on average Yes, and that's like what two autos to mem for the most part Starting off nice a Chris Olavae jumbo jersey that goes to the Saints.   So you got ridder and um London London the beast too Got a Justin Herbert's you go Chargers number to 25 Jameson Williams Cooper cup Matt Corral rated rookie optic for the Panthers And Jordan Davis Yeah, Ryan, that's crazy, man George Carlatis college ticket auto to 99 that's so cool though. Congrats again, dude Carlatis Carlatis chiefs on the auto. Hey Palamalu Kenneth Walker.  Come on now Eagles Eagles Carson strong Aaron Rogers to 149 for the pack Dachshund Hill With the origins auto here and that is Bengals on the Dachshund Hill Yeah, three autos in the first box nice Williams Aidan Hutchinson rated rookie optic There you go. Detroit and hollow Jalen. Jalen widemeyer. If I miss a card Numbered car. I mean Yeah, it's true. It's true illegal Aidan Hutchinson jumbo jersey for the Lions Dean Traylon Burke's Titans rated rookie optic Carson strong Deandre Swift spectra Dalvin Cook Woodson Woodson goes to the Raiders by the way guys vets are going to go to current team or longest tenure if they're inactive Stingley and Kyren Williams an active being free agent or Um retired Deandre Swift spectra this time to 99 for the Lions Willis Hamilton Herbert and a Malik Willis Titans rated rookie optic redemption Khalil Shakir, I think he's bills, right? Remember his name for some reason Khalil Shakir is bills. Yep on the uh in the zone signatures Red Desmond Ritter to 149 Uh, Balkans rated rookie. We've got a Damion Pierce college ticket auto Damion Pierce went to the Texans Damian Pierce Texans Damian Pierce Howl there's a woods into 149 for the Raiders Kyren Williams rated rookie optic Malik Willis Okay, there's a Jermaine Johnson the second Non-numbered origins auto Jermaine Johnson Jets on the Jermaine Johnson. Uh, no, don't think any Drake London yet. Not any numbered anyway or hits George Pickens optic rated rookie Let's keep it rolling Justin Ross, where did he end up signing again patch auto to 199 like that. They have impeccable in here Justin Ross Notable undrafted player Injuries man sucks Chiefs Justin Ross, that's right. What's up kicks Johan Dotson and to 49 a Ahmad Gardner Jets college ticket That's a cool look right there man contenders optic Is that what is that what contenders gonna look like this year? That would be a fire Yeah, I think they haven't they had them last year too illegal So oh we got Brian Robinson jr. College ticket auto to 49 Brian Robinson Washington on the hit Dippadoe you got to uh 1099 dolphins out of XR Nicoby Dean optic rated rookie Jack Sanborn Auto to 49 Sanborn Sanborn jack Sanborn Bears jack Sanborn to 49 origins auto there Chancellors or reader There's a London and a Carson strong a hollow On that rated rookie Here's a dalkins drake london jersey card here jumbo jersey. It's a garratt wilson Kyler jameson williams lions right on jameson The marvin leal kyle hamilton out of 99 ravens rookie Chronicles base got lute keekley for the panthers to 75 Eli Manning That is rashad whites aden hutchinson John mechie on the spectra not numbered That's jahan dotson. There's ross Carson strong and jalen tulbert rated rookie optic need to speed up or anything We've got alec pierce patch to 10 Alec pierce this time. We had damion a minute ago alec pierce Colts on that one jumbo patch To uh christ johnson trailing berks john mechie mechie is texans optic rated rookie Is who's that troy akeman to 149 for the cowboys? spectra keekley again panthers to 99 jabbo strong drake london dalkins rated rookie and uh pierce strung a j brown that goes to the eagles current team Camara lt zamir whites isaia spiller redemption Going to the chief's justin ross don rus rated rookie auto purple Sheeps on the justin ross london brice hall joe burrow red to 149 bangles out of phoenix zamir white on the impeccable patch auto zamir white Is raiders lamar jackson nice aiden hutchinson to 149 lions Kyle hamilton and a justin ross with some dings in it there We'll send an empty box and wrapper to the chiefs Hopefully you can get that replaced. I'm not sure if they'll do a base card Maybe is chronicles trey sterling on the auto to 49 trey sterling react trey trey sterling Don't think he's On a team or was on a team? See what twitter says I don't think he was ever on a team. I'm gonna look around a little more here, but I Looks like he's not on a team Packers it looks like Really hard to find but there's a uh I'm gonna go packers Yeah, there's like a sports illustrated thing here and he is in packers camp in the photo So we're gonna go packers. I can't find anything else I could barely find that. Yeah, and he's on looks like packers.com too. Yeah, I will go packers It's tough Don't know why the packers.com wasn't like the first thing there for me. That's strange Uh pickets and silver desmond ridder from phoenix for the falcons I wonder if he's related to scott sterling Yep, personals are full tonight What's up, bernie? Isaiah spiller triple jersey auto to 199 Chargers is a spiller scott sterling Yeah, scott sterling dude the legend Got red kenneth walker c or not red with blue kenneth walker seahawks to the 99 The trace sterling car is gonna shut us down. I mean, we're right. It's if he is packers Patriots legend right here bailey zap to 199 triple jersey auto Is it zappy or zap? It is patriots either way Corral howl devin loyde kenzie milton now this should be a random to all at the end to 49 Uh, pretty sure he never signed right? I don't think he ever tried to make it to the nfl kenzie milton He announced his retirement a month ago Yeah, that means he wouldn't have signed anywhere. He'd have been in camp at that time That's a random to all at the end guys. I'm kenzie milton the legend dude ucf legend So terrible what happened to him Glad florida state gave him another chance silver rookie k bond tippadoe Oh, well, man learning learning a lot right now with uh, with the new players I don't know this guy can he pick it jumbo patch Steelers There's the guy can he pick it trail on berks Matt corral trey mcbryde He's the top tight end draft to right trey mcbryde one of one russell wilson broncos boom Congrats denver There you go 2022 don russell wilson One of one for the broncos again collegiate uniformers current team jaylin widermeyer isaas spiller That's pretty cool. Could he hit a one-on-one anytime? God deandre swift going to the lions other spectra deandre that was the 75 Mechie walker Can't believe zack levine got the max Actually first one of one a congrats I need to get him. I need to get myself a one-on-one to find a one-on-one and just buy it Don't even have to be anything big. I just need a one-on-one, you know God, well that's supposed to be That's kendrick prior to 99 on the auto Kendrick prior It's a deal in the kendrick. Where's kendrick prior? Kendrick prior Bengals it looks like I see Uh, yeah, his face is on bangles website. I don't see it anywhere else Check news real quick. Yep Bengals on the kendrick prior breeze hall Silver james and williams college ticket That's still pretty good chat pretty good player to have a one-on-one of even if it is a printing plate Joel burrow jersey card Moxie jersey card Sinsy to 149. Who's that bret farf? Yeah bret farf longest tenure as packers bret farf Kenneth walker ergo seahawks spectra to 49 homes baddest walker and the Kobe dean Hey, thanks, kyle two days late, but I forgive you Uh Jabo my homes, man, man, I've been 30 for a while now About two days Alec pierce college ticket auto We just had alec pierce is washington Colts alec pierce Damian pierce. I think is washington Oh, man. Well, I'll get it eventually. I eventually maybe not today. Maybe not tomorrow, but eventually Kenny pickets Brandon rookie optic. That's going to the Steelers david ol jabo to 149. Yeah, seriously illegal Got redemption travesh jones origins rookie auto red Travis jones ravens on that one Wilson we've got an alvin camara to 149 saints A kaboom. I'll play the kaboom another redemption Kennedy brooks contenders college ticket auto Kennedy brooks Kennedy brooks. Wait, was he not? I thought he was Eagles kennedy brooks Olave optic rated rookie got blue jameson williams for the lions to 99 Yep, brad is Doing gaming only for the most part now He's been over on late in gaming recently to 99 is a mere white select auto No, we had his card earlier is a mere white It's a mere white Raiders Yeah, brad was over there earlier today. Actually he was live during the day to 99 nicobi dean He could draft it Eagles nicobi dean I think he's over there three days a week Many does it the other two days Uh daemon or daemon They did daemon clark to 99 cowboys daemon clark. Yep cowboys on that one pick it Kyle hamilton optic rated rookie. Hello sam howl Eagle panthers mac jones patriots patch card. Yeah, I don't google anything health wise now.  Doctor's expensive. They're gonna do anything. Anyway, that's gonna tell me to like Oh, yeah, just drink more water. I'll be like What do you mean? jacquan brisker jacquan brisker Where you at jacquan brisker? Where'd you go? What team are you on? Think bears Yep bears jacquan brisker Alvin kameritan 99 saints Kenny picket optic rated rookie for the for the Steelers Kingsley enag barre Kingsley enag barre Kingsley is packers On that origins auto not numbered Watts silver rashad white Got tyler alligier. I think that's washington, right? jumbo jersey card Falcons on the algear. Excuse me falcons on the algear Got a breeze hall rated rookie jets on the optic Khalilo Shakir Drake london for the falcons to 99 Garrett wilson got the kobe dean david bell stingley CD lamb cowboys pink spectra to 75 tyler goodson Malik willis patch auto to 25 nice hit for the titans Fantastic hit in the last pack Malik willis Traylon berks ojabo mohomes blue college ticket drake london for the falcons Out of 99 all right give me a sec We got a multi random and then we will do a recap So we had a mackenzie milton to 49 on the auto random to all nine times Go whichever team is up top and get the card one two three four five six seven eight nine mark k Mark k the mackenzie milton relics. We got tyler algear mac jones joe burrow Kenny pickett alec pierce drake london Aidan hutchinson chrysalave Mackenzie milton was random to all it went to mark on the random mark k That malik willis 25 nice patch auto there Uh kingsley anak barre Uh jackwan brisker damon clark zamir whites redemption kennedy brooks travish jones redemption alec pierce kendrick pryor bailey zapp isiah spiller tray sterling zamir white justin rosh chiefs redemption jack sandborn brian robinson jr. Justin ross jermaine johnson damien pierce Khalil Shakir redemption for the bills dachshund hill karson strong and uh george carlaftis And then there is a one of one russel wilson congrats broncos And that's got to do it for the break the another one of those chronicles draft coming up


Hi you guys, Lindsay here. Welcome back to my channel, Inside the Hem. There is nothing like handmade pajamas and when you can give them a catchy name, it's a home run. But before I tell you about my llama pajamas, I'd like to introduce you to the sponsor of this video, Bedscape. Bedscape is a luxury bedding products brand that just launched. The sheets are designed in New York and are produced in one of the oldest textile factories in the world located in Israel. They are OECO-TEX standard 100 certified, meaning that their textile products have undergone laboratory testing for a wide range of harmful substances and that the content of those substances remains below the limit values established by the OECO-TEX Association. In other words, there's absolutely no chemicals or GMO used to make these sheets. The collection available on the site is very classic and timeless in terms of colors and fabrics offering versatility and long-term use. The sheets are made of 100% long-staple cotton and are available in two different substrates, percale and satin. Percale sheets are known for keeping you cool at night, especially during hot summer months. They can feel crisp at first, but generally soften up with repeated washings. The downside to percale is that it can wrinkle quite easily. Bedscapes percale sheets have a 300 thread count. As you might know from garment sewing, satin is 100% cotton that's tightly woven to create a slick, smooth feeling and almost shiny appearance. These sheets are 350 thread count and therefore warmer and a bit heavier, making them ideal for all seasons. The downside to satin sheets is that they aren't great for hot sleepers because they aren't as breathable as looser weave fabrics. Both the percale and satin sheets come in a variety of colors and sizes and they come packaged in a super cute matching storage bag. I chose the satin sheet set in dark gray. They are just as soft as you would imagine them to be and the color is perfect for my decor. They fit my queen size mattress perfectly. The fitted sheet stays in place the entire week between washings. I've slept in the sheets for about two weeks now and washed them twice. They wash beautifully and I'm guessing because of the tight weave retain the smell of my detergent for days.  Another detail that's unexpectedly nice is how the pillow cases fold over like an envelope on the open end. This keeps the pillows inside and those annoying tags too. The only downside to these sheets is having to get out of bed in the morning.  They also offer free shipping anywhere in the US all the time. Use the link in the description box to access their site and shop for your new favorite set of sheets. Okay now that you've got your sheets you need some pajamas that are equally as luxurious and comfortable right? Well if you haven't heard of the carolin pajamas yet you've been missing out. This is my second set of carolins and I love them even more than the first. They are a bit labor intensive with the collar set in sleeves and full front placket but it's so worth it to have pajamas that feel grown up special and detailed. Consider them the black tie of your nightgown drawer. As much as I love the pattern the fabric is the real star of these pajamas. This adorable llama fabric is from Joanne's Doodles Juvenile Aparic Fabric Collection. So yeah it's intended for kids clothes but who cares? These llamas really do make the perfect pajamas. The fabric is 100% cotton making them perfect for pajamas because it is soft, breathable, and moisture absorbent. You can also machine wash and dry on low heat. The only thing you really need to worry about with this fabric is that it does tend to grow as you sew it. I would recommend using a walking foot for all seams especially those that aren't on the straight grain like the collar, waistband, and the hems. When I discussed this project in a previous video many people commented suggesting pre-washing three or more times to make sure all the fabric shrinkage is removed. In full disclosure though I only washed mine once and haven't noticed any shrinkage in any washings after sewing even using the dryer. So just use your best judgment here. Currently all of the juvenile fabrics are 50% off at Joanne so you can grab this fabric for $5 a yard which is good because the carolin pajamas can use quite a bit of fabric depending on the combination of pattern pieces. A long sleeve top with pajama pants for example would require more than four yards of 60 inch wide fabric. I've got a link in the description box that will take you directly to the fabric I used and another link that will take you to a listing of all the llama fabrics at Joanne. There are some others that are really cute and flannel and fleece. Well that's going to do it for me today. I really hope you like my llama pajamas as much as I do and I hope you'll try out Bedscape. Both things together really do make for a great night's sleep. Thanks for watching. I'll see you all next time. Bye!


Hello and welcome to today's episode of the International Daily Roundup by People's Dispatch where we bring you some of the top stories from around the world. Let's take a look at today's headlines. Yemen war investigator targeted with Pegasus Spiveyre, Egyptian activist Ala Abdel Fattah sentenced to prison, UK court ruling continues blockade on Venezuelan reserves, and mining law withdrawn amid protests in Argentina. A United Nations backed investigator who was looking into war crimes in Yemen was targeted by the Israeli NSO groups Pegasus Spiveyre. Analysis suggests that Tunisian politician Kamal Jandubi was selected as a potential surveillance target by Saudi Arabia. Analysis by Amnesty International and the Citizen Lab shows that his mobile phone was targeted in August 2019. Jandubi was the head of the former group of eminent experts or GEE in Yemen set up by the United Nations in 2017. In September 2019, the panel released a report concluding that the Saudi-led coalition had committed serious violations of international law and possible war crimes in Yemen. Jandubi's phone was targeted shortly before this. His mobile number was also part of the leaked database which was at the center of the Pegasus project investigation. While forensic analysis did show that an NSO client had tried to hack his phone, it is not clear if the attempt was successful. Nevertheless, the revelations are serious in light of Saudi Arabia's effort to shut down the UN war crimes probe into Yemen. A report by the Guardian revealed that Saudi officials had lobbied extensively to shut down the probe using threats and incentives. In 2020, the GEE had started pushing for war crimes accountability stating that the Security Council referred the matter to the International Criminal Court. However, a resolution to extend the GEE's mandate was defeated by a majority of 21 to 18 in October 2021. Among the countries targeted by the Saudi threats and incentives were Indonesia and Togo. Between 2020 and 2021, both changed their votes from abstention to no on the Yemen resolution. In our next story, we take a look at Egypt, where prominent activist Al-Abdul Fattah has been sentenced to five years in prison. Human rights lawyer Mohammed Al-Baqir and blogger Mohammed Oxygen Ibrahim have also been sentenced to four years. The rulings were issued by Egypt's Emergency State Security Court on December 20. Abdul Fattah is a left-wing blogger and activist who was one of the key figures in the 2011 revolution. He was first jailed in 2013 and then again in 2015. He was granted conditional release in March 2019 before being arrested again in November with charges of publishing false news belonging to a terrorist group and a misuse of social media. Lawyer Mohammed Al-Baqir was also arrested during this time while serving as Abdul Fattah's legal counsel. Meanwhile, blogger Mohammed Ibrahim was arrested in 2018 for reporting on irregularities in the presidential election and opposition figures. He was released on parole before being arrested again under new charges in September 2019. All three men have already spent over two years in pre-trial detention. They have been sentenced for spreading false news undermining national security in a new case numbered 1228. This case is a replication of the original 2019 case and has been rejected as an attempt to prolong detention beyond the law. As reported by Middle East Eye, the trial was also based on a series of due process violations. The activist's lawyer were not informed of the charges and did not have access to the files. No other evidence except for social media posts have been presented. Despite all this, the prison sentence cannot be appealed and must now be ratified by the President. Now we take a look at the United Kingdom, where the Supreme Court has ruled to continue a blockade on 31 tons of Venezuelan gold. The gold which is worth nearly $2 billion is being held at the Bank of England. The case first went to court in 2020 after the bank refused to release the gold reserves to the Bolivarian government of Nicolás Maduro. It stated that it recognized opposition member and co-leader Juan Guaidó as the legitimate authority. However, the Court of Appeal ruled in favor of the Central Bank of Venezuela in October. It considered the possibility that the UK could recognize a de jure president which would be Guaidó and a de facto president which would be Maduro. This order was overturned by the Supreme Court this Monday based on the so-called one-voice doctrine. It argued that courts could not go against the UK government's political decision to recognize Guaidó as Venezuela's president in charge. It added that until the conflict of authorities was resolved, the reserves would remain in the Bank of England. Meanwhile, another aspect of the case is the ruling by Venezuela's Supreme Court declaring Guaidó's transition statute as null and void. The UK Supreme Court has asked the commercial court to decide if this ruling is to be recognized. The Maduro administration had proposed that the reserve money be transferred to the UN to buy medical supplies for the pandemic. It has rejected the UK Supreme Court ruling as an abusive action representing the judicial system's subordination to illegal foreign policy actions. And finally, we go to Chubut Province in Argentina where the government has agreed to repeal a controversial mining law. Law 17 No. 149 for the zoning of mining activity was approved by the Chubut's provincial legislature on December 15. It would have allowed open-pit mega-mining in the department of Telsen and Gastre. Environmental groups and activists had long opposed mining in the area due to potential contamination. Following the vote last week, major protests broke out in different parts of Chubut Province. Violent police repression was reported in the capital of Rawson on December 15 where several protesters were injured with rubber bullets. Protests were held again on December 16 in the town of Askel. Massive demonstrations were also held in the cities of Porto Madrid and Commando Ro Rivadavia on December 17. Raising the slogan mega-mining is equal to death, protesters marched to the government house from the governor's residence. People also raised the slogan, water is worth more than gold to protest water, scarcities and chemical contamination caused by mining projects. A massive anti-mining demonstration was held in Madrid again on December 20. Governor Mariano Arsione has stated that a provincial plebiscite will be held on the mining law. In 2003, Chubut had passed a law banning open pit mining and the use of cyanide for mineral processing in the entire province. This impacted companies like the Canadian Pan Am Silver which was forced to halt operations at its Navidad Silver Mine in 2013. The zoning law passed last week would have allowed mining to resume at the site. And that's all for today's episode. For more such stories, visit our website at www.peoplesdispatch.org and follow us on Facebook, Twitter and Instagram. Thank you for watching.


From Hollywood. It's time now for Bob Bailey as Johnny dollar Pat Gallagher Universal how'd you make out with mr. Reardon? I met her she thinks I'm an insurance broker or something. I told her I knew her husband when he was alive Industrial act. Did you find out anything that'll help you? I found out she's pretty upset about everything in the world Oh, she invited me for cocktails. I'm gonna call her later this afternoon and keep the date Maybe I'll get some information then Shut up Tonight in every weekday night Bob Bailey in the transcribed adventures of the man with the action-packed expense account America's fabulous freelance insurance investigator. Just really Johnny dollar Expense accounts submitted by special investigator Johnny dollar to the Universal Adjustment Bureau Baltimore, Maryland The following is an accounting of expenditure is during my investigation of the Chesapeake fraud matter Expense account item three twenty three dollars and sixty cents long-distance telephone call to George Hanley in Denver, Colorado George is an old friend of mine in the private detective business I told him about the report that John Reardon was still alive and living in Denver under the name of Frank Bowers. I Requested him to gather information that would help in determining whether Bowers was really John Reardon or not I spent the remainder of the day reading over the facts of the case as supplied to me by Pat Callahare of Universal Adjustment Expense account item four ten cents another phone call This one to John Reardon's widow Mrs. Reardon, yes, this is Johnny dollar. Yes What time I was at her home at seven o'clock knocking on the door It was a nice home and she seemed like a nice person even nicer than the night before I Asked you to call me Elizabeth. Mr. Dollar. I remember Yes, you also asked me not to mention your husband's name. I Wish you'd forget that I was upset last night when we met forgive me How's your drink? That's well, I Don't know why but I feel I should explain myself a little more about saying what I did about John I Was very shocked at his death. I suppose I still am even though it was five years ago It always disturbs me when I'm reminded of it Yet it's good to be reminded I suppose to know that he Really is dead that he won't come through that door anymore That he won't telephone me from the office or make any plans with me Does that make sense I suppose so We can drink another one sometimes things make more sense with a few drinks Sometimes they don't make any sense at all Elizabeth That's right to Johnny.  I like you Tell me about your business. You said insurance.  No I'm an investigator. That must be terribly interesting work. I suppose you travel everywhere She had a nice mouth soft Frank wide open eyes a Couple of times I was on the verge of telling her exactly what I was working on and why I was talking to her But I didn't Somehow I felt comfortable in the house Other drinks and music we eventually got around to John Rudin She told me of their four years marriage that ended with his sudden death possibly want to have Why do I tell you all this? I never talked to anybody about it. I don't know possibly because you Just want to talk to somebody about it You're easy to talk to Johnny. I Was 19 when I was married. I'd never known another man It was wonderful at first Wonderful all the time I suppose. I just wasn't grown up enough to realize it Can I ask you a question? Julie Did you really love him? Yes, I'm not convinced why Just a feeling well, I did I'm not so sure he loved me I Don't awful thing to say. I don't think so It's probably been on your mind a long time You don't know me from a load of coal, but we've sat here and talked an hour. I think I know you I Think so, too. You still seem very despondent about his death Yet you aren't sure he loved you. I loved him. Oh Here I am explaining things again, I suppose because they sound so foolish I Once we both loved each other very much, but we kicked it away We just didn't get along. He was out spending his money on other people and I was taking up this past time Can you tell when I've had too much no, thank you awfully oh Hugh Elizabeth Johnny this is Hugh Brian This is mr. Dollar Hugh and I'm mr. Dollar How's your drink Liz? Fine. I'll tell me again. Who is this? This is mr. Dollar. What's your business mr. Dollar? I haven't seen you around before Obviously, you just met mr. Reardon or you would never never start drinking with her. I wouldn't know That's true. Liz isn't it. He was a friend of John's Hugh. Well, that's nice I don't think I ever heard him mention your name. I Was a friend of his too as a matter of fact his attorney Hugh you don't have to do this and since John is no longer here I've undertaken to look after some of the problems he left behind him as an old friend would Elizabeth say good night to mr. Dollar now look here. You know night to him. He's just leaving Maybe it's better right now, Johnny Good night. Do you want me to leave? She just said it would be better. I'll call you at your hotel Good night. Good night Mr. No, no, you still have something in your glass Finish your drink Okay An old friend of John's That's good Very good.  I saw her. I was with her you never knew John Reardon in your life You have no business being here and I don't like cheap opportunists invading her own Evidently you can talk to her anyway you want to and she'll take it why I don't know But don't talk to me that way. I don't have to take anything. You were just leaving Weren't you?  I didn't like him and he didn't like me Expense account item five eighteen dollars even cav fairs lunches, etc in and about Chesapeake Bay talking to the principles Connected with the boat explosion death of John Reardon One of these was Lieutenant Jack Halverson United States Coast Guard You want some coffee if I have to go out in that window get it and all make it right here for just such occasions Just a sec. I'll plug her in There brother someday It's nice in the summertime now. What can I do for you? Tell me about the boat going down You made out the report for the Coast Guard you mean the Sharpsons boat Yeah, we have a reliable witness who thinks that one of the passengers a man named John Reardon didn't go down with it at all that he's Still alive.  Why not the fourth? Why not Reardon's? Well, we searched the bay for solid week looking for his body. We used ever piece of equipment at our disposal We did everything we could but you didn't find him First you come in here complaining about our weather now you're mad about the way we were on the Coast Guard I'm sorry. It's a very lousy sounding apology. What do you want to find out how that boat exploded? Why you couldn't find Reardon's body if you found the others Look if a bunch of rich jerks want to take a high-powered boat out and they don't know the first thing about high-test fuel or engine running They're doing it at their own risk that help. Yes, something. I wish you could have put it on the report That's my ideas buddy. The report just has a fax now for the other about finding Reardon I don't know why he blew up went down or drifted out to see if his body had been in the bay We'd found it. Why is there a chance he might have survived and been rescued all we had left of the boat Was pieces of wreckage and if he was rescued it was never reported and I wouldn't know about that could that have happened sure I Could be an admiral tomorrow It was four o'clock in the afternoon when I got to Elizabeth Reardon's house You hello mr. Brian as Mrs. Reardon in no then I'll wait it's important that I see it I thought I made it clear to you last night I didn't want her being molested you did make it clear and cruel mr. Brian now I'm here any business for her Comes to me first. I'm an insurance investigator. I know that she told me but she didn't tell you because she didn't know and I didn't Wanted to know that I'm working on a case that involves her what I? Have a report that her husband might still be alive Come in mr. Dollar I'll have to admit that you Brian's concern was as genuine as a surprise He led me into the house and we sat at the bar only this time no one had a drink He listened while I told him about the report of Paul Coombs The John Reardon was living in Denver under the name of Frank Bowers Do you think there's any truth to it? It doesn't matter what I think mr. Brian. I have to investigate it Yes, of course, none of you were alive. It would be the best thing in the world What it of course she's been lost without him all these years She needs him mr. Dollar. She always needed him This little bit of drinking has been going on too long these terrible little episodes with one man or another Yes, I mistook you for one of those last night. I apologize for that sincerely Actually mr. Dollar she She's been quite a task Well, maybe I better talk to her now and you have to there's certain information I'd like to get I think she's the only one who can give it to me You'll have to tell her about the report. Yes, and it's probably so much talk Better to give her a terrible kind of hope All right, I'll get her No, you'd better mix one for her. She'll need it Wait a minute. Yeah, I Need vital statistics on reardon pictures handwriting samples everything. Could you help me gather them? I'll do anything.  Dollar. I don't know why I do You don't want to hurt her any more than I do An hour later. I was back in my hotel The next day I had an appointment to meet you Brian and get all the material I had asked for I was more depressed than ever about the case about then the phone Johnny dollar Johnny.  I'm sorry Elizabeth. I have to investigate it. I'm sorry. I don't have any choice Elizabeth Elizabeth there'll be another exciting episode in our story of the Chesapeake fraud matter tomorrow tomorrow a trip to Denver and a look at a man whose gun makes it pretty emphatic that he Doesn't want to be looked at Join us. Won't you yours truly Johnny dollar doors truly Johnny dollars starring Bob Bailey is transcribed in Hollywood Written by John Dawson. It is produced and directed by Jack Johnstone Be sure to join us tomorrow night same time and station for the next exciting episode of yours truly Johnny dollar Roy Rowan speaking


We got a crash in the four man bobsled breakdowns brought to you by seat geek and if you enjoy these videos subscribe to the channel Please that helps me a whole bunch So team Kranz coming to you from Liechtenstein the four man bobsled and look how ready they are look how in sync They are watch this look at the high five breakdown Okay, dude on the left gets a big old high five from the driver Kranz And then he's gonna get the guy in the middle and everything's going well Then he's gonna get the guy on the right This is the best part now the two on the wings they high five each other and then get the guy in the backs back That's perfect. It's beautiful. They're destined for success. They're going to impress They are the Liechtenstein bobsled team team Kranz.  He might not even know he's down a man down a break man So they're just zipping around there disqualified. This is just a fun run Just tossing up in the end zone hoping something happens, but it can't they got DQ This coach is like ah well what are you gonna do and this guy's got to make his way down the hill through the crowd And that's awkward like sign autographs and he's like I'm not in the mood. I fell out the bobsled I'm pretty upset about it. So team Kranz finishes in last place because they got DQ 20th He's like hey man that guy fell out.  He's not here. They're like no Whoa, okay. He's like, uh Okay, I guess he fell out. I didn't push him my bad. Okay. See you later. Bye And yeah, here's what happened the two dudes on the wing were so in sync They got out of sync and his hand goes under the sled. That's Scary Oh on his back hand comes out clean has all his digits hits the wall turns and looks and says Oh, good luck. I'll be up here making my way through the crowd So what I did is I went and I watched every other team enter the sled and I'm becoming a professional bobsled coach or guru I'm going through all the footage. These guys. They're probably not going through the footage like me And I'm saying what can Lichtenstein do different. What did they do wrong? Okay? Something I found was they started getting in the bobsled way earlier than the other teams The other teams ran pretty much down the hill then jumped in Lichtenstein. They got in right away now These are the Germans. They're good. Actually, that's third place Germans. Not that good China that the 10th place this team Look at that driver. They just hop in right away Latvia pretty good though This is the second place team the Germans. They're in this is the first place Germans and they're in kind of late actually so anyway What I'm trying to tell you is I'm an expert Went through everything. I watched them all I compared them side by side I tried to figure out what did the good teams do that Lichtenstein didn't do something I ran into was where do you put your two man? Does he go on the same side as the driver to go the opposite side of the driver the first place team from Germany? Their two man. He's on the other side of the driver. See and he jumps in behind him But that's not what Lichtenstein did. They just battled for it. I don't maybe they didn't even know the other German team second place German team two man on The other side of the driver, so I'm thinking okay. Maybe that's something third place team though Great Britain Hall is the driver their two man is on the same side of the driver So you can have success and do it that way ultimately. I don't know if Lichtenstein They both seem to be competing to be the two man They were so worried about doing the high five and the back five that they forgot to figure out Hey, where do you sit and where do I sit? It's a four-man bobsled So reviewing all the tape comparing them to all the other Teams trying to figure out what could they do better and what could they do not? My biggest piece of advice is that when you jump into the car Don't slip because you're supposed to do that and only touch the side of the the car Once and then your left foot goes in but see his right foot slipped which slowed down as cadence Which means the other dude was now, you know, he was in that guy's time because he slipped so a lot of learning by me I Become somewhat of an expert and slipping while entering the bobsled not good Another important note check out this fan. This breakdown is brought to you by seat geek Thank you to seat geek for sponsoring the breakdown use code at John Boy and you get $20 off your first purchase They got tickets all over they got the best ticketing app and a website and you can buy tickets code John Boy