I'm going to leave this unresolved for a day or so to see if anyone else can think of a way to accomplish that (szlamany or bruce, maybe?).
Sorry I can't be of more help as I don't know MySQL. The Insert statement works in SQL Server (including the select count subqueries) so obviously it processes things differently.