In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.

Engineering teams from Facebook, Google, LinkedIn and Twitter have begun work on WebScaleSQL, an open source project designed to address the challenges of running MySQL at Web scale.