12.2.8.7. Correlated Subqueries

A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example:

SELECT * FROM t1 WHERE column1 = ANY
(SELECT column1 FROM t2 WHERE t2.column2 = t1.column2);

Notice that the subquery contains a reference to a column of t1, even though the subquery's FROM clause does not mention a table t1. So, MySQL looks outside the subquery, and finds t1 in the outer query.

VERY useful if say... someone makes a table field an ENUM when it should be another table or individual boolean fields.

MySQL AB :: MySQL 5.0 Reference Manual :: 12.2.8.7 Correlated Subqueries

For almost 200 years, the Seminole Tribe's struggle was simply to survive. Chased by 19th century soldiers into Florida's interior, the Indians battled inhospitable wetlands, poverty, and governmental neglect to gain independence and sovereignty. Now, thanks to casino gambling, the tribe has grown rich. Health care is free, college tuition is covered, and each of the tribe's more than 3,300 members — from infants to seniors — receives monthly dividend checks that add up to about $120,000 a year. The struggle now, say many Seminole leaders, is how to meld the tribe's exploding prosperity into a life that values and preserves their culture.

Dividends get a lot of press, but its important to note that <10% of tribes with casinos give dividends. The main benefit of tribal gaming is to fund tribal governments to provide basic services on the reservation, and through employment (both at the casino and in tribe backed businesses).

A centuries-old struggle for tribal survival has become new challenge in a new century: How to survive success? -- South Florida Sun-Sentinel.com

A three-fin design created by Infinity through a rethinking of the function, size and positioning of the fins. Realizing that you turn a board on the rail, We put the biggest fins on the rail and clustered (aligned) all three fins, focusing them at the pivot point of each rail. The V - bottom gives the board “power steering”. The Cluster makes every other board feel unresponsive.

Floater: We match floatation to your weight and ability in the above models. Not everyone is a light, young surfer: yet big or "matured" guys deserve the best in our shapes with enough thickness.

Surfboards for fat men. I'm going to Hawaii on my honeymoon... twice this year. Thinking of getting one of these and making regular trips to Cocoa Beach/Flagler FL/LA/San Diego/Oahu.

Hey Decius, wanna split a board? These things are like $900.

Infinity Surfboards and Surf Shop - Cluster

Documentary about the real cannonball run.

32 Hours 7 Minutes :: Large Trailer

After 7,700 miles and three attempts to cross the country at warp speed, Captain Roy has experienced something like a Maher mindmeld. As in any marathon, exhaustion and fear make quitting seem smart. You can say you tried, blame the weather, and find a hotel. But breaking a record — any record — takes something more, something personal. Right now, it will take everything. There's no room left for strategy. Roy simply has to hit it hard.

The radar is crazy with bleep! and blatt!, the spreadsheets litter the cockpit like dirty floor mats, but Roy hits it anyway. He doesn't need charts anymore. He is the chart, and Excel and Google Earth and Garmin MapSource and something more, too, a guy with something to prove.

He passes a minivan in the carpool lane at 102 mph and merges onto California's I-10 headed into Los Angeles with blocks of lit towers to the right and oncoming halogens kaleidoscoping his bleary corneas. But Roy sees only the road ahead and the best path through it, the racing line that shaves fat off the hips of the curves as he apexes them at 100 mph, now 117 past Crenshaw Boulevard, La Brea Avenue at 115. The curve and acceleration is a physical sensation in the gut, and now the city is 10 miles out, now 8, and the turbos spool up and kick and Maher says, "Cop! No — taxi!" while Roy hits 117 past Cloverfield Boulevard, peels off on the exit to a light gone green, the next one green — one, two, three more — through the gate of the Santa Monica Pier, where wooden planks rattle beneath the car. The curve and acceleration is a physical sensation in the gut, and now the city is 10 miles out, now 8, and Maher says, "Cop! No — taxi!" while Roy hits 117 past Cloverfield Boulevard, peels off on the exit to a light gone green, the next one green — one, two, three more — through the gate of the Santa Monica Pier, where wooden planks rattle beneath the car. 1

This is one of the best articles I've read in a while.

Gold Star.

The Pedal-to-the-Metal, Totally Illegal, Cross-Country Sprint for Glory

What Frequent-Flier Miles
Really Get You
Our Test of Six Major Airlines
Found Significant Differences
In Seat Cost and Availability
March 6, 2007

Are some airlines more miserly than others when making discounted frequent-flier award seats available? It would appear so.

I recently checked available award seats on 24 routes for various summer and fall 2007 travel dates found that Delta Air Lines Inc. and US Airways Group Inc. often required more miles than other major carriers.

AMR Corp.'s American and UAL Corp.'s United were the most generous, with coach seats available at their lowest award levels on 14 of 24 trips checked. Continental Airlines Inc. and Northwest Airlines Corp. fell in the middle. US Airways, however, offered its lowest-priced award on only two of 24 itineraries; Delta on zero.

