UPDATE selectzona SET areaOperativa='10113',dAreaOperativa='REKALDE' WHERE dZonaOperativa='Z.SAN SEBASTIAN';

INSERT INTO selectzona (`ambito`,`dAmbito`,`delegacion`,`dDelegacion`,`zonaOperativa`,`dZonaOperativa`,`areaOperativa`,`dAreaOperativa`,`centro`,`dCentro`,`sociedad`) 
VALUES 
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1680','REKALDE','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1681','MORLANS','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1684','OIARTZUN','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1685','HERNANI','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1686','VILLABONA','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1687','TOLOSA','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1688','ANDOAIN','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1689','OLABERRIA','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10112','IRUN','1690','IRUN','1702'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10117','BAZTAN','1691','ELIZONDO','1704'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10117','BAZTAN','1692','DONEZTEBE','1704'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1694','ERRENTERIA LANDARRI','1701'),
('11','MEMORA','102','NORTE','1013','Z.SAN SEBASTIAN','10113','REKALDE','1695','ZENTOLEN','1701');



// NUEVA ZONA BARCELONA

INSERT INTO selectzona (`ambito`,`dAmbito`,`delegacion`,`dDelegacion`,`zonaOperativa`,`dZonaOperativa`,`areaOperativa`,`dAreaOperativa`,`centro`,`dCentro`,`sociedad`) 
VALUES 
('11','MEMORA','104','SFB','1030','Z.BCN','10031','BCN','6543','Oficina Sabadell','500'),
('11','MEMORA','104','SFB','Z001','BCN+AMB','10031','BCN','6543','Oficina Sabadell','500'),
('11','MEMORA','115','ANDALUCIA','1050','Z.SEVILLA','10080','GINES','6008','TANATORIO GINES','500')

// Crear centro desde Frotcom y vincular a Filtro Z.BCN/AMB+BCN/BCN