I doubt it's the same pop-up. This one specifically states: 'Based on your update settings you're scheduled to upgrade on ...'. Just closing the pop-up wouldn't change this fact.
Can't really empathise with people complaining about this.
I'm not sure what you mean, but the parent's SQL is valid and returns the same data as the gp's, only in a more efficient manner. No need to do three inner joins when you can get away with one.
In fact, you can take out the second part of the inner join condition and move it in the where clause, like this (execution plan will stay the same):
SELECT posts.* FROM posts
INNER JOIN post_tags pt ON pt.post_id = posts.id
WHERE posts.author IN ('Joe', 'Jane') AND pt.tag IN ('foo', 'bar', 'baz')
ORDER BY post_date DESC;
It's pretty straightforward to check if there are people in your TV box or not. Doesn't sound like a reasonable (or valid) position.
What about Santa or the Spaghetti Monster? Do we have to be (or claim to be) agnostics about everything we can't prove it doesn't exist? There's no need to prove these things because there's no good reason to believe otherwise. And no, just feeling you're right and visions don't count.
TLDR: Burden of proof is on religious people, not on atheists. Thus, agnosticism seems like an unnecessary compromise.