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.

Merging MySQL Tables With phpMyAdmin. PhpMyAdmin is used as the backend database interface for a number of leading content management systems deployed by businesses, including WordPress, Joomla ...

Fastest Way to Check if MYSQL Table Exists in PHP. Dynamic PHP pages give you the option to choose a MySQL table dynamically from which to query. You must ensure that the table exists before ...