MySQL: INSERT di un singolo campo recuperato da una SELECT

[Magicale]

INSERT INTO tabella2(field2) SELECT field1 FROM (SELECT field1, COUNT(field1) AS AggrName FROM table1 GROUP BY field1 HAVING AggrName> 10 ORDER BY field1) AS temp_tabella