Cte World Puns

There wasn't a spate of really bad head injuries, they weren't shamed into acting by an outraged public... they found out that bonks on your head are worse than anyone thought and they did what you'd expect: hired independent experts, formed committees, worked with players unions, then instituted new laws, guidelines, penalties, and a GOLBAL education programme to back it up.

If the NFL were to ever do similarly, it's hard to see them coming back with anything more comprehensive....

As someone who's played both sports, it really makes me wonder why this is beyond the realm of the NFL or fundamentally incompatible with the nature of American Football.

From the press release back in 2016:

###Global education programme

World Rugby will support this initiative with a global awareness and education programme aimed at:

• Reinforcing the zero-tolerance culture regarding head contact in the game at all levels using practical advice and visual educational materials
• Educating that illegal tackles are not necessarily defined by where they start as they can slip up from a legal position to make contact with the neck/head
• Educating that "bent at the waist” while tackling and entering into contact is the optimal position for injury prevention
• Promoting best-possible technique to protect the head – expert advice will be obtained from elite defence coaches to identify the best tackle technique and the best impact position for the ball-carrier, including guidelines on double and treble tackling.

From 3 January, two new categories of dangerous tackles will carry penalty offences to deter and eradicate high tackles:

###Reckless tackle A player is deemed to have made reckless contact during a tackle or attempted tackle or during other phases of the game if in making contact, the player knew or should have known that there was a risk of making contact with the head of an opponent, but did so anyway. This sanction applies even if the tackle starts below the line of the shoulders. This type of contact also applies to grabbing and rolling or twisting around the head/neck area even if the contact starts below the line of the shoulders.

Minimum sanction: Yellow card.
Maximum sanction: Red card

###Accidental tackle When making contact with another player during a tackle or attempted tackle or during other phases of the game, if a player makes accidental contact with an opponent's head, either directly or where

tldr; Are there any advantages of subqueries that I am missing out on by relying on CTEs so heavily? For example, are subqueries more efficient than CTEs?

I've been learning SQL over the past two months and practicing on baseball data, and have found myself relying heavily on CTEs when needing to transform data (i.e. aggregates of aggregates, filtering results of window functions, lazy and don't want to rewrite the same complex formula multiple times).

I realize that many problems I am solving with CTEs could also be solved using subqueries, but my brain simply understands CTEs much better in terms of logical flow of the reading the query.

My question: Are there any advantages of subqueries that I am missing out on by relying on CTEs so heavily? For example, are subqueries more efficient than CTEs?

Here is an example from a problem I recently was working through:

------

CTE1:

- Prep table with joins, formula's I don't want to rewrite, and filters to reduce row count and create sample population of data.

- Assign row count to remaining data using ROW().

CTE2:

- Use LAG() to return element in preceding row in sample population (context was determining if Baseball player changed teams).

CTE3:

- Use WHERE clause to filter onto data where element about data changes between current row and previous row.

------

Is the above a good use of CTEs? Or am I being overly reliant and lazy?

sparring in striking can be done at 100 percent intensity. Is it better than grappling now?

I know a lot of people vehemently defend the NFL by trying to discredit Dr. Omalu and all he has discovered about the effects of concussions on the brain. But no matter how much of an NFL fan you are, at some point you have to admit that football is extremely dangerous given the information we now have. Omalu and his team have studied the brains of every former NFL player, along with athletes from other sports, that have committed suicide in recent years and every single one of them had evidence of CTE. He also tested as accurately as can be done on living specimens, vast numbers of current and former football players. Over 90% had shown symptoms of the degenerative brain disease. Yet, there are still a large number of people that lash out in a display of irrational anger a la cognitive dissonance at the very mention of the disease or Dr. Omalu. Omalu came to this country as s highly accredited neurosurgeon and was black listed and made into a pariah by the NFL for simply trying to save America's favorite athletes from a horrible demise. They called him a witch doctor because he's from Nigeria, along with the majority of the American medical establishment, who was just butthurt that an African doctor discovered something that they hadn't.

I'm sorry if there's more people that now feel the same as me about this topic, but as far as I know, it's still a pretty unpopular opinion in America. But to those who disagree with me, just ask yourself one thing. Even if you don't believe CTE to be real for a fact, are you still willing to take the chance that it is and that your kids will take their own lives at a young age because they couldn't take any more of the mental anguish and confusion they feel? Even Mike Ditka has came out and said that if he had school age children with what he knows now, there's no way he would let them play football.

I have been hearing a lot about CTE and other discorders caused by repeated concussions in athletes (particularly boxing, wrestling, and football). I been wondering, do we know if these disorders were common in the ancient-medevial world as well? I do know that a weapon like the mace (or techniques like half swording) got around thick helmets and armor by using blunt force trauma, particularly against the head. So, since people were slamming heavy metal weapons against each other's skulls with the intent to kill the oppositiong, was long term head trauma disorders common?

