CREATE TRIGGER trigger AFTER INSERT ON table1 BEGIN 
                       INSERT INTO table2( name, top)
                        SELECT name,
                        (select count(*) from table1 b where a.top >= b.top AND name = "NEW.name" ) AS top                    
                        from table1 a WHERE top IN (SELECT top FROM table1 c WHERE c.map = "NEW.name" LIMIT 10) AND name = "NEW.name";
                        END