The Middle Seat - WSJ.com

JavaScript Popup Boxes

JavaScript Popup Boxes

They set off on “a grand tour of the nuclear-power world, from dust-blown uranium mines to the depths of a pilot facility for Uncle Sam’s waste deposit at Nevada’s Yucca Mountain.” And they come back raving — in favor of nuclear power. The review’s author, Spencer Reiss, sums things up nicely here:

It’s hard not to read Ms. Cravens’s book as a 400-page indictment of the nuclear power industry’s tragicomic inability to tell its own story. Going all the way back to Three Mile Island (1979) and Chernobyl (1986) — disasters that look a lot less disastrous in retrospect, as Ms. Cravens discovers — the industry has swapped missionary zeal for a hair shirt and a defensive crouch.

In other words, even if you end up pro-nuke, you can still find something to blame on nuclear industry. (I have always found this argument shaky, especially when put forth by journalists: that the nuclear industry didn’t tell its own story well. When a besieged industry does “tell its own story well,” it is said to be manipulating the media; and when it doesn’t, it’s not the media that’s at fault, but the industry itself.)

Do Not Read This If You Are Anti-Nuclear Energy - Freakonomics - Opinion - New York Times Blog

At Fruit Towers, the playfully named headquarters of Innocent Drinks in west London, the destruction of the Amazon and the role of the ribeirinhos has not gone unnoticed. One of the company's best-selling fruit smoothies contains a small amount of pulped a�ai (ass-eye-ee), a berry that grows only within 25 yards of the Amazon's banks. To harvest it, the palm on which it grows does not have to be cut down; better still, it thrives in the shade of other rainforest trees such as rubber, Brazil nut, cabbage palm and miriti palm, encouraging growers to mimic nature rather than plant a�ai in endless regimented rows - the kind of monoculture that destroys biodiversity.

'We buy 300 tonnes of frozen pulp a year from our supplier, Sambazon,' says Richard Reed, co-founder of Innocent, 'and we're paying them �1,300 a tonne. That puts about �300,000 a year into those riverbank communities.'

In the Amazon, where 90 per cent of ribeirinho families survive on less than US$4 (�1.90) a day, such shared income goes a long way. What's more, Sambazon guarantees to buy all the a�ai its suppliers produce, eliminating risk to the grower. It calculates the average daily market price, then adds a five per cent premium - which is why Sambazon's pulp (but not Innocent's smoothie) is certified by the US Fair Trade Federation. Sambazon pays cash up-front instead of making farmers wait, and buys direct from the grower to cut out middlemen. Organic, processed in a pristine new factory and fully traceable to the person who grew it, the a�ai used by Sambazon and Innocent typically fetches 44 reais (�12) a sack compared to 15 reais five years ago.

Irrigated twice a day by the tidal waters of the Amazon, the a�ai tree requires little maintenance. Prune it occasionally and keep the grove free of weeds and disease, and it will keep producing fruit - eight to 12 baskets in two hours of picking, from a plot no bigger than a large suburban garden. If managed properly, an acre of rainforest will yield 14 tonnes of berries a year.

It is a high-income, low-impact crop for sure, but that is not the only reason it appears in Innocent's portfolio. A�ai is also the ultimate superfruit, its reddish skin containing anthocyanins (plant chemicals that neutralise the 'free radicals' associated with disease and ageing) and other antioxidants. Weight for weight, a�ai contains 60 per cent more antioxidants than the acclaimed pomegranate, 2.7 times more than blueberries and over six times more than strawberries. Beneath its skin is a yellowish fat, making it rich in calories.

Cold Acai juice is like a fruit smoothy or a chocolate shake... but its better. So much better. Its loaded with fiber and protein so it congeals into... the best dessert I've ever had.

Anyone know where one can get this stuff stateside?

Can the discovery of new fruit used in smoothies save the rainforest? | Food monthly | The Observer

David Rubenstein (a founder of the Carlyle Group) described that time to a convention of pension managers in Los Angeles last year, recalling that Republican fund raiser, Fred Malek approached him and said, "There is a guy who would like to be on the board. He's kind of down on his luck a bit. Needs a job. . . . Needs some board positions." Though Rubenstein didn't think George W. Bush, then in his mid-40's, "added much value," he put him on the Caterair board. "Came to all the meetings," Rubenstein told the conventioneers. "Told a lot of jokes. Not that many clean ones. And after a while I kind of said to him, after about three years: You know, I'm not sure this is really for you. Maybe you should do something else. Because I don't think you're adding that much value to the board. You don't know that much about the company." He said: "Well, I think I'm getting out of this business anyway. And I don't really like it that much. So I'm probably going to resign from the board." And I said "thanks". Didn't think I'd ever see him again.' - New York Times, Ron Suskind, Without A Doubt, 17 October 2004.

...

Caterair - Wikipedia, the free encyclopedia