Im currently rewatching Dark Waters (2020) and i believe that more and more people should watch it as its such an important story that i feel like i dont hear enough about.

For those who havent seen it, its about Rob Bilott who was a lawyer who used to defend chemical companies until he was brought on to defend a farmer called Wilbur Tennant.

Without spoiling it too much its about Dupont who make Teflon were poisioning locals by dumping hazardous material and that there products were dangerous

I think its an important story of corruption and a person willing to stand up against it. I also think its important to shine a light on Ron Bilott and the work he has done to fight for this.

What films based on true stories do you believe are important to be shared and seen.

Edit 1: Oh i also wanted to mention official secrets which again very interesting and important story of Katharine Gun

I think the folks who read this will be like yeah duh this is the point of this sub, but hear me out.

I have a BS in environmental policy and a MS in sustainability management. In my undergraduate years, I had the typical awakening that I think most college kids have where they learn how the world truly works. What left the strongest impression on me was the relentless ecological damage humans have done, climate change, mistreatment of humans and animals, waste, corporate greed, and financial gain at all costs. I came all the way from an idealist/activist person working at a nonprofit, to getting a MS to understand business management so I can one day help the private sector reduce their negative environmental and social impacts. Still job hunting 1 year later...

I now think of all manufactured objects and buildings through a life cycle assessment lens. All the energy, water, materials, and waste that have gone into providing goods and services. Was this good or service provided to me in the most sustainable way? Am I supporting unethical treatment of workers? A bad company? A corrupt CEO? How much of the natural landscape and ocean was impacted by this supply chain? What happens when it breaks, can I repair it or do I send it to the landfill for eternity? Will it actually be recycled?

As a result I've become so anti-consumption I have a hard time accepting gifts, and feel like I'm hurting people when I tell them not to get me gifts. I get depressed and cynical when I see ads on tv for anything you're meant to buy. I hate receiving free swag from special events or clubs. There are definitely benefits as I don't buy as much stuff, have less clutter, and save money.

But what I didn't expect was that this "awakening" I had in college affected how I view all other industries, institutions, and businesses. Anything mainstream lost its charm and glow, and all that remained was the hollow marketing message trying to sell me on a mood and a lifestyle. Big blockbuster movie with hugely popular actors (e.g. John Wick), mainstream, basic and boring. NFL and NBA games? Mainstream, basic, and boring. Flying to a beach vacation? Crocs? Boozy brunch? Weekend in Vegas? Social media is now well known for being problematic in all kinds of ways, but I was feeling conflicted using Facebook and Instagram back in 2014. Mainstream, basic, and boring. AND bad for your mental health. The same skepticism I had for manufactured goods in terms of their environmental footprint, w

I don't want to step on anybody's toes here, but the amount of non-dad jokes here in this subreddit really annoys me. First of all, dad jokes CAN be NSFW, it clearly says so in the sub rules. Secondly, it doesn't automatically make it a dad joke if it's from a conversation between you and your child. Most importantly, the jokes that your CHILDREN tell YOU are not dad jokes. The point of a dad joke is that it's so cheesy only a dad who's trying to be funny would make such a joke. That's it. They are stupid plays on words, lame puns and so on. There has to be a clever pun or wordplay for it to be considered a dad joke.

Again, to all the fellow dads, I apologise if I'm sounding too harsh. But I just needed to get it off my chest.

The nurse asked the rabbit, “what is your blood type?”

“I am probably a type O” said the rabbit.

Are any Blankies going to root, root root for Home Team, the Happy Madison Netflix sports comedy starring The King of Queens, Deuce Bigalow, and a creepily possessive baby-imprinting werewolf that dropped on Netflix today?

Apparently, it's a hybrid of Bad News Bears and a the real-life "redemption" story of New Orleans Saints football coach Sean Payton, who was suspended from the NFL for a season after it was discovered that his coaches and players were offering cash bounties for injuring players on the opposing team, a pretty horrifying scandal given what we know about CTE that was unimaginatively dubbed 'Bountygate.' Both Payton and Gregg Williams, the coach who orchestrated the scheme, continued coaching in the NFL for years after serving their suspensions, because if you think Hollywood is good at enabling terrible old white dudes (and it is!), just wait'll you get a load of the perpetually upward-failing world of sports.

Reviews are, as would be expected, not good.

I bring this up both for the Jacob/whatever his name was in Abduction of it all (his first movie since 2016!) and because I lamented the death of sports comedies in this sub and I wish to sincerely apologize for my mistake. If any Blankies join the team, please report. I don't think I can do it.

Mentos

(I will see myself out)