For one, you don't edit the news. You relay the facts as is.

They did. The relayed fact was both correct and relevant. All this noise is about choosing one fact over the other when both could not be picked.

How about instead of trying to spin it one way or the other, try publishing the facts.

The facts of what? "Intoxicated man takes a taxi, family of four gets home safe and sound"?

Worse than that. It's like Brave New World news. The only things fit to publish are the things that keep us happy(and thus amendable to advertisements in this case). It's not trying to make on specific entity look good, it's trying to engage in actual mind control via selection bias.

Ironically, this might actually end up giving a more accurate picture of the world, because disasters and scandals tend to be big and flashy, while good news come as constant stream of small things. Overall, the stream drowns out the flames - our civilization would had never gotten off the ground otherwise - but it's the odd flame that becomes ever so more newsworthy by its very rareness.

Politics of fear are based on and enabled by this very phenomenom, and we've all seen them cause completely irrational - and often very destructive - decisions. So feel-good popular newsfeed could very well end up undermining demagogues by acting as counterpoison to fearmongering.

Is there a threat (even a theoretical one) of the server going into an infinite loop based upon what you're doing?
It may be that the database engine requires the subquery to break the possibility of a cycle in the code, and sequence the computation.

Take a couple pilz and call me in the morning.

Why didn't I think of that.... penal colony for illegal immigrants involving long term imprisonment and hard labor.

Does a private prison company gaining sentience and posting on Slashdot count as AI, some kind of group mind or just a regular evil overlord?

Nature -- specifically evolution -- disagrees.

Evolution doesn't deal with life or death, it deals with the relative abundance of properties in populations. If anything, our innovation - cultural evolution - is such success precisely because it removes death from the equation. Now the main thrust is on the evolution of our various superorganisms - cultures - rather than our bodies, thus allowing adaptation at blitzkrieg speeds compared to even bacteria, much less any other complex organisms.

In other words, even though the statement about cars kill a lot of people is true, the statement does NOT make the cyclist are menace to be false.

"Menace" is a subjective value judgement. "Cars kill a lot of people" does affect "cyclists are a menace" because both are statements about the dangers of various forms of locomotion. Locomotion itself is unavoidable, so the question becomes which form is safest, and "menace" implies cycling is far from it.

All majorities are potential wolves, unless restrained by government limits that are respected. They respect the limits because they know they aren't the only majority.

So why would they be "potential wolves" in the first place, if they understand this?

originally, in the early 80s, 100 percent of all cross-exchange calls were listened to, without warrants. Basically, anything that went beyond a service area.

However, the tech at the time meant that most calls were not recorded, beyond the first few seconds, unless you used a trigger word or were on a list to be recorded.

This did mean no local exchange calls at the time.

Now the five data centers record a lot more than we admit.

And, yes, I said five.

The NSA and the mil intel agencies all run off the non-published "black" budget, which you're not told about.

And you wonder why we're in debt ... it's not welfare checks, it's the stuff you're not allowed to know about that we do each and every day.

Fun fact: You've had all your calls intercepted since at least the early 1980s, America, in violation of the US Constitution.

I can neither confirm nor deny that I have firsthand knowledge of such data collection.

But you see you are in the Windows CE embedded niche. Your vision is clouded.

I'm not in a "windows CE embedded" niche and the grandparent poster is right.

It's not an issue with the target. It's an issue with the platform(s) supported by the development tool vendors and the chip manufacturers.

For instance: With Bluetooth 4.0 / Bluetooth Low Energy (BLE), two of the premier system-on-a-chip product families are from Texas Instruments and Nordic Semiconductors.

TI developed their software in IAR's proprietary development environment and only supports that. Their bluetooth stack is only distributed in object form - for IAR's tools - with a "no reverse engineering" and "no linking to open source (which might force disclosure)". IAR, in turn, doesn't support anything but Windows. (You can't even use Wine: The IAR license manager needs real Windows to install, and the CC Debugger dongle, for burning the chip and necessary for hooking the debugger to the hardware debugging module, keeps important parts of its functionality in a closed-source windows driver.) IAR is about $3,000/seat after the one-month free evaluation (though they also allow a perpetual evaluation that is size-crippled, and too small to run the stack.)

The TI system-on-a-chip comes with some very good and very cheap hardware development platforms. (The CC Debugger dongle, the USB/BLE-radio stick, and the Sensor Tag (a battery-powered BLE device with buttons, magnetometer, gyro, barometer, humidity sensor, ambient temp sensor, and IR remote temp sensor), go for $49 for each of the three kits.) Their source code is free-as-in-beer, even when built into a commercial product, and gives you the whole infrastructure on which to build your app. But if you want to program these chips you either do it on Windows with the pricey IAR tools or build your own toolset and program the "bare metal", discarding ALL TI's code and writing a radio stack and OS from scratch.

Nordic is similar: Their license lets you reverse-engineer and modify their code (at your own risk). But their development platforms are built by Segger and the Windows-only development kit comes with TWO licenses. The Segger license (under German law), for the burner dongle and other debug infrastruture, not only has a no-reverse-engineering clause but also an anti-compete: Use their tools (even for comparison while developing your own) and you've signed away your right to EVER develop either anything similar or any product that competes with any of theirs.

So until the chip makers wise up (or are out-competed by ones who have), or some open-source people build something from scratch, with no help from them, to support their products, you're either stuck on Windows or stuck violating contracts and coming afoul of the law.

That I'm running a risk with the first of > 800 Model Points, but in my database, I never exceed 80 modelpoints for a given job ID.

But I still don't understand why the subquery is necessary (in some cases).