insert into spn_prod.staff_executive
SELECT 
    0 as id,
    concat('N',
            if(sss.staff < 10,
                LPAD(sss.staff, 2, '0'),
                sss.staff)) as staff_id,
	ssaw.admin_cat_id as type,
    ssaw.date as year,
	ssaw.ADMIN_WORK as executive
FROM
    spn_staff.adminwork ssaw
        left join
    spn_staff.staff sss ON ssaw.PID = sss.ID