[link|http://dev.mysql.com/doc/mysql/en/rewriting-subqueries.html|http://dev.mysql.com...g-subqueries.html]