text:
Tag: defending the air raid
MQ Film Study: Oklahoma vs Alabama (1st Half – 2018)
Let's talk about that dominant first half by the 'Bama defense.
The 2018 Orange Bowl was the most appealing contest of the two playoff games. The matchup put the greatest defensive mind in college football (Saban) with arguably the greatest offensive one (Lincoln Riley). It also had one of the more intriguing QB matchups of the bowl season. The efficiency at which both Heisman Trophy winner Kyler Murray and Heisman runner-up Tua Tagovailoa play it is astonishing. Both are built completely different as well, with Murray listed at 5'10 and Tua 6'1″.
Murray is an absolute legend in the state of Texas, finishing his high school career at 42-0 while competing in the highest division in the state. Tua has become a legend in his own right, taking over for Jalen Hurts in last years Championship Game, and seemingly never looking back. The Tide's offense is just different when he is in the game and has been steamrolling ever since. Overall, the game was a matchup of the two most efficient offenses in the country and one of the best defenses in the country. There was only one thing that didn't fit into the game, Oklahoma's defense, as I pointed out in this pre-game tweet:
One of these is not like the other ⤵
Offense Efficiency: #1⃣ & #2⃣
Defense Efficiency: #1⃣ & #9⃣8⃣#OrangeBowl
— Cody Alexander (@The_Coach_A) December 29, 2018
Alabama's defense has dominated the last decade of college football. Outside of Saban's first year in Tuscaloosa (#36 in Defensive Efficiency), the Tide have been a mainstay in the top 10 defenses in the country. The only outlier being the 2010 team that finished #13 in defensive efficiency. Defensive efficiency is a great way to monitor how well a defense is playing overall because it accounts for every down and judges a defense on whether they stay ahead of the chains. One player that stood out over any during the game was Alabama's interior lineman Quinnen Williams. He consistently was camped in the backfield and early on made it hard for Murray to step up into the pocket. Oklahoma's redshirt freshman Center, Creed Humphrey, played valiantly, but there were multiple times Williams did whatever he wanted and single-handedly blew plays up.
On the other sideline, one could argue, Lincoln Riley is building the Spread of the future. I saw an interview where Bud Foster, long time Defensive Coordinator for Virginia Tech, stated that 12 personnel is the new 21 pers. Except it is much more versatile because of the two TEs. I agree with the 4-2-5 legend. The addition of multiple TEs into the game is something the NFL has been doing since Bill Belichick went to it in early 2000. The major colleges are moving towards it too as defenses are getting "smaller." Hybrid TEs are a completely different animal, and Oklahoma has two of them.
The Sooners offense looked dominant all year, only stumbling to the Texas Longhorns in the annual Red River Rivalry (it's hard to beat a good team twice). Only Army and their slow-paced Option offense were able to keep the vaunted Sooner offense under 30 points. The Iowa State Cyclones and their three-safety Broken Stack were able to even keep Oklahoma under 40 points in Big 12 play. Something no one else did. Needless to say, the offense in Norman was electric all year long. The Sooners based out of 12 personnel for most of the game against the Tide. Riley's combination of Air Raid pass concepts with a power run game has been devastating for defenses. Below is a basic 3×1 look for the Sooners offense, which they ran numerous times versus the Tide defense.
For several years now, Riley has been staying in a 12 pers. look for better parts of most games. This allows the Sooners to have a hybrid TE in #80 Grant Calcaterra (So./6'4″ 220) and a blocking TE in #45 Carson Meier (Sr./6'5″ 254 and is actually listed as a FB). Both can catch the ball, but Riley uses Calcaterra mainly flexed out at WR (what is referred to as a "Joker" TE). Both accumulated over 300+ yards of receiving throughout the 2018 season. By having two larger hybrid players on the field, Riley doesn't have to sub and can use timely tempo to challenge defenses that choose to go small versus the high powered Sooner offense. As stated prior, the Sooners lived in 3×1 for most of the game and mixed in different 2×2 looks as well as some 12 pers. Wing Twin to load the box.
Last year (2017), Riley used two current NFL players in the same way, current Jacksonville FB Dimitri Flowers and Ravens' TE Mark Andrews (who had 500+ yards receiving). This is a trend that is probably not going away. Riley's adaptation of the Air Raid offense to one that has a power run game has paid dividends for the Sooners since his arrival on campus. This year alone, Murray and RB Kennedy Brooks (#26) both had 1,000 yard rushing seasons. Trey Sermon (#4) would accumulate just under 950 yards for himself as well. To see the Oklahoma offense as one that is pass heavy is to miss the mark on what Riley is doing in Norman. In the passing game, Murray threw for over 4,000+ yards and Marquise Brown (#5) and CeeDee Lamb (#2) both had 1,000+ yard seasons. The former in Brown was hurt during the Big 12 Championship and looked off all night against Alabama, being held to ZERO catches on the night.
Limiting Brown (who was averaging over 100+ yards a game) to no production was a coup for the Tide and hindered the Sooners ability to attack through the air early in the game. Riley chose to attack the Tide with multiple 3×1 formations using several different personnel groupings (10/11/12) and moving his "Joker" TE, Calcaterra, around. Lamb would end the night with over 100+ yards receiving, picking on 'Bama's freshman CB in Patrick Surtain II. The Tide would also stifle the Sooners run game, only allowing Murray over 100 yards rushing (Brooks – 35/Sermon – 19). Needless to say, Bama forced Murray to beat them passing, and it paid off in the first half.
Take away the abysmal first quarter for the Sooner offense and the game was evenly matched. A team cannot spot a Saban team 28 points and figure to win the game. This is why the game is played a full 60 minutes! Riley adjusted to the lack of explosion from Brown and a nonexistent run game starting in the second quarter. It was too little too late.
The Sooners couldn't get the stops they needed down the stretch on defense and lost 45-34. Overall, the game was a look into the future. Riley's hybrid Air Raid scheme and Saban's masterclass in adaptability highlighted where football is headed. As I wrote in my latest book, Hybrids: The Making of a Modern Defense, the pendulum is constantly swinging back and forth between offense and defense. As defenses get smaller to counteract the high powered Spread attacks, offenses will eventually get "bigger" to push them around. The Sooners are the epitome of this cat-and-mouse game. The use of two hybrid big-men is evidence that the top offensive minds are beginning to go back to a power game.
The basis of this MQ Film Study is to see how the greatest defensive mind in college football (Saban) chose to attack the vaunted Oklahoma offense (#1 or #2 in O. Eff since 2016). Outside of the first quarter, the Tide really didn't stop the Sooner offense. One thing the Tide did well all night was inhibit the power run game of the Sooners, forcing Murray to do it all by himself. Below is a breakdown of every play the Sooners offense ran during the first half of the Orange Bowl (outside of the last drive of the half). The Orange Bowl was a look into the future of football and how modern defense will defend the "Power" Spread going forward. Continue reading "MQ Film Study: Oklahoma vs Alabama (1st Half – 2018)"
Author MatchQuartersPosted on January 4, 2019 January 4, 2019 Categories Defending the spread, Defensive SchemeTags Alabama, CFP, defending the air raid, Defending the spread, Nick Saban, Oklahoma1 Comment on MQ Film Study: Oklahoma vs Alabama (1st Half – 2018)
Three Coverages Every Quarters Team Needs in Its Toolbox
Go beyond static Quarters and be aggressive in your coverage schemes.
Split-field Quarters is one of the most adaptive and flexible defenses a modern defensive coordinator can base out of. It molds and flexes to fit whatever an offense can throw at it. Offenses can only throw so many different numbers on either side of the center; up to four eligible receivers at the most, and Quarters can adapt to all of them. At the fundamental level, Quarters is based off a numbers system. The corners always relate to #1, the safeties and outside linebackers #2 (bracket), and the Mike always relates to #3. If a player can count to three he can play Quarters.
Utilizing split-field coverages takes the Quarters scheme one step further, creating even more adaptiveness and flexibility. Being able to tag a base defense with small coverage manipulations can transform a static Quarters look into a robber, invert (Sky), or trap coverage. Pressure doesn't always have to be the answer either. The defensive coordinator doesn't have to outsmart his coaching counterpart on the other side of the ball, just the young QB trying to run the offense.
Many coordinators want to focus on pressures as a way to combat offensive schemes. Don Brown, the Defensive Coordinator for the University of Michigan puts the words "Solve your problems with aggression," in his install playbooks. Pressures are a great way to force the issue with offenses, but sometimes a defense needs to sit back and run its base. When sending five or more, a defense loses a man in coverage and can get overexposed or become deficient in a certain zone if the blitz coverage is not structured correctly. On early downs, many top DCs like to sit in their base defense. Being static can have its own set of issues too, but adding coverage tags to change leverage points and run fits can be just as "aggressive" as a pressure and force the QB to beat the defense and not the OC.
Aggression can mean a multitude of different things when it comes to defense. The obvious answer is to blitz, but defenses can manipulate the secondary to be aggressive in their pass distributions and against certain receiving threats. Every offense has counters built into their scheme to take advantage of a defense vacating zones or spinning to single-high. Not every problem can be fixed through blitzing. Sometimes you have to play your base. Below are three ways a split-field Quarters team can tweak their coverage while staying sound and aggressive in nature. You know, Cautious Aggression. Continue reading "Three Coverages Every Quarters Team Needs in Its Toolbox"
Author MatchQuartersPosted on January 2, 2019 January 1, 2019 Categories Defending the spread, Defensive SchemeTags defending 20 personnel, defending the air raid, don brown, quarters coverage, Read Coverage, steal coverage, trap coverage1 Comment on Three Coverages Every Quarters Team Needs in Its Toolbox
MQ Quick Hits Ep. 12 – The 3-Down Dime
MQ breaks down the rising popularity of the 3-Down Dime package found in the Big 12.
The 3-Down Dime package has become an intriguing challenge for Spread offenses and is becoming the way many Big 12 defenses are choosing to defend the high-octane Air Raid offenses seen predominantly in the league (or at least have a package to get into it). MQ breaks down the scheme and helps you understand the HOW and WHY teams around the country are turning to the "Dime" package to defend the Spread. Many Odd Stack disciples will see familiarity in the scheme. If interested in learning more about the scheme, be sure to visit MatchQuarters.com's article on the Iowa St. and Oklahoma St. Air Raid killer defense.
Continue reading "MQ Quick Hits Ep. 12 – The 3-Down Dime"
Author MatchQuartersPosted on September 21, 2018 September 20, 2018 Categories Defensive Scheme, Quick HitsTags 3-down dime, defending the air raid, dime package, installing a dime package, iowa st, Quick HitsLeave a comment on MQ Quick Hits Ep. 12 – The 3-Down Dime
Running Dime as Your Base – A Lesson From the Big 12
Welcome to the Big 12 where Dime has now become your base.
The Big 12 has always been on the outer limits of what coaches are willing to do on offense and a graveyard for "guru" defensive coordinators (just ask Diaz and Strong). Defenses in the Big 12 play more snaps than the average Power 5 defense. Tempo and the Air Raid reign supreme in a league that prides itself on scoring points. The knock on the league has always been the defenses in the conference. To many outsiders, the Big 12 is offense first, and it is, but if you are looking to defend the spread, there is no other place to look – they live with it every day.
If looking at defensive stats alone, the Big 12 is on the outside looking in, but there is something to be learned here. Starting in 2016, teams in the Big 12, primarily Oklahoma St. (2016) and Iowa St. (2017), began using a modified Dime (3-down) and Nickle (4-down) package to combat the Air Raid heavy teams in the league. I discussed in January's article about how teams are becoming more fluid in their fronts; switching from 4-down to 3-down without losing scheme.
The Dime package utilized by Iowa St. in 2017 was no different. Versus a run-heavy Oklahoma team, the Cyclones relied on a modified 4-down defense to defeat the Sooners in Norman. There ability to switch from a 4-down to a 3-down without subbing made the scheme a perfect fit for the multiple Sooners. With a TE like Mark Andrews and an H-back like Dimitri Flowers, the Sooners could give multiple looks without subbing. This fact alone is why the Big 12 is so innovative on defense. Hybrid players are a premium in the league. In Iowa St.'s season finale versus a high-powered spread attack in Memphis, Iowa St. utilized the 3-down version of their hybrid Dime to defeat Memphis 21-20.
The Dime/Nickel hybrid defense has become Iowa St.'s base defense and is fluid between the different front structures. When the Cyclones go 4-down, it is no different than if they are blitzing a linebacker from their Dime package. The coverages are similar too. Here is a look at the two base defenses:
Oklahoma St. Nickel (4-Down)
Cyclone Dime (3-Down)
Continue reading "Running Dime as Your Base – A Lesson From the Big 12"
Author MatchQuartersPosted on March 2, 2018 September 6, 2018 Categories Defending the spread, Defensive SchemeTags 3-3-5, 3-4, 3-4 playbook, 4-2-5, 4-2-5 playbook, 4-3, 4-3 hybrid defense, 4-3 under, air raid, Big 12, cloud coverage, cover 2, defending 10 personnel, defending 11 personnel, defending 12 personnel, defending 20 personnel, defending the air raid, Defending the spread, Defending Trips, dime, dime blitz package, Dime Blitzes, dime package, down and distance, even front, Formation into the boundary, hybrid defenses, installing a dime package, iowa st, jet motion, Matt Campbell, Memphis, mike Gundy, nickel package, Odd front, Odd Stack, Oklahoma, Oklahoma St, Quarters, robber coverage, sky coverage, split field coverage, tampa 2, Tampa Two, texas tech, Under Front, west virginia14 Comments on Running Dime as Your Base – A Lesson From the Big 12
Breaking Down the Run
MatchQuarter's guide to breaking down your opponent's run data.
Of the two play types, breaking down the run concepts is much easier than the pass break down. There is less individual player variance and most run concepts are blocked relatively similar across offensive playbooks. The front of a defense many times will dictate the types of gap and option plays a defense might see. When looking to break down the run it is important for defenses to consider what defensive schemes are showing up in their opponent break down. If the teams in a league or district all run similar defensive schemes then the breakdown will stay relatively true across opponents. It is when teams run different fronts that the run breakdown can give false tendencies. One thing a defensive staff must keep in mind is how offenses change run schemes when facing a four-down front and a three-down front.
In order to keep the breakdown streamlined and efficient, each data point must help the staff paint a clear picture of what the offense is doing. Much like pass concepts, each offensive type (Slot-T, Air Raid, Pro Spread, etc.) has a unique way of blocking traditional runs. Formations add to the variations in blocking schemes as well. For instance, in a two-back power, the offense may choose to "J" block with the H-back and down block with the Tackle, while another offense may insert the H-back as a lead blocker and out-block with the Tackle. Each play is Power, but a defense needs to know the difference in blocking schemes. Luckily, most offenses choose a single blocking scheme and stick with it (therefore, no need to tag the variation), but when doing self-scout, it is important to be able to sort the Powers altogether and the variations between them. Even a play like Counter can be run several different ways from a two-back scheme. Is the offense pulling the Guard and Tackle, or are they using the H-back as the fold player? Add RPOs and a defensive coordinator can have a lot of information on one line. A defensive staff must have a structured, almost scientific, way of breaking down an opponent. Continue reading "Breaking Down the Run"
Author MatchQuartersPosted on February 24, 2017 November 2, 2017 Categories Defending the spread, Defensive Scheme, Opponent BreakdownsTags air raid, arc read, breaking down an opponent, breaking down pass concepts, breaking down run concepts, buck sweep, counter, defending against counter, defending against power, defending option, defending the air raid, defending the slot t, Defending the spread, defending the zone read, defending two-back spread, defensive alignments, four down front, gap play, inside zone, opponent breakdown, outside zone, power, Pro Spread, Pro-Style offense, quick screens, read-arc, RPO, slot-T, split zone, spread offense, three down front, triple option, two back power5 Comments on Breaking Down the Run
Breaking Down the Pass
MatchQuarters guide to breaking down your opponents passing data.
Once the down and distance data (D&D) and formation data are placed into a breakdown, the task turns to breaking down the plays an offense runs. Breaking down the run can be easy as long as the coaches inputting data speak the same language. At the root level, power is a power, a counter is a counter, and a zone is a zone. The biggest task in breaking down the run is if the team is a read/option team and deciding who the conflicted player is (who are they reading). In many cases, especially at the high school level, the plays are basic and can be easily labeled. Pass plays, on the other hand, are a whole different animal.
Unlike run plays that have a base set of rules and can easily be determined, pass concepts can get muddy fast. With so many moving parts and different tags to concepts, it is hard for defensive coaches to look at pass data and not have a convoluted mess. With so many variations within offenses and different tags for certain players, it can make a defensive coordinator feel like he is lost in a sea of data. Add the factor of formations (2×2 versus 3×1 pass can be much different) and it multiplies the problem. Continue reading "Breaking Down the Pass"
Author MatchQuartersPosted on February 17, 2017 December 17, 2017 Categories Defending the spread, Opponent BreakdownsTags breaking down an opponent, counter, defending by formation, defending the air raid, Defending the spread, Defending Trips, down and distance, formation data, formationing your defense, inside zone, opponent breakdown, opponent data, opponent scouting, power4 Comments on Breaking Down the Pass
Steal Coverage to Combat Air Raid Offenses
A "how to" guide to defending the Air Raid's top pass concepts.
With the birth of the Air Raid offense under Hal Mumme and its expansion under Leach, the Air Raid concept has flourished alongside the advancement of the spread in modern football. The Air Raid offense, in particular, is married well with the no-huddle concept and can be run out of multiple formations even with the added effect of tempo. True Air Raid offenses base out of 20, 10, and 11 personnel sets. Many of the concepts needed to run the offense utilize 2×2 and 2×1 sets to put pressure on the defense's back seven.
The Air Raid offense and its vast offshoots still boil down to several basic concepts. The key to any Air Raid offense is the use of "triangle" and simple high-low reads. The offense has been used to rewrite many record books and its concepts are present in most modern spread offenses. The main way Air Raid teams attack a defense is the soft middle of the field left by vertical pushing routes with the outside wide receivers. This vertical push forces the safeties in a two-high look to climb with the outside WRs. The zone dropping linebackers are left to defend WRs coming from the opposite way behind their view. These simple crossing routes are deadly to a defense that cannot get support from the backside safety or simply spot drop. One way a defense can counteract the Air Raids propensity to attack the soft middle vacated by the boundary safety is to run "Steal" coverage.
Steal Coverage
Unlike "Read" Coverage that takes advantage of the offense attacking the front side triangle (think pick/flat/corner), "Steal" coverage uses the boundary safety as a "robber" for the crossing routes. Much like its sister versus Trips coverage "Solo," Steal uses the boundary safety as a spy on a front side WR. The main objective of the DS in Steal is to read the crossing route and hold his ground in the window vacated by the Will LB. The diagram below demonstrates Steal Coverage: Continue reading "Steal Coverage to Combat Air Raid Offenses"
Author MatchQuartersPosted on February 3, 2017 November 2, 2017 Categories Defending the spread, Defensive SchemeTags 2 read, 3rd down, air raid, banjo coverage, cloud coverage, cover 2, dana holgerson, defending 11 personnel, defending 20 personnel, defending the air raid, Defending the spread, defending two-back spread, hal mumme, kliff kingsbury, man coverage, mike leach, Quarters, quarters coverage, Read Coverage, robber coverage, solo coverage, spread offense, steal coverage, texas tech, third down, two read, two-high scheme, washington st, west virginia13 Comments on Steal Coverage to Combat Air Raid Offenses


Don't clam up and simmer in silence when she says something that upsets you. It's possible to let her know what you don't like, and why, without causing major offence.... 8/11/2018 · In this Article: Getting Out Gracefully Moving on Living Life Without Girls Community Q&A 11 References. There are times when you may have been through a lot emotionally, romantically, or spiritually, and you feel that the best thing is to give up on girls and dating, at least for a while.
Don't clam up and simmer in silence when she says something that upsets you. It's possible to let her know what you don't like, and why, without causing major offence. witcher 3 how to get good ending I knew that if I spoke up we would argue, they would get mad at me, and they would not love me. I failed to realize that this was something I only experienced with them. I failed to realize that this was something I only experienced with them.
Love does not exist. Instead there's a cruel, soul-destroying and life-draining nightmare of unending suffering and remorse that is experienced only by MEN at the whim of a WOMAN. Empathy be damned. how to grow garlic from a clove Simply put, there's no reason you can't find the love of your life if you hang in there, keep going, and stay persistent. If you want to dramatically increase your chances of "winning" a wonderful partner, start by deciding to never give up.
Home » Love Quotes For Him • True Love Quotes » Love Quotes to Get Him Back Forever If your boyfriend or husband slipped from your hands and you want to get him back by making some love and romantic environment, quotes and poems are best and easy way to do this.
well that decision is up to you if you feel you can give up on women at that point in your life. I make no effort anymore, if I need to talk to a woman it's purely in a business/platonic way. I no longer feel like I have to be funny or interesting or feel the pressure to ask her out. I spent almost a decade being rejected by women which led me to the point of acceptance.
There is a difference between giving up and knowing when you have had enough. Once you come into terms with this, it's pretty easy to walk away.
I knew that if I spoke up we would argue, they would get mad at me, and they would not love me. I failed to realize that this was something I only experienced with them. I failed to realize that this was something I only experienced with them.


text:
Let's Dance with Mel B Trophy Guide
Let's Dance with Mel B Trophy Guide. Difficulty: *** A competitive dance game which utilizes the PlayStation Move controller and hosted by Melanie Brown. Getting A+ scores, which are requires for the Platinum, can be challenging with the poor accuracy detection.
Let's Dance with Mel B *** 35 Lightning Fish U.K. 21 8 5 0 0
Let's Dance with Mel B
Let's Dance with Mel B is a competitive dance game which utilizes the PlayStation Move controller. Possessing a number of popular tracks that range from 1980's to current, up to 8 players can compete in a dance off, with Mel B demonstrating the required dance moves. The game includes solo, competitive, and co-op dancing, as well as different modes of difficulty.
Overall, Let's Dance with Mel B received low scores from the few online magazines which reviews the game, criticized for the lack of tutorials, variety in game modes, and poor accuracy detection.
The difficulty for the Platinum lies not so much in the game itself, but the accuracy of having your dance moves detected. This can be a problem when several trophies require you to receive an A+ rating on the songs. But with enough practice, luck with the camera, and patience, the Platinum can be unlocked.
Expect roughly 30 hours of gameplay if you're having good luck with the accuracy detection, and more if you're not.
NOTE: You will need 2 Move controllers for the Platinum.
This game doesn't require much of a roadmap, as you'll basically want to dance through each of the tracks, working towards achieving an A+ rating on each. We recommend simply going through song after song, until you've completed all the tracks and unlocked the Let's Dance trophy, with several others along the way. After that, head back into the songs you couldn't achieve an A+ rating, and work on those until you do.
At some point, you'll need to invite a friend over to help you with the co-op and competitive trophies. Here is where you'll need two Move controllers. Luckily, since the game only supports two players at a time, that's all you'll need to complete the eight player dance party game for the Pieces of 8 trophy.
For the Dance The Night Away trophy, you can easily adjust the clock on your PS3 to a time between midnight and 6am.
Where there seems to be no trophy guides online, here's a Forum on PlaystationTrophies were you can try posting any questions you may have:
http://www.playstationtrophies.org/forum/forumdisplay.php?f=1324
This is a Track List for the game:
http://www.trueachievements.com/n3665/lets-dance-with-mel-b-track-list-revealed.htm
And here's a basic Trophy List:
http://psnprofiles.com/trophies/1006-Lets-Dance-with-Mel-B
Categories: PS3 DatabaseTags: Let's Dance with Mel B, Lightning Fish

redpajama_set_name: RedPajamaCommonCrawl


WireNine offers hosting packages optimized for businesses and WordPress users, as well as Reseller and VPS hosting plans. Many of their plans come with 24/7 friendly support, daily backups, 100% uptime guarantee, and $100 in Google AdWords credit. WireNine also uses cPanel, giving you access to hundreds of hosting applications like Magento, Zen Cart, Drupal, and more.
Note: WHdb.com is funded with the help of our visitors. We receive a small commission fee when a user signs up for hosting at no additional cost to our visitors. All information on this website, including prices, is intended to be informational only.


text:
Q: MYSQL Concat not working
UPDATE profile SET
  favourties=CONCAT(favourties,"123")
  WHERE id=1

i want to append 123 in favourties but if default value of favourties is set to NULL then this query will not work. What will be query if favourties is set to NULL and then append 123 with it

A: UPDATE profile SET favourties=CONCAT(IFNULL(favourties, ''),"123") WHERE id=1

A: Wrap the field around with the COALESCE function:
UPDATE profile
SET favourties = CONCAT(COALESCE(favourties, ''),"123")
WHERE id=1

A: You probably can't concatenate something to NULL. Maybe you can use coalesce?
UPDATE profile SET favourties=CONCAT(COALESCE(favourites,""),"123") WHERE id=1

see: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_coalesce
You can use ifnull like @zerkms says, but that is not in the SQL standard. It is a tiny tad faster though. Read up on it at this link: http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/performance-isnull-vs-coalesce.aspx

A: You can also use CONCAT_WS() (docs) which deals with NULLs as you would expect: converts them to an empty string:
UPDATE profile SET favourties = CONCAT_WS('', favourties, "123") WHERE id = 1;

I personally actually only use CONCAT_WS() now because having to worry about NULLs annoys me. I rarely use NULLs so I don't have to worry about it, but just incase. It's just an annoying thing to figure out why you you're ending up with an empty string when it just doesn't seem to make sense.

A: In PHP, I use:
SET `trans`=concat('$var', trans)

to add to a string already in the trans column.
It wouldn't work on column named group without using back ticked group inside the brackets as well, whereas with trans, back ticks were not needed.

redpajama_set_name: RedPajamaStackExchange


The Quinta Mamba 2016 is a Ribera made with 100% grape Tempranillo from the vineyards of La Horra-Burgos, with 5 months of rest in American oak barrels that bring elegance and complexity.
A wine that combines elegance and modernity, with elements of the past and the future of Ribera del Duero wines. The past is a tradition and know-how unique in the world, combined with an exceptional quality of the grape, and the future is a casual and cheerful wine to drink at any time.
View: Vivid color, intense and clean simple view. A dense wine with a cheerful reddish color and a violet meniscus, with a bright tear.
Nose: Fresh fruit, with a reminder of red fruits and the forest, with a slight vanilla taste due to its aging in oak barrels.
Mouth: They dominate the fruits of the forest that release in the retronasal all their potential, fresh wine with soft and very balanced tannins, long aftertaste and permanence in the mouth.


text:
Hiding In Plain Sight: The Story Of A Milwaukee Sex Trafficking Survivor
By Maayan Silver • Apr 17, 2019
Cincinart/stock.adobe.com
WUWM's Maayan Silver speaks with "Michelle," a sex trafficking survivor.
Michelle is a sex trafficking survivor. She says it was a milestone when she started sharing her experiences. "For a long time, due to the fear of being discriminated against and preconceived notions of what it is to be trafficked, I was really too afraid to step out and tell people," says Michelle, who's originally from Milwaukee.
It's important to note that Michelle isn't the woman's real name, but we're using it to protect her identity. Also, Lotus Legal Clinic connected us with her and vouches for her story.
People who fall prey to sex traffickers span all ages and genders. They include all racial and ethnic backgrounds and sexual orientations and identities. But they tend to have one thing in common: a vulnerability that a trafficker can exploit.
READ: Sex Trafficking Is 'A Crime That Doesn't Discriminate'
Michelle was trafficked from the ages of 19-24 — first from Milwaukee to Chicago, then out west, before she was able to find her way home. And Michelle says two things set her up to be trafficked at 19.
"I think that desire to be loved because I kept feeling like I was unloved in so many different areas of my life. And then that desire to have the material things that I saw some of the other youth around me having that I associated with success and popularity," she explains.
And one seemingly normal day changed Michelle's life forever. She was walking to a bus stop from a friend's house on the near west side, and a stranger drove up to her and offered her a ride. At that time, she says she was very depressed because of a recent break-up, and she was impulsive.
"I said, 'Yeah, sure,' that way I don't have to get on the bus. And in the meantime, he engages me in this conversation. He's very nice, very friendly, very reassuring, laughing, joking. Immediate comfort happens there," Michelle says.
She left with the impression that this was a very nice guy.
In a short span of time, he took her to meet young women he called "wife-in-laws," and she moved in with them.
He promised her affection and comfort, she says and told her all she had to do was be loyal.
"After a few days, he introduces the idea of, 'You can have the world at your fingertips, and all you have to do is have sex for money.' So, then he takes me to Chicago, and I turn my first trick there. I make $200, and to me, $200 is like 'Wow, this is a ton of money.' "
But she didn't get the money. The trafficker got the money — and the women she was living with told her that was how things worked.
"And by them reassuring me that, 'Hey, this is OK, this is how we live, and it's us against the world.' I'm thinking it's a very OK thing," Michelle explains.
"After a few days, he introduces the idea of, 'You can have the world at your fingertips, and all you have to do is have sex for money.' "
Not long after, the trafficker took her to work in Nevada. She ended up being trafficked by someone else in that state.
Michelle says he occasionally gave her gifts, but he was also very violent.
"In my personal situation anyway, he might give me a gift very few and far between many beatings — bad beatings, beatings that let me know that I could potentially be killed by him if I didn't confer to what he wanted me to do," says Michelle.
One beating was particularly harsh.
"I can remember one beating that was so bad, both of my eyes — I don't know if you've seen anybody's eyes bleed — but my eyes, both of them, literally bled," she says.
A couple of days later, the trafficker had her back out selling her body.
"I'm out there, and I look … and anybody with any sense would've been like, 'Call 911 for this girl because this girl is in a very bad way,' " Michelle says.
"Anybody with any sense would've been like, 'Call 911 for this girl because this girl is in a very bad way.' "
Despite her injuries, she says johns still paid for sex acts.
Meanwhile, Michelle feared for her life because of her trafficker's violence.
"He is going to kill you one day, and he is not going to care. And your family is not going to know what happened to you," she recalls thinking.
But one day Michelle fought back. After fighting her way out of a car, she ran to a nearby hotel and told a security guard she needed help. She was able to get in touch with her family and fly back to Milwaukee.
It's been seven years since her escape from the life.
She says she's had to fight criminal charges of prostitution and related crimes, spending years to get them vacated. While the people that trafficked her — as far as she knows — never faced charges.
Michelle went back to school, earning a college degree.
And she's seen a therapist. She says it was important to find someone who understood trafficking, to address PTSD and mental health needs.
"What I've learned, and what's been absolutely beautiful for me, is understanding that I can either live in conflict with my past or I can reconcile my past to my present," Michelle says.
One way she's reconciling her past with her present is by working with organizations that help other survivors of trafficking.
Editor's note: This is the second story in our series on sex trafficking. On Thursday, we'll explore organizations that help survivors of sex trafficking.
Sex Trafficking In Milwaukee: 'A Crime That Doesn't Discriminate'
By Maayan Silver & Lauren Sigfusson • Apr 16, 2019
AtjananC./stock.adobe.com
Milwaukee has a reputation as a hub for sex trafficking. So, what is it? Who is it affecting? What are the numbers?
Here's a primer on what the crime looks like here in Milwaukee.
Sex traffickers get an adult to exchange sex for money through force, fraud or coercion. But it's also considered trafficking to have a child exchange sex for money, under any circumstance.
Traffickers may separate victims from family, control their lives and even move them from one city to another.
Milwaukee Activists Aim For 'Circle Of Support' Around Sex Trafficking Survivors
Maayan Silver
Near Washington Park on Milwaukee's west side, Nancy Yarbrough runs the Humble Beginnings organization for women facing domestic violence, drug addiction or sex trafficking.
In homage to Jeffrey, a 17-year-old boy who lost his life to human trafficking, the organization gives away fleece blankets to victims and others who need help. Yarbrough says the blankets were hand-sewn and donated by a 15-year-old girl from Tomah.
What's Happening With Human Trafficking Legislation In Wisconsin?
Lacey's Hope Project
Sex trafficking has been reported in all 72 counties across Wisconsin — earning the state a reputation as a hub for the crime. Some elected officials are working to end the problem.
State lawmakers have considered a number of bills in recent years in an effort to toughen laws pertaining to sex trafficking. Federal and state law defines the crime as the use of force, fraud or coercion to compel someone to have sex for money.
'The Slave Across The Street': How Human Trafficking Is Hidden In Plain Sight
By Audrey Nowakowski • Mar 18, 2019
yupachingping / stock.adobe.com
There are more than 40 million victims of human trafficking around the world, according to statistics from the International Labour Organization. The group says 25 percent are children, and 75 percent are women and girls. It's a multi-billion dollar industry that enriches the perpetrators through the sexual slavery of their victims.
Noticing Risk Factors, Signs Of Sex Trafficking In Wisconsin & Beyond
For the past week, WUWM has been reporting on sex trafficking — what it is, who's affected, and how activists and


text:
Q: need to fix ValueError: I/O operation on closed file Hi I keep getting this error when I run this function in my main code. It's supposed to take the row and columns that have a @ as a value and dump them into a file. I keep getting the error: ValueError: I/O operation on closed file.
def savePattern(Gen):
    file = open("SavedFile.txt", "r+")
    file.truncate(0)
    file.close()
    print("Pattern has been saved in SavedFile.txt!")
    for row, index in enumerate(Gen):
        for col, indices in enumerate(index):
            if "@" in indices:
                import sys
                sys.stdout = open("SavedFile.txt", "a")
                print(row, col)
                sys.stdout.close()

Any suggestion on how to fix this helps. Thanks


SEMINOLE COUNTY, Fla. (Dec. 27, 2016) – Orlando North, Seminole County Sports Tourism, Central Florida Sports Commission, Orlando City Youth Soccer, and Elite Clubs National League (ECNL) announced today that a new three-year agreement has been signed between the organizations for the ECNL National Event to remain in Seminole County from 2017-2019. It was also announced that the parties will be expanding their relationship by adding the inaugural Boys ECNL National Event in January, 2018. ECNL is hosting its' National Event in Sanford this week for the seventh consecutive year.


text:
Q: Improve speed of pandas rolling apply I'm trying to improve the runtime speed of pandas rolling apply. My input dataframe is pretty big [df.shape=(257,2000000)] so I'm getting runtimes on the order of a number of days, which is unacceptable.
Here's my function:
def rolling_grad(y):
    model = stats.linregress(np.arange(len(y)), y)
    return model[0]

That applies over every column in the df:
grad = df.rolling(30).apply(rolling_grad)

Essentially I'm after the slope in rolling windows of size 30 for each column. I've tried using swifter and pandarallel with no luck.
Any help/advice very much appreciated.
Thanks!