sql tips: i heard you like queries so i put more queries in your query (aka "subqueries")pic.twitter.com/IOvbrEZkIk
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
A correlated subquery is one that has outer references, i.e. references to table columns from the enclosing query. Often but not always bad, except in the special case of EXISTS which is better thought of as a kind of join.
Once you see how a few of these show up in the execution plan, you just establish a rule to avoid them. Too much rework long term. Just use joins and CTEs.
Used carefully, they can be very effective. (Ditto for lateral joins, which are effectively correlated table subqueries.)
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.