CREATE table #Obra ([Id_obra] int, [Obra] varchar(30)) ; ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

CREATE table #Obra
    ([Id_obra] int, [Obra] varchar(30))
;
CREATE table #Contato
    ([Id_contato] int, [Id_obra] int, [Id_cargo] varchar(30), [ContatoNome] varchar(120), [DDD] varchar(30), [Telefone] varchar(30), [DDDFax] varchar(30), [FAX] varchar(30),[Email] varchar(255),[Id_empresa] int)
;

INSERT INTO #Contato
     ([Id_contato],[Id_obra],[Id_cargo],[ContatoNome],[DDD],[Telefone],[DDDFax],[FAX],[Email],[id_empresa])

VALUES

(70167,27738,16,'Maria Carolina Sonehara','16','3514-2000','16','3514-2020','carol@enoch.com.br',13900),
(70168,27738,49,'Anderson Micheleto','16','7813-3143','16','3514-2223','anderson@enoch.com.br',13900),
(70169,27738,20,'Mário (Adm)','16','3514-2020','16','3514-2020','',13900),
(70198,27751,16,'Fabrisa Talita de Souza','47','3365-5000','47','3365-5000','fabrisa_g12@hotmail.com',13907),
(70199,27751,49,'Cristian Lins','47','3365-5000','47','3365-5000','ctlins@terra.com.br',13907),
(70200,27751,20,'Fabrisa Talita de Souza','47','3365-5000','47','3365-5000','fabrisa_g12@hotmail.com',13907),
(70341,27774,20,'Juliana Silva (Projetos)','11','3018-6900','11','3018-7680','juliana.silva@cpsa.com.br',13917),
(70353,27783,49,'Engº Hélio Yoshio','44','3226-9422','44','3222-8866','helio@pedrogranado.com.br',13915),
(70354,27783,16,'Everton Ferriolli','44','3222-8866','44','3222-8866','compras@pedrogranado.com.br',13915),
(70355,27783,20,'João de Deus (Almox.)','44','3226-9422','44','3222-8866','engenharia@pedrogranado.com.br',13915),
(70634,27876,16,'Fernando Dias','31','3348-7100','31','3348-7101','fernandod@mrv.com.br',3009),
(70635,27876,21,'Celso Freitas (Coord. Obras)','31','3348-7100','31','3348-7101','celsobh@mrv.com.br',3009),
(70636,27876,20,'Marcus Tomaz (Planejamento)','31','3348-7100','31','3348-7101','marcus.tomaz@mrv.com.br',3009),
(70652,27882,16,'Ronaldo de Castro','48','3028-3151','48','3028-3151','ronaldo@rdlconstrutora.com.br',13944),
(70653,27882,20,'Marlise Régis (Adm.)','48','3028-3151','48','3028-3151','marlise@rdlconstrutora.com.br',13944),
(70654,27882,49,'Bruno Eduardo','48','3028-3151','48','3028-3151','bruno@rdlconstrutora.com.br',13944),
(70853,27957,16,'Alexei Cardoso','11','3147-0000','11','3147-0403','alexeicardoso@trisul-sa.com.br',10099),
(70854,27957,20,'Mariana Costa (Marketing)','11','3147-0000','11','3147-1204','marianacosta@trisul-sa.com.br',10099),
(70855,27957,70,'William Vitor','11','3147-0000','11','3147-0403','williamvitor@trisul-sa.com.br',10099),
(81520,27957,29,'Sérgio Basse','11','3147-0000','11','3147-0403','sergiobasse@trisul-sa.com.br',10099),
(70930,27993,16,'Donizzette Cristiano da Silva','61','3201-0808','61','3031-4835','donizzette@realeng.com.br',2999),
(70931,27993,49,'Alcyr Mello','61','3201-0808','61','3031-4835','alcyr@realeng.com.br',2999),
(70932,27993,20,'Alcyr Mello','61','3201-0808','61','3031-4835','alcyr@realeng.com.br',2999),
(71097,28057,20,'Adácio Carvalho (Diretor Operacional)','21','3891-5306','21','3289-4800','adacio.carvalho@gmail.com',13987),
(71122,28068,16,'Valmiria Souza','11','3018-1900','11','3018-1902','valmiria.souza@cmudar.com.br',6088),
(71123,28068,49,'Aline Franca (Atendimento)','11','3018-1900','11','3018-1902','aline.franca@construtoramudar.com.br',6088),
(71124,28068,20,'Aristel Bento','21','3485-1300','21','3485-1300','',8601),
(71129,28071,20,'Engª Dyane Almeida','79','3236-3220','79','3236-3626','dyane@uniaoconstrucoes.com.br',12840),
(71130,28071,16,'Aldair Nascimento','79','3236-4058','79','3214-2286','nascimento@uniaoconstrucoes.com.br',12840),
(84440,28071,49,'Priscila Minan','79','3236-3220','79','3236-3626','unieng@infonet.com.br',12840),
(71181,28092,16,'Edvaldo Oliveira','86','3216-2400','86','3218-5131','compras@construtorasucesso.com.br',8231),
(71182,28092,20,'Carlos Augusto Daniel Júnior','86','3216-2400','86','3218-5131','daniel@construtorasucesso.com.br',8231),
(71183,28092,49,'Carlos Augusto Daniel Júnior','86','3216-2400','86','3218-5131','daniel@construtorasucesso.com.br',8231),
(71247,28111,20,'Marinaldo Bastos','11','5521-3488','11','5683-2894','marinaldo@zaori.com.br',2324),
(79171,28111,49,'Fabrício Silva','11','4071-2371','11','5521-3488','fabricio@zaori.com.br',2324),
(79172,28111,20,'Fabrício Silva','11','4071-2371','11','5521-3488','fabricio@zaori.com.br',2324),
(71250,28114,20,'Renata Domingues (Setor de Meio Ambiente)','11','3815-0950','11','3815-0950','renata@bioenergy.com.br',8655),
(85683,28114,61,'Tatiane Nakamura','11','3815-0950','11','3815-0950','tatiane@bioenergy.com.br',8655),
(71305,28131,20,'Sabrina Carvalho','11','4301-4684','11','4301-4686','sabrina.carvalho@esbrasa.com.br',14013),
(71306,28131,21,'Pedro Parigot','11','4301-4684','11','4301-4686','sabrina.carvalho@esbrasa.com.br',14013),
(71500,28191,16,'Wellington Alves','31','2128-3700','31','2128-3770','wellington@masb.com.br',14036),
(71501,28191,49,'José Eduardo','31','2128-3700','31','2128-3770','joseeduardo@masb.com.br',14036),
(71502,28191,20,'Tatiana Linses (Relacionamento)','31','2128-3700','31','2128-3770','relacionamento@masb.com.br',14036),
(71503,28192,16,'Wellington Alves','31','2128-3700','31','2128-3770','wellington@masb.com.br',14036),
(71504,28192,20,'Tatiana Linses (Relacionamento)','31','2128-3700','31','2128-3770','relacionamento@masb.com.br',14036),
(71505,28192,21,'José Eduardo','31','2128-3700','31','2128-3770','joseeduardo@masb.com.br',14036),
(71618,28233,16,'Wellington Alves','31','2128-3700','31','2128-3770','wellington@masb.com.br',14036),
(71619,28233,21,'José Eduardo','31','2128-3700','31','2128-3770','joseeduardo@masb.com.br',14036),
(71620,28233,20,'Wellington Alves','31','2128-3700','31','2128-3770','wellington@masb.com.br',14036),
(71621,28234,16,'Wellington Alves','31','2128-3700','31','2128-3770','wellington@masb.com.br',14036),
(71622,28234,21,'José Eduardo','31','2128-3700','31','2128-3770','joseeduardo@masb.com.br',14036),
(71623,28234,20,'Magna Alves (Engenharia)','31','2128-3700','31','2128-3770','magna@masb.com.br',14036),
(71635,28237,16,'Marcelo Gonçalves / Gabriel','31','3503-1855','31','3503-1855','marcelo.goncalves@phvengenharia.com.br',11209),
(71636,28237,20,'Marcelo Gonçalves / Gabriel','31','3503-1855','31','3503-1855','marcelo.goncales@phvengenharia.com.br',11209),
(71637,28237,49,'Damiano Barbosa','31','3503-1855','31','3503-1855','damiano.barbosa@phvengenharia.com.br',11209),
(71638,28238,16,'Marcelo Gonçalves','31','3503-1855','31','3503-1855','marcelo@phvengenharia.com.br',11209),
(71639,28238,49,'A definir','31','3503-1855','31','3503-1855','',11209),
(71640,28238,20,'Hélcio Neves (Licenciamento)','31','3503-1855','31','3503-1855','helcio@phvengenharia.com.br',11209),
(71643,28241,20,'Valdemir Azevedo','87','3221-2000','87','3221-2000','dema@frangonatto.com.br',10726),
(80370,28241,21,'Valdemir Azevedo','87','3221-2000','87','3221-2000','dema@frangonatto.com.br',10726),
(71648,28244,16,'Fernanda Martins','48','3027-2144','48','3027-2140','compras@formacco.com.br',6783),
(71649,28244,49,'Tonio César Bento','48','3234-7949','48','3027-2144','tonio@formacco.com.br',6783),
(71650,28244,20,'Nilo Neto (Almoxarifado)','48','3234-7949','48','3027-2144','nilobn2009@hotmail.com',6783),
(71690,28260,16,'César Miranda','16','3237-5800','16','3237-5800','miranda@construpab.com.br',14065),
(71691,28260,20,'Engº Carlos Rodix','16','7814-0934','16','3237-5800','miranda@construpab.com.br',14065),
(99162,28260,49,'Eng. Carlos Rodix','16','7814-0934','16','3237-5800','engenharia@construpab.com.br',14065),
(71824,28314,20,'Denise Bragantine (Secretária)','21','2546-3675','21','2546-3337','denise@odebrecht.com',14093),
(71825,28314,21,'Dr. Fernando Barbosa (Diretor Superintendente)','21','2546-3675','21','2546-3337','denise@odebrecht.com',14093),
(71836,28316,16,'Amanda Silveiira Costa','81','3465-0095','81','3465-0095','freitas@freitasconstrucoes.com.br',14095),
(71837,28316,49,'Cláudio Freitas','81','3465-0095','81','3465-0095','freitas@freitasconstrucoes.com.br',14095),
(71838,28316,20,'Amanda Silveira Costa','81','3465-0095','81','3465-0095','freitas@freitasconstrucoes.com.br',14095),
(71877,28335,20,'Alixandre Zarifo','11','3309-5008','11','2114-1234','inberrini@barbara.com.br',300),
(78926,28335,16,'Rosana Franco (Suprimentos)','11','2114-1234','11','2114-1235','rosana@barbara.com.br',300),
(78927,28335,49,'Marcos Pugliesi','11','2114-1234','11','2114-1235','inberrini@barbara.com.br',300),
(71897,28343,49,'Guilherme Farnezi','62','4015-1233','62','4015-1233','guilherme.farnezi@granol.com.br',10448),
(71898,28343,20,'Danilo Torres (Engenharia)','18','3529-9200','18','3528-4660','danilo.torres@granol.com.br',6581),
(88245,28343,20,'Guilherme Farnezi','62','4015-1233','62','4015-1233','guilherme.farnezi@granol.com.br',10448),
(71930,28354,16,'José Domingos','11','3018-1900','11','3018-1902','jose.domingos@construtoramudar.com.br',6088),
(71931,28354,49,'Fábio Monteiro','11','3018-1900','11','3018-1902','fabio.monteiro@construtoramudar.com.br',6088),
(71932,28354,20,'Fábio Monteiro','11','3018-1900','11','3018-1902','fabio.monteiro@construtoramudar.com.br',6088),
(71933,28355,16,'Departamento de Compras','19','3512-1832','19','3512-1831','suprimentos@mrv.com.br',4066),
(71934,28355,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(71935,28355,49,'Fábio de Paula / Rodrigo Grazia','19','3512-1800','19','3512-1801','rodrigog@mrv.com.br',4066),
(83359,28355,21,'Fábio de Paula / Rodrigo Grazia','19','3512-1800','19','3512-1801','rodrigog@mrv.com.br',4066),
(71951,28362,16,'Alessandra Grell','11','3127-9200','11','3127-9260','alessandra.grell@br.brookfield.com',430),
(71952,28362,21,'Gabriel Meneguim','11','3127-9200','11','3127-9260','gabriel.meneguim@br.broohfield.com',430),
(83399,28362,20,'Glaudecir Oliveira (Adm.)','11','2268-0597','11','3127-9200','glaudecir.oliveira@br.brookfield.com',430),
(101872,28362,49,'Fernando Luíz Matarazzo','11','2268-0597','11','3127-9200','fernando.matarazzo@br.brookfield.com',430),
(72073,28406,49,'Lorival','11','5070-0500','11','5070-0533','lorival@sivercon.com.br',1068),
(72074,28406,16,'Renan Forster','11','5070-0500','11','5070-0533','renan@sivercon.com.br',1068),
(72075,28406,20,'Renan Forster','11','5070-0500','11','5070-0533','renan@sivercon.com.br',1068),
(72157,28433,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(72214,28450,16,'João Luís / Abraão Jorge','19','3705-2222','19','3705-2222','compras@nogueiraporto.com.br',6327),
(72215,28450,49,'João Luís','19','3705-2222','19','3705-2222','compras@nogueiraporto.com.br',6327),
(72216,28450,20,'Eng. José Carlos Viel','19','3705-2222','19','3705-2222','viel@nogueiraporto.com.br',6327),
(72247,28461,16,'Guilherme Hanke','41','3343-3791','41','3012-9705','guilherme.hanke@mrv.com.br',6793),
(72248,28461,20,'Marco Tavares','41','3012-9129','41','3012-9705','marcotavares@mrv.com.br',6793),
(72249,28461,21,'Marcelo Melo','41','3343-3791','41','3012-9705','marcelomelo@mrv.com.br',6793),
(78975,28473,16,'Juliano Augusto','41','3883-5550','','','juliano.augusto@marza.com.br',14960),
(78976,28473,21,'Rogério Gonçalves (Engenheiro)','41','3883-5550','','','rogerio.goncalves@marza.com.br',14960),
(95070,28473,20,'Juliano Augusto','41','3883-5550','','','juliano.augusto@marza.com.br',14960),
(72324,28485,20,'Luiz Augusto de Oliveira Souza (Ass. Presidência)','65','3322-3090','65','3322-3090','coremat@terra.com.br',14150),
(72325,28486,16,'Guilherme Alexandre Souza','31','3078-8690','31','3078-8600','suprimentos@construtoracastor.com.br',8303),
(72326,28486,49,'Ricardo Gallo','31','3279-1200 - R: 55','31','3078-8688','gallo@construtoracastor.com.br',8303),
(78312,28486,20,'Guilherme Alexandre Souza','31','3279-1200 - R: 55','31','3078-8688','suprimentos@construtoracastor.com.br',8303),
(72512,28549,16,'Kellen Cristina','32','3234-1805','32','3234-6111','comprasggp@hotmail.com',5120),
(72513,28549,49,'Luiz Eduardo','32','3234-1805','32','3257-6111','luizeduardovieiraaraujo@gmail.com',5120),
(72514,28549,20,'Kellen Cristina','32','3234-1805','32','3257-6111','comprasggp@hotmail.com',5120),
(109144,28549,20,'Wanessa','32','3234-1805','32','3257-6111','wanessavieiraaraujo@gmail.com',5120),
(79891,28571,16,'Marcos Antônio','41','3334-1868','41','3334-1868','dartatec@dartaconst.com.br',6435),
(79892,28571,20,'Vinícius Aires (Engenharia)','41','3334-1868','41','3334-1868','dartatec@dartaconst.com.br',6435),
(79893,28571,49,'Valmor José Francioli','41','3334-1868','41','3334-1868','dartatec@dartaconst.com.br',6435),
(72704,28616,20,'Eveliin Andressa','11','3018-4000','11','3018-4001','recepcao@yuny.com.br',10961),
(72795,28645,20,'Valdecir Barbosa (Gerente da Unidade)','31','3597-0290','31','3597-0290','valdecir@expressojavali.com.br',14209),
(72796,28645,21,'Valdecir Barbosa (Gerente da Unidade)','31','3597-0290','31','3597-0290','valdecir@expressojavali.com.br',14209),
(72828,28654,16,'Fabiano Escorel','81','3087-8000','81','3087-8000','compras@mouradubeux.com.br',898),
(72829,28654,49,'Marcos Rezende','81','3325-2465','81','3087-8000','executive@mouradubeux.com.br',898),
(72830,28654,20,'Valter José (Almoxarife)','81','3325-2465','81','3087-8000','executive@mouradubeux.com.br',898),
(72841,28660,20,'Paulo Sérgio','71','3359-2975','71','3359-2975','paulo@mpmempreendimentos.com.br',3185),
(72842,28660,49,'Paulo Sérgio','71','3359-2975','71','3359-2975','paulo@mpmempreendimentos.com.br',3185),
(72843,28660,16,'Bruno Mota','71','3359-2975','71','3359-2975','bruno@mpmempreendimentos.com.br',3185),
(72847,28661,16,'Glaydson Sousa','11','2132-8900','11','2132-8927','glaydson.sousa@rfm.com.br',322),
(107241,28661,20,'Nicolas Dhoye','11','2132-8900','11','2132-8927','Restrito',18421),
(107242,28661,49,'Nicolas Dhoye','11','2132-8900','11','2132-8927','Restrito',18421),
(72849,28663,16,'Carlos Soares de Carvalho','11','2575-7400','11','2575-7404','carlinhos@demoeng.com.br',289),
(72850,28663,20,'Ana Paula Martins (Engenharia)','11','2575-7400','11','2575-7404','a.martins@demoeng.com.br',289),
(72851,28663,70,'Luiz Ricardo Ferreira da Silva','11','2575-7400','11','2575-7404','ricardo@demoeng.com.br',289),
(72974,28715,16,'Samuel Brito','11','3025-9000','11','3025-9217','sbsouza@gafisa.com.br',433),
(72975,28715,20,'Daniele Souza Viana (Secret. Gerentes de Obras)','11','3025-9098','11','3025-9217','telefonista.sp@gafisa.com.br',433),
(93750,28715,49,'Diego Esteves','11','3071-4596','11','3025-9000','desteves@gafisa.com.br',433),
(104029,28715,29,'Thiago Heitor Camargo Faria','11','3025-9098','11','3025-9217','tfaria@gafisa.com.br',433),
(72987,28719,20,'Celso Pinto','46','3524-6060','46','3524-6060','celsopinto@msn.com',11494),
(78161,28719,49,'Celso Pinto','46','3524-6060','46','3524-6060','celsopinto@msn.com',11494),
(78162,28719,16,'Valdir Macagnan','46','3523-4519','46','3523-4519','valdir@empremac.com.br',11493),
(72991,28721,20,'Raquel Silveira (Controladoria)','11','2187-2000 - R. 2297','11','2187-2300','r.kateken@vicunha.com.br',5273),
(73007,28727,16,'Edmar Buzzo','27','3325-6565','27','3325-6565','edmar@vigaconstrutora.com.br',14247),
(73008,28727,21,'Célio Canni','27','3325-6565','27','3325-6565','celio@vigaconstrutora.com.br',14247),
(73009,28727,20,'Guilherme Diaz (Planejamento)','27','3325-6565','27','3325-6565','guilherme@vigaconstrutora.com.br',14247),
(73014,28731,16,'Fábio Monteiro','11','3049-4000','11','3049-4000','fabio.monteiro@citycon.com.br',3200),
(73015,28731,49,'Fábio Monteiro','11','3049-4000','11','3049-4000','fabio.monteiro@citycon.com.br',3200),
(73016,28731,20,'Fábio Monteiro','11','3049-4000','11','3049-4000','fabio.monteiro@citycon.com.br',3200),
(73019,28732,20,'Setor de Licitação','41','3330-3636','41','3330-3636','',463),
(73027,28736,16,'Edmar Buzzo','27','3327-6565','27','3327-6565','edmar@vigaconstrutora.com.br',14247),
(73028,28736,21,'Célio Canni','27','3327-6565','27','3327-6565','celio@vigaconstrutora.com.br',14247),
(73029,28736,20,'Josi Ferreira (Engenharia)','27','3327-6565','27','3327-6565','josi@vigaconstrutora.com.br',14247),
(73042,28740,16,'Edmar Buzzo','27','3327-6565','27','3327-6565','edmar@vigaconstrutora.com.br',14247),
(73043,28740,21,'Célio Canni','27','3327-6565','27','3327-6565','celio@vigaconstrutora.com.br',14247),
(73044,28740,20,'Josi Ferreira (Engenharia)','27','3327-6565','27','3327-6565','josi@vigaconstrutora.com.br',14247),
(79962,28746,20,'Setor de Infraestrutura','22','2761-5296','22','2761-5296','',14252),
(95226,28746,61,'Adriana Alcantara','22','2761-9809','22','2761-5296','',14252),
(95227,28746,49,'Vinícius De Holeben','22','2768-6036 - R. 1143','41','9121-3309','',3159),
(95228,28746,16,'Dimas Gruba','41','3313-8000','41','3313-8001','dimas@dmconstrutora.com.br',3159),
(73066,28749,16,'Alexandre de Lima','83','3246-1616','83','3246-1616','magmatec@magmatec.com.br',14224),
(73067,28749,49,'Carla Silveira','83','3244-3635','83','3246-1616','carlaengenheira@hotmail.com',14224),
(73068,28749,20,'Carla Silveira','83','3244-3635','83','3246-1616','carlaengenheira@hotmail.com',14224),
(73072,28751,16,'Departamento de Compras','11','3025-9000','11','3025-9217','',433),
(73073,28751,20,'Anderson Silva (Assistência Técnica)','11','4002-1001','11','4002-1001','atendimento@gafisa.com.br',433),
(73074,28751,29,'Glaico Araújo','11','3025-9000','11','3025-9111','',433),
(73091,28757,20,'Talita Andrade (licitação )','11','3702-8000','11','3702-8000','licitacoes.internacionais@dersa.sp.gov.br',550),
(98986,28757,67,'Marcelo Barbosa (Divisão de Meio-Ambiente)','11','3702-8000','11','3702-8000','marcelo.barbosa@dersa.sp.gov.br',550),
(73101,28762,16,'Luiz Osmar','31','2519-7907','31','2519-7901','luiz.osmar@construtoradinamo.com.br',13278),
(73102,28762,20,'Matheus Fernandes (Orçamento)','31','3495-4395','31','3495-4395','matheus.fernandes@construtoradinamo.com.br',13278),
(91098,28762,49,'Gisele Silva','31','2519-7900','31','2519-7901','gisele.silva@construtoradinamo.com.br',13278),
(73105,28764,16,'Telma Lima','31','2519-7907','31','2519-7901','telma.lima@construtoradinamo.com.br',13278),
(73106,28764,49,'Antônio Claudio','31','2519-7900','31','2519-7901','antonio.claudio@construtoradinamo.com.br',13278),
(73107,28764,20,'Lorene Paula','31','8421-5477','31','3490-4353','lorene.paula@construtoradinamo.com.br',13278),
(73111,28766,16,'Rafael Soares','11','4332-1960','11','4191-4877','rsoares@mpd.com.br',1432),
(73112,28766,49,'João Carlos','11','4332-1960','11','4191-4877','jcarlos@mpd.com.br',1432),
(82553,28766,20,'Rafael Soares','11','4332-1960','11','4191-4877','rsoares@mpd.com.br',1432),
(73113,28767,20,'Nicole Souza (Atendimento)','17','99134-9178 Obra','11','3137-6969','nlsouza@construcap.com.br',630),
(109674,28767,16,'Marcio Marques Aguiar','17','99134-9178 obra','17','3017-8000','mmaguiar@construcap.com.br',630),
(109677,28767,49,'José Mário Andrade','17','99134-9178 obra','11','3017-8000','mmaguiar@construcap.com.br',630),
(73119,28771,20,'Yuri Dadauto','11','4571-2400','11','3045-9699','ydadauto@alupar.com.br',14263),
(111214,28772,21,'Yuri Dadauto','11','98931-9003','11','4571-2400','ydadauto@alupar.com.br',14263),
(73135,28778,16,'Sérgio Batista','21','3385-3434','21','3385-3434','sergio@grupofaraujo.com.br',13796),
(73136,28778,49,'Marcos de Carvalho Abreu','21','3385-3434','21','3385-3434','',13796),
(73137,28778,20,'Anacleto Cabral','21','3385-3434','21','3385-3434','',13796),
(73139,28779,16,'Maria de Lourdes','11','3025-9000','11','3025-9217','m.fabre@gafisa.com.br',433),
(73140,28779,20,'Wellington Machado (Adm. Obra)','12','3931-8453','11','3025-9000','wmachado@gafisa.com.br',433),
(78441,28779,49,'João Guilherme Siqueira','12','3931-8453','11','3025-9000','obraf400@gafisa.com.br',433),
(76056,28781,16,'Wanderlei Dutra','31','3297-2500','31','2127-4833','wanderlei@construtorasoma.com.br',12147),
(76057,28781,49,'Alexandre Mendes Marques','31','3297-2500','31','2127-4833','ammarques@construtorasoma.com.br',12147),
(76058,28781,20,'Wanderlei Dutra','31','3297-2500','31','2127-4833','wanderlei@construtorasoma.com.br',12147),
(73151,28784,49,'Guilherme Diniz','65','2123-5095','65','2123-5001','guilherme.diniz@mavi.eng.br',14269),
(73152,28784,29,'Júlio César','65','2123-5095','65','2123-5001','julio.barbedo@mavi.eng.br',14269),
(77649,28784,20,'Júlio César','65','2123-5093','65','2123-5001','julio.barbedo@bimetal.eng.br',14269),
(77650,28784,16,'Lígia Polido','65','2123-5063','65','2123-5001','ligia.polido@bimetal.eng.br',14269),
(73158,28787,16,'Vinícius','48','3621-1600','48','3621-1616','compras@camiloeghisi.com.br',8952),
(73159,28787,49,'Daniel Balestrin','48','9995-5161','48','3621-1600','daniel@camiloeghisi.com.br',8952),
(73160,28787,20,'José Fernandes','48','9995-5161','48','3621-1600','compras@camiloeghisi.com.br',8952),
(78478,28787,49,'Leandro Camilo','48','9995-5161','48','3621-1600','leandro@camiloeghisi.com.br',8952),
(73169,28791,16,'Caroline Machado','47','3246-1688','47','3246-1688','caroline@seixasconstrutora.com.br',14270),
(73170,28791,49,'Fabiano Seixas','47','3246-1688','47','3246-1688','fabcivil@terra.com.br',14270),
(73171,28791,20,'Adriana Rich (Atendimento)','47','3246-1688','47','3246-1688','contato@seixasconstrutora.com.br',14270),
(73200,28802,16,'Thales Balbo','16','3512-4500','16','3512-4530','suprimentos.rp@mrv.com.br',4203),
(73201,28802,21,'Ralf Addad e José Márcio','16','3512-4500','16','3512-4530','',4203),
(83268,28802,49,'Ralf Addad e José Márcio','16','3512-4500','16','3512-4530','',4203),
(83269,28802,20,'Ana Paula Passos (Planejamento)','31','3516-4428','31','3348-7101','ana.passos@mrv.com.br',3009),
(73205,28804,16,'Roberto Butura','16','3512-4500','16','3512-4530','suprimentos@mrv.com.br',4203),
(73206,28804,20,'Ricardo Carrenho','16','8144-1454','16','3512-4500','ricardo.carrenho@mrv.com.br',4203),
(73207,28804,21,'Ricardo Carrenho','16','8144-1454','16','3512-4500','ricardo.carrenho@mrv.com.br',4203),
(73208,28805,16,'Roberto Butura','16','3512-4500','16','3512-4530','suprimentos@mrv.com.br',4203),
(73209,28805,20,'Ricardo Carrenho','16','8144-1454','16','3512-4500','ricardo.carrenha@mrv.com.br',4203),
(73210,28805,21,'Ricardo Carrenho','16','8144-1454','16','3512-4500','ricardo.carrenha@mrv.com.br',4203),
(73211,28806,16,'Roberto Burtura','16','3512-4500','16','3512-4530','suprimentos@mrv.com.br',4203),
(73212,28806,20,'Ricardo Carrenho','16','8144-1454','16','3512-4500','ricardo.carrenho@mrv.com.br',4203),
(73213,28806,21,'Ricardo Carrenho','16','8144-1454','16','3512-4500','ricardo.carrenho@mrv.com.br',4203),
(73214,28807,16,'Lurdes','91','3224-9492','91','3224-9492','compras@quantaengenharia.com.br',9400),
(73215,28807,49,'Raphaela de Andrade','91','3222-5542','91','3224-9492','raphaelabemmuyal@hotmail.com',9400),
(73216,28807,20,'Raphaela de Andrade','91','3222-5542','91','3224-9492','raphaelabemmuyal@hotmail.com',9400),
(73219,28809,16,'Enilton Nogueira','11','5573-9511','11','5573-9511','comprasengetal@uol.com.br',2014),
(87404,28809,20,'Evandro Lins dos Santos','11','5573-9511','11','5573-9511','obrasorocaba@yahoo.com.br',2014),
(87405,28809,49,'Evandro Lins dos Santos','11','5573-9511','11','5573-9511','elinsjr@bol.com.br',2014),
(99623,28813,20,'Eduardo Morioka','11','2627-8236','11','2627-8289','emorioka@sp.gov.br',9113),
(73917,28815,20,'Luis Ramos (Arquiteto)','11','3291-4841','11','3291-4843','deurb@prefeitura.sp.gov.br',14366),
(73225,28817,16,'Maria de Lourdes Albuquerque Fabre','11','3025-9000','11','3025-9217','mfabre@gafisa.com.br',433),
(73226,28817,20,'Juliana Morais (Marketing)','21','2101-2700','21','2101-2746','jsmorais@gafisa.com.br',575),
(73227,28817,29,'Carlos André','21','2101-2700','21','2101-2746','',575),
(73235,28821,16,'Dagmar Stevan','47','3323-7000','47','3323-7000','dagmar@batestal.com.br',14276),
(73236,28821,49,'Dagmar Stevan','47','3323-7000','47','3323-7000','dagmar@batestal.com.br',14276),
(73237,28821,20,'Amilton Silveira (Administrativo)','47','3323-7000','47','3323-7000','batestal@batestal.com.br',14276),
(73244,28824,20,'Roberto Barreto (Licitação)','71','3115-2253','71','3115-2151','roberto@derba.ba.gov.br',4764),
(73245,28825,16,'Adriana','11','3287-8000','11','2129-2225','suprimentos@caucaso.com.br',1796),
(73246,28825,20,'Viviane Cristina (Comercial)','11','3287-8000','11','2129-2225','viviane@caucaso.com.br',1796),
(80896,28825,21,'Paulo Eduardo','11','3287-8000','11','2129-2225','caucaso@caucaso.com.br',1796),
(73253,28828,16,'Adriano Ferreira','21','2244-6107','27','3320-7600','adrianogalwan@gmail.com',6547),
(73254,28828,49,'Felipe Bugarim / Vinícius Mota','21','2244-6107','27','3320-7600','ibiscopacabana@gmail.com',6547),
(73255,28828,20,'Vinicius Mata','21','2244-6107','27','3320-7600','ibiscopacabana@gmail.com',6547),
(73267,28835,16,'Carlos Henrique Luiz','48','3241-4100','48','3241-4100','henrique@lumisconstrutora.com.br',5849),
(73268,28835,49,'Evando Wiethorn','48','3241-4100','48','3241-4100','evandro@lumisconstrutora.com.br',5849),
(73269,28835,20,'Cristine Weber (Coord. RH)','48','3241-4100','48','3241-4100','cristine@lumisconstrutora.com.br',5849),
(73282,28840,49,'Sérgio Morais','27','8816-0618','27','3320-7600','sergio@galwan.com.br',6547),
(73283,28840,16,'Celso Cândido da Rocha','27','3320-7600','27','3320-7600','celso.compras@galwan.com.br',6547),
(73284,28840,20,'Sérgio Morais','27','8816-0618','27','3320-7600','sergio@galwan.com.br',6547),
(73295,28848,16,'Conrado Mascarello','49','3323-2002','49','3322-2341','conrado@construtoracatarinense.com.br',14282),
(73296,28848,49,'Josias Antônio Mascarello','49','3323-2002','49','3322-2341','catarinense@construtoracatarinense.com.br',14282),
(73297,28848,20,'Ana (Atendente)','49','3323-2002','49','3322-2341','recepcao@construtoracatarinense.com.br',14282),
(73400,28894,16,'Hilton Carlos','34','3221-7570','34','3221-7580','hilton@britamix.com.br',14304),
(73401,28894,49,'Werley Machado','34','3221-7500','34','3221-7580','werley@britamix.com.br',14304),
(73402,28894,20,'Hilton Carlos','34','3221-7570','34','3221-7580','hilton@britamix.com.br',14304),
(73411,28896,16,'Eduardo Pereira','69','3224-2599','69','3224-2599','eduardo.pereira@welcon.eng.br',12196),
(73412,28896,49,'Gilvan José','69','3223-0197','69','3224-2599','gilvan.jose@welcon.eng.br',12196),
(73413,28896,20,'Gilvan José','69','3223-0197','69','3224-2599','gilvan.jose@welcon.eng.br',12196),
(73416,28900,20,'Ricardo Borenstain (Licitação)','11','4336-9132','11','4336-9133','licitacao.obras@saobernado.sp.gov.br',737),
(73417,28902,16,'Misael Barreto','85','4008-3322','85','4008-3322','misael@marquise.com.br',688),
(73418,28902,49,'Ana Ruth de Souza','85','9172-6111','85','4008-3322','anaruth@construtoramarquise.com.br',688),
(73419,28902,20,'Ana Ruth de Souza','85','9172-6111','85','4008-3322','anaruth@construtoramarquise.com.br',688),
(73440,28911,16,'José Adauto da Silva','43','3372-1480','','','adauto@selmi.com.br',14310),
(109699,28911,20,'José Adauto da Silva','43','3372-1480','','','adauto@selmi.com.br',14310),
(109700,28911,49,'Elias Madi','43','3372-1480','43','9151-5253','adauto@yahoo.com.br',14310),
(73560,28958,16,'Rodrigo Coelho','67','3312-1000','67','3312-1001','ro.coelho@plaenge.com.br',135),
(73561,28958,20,'Marcelo Kenchikoski (Gerente de Obra)','67','3312-1000','67','3312-1001','m.kenchikoski@plaenge.com.br',135),
(84587,28958,49,'Marcelo Kenchikoski (Gerente de Obras)','67','3312-1000','67','3312-1001','m.kenchikoski@plaenge.com.br',135),
(97662,28958,70,'Marcelo Kenchikoski','67','3312-1000','67','3312-1001','m.kenchikoski@plaenge.com.br',135),
(73570,28962,16,'Rodrigo Coelho','67','3312-1000','67','3312-1001','ro.coelho@plaenge.com.br',135),
(73571,28962,20,'Mauro Queiroz (Engenheiro)','67','3312-1000','67','3312-1001','m.queiroz@plaenge.com.br',135),
(73572,28962,49,'Marcelo Kenchikoski (Coordenador)','67','3312-1000','67','3312-1001','m.kenchikoski@plaenge.com.br',135),
(97677,28962,21,'Marcelo Kenchikoski','67','3312-1000','67','3312-1001','m.kenchikoski@plaenge.com.br',135),
(73591,28971,16,'Donizzetti Cristino da Silva','61','3031-4830','61','3031-4835','donizzetti@realeng.com.br',2999),
(73592,28971,20,'João Marquês Neto','61','3568-6993','61','3201-0808','joao.marques.neto@hotmail.com',2999),
(84172,28971,49,'Julio Ribas','61','9699-9206','61','3568-6993','carlison@realeng.com.br',2999),
(73599,28974,16,'Walchir Amaral','37','3229-9634','37','3229-9506','walchir@superabc.com.br',14327),
(73600,28974,49,'Mário Gontijo','37','3229-9634','37','3229-9506','projetos@superabc.com.br',14327),
(73601,28974,20,'Walchir Amaral','37','3229-9634','37','3229-9506','walchir@superabc.com.br',14327),
(73602,28974,7,'Gina Maria Leandro','31','3547-2152','31','3547-2152','gdesigner.bhz@terra.com.br',14326),
(73611,28980,16,'Rodrigo Sabino Fleury','11','3649-9000','11','3649-9000','rodrigo@conspar.com.br',6073),
(73612,28980,49,'Douglas Araújo','11','7859-2585','11','3649-9000','douglas.obras@conspar.com.br',6073),
(73613,28980,20,'Rodrigo Sabino Fleury','11','3649-9000','11','3649-9000','rodrigo@conspar.com.br',6073),
(73614,28981,16,'Eduardo Lira','82','3241-7901','82','3338-2123','pimentelengenharia@hotmail.com',14332),
(73615,28981,49,'Erlon Lira','82','3241-7901','82','3338-2123','pimentelengenharia@hotmail.com',14332),
(73616,28981,20,'Erlon Lira','82','3241-7901','82','3338-2123','pimentelengenharia@hotmail.com',14332),
(73620,28983,16,'Danielle Mendes (Coord. Suprimentos)','21','3724-8100','21','3724-8100','danielle@pdg.com.br',473),
(73621,28983,20,'Luiza Lima (Marketing)','21','3724-8000','21','3724-8100','luiza.lima@pdg.com.br',473),
(73622,28983,29,'José Barreiro Júnior','21','3724-8000','21','3724-8100','jjunior@pdg.com.br',473),
(73632,28988,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(73658,29002,20,'Ricardo Martins (Novos Mercados)','11','4234-9917','11','4234-9671','ricardo.martins@delphi.com',14338),
(73659,29002,21,'Ricardo Martins','11','4234-9917','11','4234-9671','ricardo.martins@delphi.com',14338),
(73672,29007,16,'Advan Benvindo','11','4990-3344','11','4990-3344','compras@bomfimarquitetura.com.br',3162),
(73673,29007,20,'Jaqueline Cristina (Financeiro)','11','4427-8319','11','4990-3344','financeiro@bomfimarquitetura.com.br',3162),
(73674,29007,49,'Eduardo Poleto','11','4427-8319','11','4990-3344','eduardo@arcengenharia.com',2923),
(73684,29011,16,'Edvar Noronha','31','3298-5700','31','3298-5760','supri@paranasa.com.br',4651),
(73685,29011,49,'Patrícia Mendes','31','3298-5700','31','3298-5758','patricia.mendes@paranasa.com.br',4651),
(73686,29011,20,'Charles Gomes (Compras)','31','3298-5700','31','3298-5760','charles.gomes@paranasa.com.br',4651),
(73692,29014,16,'Austry França da Silva','21','3501-4900','21','3501-4800','austryfranca@joaofortes.com.br',839),
(73694,29014,49,'Felipe Paiva','21','2401-0027','21','3501-4900','felipepaiva@joaofortes.com.br',839),
(73695,29014,20,'Roberta Bordalo (Obras)','21','3501-4900','21','3501-4800','robertabordalo@joaofortes.com.br',839),
(73719,29021,16,'Franklin Philipe','31','3281-5566','31','3281-5566','suprimentos@concreto.com.br',3916),
(73720,29021,49,'Francisco Pinheiro','31','3281-5566','31','3281-5566','francisco@concreto.com.br',3916),
(73721,29021,20,'Fernanda Carvalho (Recepção)','31','3281-5566','31','3281-5566','recepcao@concreto.com.br',3916),
(83308,29023,49,'Miguel Matheus','15','3222-6666','15','3222-6666','miguel@jhdconstrucoes.com.br',16954),
(98250,29023,20,'Miguel Matheus','15','3222-6666','15','3222-6666','miguel@jhdconstrucoes.com.br',16954),
(98251,29023,16,'Aparecido Camargo','15','3222-6666','15','3222-6666','aparecido@jhdconstrucoes.com.br',16954),
(73726,29024,16,'Carla Danubia','41','3322-9330','41','3322-9330','compras@construtorabenevento.com.br',13031),
(73727,29024,49,'Ricardo Michelin','41','3322-9330','41','3322-9330','ricardo@construtorabenevento.com.br',13031),
(73728,29024,20,'Carla Danubia','41','3322-9330','41','3322-9330','compras@construtorabenevento.com.br',13031),
(73758,29036,20,'Carlos Belmonte (Tecnologia da Informação)','65','3337-1167','65','3337-1167','carlos.belmonte@mabella.com.br',14351),
(84206,29036,21,'Braz Catoo','65','9615-8028','65','3337-1167','braz.catoo@mabella.com.br',14351),
(73759,29037,20,'Carlos Belmonte (Tecnologia da Informação)','65','3337-1167','65','3337-1167','carlos.belmonte@mabella.com.br',14351),
(84205,29037,21,'Braz Catoo','65','9615-8028','65','3337-1167','braz.catoo@mabella.com.br',14351),
(73769,29040,16,'Cleide Ferreira','12','3882-3585','12','3882-2867','compras@construtoratabapora.com.br',14352),
(73770,29040,49,'Sylvio Ferreira','12','3882-3585','12','3882-2867','sylvio@construtoratabapora.com.br',14352),
(73771,29040,20,'Heraldo Pedroso (Almoxarifado)','12','3882-3585','12','3882-2867','heraldo@construtoratabapora.com.br',14352),
(73773,29041,16,'Raul Marcelo / Leandro','11','4123-6500','11','4123-6500','compras@absolutaconstrutora.com.br',5888),
(73775,29041,49,'Leandro Seguidin','11','4123-6500','11','4123-6500','leandro@absolutaconstrutora.com.br',5888),
(73776,29041,20,'Kerla Amim (Fincanceiro)','11','4123-6500','11','4123-6500','absoluta@absolutaconstrutora.com.br',5888),
(101291,29041,21,'Leandro Seguidin','11','4123-6500','11','4123-6500','leandro@absolutaconstrutora.com.br',5888),
(73777,29042,49,'Eduardo Souza','21','3513-4013','21','3513-4057','',4893),
(73778,29042,16,'Sebastião Giovane','21','3513-4034','21','3513-4057','sebastiaogiovane@mrv.com.br',4893),
(73779,29042,20,'André Magalhães (Planejamento)','21','3513-4013','21','3513-4057','andre.magalhaes@mrv.com.br',4893),
(73780,29042,21,'Ricardo Blaz','21','3513-4013','21','3513-4057','andre.magalhaes@mrv.com.br',4893),
(73783,29044,16,'Lúcio Chaves','15','3232-3000','15','3232-3000','obras@tecbase.com.br',10579),
(73784,29044,49,'A definir','15','3232-3000','15','3232-3000','',10579),
(73786,29044,20,'Paulo (Colaborador de Compras)','15','3232-3000','15','3232-3000','compras@tecbase.com.br',10579),
(91169,29045,15,'Jaime','21','2416-3551','21','2416-3551','jaime@psrio.com.br',5281),
(91170,29045,49,'Gladson Apolinário','21','3289-1300','31','3348-7101','gladson.apolinario@mrlengenharia.com.br',15827),
(91171,29045,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(97639,29045,106,'Gladson Apolinário','21','3289-1300','31','3348-7101','gladson.apolinario@mrlengenharia.com.br',15827),
(73788,29046,16,'Rosa Leite','95','3224-8231','95','3224-8231','rasa@cblokus.com.br',3445),
(73789,29046,49,'José Jair Praciano','95','3224-8231','95','3224-8231','jair@cblokus.com.br',3445),
(73790,29046,20,'Adriana Fernandes','95','3224-8231','95','3224-8231','adriana@cblokus.com.br',3445),
(73796,29048,21,'Carlos Eduardo babo Cardoso (Gerente de projetos)','21','3224-4477','21','3224-4477','',19),
(110015,29048,16,'Luiz Prince','34','3319-8144','','','luiz.prince@toyosetal.com',18227),
(113072,29048,21,'José Renato Nedochetko','11','5525-4834 R.4856','11','5525-4841','jose.nedochetko@toyosetal.com',18227),
(121965,29048,20,'Luiz Prince','34','3319-8144','','','luiz.prince@toyosetal.com',18227),
(73798,29050,20,'Marcela Zago (Comunicação)','11','4341-1966','11','4341-8388','',5806),
(73799,29050,105,'Sra. Tatiana Kitano (Depto Comunicação)','11','4341-1965','11','4341-8388','t.kitano@mangels.com.br',5806),
(73800,29050,2,'Sr. Adelmo Felizati','11','5188-8807','11','5188-0155','',5300),
(73802,29051,16,'Anildo Giuliane','54','3028-2800','54','3223-2800','compras@basincorp.com.br',8387),
(73803,29051,49,'Marcelo Balbinot','54','3028-2800','54','3223-2800','marcelo@basincorp.com.br',8387),
(73804,29051,20,'Anildo Giuliane','54','3028-2800','54','3223-2800','compras@basincorp.com.br',8387),
(87027,29054,16,'Glaydson Souza','21','3289-1300','21','3289-1307','glaydson.souza@mrlengenharia.com.br',15827),
(87028,29054,21,'Engº Ricardo Blás','21','3289-1300','21','3289-1307','ricardo@blasengenharia.com.br',15827),
(87029,29054,20,'Ana Paula Passos (Planejamento)','21','3515-8324','21','3515-8000','ana.passos@mrv.com.br',3009),
(73811,29055,20,'Lucas Fabiano Soares','48','3821-9050','48','3821-9051','fabiano@klokplan.com.br',13989),
(73812,29055,16,'Lucas Fabiano Soares','48','3821-9050','48','3821-9051','fabiano@klokplan.com.br',13989),
(73813,29055,49,'Edvaldo Antônio Klokner (Proprietário)','48','3821-9050','48','3821-9051','',13989),
(73814,29055,7,'Kenia Siemann','48','3821-9050','48','3821-9051','kenia@klokplan.com.br',13989),
(73821,29058,16,'Sheila','82','3357-1271','82','3357-1271','compras.iloa@vivendi-al.com.br',14356),
(73822,29058,49,'Marcelo Melo','82','3357-1271','82','3357-1271','marcelo@vivendi-al.com.br',14356),
(73823,29058,20,'Julio Rocha','82','3272-1840','82','3357-1271','juliorocha@vivendi-al.com.br',14356),
(82651,29060,16,'José Aloísio Pereira','11','3320-3000 - R. 3030','11','3320-3031','aloisio.pereira@tiisa.com.br',15284),
(82652,29060,49,'Ricardo Bellon','11','3320-3000','11','3320-3031','ricardo.bellon@tiisa.com.br',15284),
(96933,29060,20,'José Aloísio Pereira','11','3320-3000 - R. 3030','11','3320-3031','aloisio.pereira@tiisa.com.br',15284),
(73853,29064,16,'Gabriel Leite Brito','54','3022-4300','54','3022-4301','compras@fisaincorporadora.com.br',8386),
(73857,29064,20,'Engº Ismael Monaretto','54','9148-6469','54','3022-4300','ismael@fisaincorporadora.com.br',8386),
(83343,29064,49,'Ismael Monaretto','54','9148-6469','54','3022-4300','ismael@fisaincorporadora.com.br',8386),
(73854,29065,16,'Mary Amorim','82','3131-1505','82','3327-4892','compras@delman.com.br',5791),
(73855,29065,29,'Cristian Marcus','82','3131-1505','82','3131-1414','cristian.marcus@delman.com.br',5791),
(73856,29065,20,'Felipe Bastos (Marketing)','82','3327-4892','82','3327-4892','marketing@delman.com.br',5791),
(73858,29066,16,'Marcos Sérgio','82','3131-1505','82','3327-4892','compras@delman.com.br',5791),
(73859,29066,29,'Cristian Marcus','82','3131-1505','82','3131-1414','cristian.marcus@delman.com.br',5791),
(73860,29066,20,'Felipe Bastos (Marketing)','82','3327-4892','82','3327-4892','marketing@delman.com.br',5791),
(73873,29071,16,'Gleydson Wendell','62','3097-9700','62','3097-9779','gleydson@fgr.com.br',1444),
(73874,29071,49,'Marcelo José','62','3097-9700','62','3097-9779','marcelo@fgr.com.br',1444),
(73875,29071,20,'Alessandra Gomes (Comercial)','62','3097-9700','62','3097-9779','alegomes@fgr.com.br',1444),
(82216,29073,16,'Gisele Machado','41','3018-0458','41','3018-0889','cnmenezes@terra.com.br',14852),
(82217,29073,20,'Luciana Lopes (Comercial)','41','3018-0458','41','3018-0889','cnmenezes@terra.com.br',14852),
(82218,29073,49,'Carlos Menezes Alves','41','3018-0458','41','3018-0889','cnmenezes@terra.com.br',14852),
(73882,29077,21,'José Hasten','31','9626-9598','31','3660-3858','jose.hasten@precon.com.br',3538),
(83706,29077,20,'José Hasten','31','9626-9598','31','3660-3858','jose.hasten@precon.com.br',3538),
(100287,29077,21,'Cléber Borges (Diretor de Operações)','31','3660-3858  R. 3994','31','3660-3990','cleber.borges@precon.com.br',3538),
(73888,29080,16,'Gleydson Wendell','62','3097-9700','62','3097-9779','gleydson@fgr.com.br',1444),
(73889,29080,49,'Leandro Leite','62','3097-9700','62','3097-9779','leite@fgr.com.br',1444),
(73890,29080,20,'Gleydson Wendell','62','3097-9700','62','3097-9779','gleydson@fgr.com.br',1444),
(91437,29080,70,'Leandro Sintra','62','3097-9700','62','3097-9779','sintra@fgr.com.br',1444),
(73892,29082,16,'Sandra Bokane','62','3097-9700','62','3097-9779','sandra@fgr.com.br',1444),
(73893,29082,49,'Marcelo Mendes','62','3097-9700','62','3097-9779','marcelo@fgr.com.br',1444),
(117950,29082,20,'Sandra Bokane','62','3097-9700','62','3097-9779','sandra@fgr.com.br',1444),
(73894,29084,20,'Regiane Oliveira (Técnico)','61','3272-0394','61','3323-1120','deptecnico@lbvalor.com.br',13390),
(87088,29089,16,'Glaydson Souza','21','3289-1300','21','3289-1307','glaydson.souza@mrlengenharia.com.br',15827),
(87089,29089,21,'Engº. Ricardo Blás','21','3289-1300','21','3289-1307','ricardo@blasengenharia.com.br',15827),
(87090,29089,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3515-8000','ana.passos@mrv.com.br',3009),
(104360,29089,105,'Cristiano Teixeira','21','3289-1300','21','3289-1307','marcia@mrlengenharia.com.br',15827),
(104361,29089,49,'Luiz Antônio','21','3289-1300','21','3289-1307','',15827),
(73920,29097,16,'Gerson Ramos','31','3526-7463','31','3261-4246','gerson.compras@emccamp.com',1746),
(73921,29097,49,'Ricardo Moraes','31','3526-7463','31','3261-4246','mg.emmcamp@yahoo.com.br',1746),
(73922,29097,20,'Eduardo Duarte','31','3526-7463','31','3261-4246','eduardo.duarte@yahoo.com.br',1746),
(73923,29098,16,'Adão Ferreira Filho','11','4195-7195','11','4195-7195','adao@cnaspitaletti.com.br',6048),
(73924,29098,49,'Adão Ferreira Filho','11','4153-8863','11','4789-3856','adao@cnaspitaletti.com.br',6048),
(73925,29098,16,'Eliana Vieira','11','4153-8863','11','4789-3856','eliana@cnaspitaletti.com.br',6048),
(87077,29101,16,'Leandro / Ângela','21','7720-6182','21','3289-1300','compras@mrlengenharia.com.br',15827),
(87078,29101,21,'Humberto Del Giudice Torres','21','3289-1300','21','3289-1307','',15827),
(87079,29101,20,'Arnaldo Almeida','31','3515-8411','31','3515-8000','arnaldo.almeida@mrv.com.br',3009),
(73930,29102,49,'Marcos Alexandre','21','3289-1300','31','3348-7101','',15827),
(91167,29102,16,'Jaime','21','2416-3551','21','2416-3551','jaime@psrio.com.br',5281),
(91168,29102,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(97640,29102,106,'Gladson Apolinário','31','9148-7293','21','3289-1300','gladson.apolinario@mrlengenharia.com.br',15827),
(73937,29107,20,'Silvio de Oliveira (Setor de Saneamento)','22','2772-5505','22','2791-9008','',14367),
(73938,29107,21,'Thadeu Campos','22','2772-5505','22','2791-9008','',14367),
(73966,29118,20,'César Cazzanelli (Gerente de Infra-estrutura)','54','3278-9000','54','3278-9300','cesar.cazzanelli@lajedepedra.com.br',14371),
(73967,29119,16,'Danielle Mendes (Coord. Suprimentos)','21','3724-8000','21','3724-8100','danielle@pdg.com.br',473),
(73968,29119,20,'Tainá (Marketing)','','4003-3734','21','3724-8100','marketing@pdg.com.br',473),
(73969,29119,29,'José Barreiro Júnior','21','3724-8000','21','3724-8100','jjunior@pdg.com.br',473),
(73995,29131,20,'Ricardo Pereira (Licitação)','11','3146-7059','11','3146-7097','licitaobras@sesisenaisp.org.br',9093),
(74006,29135,16,'João Ângelo D. Costa Curta','44','3031-0640','44','3031-0640','traco@traco.ind.br',6499),
(81167,29135,20,'João Ângelo D. Costa Curta','44','3031-0640','44','3031-0640','traco@traco.ind.br',6499),
(81168,29135,49,'João Ângelo D. Costa Curta','44','3031-0640','44','3031-0640','traco@traco.ind.br',6499),
(74014,29137,16,'Luiz Antônio','15','3275-7575','15','3272-4331','compras@construtoratardelli.com.br',14373),
(74015,29137,49,'Arivaldo de Alburquerque','15','9784-8092','15','3272-4330','tardelli@construtoratardelli.com.br',14373),
(74016,29137,20,'Nicolau Prestes (Planejamento)','15','3275-7575','15','3272-4331','tardelli@construtoratardelli.com.br',14373),
(74026,29141,16,'Valdeci José','11','2959-4455','11','2959-4455','valdeci@faobuilding.com.br',5998),
(74027,29141,49,'Flávio Borba','11','2959-4455','11','2959-4455','engenharia@faobuilding.com.br',5998),
(74028,29141,20,'Valdeci José','11','2959-4455','11','2959-4455','valdeci@faobuilding.com.br',5998),
(74032,29143,16,'Valdeci José','11','2959-4455','11','2959-4455','valdeci@faobuilding.com.br',5998),
(74033,29143,49,'Flávio Borda','11','2959-4455','11','2959-4455','engenharia@faobuilding.com.br',5998),
(74034,29143,20,'Flávio Borda','11','2959-4455','11','2959-4455','engenharia@faobuilding.com.br',5998),
(74036,29145,16,'Marcos Roberto Pereira','48','2107-0425','48','2107-0321','marcos.pereira@engevix.com.br',1727),
(80918,29145,20,'Marcos Roberto Pereira','48','2107-0425','48','2107-0321','marcos.pereira@engevix.com.br',1727),
(80919,29145,49,'Marco Aurélio Fernandes','48','3037-3274','48','2107-0321','marco.fernandes@engevix.com.br',1727),
(78083,29146,20,'Sidney Rodrigues (Engª Manutenção de Sistemas)','42','3238-1021 - R. 6088','42','3223-1865','martins@martinseng.com.br',5923),
(78084,29146,49,'Paulo Roberto Lacava','42','3238-1021','42','3223-1865','paulorobertolacava@yahoo.com.br',5923),
(78085,29146,16,'Paulo Roberto Lacava','42','3238-1021','42','3223-1865','martins@martinseng.com.br',5923),
(74040,29148,20,'Paulo Batista (Licitação)','31','3235-6223','31','3235-6191','gcl@deop.mg.gov.br',2816),
(74041,29149,20,'Thais Amadeu (Engenharia)','11','4795-8555','11','4795-8555','thais.amadeu@helbor.com.br',290),
(74042,29150,20,'Roberto Veigas (Comunicação)','11','4795-8555','11','4724-8831','veigas@helbor.com.br',290),
(91565,29151,49,'Daniel Malacrida','11','4048-2278','11','2149-4877','d.malacrida@mpd.com.br',1432),
(91566,29151,16,'Otacílio Soares','11','4048-2278','11','2149-4877','otacilio@mpd.com.br',1432),
(91567,29151,20,'Vitor Soares (Adm.)','11','4048-2278','11','2149-4877','otacilio@mpd.com.br',1432),
(75208,29152,16,'Iracema','31','3491-6464','31','3441-3525','compras.iracema@detronic.com.br',14502),
(75209,29152,20,'Engª Elaine Soares','31','3491-6464','31','3441-3525','comercial.elaine@detronic.com.br',14502),
(75210,29152,49,'Flávia','31','3491-6464','31','3441-3525','comercial.elaine@detronic.com.br',14502),
(74043,29153,16,'Sueli Alice Ikeda','44','3226-0909','','','engenhariaccv@bs2.com.br',9578),
(74044,29153,20,'Darci Rodrigues (Mestre de Obras)','44','3227-7253','','','Não Possui',9578),
(74050,29153,49,'Siomara Lima','44','3227-7253','44','3226-0909','engenhariaccv@bs2.com.br',9578),
(74045,29154,16,'Siomara Lima / Sueli','44','3226-0909','44','3226-0901','engenhariaccv@bs2.com.br',9578),
(74046,29154,49,'Siomara Lima / Paulo Suga / Lilian','44','3226-0909','44','3226-0901','engenhariaccv@bs2.com.br',9578),
(74049,29154,20,'Thaís Bataline (Engenharia)','44','3226-0909','44','3226-0901','thais.cidadeverde@hotmail.com',9578),
(74053,29156,16,'Siomara Lima / Paulo Suga','44','3226-0909','44','3226-0901','engenhariaccv@bs2.com.br',9578),
(74054,29156,49,'Siomara Lima / Paulo Suga','44','3226-0909','44','3226-0901','engenhariaccv@bs2.com.br',9578),
(74055,29156,20,'Rodrigo Inácio (Marketing)','44','3226-0909','44','3226-0901','rodrigo.cidadeverde@hotmail.com',9578),
(74075,29161,16,'Antônieta Ramos','11','2959-7511','11','2959-7511','antonieta@c2jconstrutora.com.br',14377),
(74076,29161,20,'Antônieta Ramos','11','2959-7511','11','2959-7511','antonieta@c2jconstrutora.com.br',14377),
(74077,29161,49,'Antônio Mascarenhas','11','2959-7511','11','2959-7511','',14377),
(74078,29162,20,'Rodolfo Luiz (Financeiro)','11','4728-5555','11','4728-5555','rogerio@cronengenharia.com.br',17164),
(100621,29162,16,'Sr. Darci Merencio','41','3022-6166','41','3022-6166','darci@cronengenharia.com.br',17164),
(100624,29162,49,'Luciano Plugge Freitas','41','3022-6166','41','3022-6166','',17164),
(86347,29169,20,'Soraia Dias (Assessora da Secretaria de Desenv.)','11','4348-1199','11','4348-1000','soraiadias@saobernardo.sp.gov.br',737),
(74089,29174,20,'Francisco Rueda (Gestor do Projeto)','11','3138-7000 - R. 7067','11','3138-7163','frueda@cteep.com.br',4997),
(89696,29174,49,'Gusstavo Pagotti','19','3464-5650 - R. 5685','19','3464-5650','gustavo@afap.com.br',16108),
(89697,29174,20,'Gustavo Pagotti','19','3464-5650 - R. 5685','19','3464-5650','gustavo@afap.com.br',16108),
(89698,29174,16,'Monise Nardele','19','3464-5650 - R. 5675','19','3464-5650','monise@afap.com.br',16108),
(74147,29186,16,'Antônieta Ramos','11','2959-7511','11','2959-7511','antonieta@c2jconsteutora.com.br',14377),
(74148,29186,20,'Ubaldo dos Santos Silva (Adm.)','11','2959-7511','11','2959-7511','ubaldo@c2jconstrutora.com.br',14377),
(79788,29186,49,'Nelson Nobre','11','2959-7511','11','2959-7511','nelson@c2jconstrutora.com.br',14377),
(74156,29191,16,'Mikael Minotti','47','3368-6680','47','3368-6680','mikaelminatti@yahoo.com.br',13821),
(74157,29191,49,'Mikael Minotti','47','3368-6680','47','3368-6680','mikaelminatti@yahoo.com.br',13821),
(74158,29191,20,'Mikael Minotti','47','3368-6680','47','3368-6680','mikaelminatti@yahoo.com.br',13821),
(74206,29200,16,'Marcos Couto','11','3176-1483/1270','11','3176-1270','marcos.santos@pdg.com.br',316),
(74207,29200,20,'Marcos Couto','11','3176-1483/1270','11','3176-1270','marcos.santos@pdg.com.br',316),
(74208,29200,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(74210,29201,20,'Setor de Licitação','41','3330-3636','41','3330-3330','',463),
(74211,29202,20,'Ana Beatriz (Secret. Diretoria)','31','3071-9676','31','3071-9676','',4020),
(79319,29202,21,'Luigi Alinovi','31','3071-9676','31','3071-9676','luigi.alinovi@eberbio.com.br',19840),
(79320,29202,64,'Renato Bressan','38','3071-9676','31','3071-9676','renato@eberbio.com.br',4020),
(88381,29202,16,'Geraldo Romoaldo','31','3071-9676 R:9609','31','3071-9676','geraldo.rocha@sada.com.br',4020),
(74212,29203,20,'Crodoaldo Silva (Engenheiro Florestal Responsável)','38','3526-1798','38','3526-1798','crodosilva@yahoo.com.br',13253),
(83957,29203,20,'Elaine de Moraes (Secret. do Eng. Florestal)','38','3526-1798','38','3526-1798','rfl.administrativo@sadabio.com.br',13253),
(74213,29204,16,'Lidiane','21','2512-7815','21','2239-3575','tecnico@tecnoplanengenharia.com.br',14393),
(74214,29204,49,'Nicolau Farah Ossaille','21','2239-3575','21','2239-3575','',14393),
(74215,29204,20,'Sr. Roberto','21','2239-3575','21','2239-3575','',14393),
(74219,29206,20,'Roberto Dalledone (Licitação)','41','3313-6400','41','3313-6422','robertodalledone@seop.pr.gov.br',14392),
(74220,29208,16,'Rodolfo Almeida','43','3392-1000','','','r.almeida@plaenge.com.br',3459),
(74221,29208,20,'Fernando Almeida','47','3392-1000','43','3294-4377','fe.almeida@plaenge.com.br',5194),
(149967,29208,49,'Restrito','47','3392-1000','','','restrito',14397),
(82213,29210,16,'Cristiane Bogo / Maysa Raquel','45','3224-4843','45','3224-3568','compras@abapan.com.br',7523),
(82214,29210,20,'Cristiane Bogo','45','3224-4843','45','3224-3568','compras@abapan.com.br',7523),
(82215,29210,49,'Júlio','45','3224-4843','45','3224-3568','julio@abapan.com.br',7523),
(74224,29211,16,'Elias Ebrahim Malen Neto','21','9987-3998','21','2548-0392','safira.07@bol.com.br',9570),
(74225,29211,49,'Elias Ebrahim Malen Neto','21','9987-3998','21','2548-0392','safira.07@bol.com.br',9570),
(74226,29211,20,'Elias Ebrahim Malen Neto','21','9987-3998','21','2548-0392','safira.07@bol.com.br',9570),
(74243,29218,49,'Flávio Gonçalves de Souza','21','3839-2511','21','3152-7799','flavio.eng@emccamp.com.br',6979),
(74244,29218,20,'Thalita Werneck (Técnica em Edificações)','21','3839-2511','21','3152-7799','obrario@gmail.com',6979),
(74245,29218,16,'Gerson Ramos','31','3526-7455/63','31','3261-4246','gerson.compras@emccamp.com.br',1746),
(74249,29220,49,'Flávio Gonçalves de Souza','21','3839-2511','21','3152-7799','flavio.eng@emccamp.com.br',6979),
(74250,29220,20,'Thalita Werneck (Técnica em Edificações)','21','3839-2511','21','3152-7799','obrario@gmail.com',6979),
(74251,29220,16,'Gerson Ramos','31','3526-7455/63','31','3261-4246','gerson.compras@emccamp.com.br',1746),
(74258,29223,16,'A definir','71','3082-5582','71','3082-5582','',5524),
(74259,29223,49,'A definir','71','3082-5582','71','3082-5582','',5524),
(74260,29223,20,'Manoel Neto','71','3082-5582','71','3082-5582','factor@factorltda.com.br',5524),
(87633,29224,16,'Elen Vanessa','11','4589-9522','11','4589-9522','compras@construtoraguarany.com.br',9922),
(87634,29224,49,'Gilberto Salge','11','4221-9114','11','4589-9522','gilberto@construtoraguarany.com.br',9922),
(87635,29224,20,'Gilberto Salge','11','4221-9114','11','4589-9522','gilberto@construtoraguarany.com.br',9922),
(74262,29225,16,'Silvestre Alvares Rezende','62','4001-3500','62','4001-3510','silvestre.rezende@ebm.com.br',10740),
(74263,29225,20,'Jhulyano Borges (Engenharia)','62','4001-3631','62','4001-3510','jhulyano.borges@ebm.com.br',10740),
(97129,29225,16,'Frederico Carcute','62','4001-3500','62','4001-3510','frederico.carcute@ebm.com.br',10740),
(97130,29225,49,'Lucas George Saulino Negreiros /Larro R. Junqueira','62','4001-3500','62','4001-3510','lucas.george@ebm.com.br',10740),
(74268,29227,49,'Cristiano Niemeyer','41','3317-5700','41','3317-5700','c.niemeyer@plaenge.com.br',14397),
(74269,29227,20,'Marlon Chivinski (Suprimentos)','41','3317-1700','41','3317-5700','ma.chivinski@plaenge.com.br',14397),
(105314,29227,16,'Marlon Chivinski','41','3317-1700','41','3317-5700','ma.chivinski@plaenge.com.br',14397),
(74271,29230,16,'Cassandra Rolim','85','3388-5800','85','3388-5800','cassandra@magis.com.br',12660),
(82744,29230,49,'Renata Amora','85','3388-5800','85','3388-5800','magis@magis.com.br',12660),
(99498,29230,21,'Emanuel','85','8798-3445','85','3388-5800','',12660),
(103930,29230,20,'Cassandra Rolim','85','3388-5800','85','3388-5800','cassandra@magis.com.br',12660),
(74273,29232,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(74274,29232,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(74275,29232,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(74280,29235,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(74281,29235,20,'Mariana Mazarella (Relacionamentos)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(74282,29235,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(74293,29242,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(74294,29243,16,'Edilson Cardoso','91','3182-4160','91','3182-4187','edilson@mbcapital.com.br',9760),
(74295,29243,20,'Edilson Cardoso','91','3182-4160','91','3182-4187','edilson@mbcapital.com.br',9760),
(82780,29245,20,'Eduardo Kirita','14','3433-2058','14','3433-2058','compras@@caparquiteturaeconstrucao.com.br',15304),
(82781,29245,49,'Eduardo Kirita / Silvio Guimarães','14','3433-2058','14','3433-2058','compras@caparquiteturaeconstrucao.com.br',15304),
(82782,29245,16,'Jorge Santos','14','3433-2058','14','3433-2058','compras@caparquiteturaeconstrucao.com.br',15304),
(74299,29249,16,'Eduardo Zani / Carlos Pazinato','43','3294-1092','43','3294-1710','e.zani@plaenge.com.br / c.pazinato@plaenge.com.br',3459),
(74300,29249,21,'Rodolfo Almeida (Suprimentos)','43','3294-1092','43','3294-1710','r.almeida@plaenge.com.br',3459),
(74301,29249,20,'Eduardo Zani (Suprimentos)','43','3294-1092','43','3294-1710','e.zani@plaenge.com.br',5194),
(74308,29252,67,'Alexandre Filho','41','3317-5700','41','3317-5740','a.filho@plaenge.com.br',14397),
(74309,29252,20,'Marlon Chivinski (Suprimentos)','41','3317-5700','41','3317-5740','ma.chivinski@plaenge.com.br',14397),
(105319,29252,16,'Marlon Chivinski','41','3317-5700','41','3317-5740','ma.chivinski@plaenge.com.br',14397),
(74310,29253,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(74311,29253,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(74312,29253,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(74323,29258,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(74324,29258,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(74325,29258,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(74326,29260,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(74327,29260,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(74328,29260,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(74335,29263,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(74336,29263,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(74337,29263,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(74338,29264,16,'Amanda Rotta','19','3795-4777','19','3795-4777','amanda.rotta@pdg.com.br',10897),
(74339,29264,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@pdg.com.br',10897),
(74340,29264,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@pdg.com.br',10897),
(74351,29271,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(74352,29271,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(74354,29271,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(74353,29272,20,'Pablo Pages (Projetos)','21','3505-8813','21','3505-8817','pp@performance.inc.com.br',12624),
(74425,29305,16,'Sueli Ferraz Cocink','13','3222-4884','13','3222-2620','sueli@serlam.com.br',2355),
(74426,29305,49,'Celso Jardinete','13','3222-4884','13','3222-2620','celso@serlam.com.br',2355),
(74427,29305,20,'Denise Freitas (ADM)','13','3224-1456','13','3222-4884','denise@serlam.com.br',2355),
(74428,29306,16,'Sueli Ferraz Cocink','13','3222-4884','13','3222-2620','sueli@serlam.com.br',2355),
(74429,29306,49,'Paulo Natel','13','3222-4884','13','3222-2620','paulonatel@serlam.com.br',2355),
(74430,29306,20,'Augusto Andrade (ADM)','13','3224-1416','13','3222-4884','augusto@serlam.com.br',2355),
(74431,29307,16,'Fernando Dias','31','3348-7100','31','3348-7219','fernandod@mrv.com.br',3009),
(74432,29307,20,'Bruno Eustáquio de Freitas (Projetos)','31','3515-8331','31','3348-7236','bruno.freitas@mrv.com.br',3009),
(87675,29307,49,'A definir','31','3348-7100','31','3348-7101','',3009),
(74433,29308,16,'Fernando Dias','31','3348-7100','31','3348-7219','fernandod@mrv.com.br',3009),
(74434,29308,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(87673,29308,49,'Renato Vieira Barbosa','31','3348-7101','31','3348-7101','renato.barbosa@mrv.com.br',3009),
(97153,29308,106,'André Mantovani','31','3348-7237','31','3348-7101','mantovani@mrv.com.br',3009),
(74440,29312,16,'Marcelo Fontes','21','2137-9700','21','2137-9700','marcelo@sesmariaconstrucoes.com.br',12900),
(74441,29312,20,'Isabel Oliveira (Recepção)','21','2137-9700','21','2137-9700','isabel@sesmariaconstrucoes.com.br',12900),
(74442,29312,49,'A definir','21','2137-9700','21','2137-9700','',12900),
(74447,29315,16,'Wagner Retonde','21','2206-5500','21','2206-5515','obras@volume.com.br',10668),
(74448,29315,49,'Edir Maia','21','2206-5500','21','2206-5515','edir@volume.com.br',10668),
(74449,29315,20,'Edir Maia','21','2206-5500','21','2206-5515','edir@volume.com.br',10668),
(74478,29327,16,'Gustavo Sereno','61','3035-6000','61','3035-6104','gustavo.sereno@primeconstrucoes.com.br',10893),
(74479,29327,20,'Fernando (Departamneto de Compras','61','3035-6000','61','3035-6104','',10893),
(97659,29327,106,'Roberto Egea','61','7816-3353','61','3035-6000','',10893),
(74483,29330,20,'Érica Firmino (Adm.)','21','3283-1893','','','gcampello@terra.com.br',14420),
(99163,29330,7,'Glauco Campello','21','3283-1893','','','gcampello@terra.com.br',14420),
(74533,29351,16,'Joel Vivan','43','3348-5454','43','3348-5454','joel@galmo.com.br',11487),
(74534,29351,49,'Eduardo Alves / Marcelo Henrique','43','3348-5454','43','3348-5454','eduardo@galmo.com.br,marcelohenrique@galmo.com.br',11487),
(74535,29351,20,'Engº André Sella','43','3348-5454','43','3348-5454','andre@galmo.com.br',11487),
(74730,29426,16,'Evandro','27','3315-1212','27','3315-1212','',13145),
(74731,29426,20,'Carla Vieira (Recepção)','27','3315-1212','27','3315-1212','recepcaoexit@rossiresidencial.com.br',13145),
(86319,29426,49,'Frederico Valle','27','3235-2211','27','3315-1212','fredericovalle@rossiresidencial.com.br',13145),
(74786,29453,16,'Sylvio Sofiatti','11','4523-5111','11','4523-5112','compras@faoliva.com.br',8948),
(74787,29453,20,'Douglas Sota (Engenharia)','11','4523-5111','11','4523-5110','engenharia@faoliva.com.br',8948),
(85530,29453,21,'Vicente Paulo','11','4523-5111','11','4523-5110','vicente.souza@faoliva.com.br',8948),
(74903,29502,20,'Rennar Bitarães (Adm.)','33','3279-9696','33','3279-9699','ti@bateriasraiom.com.br',14474),
(74904,29502,21,'José Moreira (Presidente)','33','3279-9696','33','3279-9699','moreira@bateriasraiom.com.br',14474),
(74981,29531,16,'Seno Luiz dos Santos','51','3382-7050','51','3382-7082','luiz@cyrelasul.com.br',1026),
(74982,29531,20,'Vitória Bernardes (Marketing)','51','3382-7064','51','3382-7066','vitoria.bernardes@cyrelasul.com.br',1026),
(82414,29531,70,'Guilherme Loureiro','51','3382-7081','51','3382-7082','guilherme.loureiro@cyrelasul.com.br',1026),
(82415,29531,20,'Caroline Osório (Marketing)','51','3382-7064','51','3382-7066','caroline.osorio@cyrelasul.com.br',1026),
(75031,29552,16,'Camila Silva','84','3234-1000','84','3234-1745','obras@martinferro.com.br',14484),
(75032,29552,49,'Marcelo Augusto','84','8868-0555','84','3234-1000','obras@martinferro.com.br',14484),
(75033,29552,20,'Pedro Correia (Gerente Administrativo)','84','9604-9058','84','3234-1000','gerencia@martinferro.com.br',14484),
(121709,29552,20,'Camila Silva','84','3234-1000','84','3234-1745','obras@martinferro.com.br',14484),
(75034,29553,16,'Frank Wellington','61','3202-1533','61','3202-1533','frank@faenge.com.br',9936),
(75035,29553,49,'Luciana Silva','61','3202-1533','61','3202-1533','luciana.silva@faenge.com.br',9936),
(75036,29553,20,'Alexandre Brandão','61','3202-1533','61','3202-1533','alexandre.brandao@faenge.com.br',9936),
(100619,29553,16,'Alexandre Brandão','61','3202-1533','61','3202-1533','alexandre.brandao@faenge.com.br',9936),
(100620,29553,49,'Charles Guedes','61','3202-1533','61','3202-1533','charles.guedes@faenge.com.br',9936),
(75057,29563,16,'Maria da Conceição','84','3219-5702','84','3219-3944','compras@moduloengenharia.com.br',6958),
(75058,29563,49,'Marcelo Augusto','84','3219-5702','84','3219-3944','',6958),
(75059,29563,20,'Ivan Pinto (Comercial)','84','9999-4166','84','3234-1004','comercial@martinferro.com.br',14484),
(75419,29565,16,'Flavio Campelo','85','4062-9011','85','3263-1642/1931','flavio.campelo@consorcioctsc.com.br',17174),
(100586,29565,49,'Sandro Gheller (Gerente Contrato Obra)','85','4062-9011','85','3263-1642/1931','sandro.gheller@consorcioctsc.com.br',17174),
(115727,29565,20,'Flavio Campelo','85','4062-9011','85','3263-1642/1931','flavio.campelo@consorcioctsc.com.br',17174),
(75101,29579,16,'Joel Teixeira','21','3206-3900','21','2521-7145','joelteixeira@santacecilia.net',1616),
(75103,29579,49,'Sandro','21','2278-2954','21','2521-7145','',1616),
(75106,29579,20,'Luciana  Brandão','21','2278-2954','21','3206-3860','luciana@santacecilia.net',1616),
(75207,29624,20,'Departamento de Projetos','12','3023-3104','12','3023-3161','',14724),
(80920,29624,21,'Sérgio Alexandre','12','3023-3115','12','3023-3161','',14724),
(89455,29624,21,'Engº Murilo Brás Ferreira (Coord. Civil)','12','3023-3540','12','3023-3161','cgmbf@ambev.com.br',14724),
(75257,29642,16,'Jorge Sirobaba','12','9713-7226','12','3931-6278','sirobaba@uol.com.br',13300),
(75258,29642,49,'Jorge Sirobaba','12','9713-7226','12','3931-6278','sirobaba@uol.com.br',13300),
(75259,29642,20,'Jorge Sirobaba','12','9713-7226','12','3931-6278','sirobaba@uol.com.br',13300),
(75494,29736,67,'Lucas Cristiano','48','3632-0006','48','3632-0006','fabricio.angelo@athena.com.br',13279),
(75495,29736,20,'Fabricio Angelo','48','3632-0006','48','3632-0006','fabricio.angelo@athena.com.br',13279),
(128325,29736,3,'Fabricio Angelo','48','3632-0006','48','3632-0006','fabricio.angelo@athena.com.br',13279),
(75500,29739,16,'Rafael de Souza','48','3632-0006','48','3632-0006','rafael@athenasconstrucoes.com.br',9105),
(75501,29739,49,'Alexandre Aguiar','48','3632-0006','48','3632-0006','alexandre@athenasconstrucoes.com.br',9105),
(75502,29739,20,'Cristiane Inácio (Atendimento)','48','3632-0006','48','3632-0006','athena@athenasconstrucoes.com.br',9105),
(75548,29757,16,'Mariana Rezende','27','3325-0009','27','3325-0009','compras@paduaconstrutora.com.br',9398),
(75549,29757,49,'Reimar Silva','27','9235-2013','27','3325-0009','engitalia@paduaconstrutora.com.br',9398),
(75550,29757,20,'Reimar Silva','27','9235-2013','27','3325-0009','engitalia@paduaconstrutora.com.br',9398),
(75589,29771,20,'Engº Rubens Romano (Superintendente)','11','3039-7480','11','3039-7450','rubens.romano@ersabrasil.com.br',10673),
(110789,29775,14,'Daniele Faria (Coord. Suprimentos)','31','3117-1800','','','dffaria@construcap.com.br',15810),
(75603,29776,16,'Arq. Jorge Brezinski','21','2447-6417','21','2447-6417','brezinskiarquitetura@globo.com',2043),
(75604,29776,49,'Arq. Jorge Brezinski','21','2447-6417','21','2447-6417','brezinskiarquitetura@globo.com',2043),
(75608,29776,20,'Arq. Jorge Brezinski','21','2447-6417','21','2447-6417','brezinskiarquitetura@globo.com',2043),
(75605,29777,20,'Engº Rubens Romano (Superintendente)','11','3039-7480','11','3039-7450','rubens.romano@ersabrasil.com.br',10673),
(75606,29777,16,'Flávio Salomão','41','3279-1901','41','3279-1901','compras@bucagrans.com.br',5949),
(75607,29777,49,'Nilo Carvalho','41','3279-1901','41','3279-1901','',5949),
(75609,29777,20,'Sr. Sidney (Administrativo)','41','3357-5125','','','',5949),
(75661,29795,16,'Arq. Ronaldo Fontainha','21','2487-4021','21','2487-4021','r.fontainha@uol.com.br',1570),
(75662,29795,49,'Arq. Ronaldo Fontainha','21','2487-4021','21','2487-4021','r.fontainha@uol.com.br',1570),
(75663,29795,20,'Arq. Ronaldo Fontainha','21','2487-4021','21','2487-4021','r.fontainha@uol.com.br',1570),
(76863,30227,16,'Crislaine Lúcia / Paulo César de Castro Carvalho','31','3284-3435','','','compras@castrocarvalho.com.br',14704),
(76864,30227,49,'Paulo César de Castro Carvalho','31','3284-3435','','','compras@castrocarvalho.com.br',14704),
(76865,30227,20,'Crislaine Lúcia','31','3284-3435','','','compras@castrocarvalho.com.br',14704),
(78918,30983,16,'Pedro Eustáquio dos Santos (Dir. Presidente)','31','3831-7409','31','3831-7409','pedro@sv.com.br',14956),
(78919,30983,20,'Pedro Eustáquio dos Santos','31','3831-7409','31','3831-7409','pedro@sv.com.br',14956),
(78920,30983,21,'Pedro Eustáquio dos Santos','31','3831-7409','31','3831-7409','pedro@sv.com.br',14956),
(79268,31099,16,'Sr. Gilciney Valente','92','2101-9700 - R. 9724','92','3615-2397','scompras@elginmao.com.br',14992),
(79329,31118,16,'Jorge Luis','98','3235-3278','98','3235-3278','jorgeluis@motamachado.com.br',3958),
(79330,31118,29,'João Vando','98','3235-3278','98','3235-3278','joaovando@motamachado.com.br',3958),
(85551,31118,20,'Jorge Luís (Compras)','98','3235-3278','98','3235-3278','jorgeluis@motamachado.com.br',3958),
(79331,31119,49,'Carlos Alberto P. Macedo','21','2453-3652','21','2453-6355','sac@imoval.com.br',7693),
(79332,31119,16,'Carlos Alberto P. Macedo','21','2453-3652','21','2453-6355','sac@imoval.com.br',7693),
(79333,31119,20,'Carlos Alberto P. Macedo','21','2453-3652','21','2453-6355','sac@imoval.com.br',7693),
(79334,31120,16,'Sívia','33','3271-8811','33','3271-8811','construtorahercon@hotmail.com',14994),
(79335,31120,49,'Hermes Marcos Vasconcelos','33','3271-8811','33','3271-8811','hermesgv@globo.com',14994),
(79336,31120,20,'Hermes Marcos','33','9989-4130','33','3271-8811','hermesgv@globo.com',14994),
(79337,31121,16,'Enio Júnior','33','3271-8811','33','3271-8811','construtorahercon@hotmail.com',14994),
(79338,31121,49,'Hermes Marcos Vasnconcelos','33','3271-8811','33','3271-8811','hermesgv@globo.com',14994),
(79339,31121,20,'Hermes Marcos Vasconcelos','33','3271-8811','33','3271-8811','hermesgv@globo.com',14994),
(79340,31122,16,'Tainara Rodrigues','15','3232-6606','15','3232-6606','compras@construtorapauloafonso.com.br',1171),
(79341,31122,49,'Paulo Afonso','15','3232-6606','15','3232-6606','',1171),
(98294,31122,20,'Tainara Rodrigues (Compras)','15','3232-6606','15','3232-6606','compras@construtorapauloafonso.com.br',1171),
(79342,31123,16,'Tainara Rodrigues','15','3232-6606','15','3232-6606','compras@construtorapauloafonso.com.br',1171),
(79343,31123,20,'Thaisa Bernardes (Arquiteta)','15','3232-6606','15','3232-6606','thaisabernardes@gmail.com',1171),
(79344,31123,49,'Paulo Afonso','15','3232-6606','15','3232-6606','projetos@construtorapauloafonso.com.br',1171),
(79345,31124,16,'Hilton Resende','15','3232-6606','15','3232-6606','compras@construtorapauloafonso.com.br',1171),
(79346,31124,49,'A definir','15','3232-6606','15','3232-6606','',1171),
(79347,31124,20,'Cinthia (Recepção)','15','3232-6606','15','3232-6606','dp@construtorapauloafonso.com.br',1171),
(79348,31125,16,'Hilton Resende','15','3232-6606','15','3232-6606','compras@construtorapauloafonso.com.br',1171),
(79349,31125,49,'Paulo Afonso','15','3232-6606','15','3232-6606','compras@construtorapauloafonso.com.br',1171),
(79350,31125,20,'Cinthia (Recepção)','15','3232-6606','15','3232-6606','dp@construtorapauloafonso.com.br',1171),
(79385,31140,16,'Pedro Marcos Granzotto','41','3077-9667','41','3077-9667','pedro.marcos@dapo.com.br',13891),
(79386,31140,49,'Tadeu Razera','41','3077-9667','41','3077-9667','tadeu.razera@dapo.com.br',13891),
(79387,31140,20,'Pedro Marcos Granzotto','41','3077-9667','41','3077-9667','pedro.marcos@dapo.com.br',13891),
(79388,31141,16,'Pedro Marcos Granzotto','41','3077-9667','41','3077-9667','pedro.marcos@dapo.com.br',13891),
(79389,31141,49,'Tadeu Razera','41','3077-9667','41','3077-9667','tadeu.razera@dapo.com.br',13891),
(79390,31141,20,'Pedro Marcos Granzotto','41','3077-9667','41','3077-9667','pedro.marcos@dapo.com.br',13891),
(79391,31142,16,'Luciano Garcia','27','2121-5151','27','2121-5135','suprimentos@lorenge.com.br',384),
(79392,31142,20,'Luciano Garcia','27','2121-5151','27','2121-5135','suprimentos@lorenge.com.br',384),
(79393,31142,21,'Giuliano Pollito','27','3064-3711','27','2121-5151','giuliano@lorenge.com.br',384),
(79394,31143,16,'Luciano Garcia','27','2121-5151','27','2121-5135','suprimentos@lorenge.com.br',384),
(79395,31143,49,'Wagner de Deus','27','3025-3338','27','2121-5151','wagner@lorenge.com.br',384),
(79396,31143,20,'Luciano Garcia','27','2121-5151','27','2121-5135','suprimentos@lorenge.com.br',384),
(79397,31144,21,'Engº Leandro Amaro','11','3512-4500','11','3512-4532','leandroa@mrv.com.br',1504),
(79398,31144,16,'Gustavo Drumond','11','3512-4500','11','3512-4532','suprimentossp@mrv.com.br',1504),
(79461,31144,20,'Ana Paula Passos (Engenharia)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(100165,31144,105,'Marcelo Pompermayer','11','3512-4500','11','3512-4532','marcelo.pompermayer@mrv.com.br',1504),
(100166,31144,49,'Márcio André','11','3512-4500','11','3512-4532','',1504),
(79399,31145,49,'Alessandro Câmara','11','3512-4500','11','3512-4532','alessandro.camara@mrv.com.br',1504),
(79400,31145,16,'Fernando Dias','31','3348-7100','31','3348-7219','fernandod@mrv.com.br',3009),
(79462,31145,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(79401,31146,49,'Alan Bazan','11','3512-4500','11','3512-4532','alan.bazan@mrv.com.br',1504),
(79402,31146,16,'Fernando Dias','31','3348-7100','31','3348-7219','fernando@mrv.com.br',3009),
(79463,31146,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(79405,31147,49,'Alessandro Câmara','11','3512-4500','11','3512-4532','alessandro.camara@mrv.com.br',1504),
(79406,31147,16,'Fernando Dias','31','3348-7100','31','3348-7219','fernando@mrv.com.br',3009),
(79464,31147,20,'Ana Paula Passos (Planejamento)','31','3515-8324','31','3348-7101','ana.passos@mrv.com.br',3009),
(79416,31148,16,'João Maria','21','3147-1700','21','3147-1701','jm@arteverde.com.br',825),
(79417,31148,49,'Paulo Roberto G. dos Santos','21','3147-1700','21','3147-1701','arteverde@arteverde.com.br',825),
(79418,31148,20,'Rogéria (Atendimento)','21','3147-1700','21','3147-1701','arteverde@arteverde.com.br',825),
(79419,31149,16,'Bruno Freitas','11','3661-7388','11','3661-7031','projetos@cevn.com.br',313),
(79420,31149,49,'Sérgio Schreier','11','3842-4429','11','3661-7388','',313),
(79421,31149,20,'José Bento (Almoxarifado)','11','3661-7388','11','3661-7031','',313),
(79422,31150,16,'Oswaldo Ferraz','11','3661-73888','11','3661-7031','oswaldoferraz@cevn.com.br',313),
(79423,31150,49,'Oswaldo Ferraz','11','3661-73888','11','3661-7031','oswaldoferraz@cevn.com.br',313),
(79424,31150,20,'Vanessa (Atendimento)','11','3661-73888','11','3661-7031','cevn@cevn.com.br',313),
(79431,31151,49,'Ana Paula','62','2290-4710','62','3219-3333','anapaula@portobeloweb.com.br',7774),
(79432,31151,20,'Jerônimo Nascimento Júnior','62','2290-4710','62','3219-3333','jeronimo@portobeloweb.com.br',7774),
(79433,31151,16,'José Cândido','62','3219-3333','62','3219-3362','compras@portobeloweb.com.br',7774),
(79436,31152,16,'Juliano Augusto','21','3147-1700','21','3147-1701','arteverde@arteverde.com.br',825),
(79437,31152,49,'Paulo Roberto G. dos Santos','21','3147-1700','21','3147-1701','arteverde@arteverde.com.br',825),
(79438,31152,20,'Juliano Augusto','21','3147-1700','21','3147-1701','arteverde@arteverde.com.br',825),
(79439,31153,16,'Luciano Garcia','27','2121-5100','27','2121-5135','suprimentos@lorenge.com.br',384),
(79440,31153,20,'Thiago Feitosa (Apontador)','27','3024-5613','27','2121-5100','obra113@lorenge.com.br',384),
(79441,31153,49,'Wagner de Deus','27','3024-5613','27','2121-5100','wagner@lorenge.com.br',384),
(79442,31154,16,'Luciano Garcia','27','2121-5100','27','2121-5135','suprimentos@lorenge.com.br',384),
(79443,31154,20,'Hildo Borges (Adm Obra)','27','3064-3711','27','2121-5100','hildoborges@lorenge.com.br',384),
(79444,31154,62,'Rafael Fernandes','27','3064-3711','27','2121-5100','rafael@lorenge.com.br',384),
(79445,31155,20,'Nilton Souza (Engenharia)','11','2246-7034','11','2246-7046','nilton.souza@saint-gobain.com',15001),
(79446,31155,21,'Nilton Souza (Engenharia)','11','2246-7034','11','2246-7046','nilton.souza@saint-gobain.com',15001),
(79447,31156,20,'Sidney Rodrigues','42','9921-0709','42','3238-1021','martins@martinseng.com.br',5923),
(87013,31156,49,'Sidney Rodrigues','42','9921-0709','42','3238-1021','martins@martinseng.com.br',5923),
(87014,31156,16,'Clodoaldo Pires','42','3238-1021','42','3238-1021','martins@martinseng.com.br',5923),
(79448,31157,49,'Donizete Felipim','44','3025-1001','44','3026-1002','donizete@metroengenharia.com.br',7385),
(87226,31157,16,'Lázaro Antônio de Oliveira Silva','44','3025-1001','44','3026-1002','compras@metroengenharia.com.br',7385),
(79455,31158,16,'Edir Cano','83','3531-1548','83','3531-1681/1789','ecano@construcap.com.br',15003),
(79456,31158,49,'Fabrício Vieira','83','3531-1548','83','3531-1681/1789','fabricio.vieira@pbsa.com.br',15003),
(101915,31158,20,'Gustavo Yamamoto(eng)','83','3531-1548','83','3531-1681/1789','gustavo.yamamoto@pbsa.com.br',15003),
(79457,31159,16,'Edir Cano','83','3531-1548','83','3531-1681/1789','ecano@construcap.com.br',15003),
(79458,31159,49,'Fabrício Vieira','83','3531-1548','83','3531-1681/1789','fabricio.vieira@pbsa.com.br',15003),
(101914,31159,20,'Cristiano Yamamoto (Eng)','83','3531-1548','83','3531-1681/1789','gustavo.yamamoto@pbsa.com.br',15003),
(79465,31160,16,'Raimundo Pacchelli','61','3363-9283','61','3363-9213','compras@hcconstrutora.com.br',1386),
(79466,31160,49,'Valdinei Batista da Silva','61','3356-7004','61','2106-1800','engenhariavaldinei@bol.com.br',1386),
(79467,31160,20,'Thiago Rossini (Almoxarife)','61','3356-7004','61','2106-1800','obrahc@bol.com.br',1386),
(79468,31161,49,'Antônio José Alves Pereira','21','9147-0298','21','3027-3069','ajengcivil@gmail.com',15004),
(79469,31161,20,'Antônio José Alves Pereira','21','9147-0298','21','3027-3069','ajengcivil@gmail.com',15004),
(79470,31161,16,'Antônio José Alves Pereira','21','9147-0298','21','3027-3069','ajengcivil@gmail.com',15004),
(79471,31162,16,'Bruno Arruda','14','3879-5717','14','3313-8149','bruno@construtoradinamica.com.br',13518),
(79472,31162,20,'Gilberto Junior','14','3879-5717','14','3313-8149','gilberto@construtoradinamica.com.br',13518),
(88997,31162,16,'Anderson Marin','14','3879-5717','14','3313-8149','anderson@construtoradinamica.com.br',13518),
(94444,31162,21,'Sérgio Santesso','14','3879-5717','14','3313-8149','sergio@construtoradinamica.com.br',13518),
(79473,31163,16,'Luciana Requena','14','3879-5717','14','3313-8149','luciana@construtoradinamica.com.br',13518),
(79474,31163,16,'Anderson Marin','14','3879-5717','14','3313-8149','anderson@construtoradinamica.com.br',13518),
(79475,31163,20,'Gilberto Júnior','14','3879-5717','14','3313-8149','gilberto@construtoradinamica.com.br',13518),
(79476,31163,21,'Sergio Santesso','14','3879-5717','14','3313-8149','sergio@construtoradinamica.com.br',13518),
(79486,31164,16,'Wilza Maria Melo Nunes','21','2734-2171','21','2734-0980','wdanunes@yahoo.com.br',7913),
(79487,31164,7,'Wilza Maria Melo Nunes','21','2734-2171','21','2734-0980','wdanunes@yahoo.com.br',7913),
(79488,31164,20,'Júlio César (Diretor)','21','2734-2171','21','2734-0980','jcmiranda_1@hotmail.com',7913),
(79489,31165,16,'Carlos Alexandre','21','2210-2446','21','2210-2446','compras@comasaconstrutora.com.br',2034),
(79490,31165,49,'Sr. Gualter','21','3172-2446','21','2210-2446','angeloagostini41@gmail.com',2034),
(79491,31165,20,'Andressa Kapleen (Atendimento)','21','2210-2446','21','2210-2446','comasa@comasaconstrutora.com.br',2034),
(88315,31166,20,'Guilherme Alves (Suprimentos)','43','3294-1000','43','3294-1710','g.alves@plaenge.com.br',3459),
(88316,31166,16,'Júlio Oliveira','43','3294-1015','43','3294-1039','j.oliveira@plaenge.com.br',3459),
(88317,31166,49,'Fausto Tsutsu','43','3294-1000','43','3294-1036','f.tsutsu@plaenge.com.br',3459),
(103677,31166,21,'Rogério Cardoso','43','3294-1000','43','3294-1710','r.cardoso@plaenge.com.br',3459),
(79492,31167,16,'Júlio Oliveira','43','3294-1081','43','3294-1584','ju.oliveira@plaenge.com.br',3459),
(87041,31167,20,'Guilherme Alves (Planejamento)','43','3294-1081','43','3294-1584','g.alves@plaenge.com.br',3459),
(87042,31167,49,'Anderson Casarin','43','3294-1081','43','3294-1584','a.casarin@plaenge.com.br',3459),
(79501,31169,21,'Engª Ana Carla','81','3366-3000','81','3366-3001','ana.carla@gbobras.com.br',3150),
(79502,31169,16,'Bruno Figueiredo','81','3366-3000','81','3366-3001','bruno.figueiredo@gabrielbacelar.com.br',3150),
(79503,31169,20,'Isabela Reis (Departamento de Reformas)','81','3366-3000','81','3366-3001','reformas@gabrielbacelar.com.br',3150),
(79507,31170,21,'Engª Ana Carla','81','3366-3000','81','3366-3001','ana.carla@gbobras.com.br',3150),
(79508,31170,16,'Bruno Figueiredo','81','3366-3046','81','3366-3001','bruno.figueiredo@gabrielbacelar.com.br',3150),
(118482,31170,20,'Bruno Figueiredo','81','3366-3046','81','3366-3001','bruno.figueiredo@gabrielbacelar.com.br',3150),
(79509,31171,49,'Hudemberg Moura','81','3366-3000','81','3366-3001','hudemberg.moura@gabrielbacelar.com.br',3150),
(79510,31171,16,'Roberto Santana','81','3366-3000','81','3366-3001','roberto@gabrielbacelar.com.br',3150),
(79511,31171,20,'Roberto Santana','81','3366-3046','81','3366-3001','roberto@gabrielbacelar.com.br',3150),
(79513,31172,49,'Breno Menezes','81','3034-5018','81','3366-3000','breno.menezes@gbobras.com.br',3150),
(79514,31172,16,'Roberto Santana','81','3366-3046','81','3366-3001','roberto@gabrielbacelar.com.br',3150),
(118531,31172,20,'roberto@gabrielbacelar.com.br','81','3366-3046','81','3366-3001','roberto@gabrielbacelar.com.br',3150),
(79515,31173,16,'Erica Oliveira','11','3246-3300','11','3246-3301','compras@sanca.com.br',1846),
(79516,31173,20,'Fernando Oliveira','11','3062-2517','11','3246-3300','fernando@sanca.com.br',1846),
(95250,31173,49,'Fernando Oliveira','11','3062-2517','11','3246-3300','fernando@sanca.com.br',1846),
(79517,31174,20,'Luana Gabriela Lach (Adm.)','47','3461-9500','47','3461-9500','luana.lach@prorim.com.br',15005),
(79518,31175,20,'Luana Gabriela Lach (Adm.)','47','3461-9500','47','3491-9500','luana.lach@prorim.com.br',15005),
(79519,31176,16,'Wilza Maria Melo Nunes','21','2734-2171','21','2734-0980','wdanunes@yahoo.com.br',7913),
(79520,31176,7,'Wilza Maria Melo Nunes','21','2734-2171','21','2734-0980','wdanunes@yahoo.com.br',7913),
(79521,31176,20,'Júlio César (Diretor)','21','2734-2171','21','2734-0980','jcmiranda_1@hotmail.com',7913),
(79522,31177,16,'Roberto Santana','81','3366-3046','81','3366-3001','roberto@gabrielbacelar.com.br',3150),
(79524,31177,49,'Luiza Neves','81','3366-3000','81','3366-3001','luiza.neves@gbobras.com.br',3150),
(118483,31177,20,'Roberto Santana','81','3366-3046','81','3366-3001','roberto@gabrielbacelar.com.br',3150),
(79523,31178,20,'Roberto Toschi (Diretor Marketing)','11','2069-3500','11','2069-3500','roberto.toschi@sabie.com.br',15010),
(84131,31179,20,'Luiz Fernando (Ger. Industrial)','34','3233-7700 R:7795','34','3212-5074','luiztraba@cocacolauberlandia.com.br',15011),
(126629,31179,20,'Rodrigo Jorge (Gerente de Projetos)','34','3233-7700 R:7795','34','3212-5074','rjorge@cocacolauberlandia.com.br',15011),
(79525,31180,20,'Marcelo Franco','31','3915-5112','31','3915-5123','marcelo.franco@tecnologia.mg.gov.br',10687),
(79526,31180,21,'Marcelo Franco','31','3915-5112','31','3915-5123','marcelo.franco@tecnologia.mg.gov.br',10687),
(79527,31181,21,'Engº Pedro Santos','81','3366-3000','81','3366-3001','pedro.santos@gbobras.com.br',3150),
(79528,31181,16,'Bruno Figueiredo','81','3366-3000','81','3366-3001','bruno.figueiredo@gabrielbacelar.com.br',3150),
(79529,31181,20,'Isabela Reis (Departamento de Reformas)','81','3366-3000','81','3366-3001','reformas@gabrielbacelar.com.br',3150),
(79531,31182,21,'Engº Pedro Santos','81','3366-3000','81','3366-3001','pedro.santos@gbobras.com.br',3150),
(79532,31182,16,'Bruno Figueiredo','81','3366-3000','81','3366-3001','bruno.figueiredo@gabrielbacelar.com.br',3150),
(79533,31182,20,'Isabela Reis (Departamento de Reformas)','81','3366-3000','81','3366-3001','reformas@gabrielbacelar.com.br',3150),
(79535,31183,21,'Anivaldo Antunes','81','3366-3000','81','3366-3001','anivaldo@gabrielbacelar.com.br',3150),
(79536,31183,16,'Bruno Figueiredo','81','3366-3000','81','3366-3001','bruno.figueiredo@gabrielbacelar.com.br',3150),
(79537,31183,20,'Bruno Figueiredo (Compras)','81','3366-3000','81','3366-3001','bruno.figueiredo@gabrielbacelar.com.br',3150),
(79541,31184,16,'Elaine Pavani','21','2431-4505','21','2431-4505','suprimentos@rubiengenharia.com.br',5417),
(79542,31184,20,'Tuani (recepção)','21','2431-4505','21','2431-4505','tuani@rubiengenharia.com.br',5417),
(79543,31184,49,'Ana Isaura','21','2431-4505','21','2431-4505','anaalvin@rubiengenharia.com.br',5417),
(79544,31185,49,'Fábio Ferreira de Araujo','16','3639-2699','16','3513-1800','obraribeirao@pherconconstrutora.com.br',1088),
(79546,31185,16,'José Roberto / Rogério Salomone','16','3513-1800','16','3513-1899','jose.roberto@pherconconstrutora.com.br',1088),
(79547,31185,21,'João Carlos Mancine','16','3513-1800','16','3513-1899','j.mancine@pherconconstrutora.com.br',1088),
(86572,31185,20,'Rogério Salomone','16','3513-1800','16','3513-1899','compras@pherconconstrutora.com.br',1088),
(79545,31186,49,'Fábio Araújo','16','3513-1808','16','3513-1899','obrabebedouro@pherconconstrutora.com.br',1088),
(79548,31186,16,'José Roberto / Rogério Salomone','16','3513-1800','16','3513-1899','jose.roberto@pherconconstrutora.com.br',1088),
(79549,31186,21,'João Carlos Mancine','16','3513-1800','16','3513-1899','j.mancine@pherconconstrutora.com.br',1088),
(79550,31187,49,'A definir','16','3513-1800','16','3513-1899','',1088),
(79551,31187,16,'José Roberto / Rogério Salomone','16','3513-1800','16','3513-1899','jose.roberto@pherconconstrutora.com.br',1088),
(79552,31187,21,'João Carlos Mancine','16','3513-1800','16','3513-1899','jmancine@pherconconstrutora.com.br',1088),
(86571,31187,20,'Rogério Salomone','16','3513-1800','16','3513-1899','compras@pherconconstrutora.com.br',1088),
(79564,31189,16,'Paulo de Tarso','21','2734-8868','21','2734-8868','arcodata@arcodata.com',14998),
(79565,31189,20,'Sr. Ribamar Campos (Comercial)','21','2734-8868','21','2734-8868','arcodata@arcodata.com',14998),
(79566,31189,7,'Wilza Maria Melo Nunes','21','9853-5711','','','wdanunes@yahoo.com.br',7913),
(79567,31190,16,'Tatiana do Nascimento','21','2290-3285','21','3868-5831','compras@midas.eng.br',2979),
(79568,31190,49,'Alexandre Badin de Vasconcelos','21','2290-3285','21','3868-5831','',2979),
(79569,31190,20,'Sara Viana (Compras)','21','2290-3285','21','3868-5831','compras@midas.eng.br',2979),
(79570,31191,20,'Silvio Gonzales (Adm.)','11','3201-1005','11','3201-1003','silvio@brpr.com.br',15012),
(98263,31191,49,'José Jardim','11','3201-1005','11','3201-1003','jardim@brpr.com.br',15012),
(98264,31191,16,'Silvio Gonzales','11','3201-1005','11','3201-1003','silvio@brpr.com.br',15012),
(93909,31192,20,'Maísa Alves (Ass. Imprensa)','31','99824-6781','31','3515-8953','maisa.alves@ferrous.com.br',11848),
(119011,31192,16,'Sr. Yusseph Tacla (Analista de Suprimentos)','31','3503-8742','','','yusseph.tacla@ferrous.com.br',11848),
(110907,31193,20,'Fernando Tiradentes (Suprimentos)','31','3503-8724','','','fernando.tiradentes@ferrous.com.br',11848),
(125678,31193,121,'Cristiano Monteiro Parreiras','31','3515-8956','','','cristiano.parreiras@ferrous.com.br',11848),
(125742,31194,121,'Cristiano Monteiro Parreiras','31','3515-8956','','','cristiano.parreiras@ferrous.com.br',11848),
(148396,31194,20,'Fernando Tiradentes (Suprimentos)','31','3503-8724','','','fernando.tiradentes@ferrous.com.br',11848),
(79583,31195,16,'André Zaidan (Diretor de Suprimentos)','11','3377-3777','11','3377-3778','azaidan@even.com.br',730),
(79584,31195,20,'Renato Arbulu (Engenharia) / Mariana Brito (Mark.)','11','3377-3777','11','3377-3778','rarbulu@even.com.br,mbrito@even.com.br',730),
(79585,31195,29,'Marcelo Zapparoli','11','3377-3777','11','3377-3778','mzapparoli@even.com.br',730),
(79586,31196,16,'Fabrisa Talita de Souza','47','3365-5000','47','3365-5000','fabrisa_g12@hotmail.com',13907),
(79587,31196,20,'Fabrisa Talita de Souza','47','3365-5000','47','3365-5000','fabrisa_g12@hotmail.com',13907),
(79588,31196,49,'Cristian Lins','47','3365-5000','47','3365-5000','ctlins@terra.com.br',13907),
(79592,31197,20,'Edivan Gonçalves','15','3262-4148','15','3262-2133','edivan@doissantos.com.br',15017),
(107365,31197,16,'Edivan Gonçalves','15','3262-4148','15','3262-2133','edivan@doissantos.com.br',15017),
(107366,31197,49,'André Vittá','11','7849-4863','15','3262-4148','',15017),
(79604,31198,16,'Sinária de Araújo Melo','21','9385-3575','21','8698-1291','sinariam@gmail.com',15016),
(79605,31198,7,'Sinária de Araújo Melo','21','9385-3575','21','8698-1291','sinariam@gmail.com',15016),
(79607,31198,20,'Sinária de Araújo Melo','21','9385-3575','21','8698-1291','sinariam@gmail.com',15016),
(79615,31199,20,'Rosimere da Silva (Secret. de Cultura)','19','2116-0791','','','cultura.adm@campinas.sp.gov.br',596),
(113054,31199,101,'Samuel Ribeiro Rossilho','19','2116-0716','','','smdes.gabinete@campinas.sp.gov.br',596),
(79617,31200,16,'Elder Souza','61','3403-4035','61','3341-1319','elder.souza@grupovia.com.br',1056),
(79618,31200,49,'Euripedes Maximiano Dias','61','3329-1400','61','3403-4035','euripedes.dias@grupovia.com.br',1056),
(79619,31200,20,'Washington Luiz (RH/Financeiro)','61','3329-1400','61','3403-4035','washingtons@grupovia.com.br',1056),
(79620,31201,16,'Antônio Silva','21','3528-2727','21','2421-9005','sanerio@sanerio.com.br',4691),
(79621,31201,49,'Luiz Carlos Bastos Matos','21','3528-2727','21','2421-9005','sanerio@sanerio.com.br',4691),
(79622,31201,20,'Luiz Carlos Bastos Matos','21','3528-2727','21','2421-9005','sanerio@sanerio.com.br',4691),
(79623,31202,16,'Sebastião Sérgio M. Marques','21','9341-7208','21','3639-5133','moreiramarques2005@yahoo.com.br',13420),
(79624,31202,49,'Sebastião Sérgio M. Marques','21','9341-7208','21','3639-5133','moreiramarques2005@yahoo.com.br',13420),
(79625,31202,20,'Sebastião Sérgio M. Marques','21','9341-7208','21','3639-5133','moreiramarques2005@yahoo.com.br',13420),
(79626,31203,20,'Lucas Garcia','11','4347-4880 R:5108','','','lucas.garcia@volkswagen.com',8358),
(79627,31204,16,'Eliazar Santos','12','3608-6065','12','3608-7788','eliazar@zuinezuin.com.br',15022),
(79628,31204,20,'Rubens Gonçalves (Compras)','19','3471-8637','19','3471-8605','rubens.goncalves@nexans.com',15023),
(79629,31204,21,'Sávio Reis','19','3471-8605','19','3471-8605','',15023),
(79630,31204,49,'Felipe Zuin','12','3608-6065','12','3608-7788','',15022),
(79631,31205,16,'Fabiano Escorel','81','3087-8000','81','3087-8056','compras@mouradubeux.com.br',898),
(79632,31205,20,'Eduardo Gomes (Projetos)','81','3087-8000','81','3087-8000','projetos@mouradubeux.com.br',898),
(79633,31205,49,'A definir','81','3087-8000','81','3087-8056','',898),
(79634,31206,20,'Juliana Morais','62','3096-1150','62','3096-1177','compras@enecengenharia.com.br',15019),
(88111,31206,16,'Juliana Morais','62','3096-1150','62','3096-1177','compras@enecengenharia.com.br',15019),
(88112,31206,49,'Herikson Santiago','62','8140-6099','62','3096-1150','herikson.santiago@enecengenharia.com.br',15019),
(79638,31207,16,'Fabiano Escorel','81','3087-8000','81','3087-8056','compras@mouradubeux.com.br',898),
(79639,31207,20,'Eduardo Gomes (Projetos)','81','3087-8000','81','3087-8000','projetos@mouradubeux.com.br',898),
(79642,31207,49,'A definir','81','3087-8000','81','3087-8056','',898),
(85087,31208,49,'Eduardo Sachelli','11','6363-0463','11','3871-1077','eduardo.sachelli@ribeirocaram.com.br',1924),
(85088,31208,16,'Celso Vieira','11','3871-1077','11','3673-3290','celso@ribeirocaram.com.br',1924),
(85089,31208,21,'Fábio Germano (Gerente de Engenharia)','15','3235-3600 - R. 3637','15','3235-3602','fabio.germano@gm.com',15537),
(85090,31208,20,'Celso Vieira','11','3871-1077','11','3673-3290','celso@ribeirocaram.com.br',1924),
(79650,31209,16,'Alberto Carvalho','11','3069-3970','11','3069-3970','alberto.carvalho@edalco.com.br',13847),
(79651,31209,20,'Vicente','11','3069-3970','11','3069-3970','jose.jesus@edalco.com.br',13847),
(89418,31209,49,'José Jesus','11','3294-1115','11','3069-3970','jose.jesus@edalco.com.br',13847),
(102438,31209,21,'Sdiney Charf','11','3069-3970','11','3069-3970','sdiney.charf@edalco.com.br',13847),
(79652,31210,16,'Alberto Carvalho','11','3069-3970','11','3069-3970','alberto.carvalho@edalco.com.br',13847),
(79653,31210,49,'Fernando Pereira','11','3069-3970','11','3069-3970','fernando.pereira@edalco.com.br',13847),
(79654,31210,20,'Ivair Alencar','11','3069-3970','11','3069-3970','ivair.alencar@edalco.com.br',13847),
(102429,31210,21,'Osvaldo Nonini / Sidney Charf','11','3069-3970','11','3069-3970','',13847),
(79655,31211,16,'Alberto Carvalho','11','3069-3970','11','3069-3970','alberto.carvalho@edalco.com.br',13847),
(79656,31211,49,'Pacoali Perrucci','11','3069-3970','11','3069-3970','pascoali.perrucci@edalco.com.br',13847),
(79657,31211,20,'Derivan Paiva','11','3069-3970','11','3069-3970','derivan.paiva@edalco.com.br',13847),
(102431,31211,21,'Osvaldo Nonini / Sidney Charf','11','3069-3970','11','3069-3970','',13847),
(79659,31212,16,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79660,31212,49,'Taís Scarpin','11','2283-6316','11','2283-6316','tais@alvesbarcelos.com.br',15024),
(79661,31212,20,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79662,31213,16,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79663,31213,49,'Taís Scarpin','11','2283-6316','11','2283-6316','tais@alvesbarcelos.com.br',15024),
(79664,31213,20,'Daniele Basile','11','2283-6316','11','2283-6316','daniele@alvesbarcelos.com.br',15024),
(79665,31214,16,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79666,31214,49,'Taís Scarpin','11','2283-6316','11','2283-6316','tais@alvesbarcelos.com.br',15024),
(79667,31214,20,'Daniele Basile (Adm.)','11','2283-6316','11','2283-6316','daniele@alvesbarcelos.com.br',15024),
(79668,31215,16,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79669,31215,49,'Tais Scarpin','11','2283-6316','11','2283-6316','tais@alvesbarcelos.com.br',15024),
(79670,31215,20,'Daniele Basile (Adm)','11','2283-6316','11','2283-6316','daniele@alvesbarcelos.com.br',15024),
(79671,31216,16,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79672,31216,49,'Taís Scarpin','11','2283-6316','11','2283-6316','tais@alvesbarcelos.com.br',15024),
(79673,31216,20,'Daniele Basile (Adm.)','11','2283-6316','11','2283-6316','daniele@alvesbarcelos.com.br',15024),
(79674,31217,16,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79675,31217,49,'Taís Scarpin','11','2283-6316','11','2283-6316','tais@alvesbarcelos.com.br',15024),
(79676,31217,20,'Fábio Bonfim','11','2283-6316','11','2283-6316','fabio@alvesbarcelos.com.br',15024),
(79677,31218,16,'Ana Paula','47','3028-7473','47','3032-9022','anapaula@vectrapar.com.br',7398),
(79678,31218,49,'Mônica Krelling / Mário Aguiar','47','3028-7473','47','3032-9022','monica@vectrapar.com.br',7398),
(79679,31218,20,'Ana Paula','47','3028-7473','47','3032-9022','anapaula@vectrapar.com.br',7398),
(79715,31230,16,'Francieli Emerlin','46','3225-2112','46','3225-2112','compras@mgempreendimentos.com.br',15028),
(79716,31230,49,'Marcelo Gabiati','46','3225-2112','46','3225-2112','',15028),
(79717,31230,20,'Francieli Emerlin','46','3225-2112','46','3225-2112','compras@mgempreendimentos.com.br',15028),
(79718,31231,16,'Henrique Batista','13','3471-4460','13','3472-5291','ragomespacheco@globo.com',6393),
(79719,31231,20,'Henrique Batista','13','3471-4460','13','3472-5291','contato@ragomespacheco.com.br',6393),
(98249,31231,49,'Thiago Pacheco Silva','13','3471-4460','13','3472-5291','contato@ragomespacheco.com.br',6393),
(79721,31232,16,'Arq. Ricardo A. L. de Carvalho','22','9824-9680','22','2771-6422','betarico@gmail.com',9590),
(79722,31232,7,'Arq. Ricardo A. L. de Carvalho','22','9824-9680','22','2771-6422','betarico@gmail.com',9590),
(79723,31232,20,'Arq. Ricardo A. L. de Carvalho','22','9824-9680','22','2771-6422','betarico@gmail.com',9590),
(79724,31233,16,'Ricardo A. L. de Carvalho','22','9824-9680','22','2771-6422','betarico@gmail.com',9590),
(79725,31233,49,'Ricardo A. L. de Carvalho','22','9824-9680','22','2771-6422','betarico@gmail.com',9590),
(79726,31233,20,'Ricardo A. L. de Carvalho','22','9824-9680','22','2771-6422','betarico@gmail.com',9590),
(79727,31234,16,'Laura Monerat','22','9946-7012','22','2771-4947','criarq.projeto@gmail.com',15029),
(79728,31234,49,'Laura Monerat','22','9946-7012','22','2771-4947','criarq.projeto@gmail.com',15029),
(79729,31234,20,'Laura Monerat','22','9946-7012','22','2771-4947','criarq.projeto@gmail.com',15029),
(79730,31235,16,'Fabiano de Souza Barcelos','22','9845-7006','','','fabianobarcel@gmail.com',15030),
(79731,31235,7,'Fabiano de Souza Barcelos','22','9845-7006','','','fabianobarcel@gmail.com',15030),
(79732,31235,20,'Fabiano de Souza Barcelos','22','9845-7006','','','fabianobarcel@gmail.com',15030),
(79733,31236,16,'Fabiano de Souza Barcelos','22','9845-7006','','','fabianobarcel@gmail.com',15030),
(79734,31236,7,'Fabiano de Souza Barcelos','22','9845-7006','','','fabianobarcel@gmail.com',15030),
(79735,31236,20,'Fabiano de Souza Barcelos','22','9845-7006','','','fabianobarcel@gmail.com',15030),
(79736,31237,16,'Engº Bill Márcio P. Coutinho','22','8805-1351','22','2778-1642','billcoutinho@uol.com.br',15031),
(79737,31237,49,'Engº Bill Márcio P. Coutinho','22','8805-1351','22','2778-1642','billcoutinho@uol.com.br',15031),
(79738,31237,20,'Engº Bill Márcio P. Coutinho','22','8805-1351','22','2778-1642','billcoutinho@uol.com.br',15031),
(79739,31238,16,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occl.com.br',821),
(79740,31238,20,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occl.com.br',821),
(79741,31238,49,'Marcelo A. Teixeira Monsanto','22','2665-9009','22','2665-9009','monsanto@occl.com.br',821),
(79742,31239,16,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occ.com.br',821),
(79743,31239,49,'Marcelo A. Teixeira Monsanto','22','2665-9009','22','2665-9009','monsanto@occ.com.br',821),
(79744,31239,20,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occ.com.br',821),
(79745,31240,16,'Célia Rochele','84','3331-2506','84','3331-2506','conpasfalcompras@uol.com.br',15033),
(79746,31240,49,'Ivaldo Amorim','84','3331-2506','84','3331-2506','conpasfal@hotmail.com',15033),
(79747,31240,20,'Lilia Viviane (Licitação)','84','3331-2506','84','3331-2506','liliaviviane@msn.com',15033),
(79748,31241,16,'Vicente Gonçalves','15','3221-9511','15','3221-9511','compras@magnumconst.com.br',9),
(79749,31241,20,'Marcos Galiazzo (Arquiteto)','15','3221-9511','15','3221-9579','arq.marcos@magnumconst.com.br',9),
(79758,31242,21,'José Carlos Novaes','31','3499-8322','31','3499-8381','jose.novaes@usiminas.com',58),
(97103,31242,16,'Sra. Mônia','31','3824-7300','31','3824-7300','049administracao@integralonline.com.br',3789),
(97104,31242,20,'Sra. Mônia','31','3824-8400','31','3824-7300','049administracao@integralonline.com.br',3789),
(97105,31242,49,'Wagner Costa','31','3217-8400','31','3217-7300','wagnercr@integralonline.com.br',3789),
(79764,31243,20,'Mário Schlickmann (Diretor Comercial)','48','8842-5251','48','3333-1770','mario.henrique@mg.copobras.com.br',15034),
(79765,31244,20,'Mário Schlickmann (Diretor Comercial)','48','8842-5251','37','3333-1770','mario.henrique@mg.copobras.com.br',15034),
(85524,31244,21,'Jânio Dinart','48','3657-3000','','','janio@copobras.com.br',15034),
(79766,31245,16,'Paulo Antônio','81','2128-4700','81','2128-4708','obra.polaris@gmail.com',846),
(79767,31245,20,'Paulo Antônio','81','9741-3433','81','2128-4708','obra.polaris@gmail.com',846),
(79768,31245,49,'Décio Milano','81','2128-4700','81','2128-4708','obra.polaris@gmail.com',846),
(79769,31246,16,'Cristina Maria','81','2128-4700','81','2128-4708','caminhaeng@caminha.com.br',846),
(79770,31246,20,'Ingrid Cristina (Vendas)','81','2128-4700','81','2128-4708','caminhaeng@caminha.com.br',846),
(79771,31246,49,'Décio Milano','81','2128-4700','81','2128-4708','caminhaeng@caminha.com.br',846),
(100517,31247,16,'Cida Dias','11','3051-9999','11','3885-1237','cida@tiberio.com.br',1096),
(100518,31247,20,'Luiza Belini (Marketing)','11','3051-9999','11','3885-1237','luiza@tiberio.com.br',1096),
(100519,31247,21,'Luciano Hass','11','3051-9999','11','3885-1237','luciano.hass@tiberio.com.br',1096),
(79772,31248,16,'Wellington Alves','31','2128-3700','31','2128-3770','wellington@masb.com.br',14036),
(79773,31248,21,'José Eduardo','31','2128-3700','31','2128-3770','joseeduardo@masb.com.br',14036),
(79774,31248,20,'Tatiana Linses (Relacionamento)','31','2128-3700','31','2128-3770','relacionamento@masb.com.br',14036),
(79775,31249,16,'Rodrigo Cordasso','19','3432-3551','19','3432-3551','rodrigocordasso@supricelconstrutora.com.br',13675),
(79776,31249,49,'Murilo Coimbra','19','3432-3551','19','3432-3551','murilo.coimbra@supricelconstrutora.com.br',13675),
(79777,31249,20,'Murilo Coimbra (Engenheiro)','19','3422-3158','19','3432-3551','murilo.coimbra@supricelconstrutora.com.br',13675),
(79778,31250,16,'Ricardo Perriraz da Silva','21','9769-5885','21','2609-8769','ricardoperriraz@ig.com.br',15038),
(79779,31250,49,'Ricardo Perriraz da Silva','21','9769-5885','21','2609-8769','ricardoperriraz@ig.com.br',15038),
(79780,31250,20,'Alexandre Rodrigues (Projetista)','21','2609-8769','','','',15038),
(79781,31251,16,'Adelson Vieira','21','3505-9300','21','3114-2083','compras@primelafem.com.br',15037),
(79782,31251,49,'Engº Fred Mendes','21','3505-9300','21','3114-2083','fred@primelafem.com.br',15037),
(79783,31251,20,'Luiz Pimenta (Gerente Adm)','21','3505-9300','21','3114-2083','fred@primelafem.com.br',15037),
(79784,31252,16,'Adilson Vieira','21','3505-9300','21','3505-9333','compras@primelafem.com.br',15037),
(79785,31252,49,'Engº Fred Mendes','21','3505-9333','21','3505-9333','fred@primelafem.com.br',15037),
(79786,31252,20,'Luiz Pimenta (Gerente Adm.)','21','3114-2038','21','3505-9333','fred@primelafem.com.br',15037),
(79790,31253,16,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79791,31253,49,'Diogo Cabral de M. Filho','21','2220-9051','21','2220-9051','diogocmfilho@yahoo.com.br',14804),
(79792,31253,20,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79793,31254,16,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79794,31254,20,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79795,31254,49,'Diogo Cabral de M. Filho','21','2220-9051','21','2220-9051','diogocmfilho@yahoo.com.br',14804),
(79796,31255,16,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79797,31255,20,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79798,31255,49,'Diogo Cabral de M. Filho','21','2220-9051','21','2220-9051','diogocmfilho@yahoo.com.br',14804),
(79799,31256,16,'Elizângela Diniz Alves','11','3884-2466','11','3885-9471','compras@zogbiengenharia.com.br',2846),
(79800,31256,20,'Osvaldo Júnior (Estagiário de Engenharia)','11','3052-3756','11','3884-2466','sppremium@zogbiengenharia.com.br',2846),
(79801,31256,49,'Raphael Gavião','11','3052-3756','11','3884-2466','projeto2@zogbiengenharia.com.br',2846),
(79802,31257,16,'Renata Lucreto / Afonso Gianetti','11','3539-7455','11','3539-7455','compras@kaslik.com.br',15039),
(79803,31257,20,'Alexandre Farias','11','2825-1770','11','3539-7455','alexandre.farias@kaslik.com.br',15039),
(79804,31257,49,'Alexandre Farias','11','2825-1770','11','3539-7455','alexandre.farias@kaslik.com.br',15039),
(79805,31258,16,'Gisela Portelo','21','3416-9001','21','2421-1346','compras@montserrat.com.br',3380),
(79806,31258,49,'Camilo Rebelo Pinto','21','3416-9001','21','2421-1346','crebelo@montserrat.com.br',3380),
(79807,31258,20,'Lílian Mendes (Adm.)','21','3416-9001','21','2421-1346','atendimento@montserrat.com.br',3380),
(79808,31259,20,'Poliane Bastos (Comunicação)','31','3316-8138','31','3316-8454','comunicacao@teksid.com.br',1202),
(79809,31260,20,'Artur Carlos (Dir. financeiro)','47','3436-0355','47','3465-6829','',15041),
(93629,31260,121,'Jacson Nassa (Diretor Infraestrutura)','47','3436-0355','47','3465-6829','jacson@cajadan.com.br',15041),
(79818,31261,16,'Juliana Morais','62','3096-1150','62','3096-1174','compras@enecengenharia.com.br',15019),
(79819,31261,49,'Murilo Santana','62','3215-2724','62','3096-1150','murilo@enecengenharia.com.br',15019),
(79820,31261,20,'Silvio de Almeida (Almoxarifado)','62','3215-2724','62','3096-1150','',15019),
(79821,31262,16,'Edemir Ern','47','3340-2080','47','3340-2080','edemir@speranzini.eng.br',15042),
(79822,31262,20,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79823,31262,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(92217,31262,49,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79824,31263,16,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79825,31263,49,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79826,31263,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79827,31264,16,'André Belk','47','3340-2080','47','3340-2080','andre@speranzini.eng.br',15042),
(79828,31264,20,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79829,31264,49,'André Belk','47','3340-2080','47','3340-2080','andre@speranzini.eng.br',15042),
(79830,31265,16,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79831,31265,20,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79832,31265,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79833,31266,16,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79834,31266,20,'Eng° Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79835,31266,49,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79842,31267,16,'Shirlei Ribeiro','11','3759-8639','11','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(79843,31267,20,'Andreza Costa (Planejamento)','11','3759-8500','11','3759-8600','andrezacosta@rossiresidencial.com.br',366),
(79844,31267,49,'Carlos Marciano','11','3759-8500','11','3759-8600','carlosmarciano@rossiresidencial.com.br',366),
(79845,31268,16,'Shirlei Ribeiro','11','3759-8639','11','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(79846,31268,20,'Andreza Costa (Planejamento)','11','3759-8500','11','3759-8600','andrezacosta@rossiresidencial.com.br',366),
(79847,31268,49,'Carlos Marciano','11','3759-8500','11','3759-8600','carlosmarciano@rossiresidencial.com.br',366),
(79851,31269,49,'Carlos Marciano','11','4058-2000','11','4058-2001','carlosmarciano@rossiresidencial.com.br',366),
(79852,31269,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(89897,31269,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79848,31270,49,'Carlos Marciano','11','4058-2000','11','4058-2001','carlosmarciano@rossiresidencial.com.br',366),
(79849,31270,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(79850,31270,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79853,31271,49,'Carlos Marciano','11','4058-2000','11','4058-2001','carlosmarciano@rossiresidencial.com.br',366),
(79854,31271,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79855,31271,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(79856,31272,16,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79857,31272,49,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79858,31272,20,'Carlos (Atendente)','22','2764-1699','','','',8412),
(79859,31273,16,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79860,31273,49,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79861,31273,20,'Carlos (Atendente)','22','2764-1699','','','',8412)

;

INSERT INTO #Obra
     ([Id_obra],[Obra])

VALUES
(27738,'RE022121'),
(27751,'RE022169'),
(27774,'IN000962'),
(27783,'RE022122'),
(27876,'IN000974'),
(27882,'RE022224'),
(27957,'RE022259'),
(27993,'IN000994'),
(28057,'RE022312'),
(28068,'IN001006'),
(28071,'IN001007'),
(28092,'IN001011'),
(28111,'CO203765'),
(28114,'IN001013'),
(28131,'RE022364'),
(28191,'RE022409'),
(28192,'RE022408'),
(28233,'IN001031'),
(28234,'RE022434'),
(28237,'IN001032'),
(28238,'RE022433'),
(28241,'IN001033'),
(28244,'IN001034'),
(28260,'CO203802'),
(28314,'RE022479'),
(28316,'RE022478'),
(28335,'RE022489'),
(28343,'RE022491'),
(28354,'RE022501'),
(28355,'CO203825'),
(28362,'RE022505'),
(28406,'CO203832'),
(28433,'IN001069'),
(28450,'RE022564'),
(28461,'RE022562'),
(28473,'IN001077'),
(28485,'IN001078'),
(28486,'IN001079'),
(28549,'RE022604'),
(28571,'CO203894'),
(28616,'RE022631'),
(28645,'RE022639'),
(28654,'RE022638'),
(28660,'CO203936'),
(28661,'RE022651'),
(28663,'CO203935'),
(28715,'RE022678'),
(28719,'RE022676'),
(28721,'RE022677'),
(28727,'CO203965'),
(28731,'CO203970'),
(28732,'RE022687'),
(28736,'CO203974'),
(28740,'CO203972'),
(28746,'CO203973'),
(28749,'CO203969'),
(28751,'CO203971'),
(28757,'RE022690'),
(28762,'RE022697'),
(28764,'RE022695'),
(28766,'IN001128'),
(28767,'CO203979'),
(28769,'RE022694'),
(28771,'RE022693'),
(28772,'RE022698'),
(28778,'CO203994'),
(28779,'CO203997'),
(28781,'CO203996'),
(28784,'CO203989'),
(28787,'CO203990'),
(28791,'CO203991'),
(28802,'RE022699'),
(28804,'IN001136'),
(28805,'IN001135'),
(28806,'CO203992'),
(28807,'CO203993'),
(28809,'IN001137'),
(28813,'RE022708'),
(28815,'RE022702'),
(28817,'RE022703'),
(28821,'RE022704'),
(28824,'CO204012'),
(28825,'RE022705'),
(28828,'RE022706'),
(28835,'RE022707'),
(28840,'RE022714'),
(28848,'RE022713'),
(28894,'RE022717'),
(28896,'RE022716'),
(28900,'RE022719'),
(28902,'RE022718'),
(28911,'RE022741'),
(28958,'IN001144'),
(28962,'IN001160'),
(28971,'RE022755'),
(28974,'RE022752'),
(28980,'RE022757'),
(28981,'RE022751'),
(28983,'RE022758'),
(28988,'RE022763'),
(29002,'RE022765'),
(29007,'RE022766'),
(29011,'RE022769'),
(29014,'RE022768'),
(29021,'IN001169'),
(29023,'IN001167'),
(29024,'IN001168'),
(29036,'RE022770'),
(29037,'RE022767'),
(29040,'IN001173'),
(29041,'IN001178'),
(29042,'CO204122'),
(29044,'CO204123'),
(29045,'IN001174'),
(29046,'RE022781'),
(29048,'IN001175'),
(29050,'IN001176'),
(29051,'RE022782'),
(29054,'IN001177'),
(29055,'RE022783'),
(29058,'RE022784'),
(29060,'RE022785'),
(29064,'RE022786'),
(29065,'RE022787'),
(29066,'RE022788'),
(29071,'RE022792'),
(29073,'RE022799'),
(29077,'IN001179'),
(29080,'RE022793'),
(29082,'RE022798'),
(29084,'RE022797'),
(29089,'RE022795'),
(29097,'RE022800'),
(29098,'CO204137'),
(29101,'CO204139'),
(29102,'CO204140'),
(29107,'CO204141'),
(29118,'RE022805'),
(29119,'RE022804'),
(29131,'RE022826'),
(29135,'RE022823'),
(29137,'RE022824'),
(29141,'RE022822'),
(29143,'RE022814'),
(29145,'RE022827'),
(29146,'RE022813'),
(29148,'RE022821'),
(29149,'RE022817'),
(29150,'RE022812'),
(29151,'RE022816'),
(29152,'RE022815'),
(29153,'RE022825'),
(29154,'RE022820'),
(29156,'CO204174'),
(29161,'RE022839'),
(29162,'RE022833'),
(29169,'RE022832'),
(29174,'RE022829'),
(29186,'IN001199'),
(29191,'RE022861'),
(29200,'RE022850'),
(29201,'RE022845'),
(29202,'RE022851'),
(29203,'RE022860'),
(29204,'RE022840'),
(29206,'RE022855'),
(29208,'RE022854'),
(29210,'CO204182'),
(29211,'RE022853'),
(29218,'CO204184'),
(29220,'CO204187'),
(29223,'CO204188'),
(29224,'RE022877'),
(29225,'CO204189'),
(29227,'CO204191'),
(29228,'RE022868'),
(29230,'RE022869'),
(29232,'RE022878'),
(29235,'RE022862'),
(29242,'CO204186'),
(29243,'RE022903'),
(29245,'RE022863'),
(29249,'RE022906'),
(29252,'RE022904'),
(29253,'RE022865'),
(29258,'RE022866'),
(29260,'RE022867'),
(29263,'RE022894'),
(29264,'RE022895'),
(29271,'RE022893'),
(29272,'RE022905'),
(29305,'RE022897'),
(29306,'RE022907'),
(29307,'RE022908'),
(29308,'RE022909'),
(29311,'RE022870'),
(29312,'RE022912'),
(29315,'RE022876'),
(29327,'RE022911'),
(29330,'RE022910'),
(29351,'IN001211'),
(29426,'IN001227'),
(29453,'IN001235'),
(29502,'IN001254'),
(29531,'IN001253'),
(29552,'IN001265'),
(29553,'RE023040'),
(29563,'CO204309'),
(29564,'CO204310'),
(29565,'IN001271'),
(29579,'IN001269'),
(29624,'CO204323'),
(29642,'IN001292'),
(29736,'IN001303'),
(29739,'IN001305'),
(29757,'IN001308'),
(29771,'RE023165'),
(29775,'IN001309'),
(29776,'IN001307'),
(29777,'IN001310'),
(29795,'CO204350'),
(30227,'RE023476'),
(30983,'IN001520'),
(31099,'CO204715'),
(31118,'CO204716'),
(31119,'CO204717'),
(31120,'IN001540'),
(31121,'IN001539'),
(31122,'RE024010'),
(31123,'RE024009'),
(31124,'RE024008'),
(31125,'RE024007'),
(31140,'RE024011'),
(31141,'CO204719'),
(31142,'RE024012'),
(31143,'RE024013'),
(31144,'CO204720'),
(31145,'RE024014'),
(31146,'RE024015'),
(31147,'RE024016'),
(31148,'RE024017'),
(31149,'IN001549'),
(31150,'IN001548'),
(31151,'RE022873'),
(31152,'RE024018'),
(31153,'IN001541'),
(31154,'RE022874'),
(31155,'RE024019'),
(31156,'IN001547'),
(31157,'RE022875'),
(31158,'RE024020'),
(31159,'RE022872'),
(31160,'IN001546'),
(31161,'RE022891'),
(31162,'IN001545'),
(31163,'IN001542'),
(31164,'RE023992'),
(31165,'RE024024'),
(31166,'RE024022'),
(31167,'IN001543'),
(31169,'IN001544'),
(31170,'RE024026'),
(31171,'RE024023'),
(31172,'RE024027'),
(31173,'CO204718'),
(31174,'RE024028'),
(31175,'RE024029'),
(31176,'CO204722'),
(31177,'RE024030'),
(31178,'CO204723'),
(31179,'CO204726'),
(31180,'CO204721'),
(31181,'RE022754'),
(31182,'CO204724'),
(31183,'CO204727'),
(31184,'CO204725'),
(31185,'CO204728'),
(31186,'RE024031'),
(31187,'RE022738'),
(31189,'IN001550'),
(31190,'RE024032'),
(31191,'RE024033'),
(31192,'RE024034'),
(31193,'RE024035'),
(31194,'RE024036'),
(31195,'CO204735'),
(31196,'RE024037'),
(31197,'RE022727'),
(31198,'CO204730'),
(31199,'RE024038'),
(31200,'RE024042'),
(31201,'CO204731'),
(31202,'RE024043'),
(31203,'RE024044'),
(31204,'RE024039'),
(31205,'CO204732'),
(31206,'RE024045'),
(31207,'RE024046'),
(31208,'RE024040'),
(31209,'RE024041'),
(31210,'RE024047'),
(31211,'CO204190'),
(31212,'RE024048'),
(31213,'CO204734'),
(31214,'RE024049'),
(31215,'RE024050'),
(31216,'CO204733'),
(31217,'RE024051'),
(31218,'RE022750'),
(31230,'RE024061'),
(31231,'IN001558'),
(31232,'RE024062'),
(31233,'IN001557'),
(31234,'RE024063'),
(31235,'IN001553'),
(31236,'IN001555'),
(31237,'IN001551'),
(31238,'RE024052'),
(31239,'IN001554'),
(31240,'IN001552'),
(31241,'IN001556'),
(31242,'RE024053'),
(31243,'RE024053'),
(31244,'RE024054'),
(31245,'RE024055'),
(31246,'RE024056'),
(31247,'RE022722'),
(31248,'CO204729'),
(31249,'RE022726'),
(31250,'RE022729'),
(31251,'RE022725'),
(31252,'CO204736'),
(31253,'RE022732'),
(31254,'CO204737'),
(31255,'RE022731'),
(31256,'CO204738'),
(31257,'CO204739'),
(31258,'RE022728'),
(31259,'CO204740'),
(31260,'RE024064'),
(31261,'RE024065'),
(31262,'RE024059'),
(31263,'RE024058'),
(31264,'RE022739'),
(31265,'RE024067'),
(31266,'RE024073'),
(31267,'CO204747'),
(31268,'RE024072'),
(31269,'RE024074'),
(31270,'RE024071'),
(31271,'RE024066'),
(31272,'RE023075'),
(31273,'CO204745')


;

select ' Projeto,Contato1,Cargo1,DDD1,Telefone1,DDDFax1,Fax1,Email1,Empresa01, Contato2,Cargo2,DDD2,Telefone2,DDDFax2,Fax2,Email2,Empresa02, Contato3,Cargo3,DDD3,Telefone3,DDDFax3,Fax3,Email3,Empresa03, Contato4,Cargo4,DDD4,Telefone4,DDDFax4,Fax4,Email4,Empresa04
Contato5,Cargo5,DDD5,Telefone5,DDDFax5,Fax5,Email5,Empresa05, Contato6,Cargo6,DDD6,Telefone6,DDDFax6,Fax6,Email6,Empresa06
Contato7,Cargo7,DDD7,Telefone7,DDDFax7,Fax7,Email7,Empresa07, Contato8,Cargo8,DDD8,Telefone8,DDDFax8,Fax8,Email8,Empresa08
' as 'linha' 
union all
 select o.Obra+','+
( 
  SELECT ContatoNome +','+id_cargo+','+ddd+','+telefone+','+dddfax+','+fax+','+email+',' AS 'data()' 
         FROM #Contato where id_obra = o.Id_obra FOR XML PATH('')
         )
from #Obra as o

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results