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

(61771,24523,16,'Hamilton Pereira da Silva','11','4722-4196','','','',12794),
(61772,24523,7,'Antônio Carlos','11','4727-4457','','','',12793),
(61773,24523,20,'Antônio Carlos','11','4727-4457','','','',12793),
(62035,24634,16,'Roberto Malta','51','3021-5000','51','3021-5400','roberto.malta@stafe.com.br',10705),
(62036,24634,49,'Manuel Luiz Ungaretti Lopes','51','3021-5400','51','3021-5400','luiz@stafe.com.br',10705),
(62037,24634,20,'Manuel Luiz Ungaretti Lopes','51','3021-5000','51','3021-5400','luiz@stafe.com.br',10705),
(62045,24639,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(62090,24659,16,'Ronaldo V. A. Pessoa','22','9219-2959','','','ronaldopessoa@hotmail.com',12832),
(62091,24659,49,'Ronaldo V. A. Pessoa','22','9219-2959','','','ronladopessoa@hotmail.com',12832),
(62092,24659,20,'Ronaldo V. A. Pessoa','22','9219-2959','','','ronaldopessoa@hotmail.com',12832),
(62181,24697,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(62182,24697,49,'Engº Paulo Motta','19','3234-1828','19','3234-1828','paulo.motta@hmengenharia.com.br',14421),
(68317,24697,20,'Gustavo Leme (Marketing)','19','3234-1828','19','3234-1828','gustavo.leme@hmengenharia.com.br',14421),
(68318,24697,29,'Marcos Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(80139,24697,20,'Adriana Ramos (Secretária da Engenharia)','19','3234-1828','19','3234-1828','adriana.ramos@hmengenharia.com.br',14421),
(62208,24709,16,'A definir','83','4009-4050','','','',15798),
(62209,24709,49,'A defiir','83','4009-4050','','','',15798),
(62210,24709,20,'Valdelene Batista','83','4009-4050','','','valdelene@ecomax.eco.br',15798),
(62227,24720,16,'Rosana Franco','11','2114-1234','11','2114-1235','suprimentos@barbara.com.br',300),
(62228,24720,49,'Alexandre Barbosa','11','3742-3144','11','2114-1234','idjardimsul@barbara.com.br',300),
(62229,24720,20,'Willian Oliveira','11','3742-3144','11','2114-1234','idjardimsul@barbara.com.br',300),
(62242,24726,16,'Vagner Silva','21','2493-0094','21','2493-0094','vagner@tecco.com.br',8778),
(62243,24726,49,'Aristeu Ramos','21','2620-8824','21','2493-0094','aristeu@tecco.com.br',8778),
(62244,24726,20,'Reginaldo Costa','21','2620-8824','21','2493-0094','reginaldo@tecco.com.br',8778),
(62248,24728,16,'Bruno Andrade Calixto','22','8808-4506','22','2763-9035','bruno@concretizaincorporacoes.com.br',8580),
(62249,24728,49,'Bruno Andrade Calixto','22','8808-4506','22','2763-9038','bruno@concretizaincorporacoes.com.br',8580),
(62250,24728,20,'Bruno Andrade Calixto','22','8808-4506','22','2763-9035','bruno@concretizaincorporacoes.com.br',8580),
(66367,24730,16,'Marcelo Ribeiro Melo','37','3222-3444','37','3222-3777','ccl.compras@yahoo.com.br',7087),
(66368,24730,49,'Paulo Roberto de Castro','37','3222-3444','37','3222-3444','ccl@mastercabo.com.br',7087),
(73849,24730,20,'Marcelo Ribeiro Melo','37','3222-3444','37','3222-3777','ccl.compras@yahoo.com.br',7087),
(62253,24732,20,'Débora de Fátima (Administrativo)','31','3282-7844','31','3282-7844','topoeng@terra.com.br',2905),
(70953,24732,49,'Antônio Alvin','31','3282-7844','31','3282-7844','topoeng@terra.com.br',2905),
(70954,24732,16,'Departamento de Compras','31','3282-7844','31','3282-7844','topoeng@terra.com.br',2905),
(62254,24733,16,'Walter Senkiio','11','5585-0001','11','5585-0008','waltersenkiio@graalconstrutora.com.br',12850),
(62255,24733,49,'Alexandre Silva','11','5585-0001','11','5585-0008','alexandresilva@graalconstrutora.com.br',12850),
(62256,24733,20,'Alexandre Silva','11','5585-0008','11','5585-0008','alexandresilva@graalconstrutora.com.br',12850),
(62285,24748,20,'Clarindo Lopes (Gerente Geral)','85','3488-9200','85','3488-9211','clarindo@rabelo.com.br',12862),
(62455,24824,16,'Andressa Pereira Brito','17','2137-1700','17','2137-1725','apbrito@rodobens.com.br',1423),
(62456,24824,20,'Márcia Brandão (Gerente de Marketing)','17','2137-1700','17','2137-1725','mbrandao@rodobens.com.br',1423),
(62457,24824,29,'Rodrigo Donizete','17','2137-1700','17','2137-1725','rdonizete@rodobens.com.br',1423),
(62476,24832,16,'Tadeu Souza','17','2137-1700','17','2137-1725','tnsouza@rodobens.com.br',1423),
(62477,24832,20,'Rodrigo Donizete','11','2137-1700','11','2137-1725','rdonizete@rodobens.com.br',1423),
(62478,24832,29,'Rodrigo Donizete','17','2137-1700','17','2137-1725','rdonizete@rodobens.com.br',1423),
(62479,24833,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(62534,24859,16,'Andressa Pedrita','17','2137-1700','17','2137-1700','apedrita@rodobens.com.br',12882),
(62535,24859,20,'Gabriela (Recepção)','11','2173-0900','11','2173-0908','',12882),
(62536,24859,20,'Estevão (Departamento de Obras)','','0800-722-0160','11','2173-0908','',12882),
(62565,24875,16,'José Wilson de Lima','84','3206-2393','84','3206-2393','compras-tecnart@hotmail.com',8275),
(62566,24875,20,'José Wilson de Lima','84','3206-2393','84','3206-2393','compras-tecnart@hotmail.com',8275),
(62567,24875,49,'Henrique Araújo Lima','84','3206-2393','84','3206-2393','contato@tecnarteng.com.br',8275),
(62570,24876,16,'Edilma Martins','84','3206-2393','84','3206-2393','compras@tecnarteng.com.br',8275),
(62571,24876,20,'Edilma Martins','84','3206-2393','84','3206-2393','compras@tecnarteng.com.br',8275),
(62572,24876,49,'Carlos Luis Cavalcante','84','3206-2393','84','3206-2393','contato@tecnarteng.com.br',8275),
(62576,24877,20,'Thierry Mestpag (Engenharia)','21','3621-8545','21','3621-8309','thierry.mestpag@br.michelin.com',11844),
(75289,24877,21,'Ricardo Pereira','21','3621-8591','21','3621-8309','',11844),
(85357,24877,49,'Paulo Fonseca','24','9267-4484/9264-9312','11','3017-8000','hacsouza@construcap.com.br',630),
(85358,24877,16,'Marcos Maia','24','9267-4484/9264-9312','11','3017-8000','mamsouza@construcap.com.br',630),
(62577,24878,20,'Vincenzo Galluzzi','11','3388-6186','11','3329-9397','',441),
(69237,24880,20,'Jefferson Santana','12','3884-2906','12','3884-2906','ctbbrasil@hotmail.com',13777),
(69238,24880,16,'Jefferson Santana','12','3884-2906','12','3884-2906','ctbbrasil@hotmail.com',13777),
(69239,24880,49,'Luís Carlos','12','3884-2906','12','3884-2906','ctbbrasil@hotmail.com',13777),
(62580,24881,20,'Rodrigo Pereira (Gerente de Projetos)','31','3249-3719','31','3249-3719','rodrigo.pereira@itambe.com.br',2863),
(62585,24884,16,'Ercílio Bueno','21','2523-4400','21','2523-4400','ercilio@klacon.com.br',611),
(62586,24884,49,'Maurício Klajman','21','2523-4400','21','2523-4400','mauricio@klacon.com.br',611),
(62587,24884,20,'Elen Santiago (Recepção)','21','2523-4400','21','2523-4400','klacon@klacon.com.br',611),
(62591,24887,16,'Fabíola Magalhães','85','3288-6611','85','3248-1075','compras@colmeia.com.br',1062),
(62592,24887,42,'Otacílio Valente Costa','85','3288-6666','85','3248-2124','construtora@colmeia.com.br',1062),
(62593,24887,20,'Márcio Fonseca','85','3288-6666','85','3248-2124','marcio@colmeia.com.br',1062),
(62625,24900,49,'Egídio Comin','67','3348-3555','67','3348-3500','',863),
(62626,24900,16,'João Carlos Melo','67','2107-3541','67','2107-3531','joaocarlos@egelte.com.br',863),
(80277,24900,20,'João Carlos Melo','67','2107-3541','67','2107-3531','joaocarlos@egelte.com.br',863),
(73824,24902,16,'Sr. Domingos Oliveira (Gerente de Compras)','31','3829-3834','31','3829-3870','domingos.oliveira@usiminasmecanica.com.br',3789),
(88597,24902,20,'Sr. Domingos Oliveira (Gerente de Compras)','31','3829-3834','31','3829-3870','domingos.oliveira@usiminasmecanica.com.br',3789),
(88598,24902,70,'Juliano Fontan','31','3829-3678','31','3829-3870','juliano.souza@usiminasmecanica.com.br',3789),
(62632,24905,16,'Cassiano de Sousa','71','3341-5244','71','3341-1744','cassianodesousa@hotmail.com',2711),
(62633,24905,49,'André Leal','71','3341-5244','71','3341-1744','andreleal@atarde.com.br',2711),
(62634,24905,20,'André Leal','71','3032-0046','71','3341-1744','andreleal@atardi.com.br',2711),
(62692,24928,16,'Célio Aparecido','31','3497-3862','31','3497-3862','cmrconstrutora@yahoo.com.br',12901),
(62693,24928,49,'Edilson Pane','31','3497-3862','31','3497-3862','cmrconstrutora@yahoo.com.br',12901),
(62694,24928,20,'Antunes Braga (Comercial)','31','3497-3862','31','3497-3862','cmrconstrutora@yahoo.com.br',12901),
(62695,24929,16,'Paulo Roberto','21','2249-2826','21','2249-2826','paulo@balassiano.com.br',2568),
(62696,24929,49,'Ramon David Balassiano','21','2249-2826','21','2249-2826','balassianoengenharia@balassiano.com.br',2568),
(62697,24929,20,'Paulo Roberto','21','2249-2826','21','2249-2826','paulo@balassiano.com.br',2568),
(62698,24930,16,'Fernando Luiz / Rita','21','3415-4248','21','3415-4248','aliadosempr@uol.com.br',4065),
(62699,24930,20,'Taiane Ferreira','21','3415-4248','21','3415-4248','aliadosempr@uol.com.br',4065),
(62700,24930,49,'Arq. Francisco J. M. Canário','21','3381-8743','','','aliadosempr@uol.com.br',4065),
(62701,24931,20,'Patrícia Braga (Gerente Geral)','85','3466-1413','85','3466-1323','patricia.braga@intercityhoteis.com.br',12904),
(78745,24931,16,'Patricia Braga','85','3466-1413','85','3466-1323','patricia.braga@intercityhoteis.com.br',12904),
(78746,24931,7,'Silvia Benedetti','85','3466-1413','85','3466-1323','',12904),
(62704,24934,16,'Orlando Tischler','51','3722-4045','51','3722-4433','tischler@tischler.com.br',12906),
(62705,24934,49,'Eduardo Carvalho / Jorge','51','3722-4045','51','3722-4433','',12906),
(62706,24934,20,'Orlando Tischler','51','3722-4045','51','3722-4433','',12906),
(62707,24935,16,'Ailton Menezes Lima','13','3285-6700','13','3285-6702','compras@mendeshoteis.com.br',12907),
(62709,24935,49,'Poliana','13','3285-6700','13','3285-6702','',12907),
(62711,24935,20,'Ailton Menezes Lima','13','3285-6700','13','3285-6702','compras@mendeshoteis.com.br',12907),
(62719,24940,20,'Valdemir Chanquini','41','9646-2046','41','2106-1899','vjc@arteche.com.br',9286),
(62720,24940,49,'Valdemir Chanquini','41','9646-2046','41','2106-1899','vjc@arteche.com.br',9286),
(62722,24940,16,'Valdemir Chanquini','41','9646-2046','41','2106-1899','vjc@arteche.com.br',9286),
(62726,24943,16,'Carlos Casado','11','2909-1129','11','2201-0340','carlos@casadosconstrutora.com.br',471),
(62729,24943,49,'Fábio Casado','11','2909-1129','11','2201-0340','fabio@casadosconstrutora.com.br',471),
(62730,24943,20,'Carlos Casado','11','2909-1129','11','2201-0340','carlos@casadosconstrutora.com.br',471),
(62731,24944,16,'Armando Vieira São Bento','21','9975-7116','21','2437-5927','avsbento@terra.com.br',5813),
(62732,24944,49,'Armando Vieira São Bento','21','9975-7116','21','2437-5927','avsbento@terra.com.br',5813),
(62733,24944,20,'Armando Vieira São Bento','21','9975-7116','21','2437-5927','avsbento@terra.com.br',5813),
(62734,24945,16,'Valdir Almeida','61','3345-9000','61','3345-9057','valdir@jcgontijo.com.br',5177),
(62735,24945,20,'Whitney Pacífico','61','3563-3111','61','3345-9000','whitney.pacifico@jcgontijo.com.br',5177),
(71522,24945,49,'Whitney Pacífico','61','3563-3111','61','3345-9000','whitney.pacifico@jcgontijo.com.br',5177),
(62736,24946,16,'Valdir Almeida','61','3345-9000','61','3345-9057','valdir@jcgontijo.com.br',5177),
(62737,24946,20,'Asaías Oliveira (Almoxarifado)','61','3381-0412','61','3345-9000','asaias.oliveira@jcgontijo.com.br',5177),
(71521,24946,49,'Nestor Júnior','61','3381-0412','61','3345-9000','nestor.junior@jcgontijo.com.br',5177),
(62750,24951,20,'Flávio Almeida (Diretor Comercial)','12','3906-2000','12','3906-2005','flavio@spani.com.br',12914),
(62753,24953,16,'Sr. Eleandro Cardoso','21','2432-4666','21','2432-4667','cardoso@labesmelo.com.br',851),
(62754,24953,49,'Tácito Melo Barbosa','21','2429-5047','21','2432-4667','',851),
(62755,24953,20,'José Francisco','21','2432-4666','21','2432-4667','',851),
(62759,24955,16,'Sr. Eleandro Cardoso','21','2432-4666','21','2432-4667','cardoso@labesmelo.com.br',851),
(62760,24955,49,'Tácito Melo Barbosa','21','2429-5047','21','2432-4667','',851),
(62761,24955,20,'José Francisco','21','2432-4666','21','2432-4667','',851),
(62768,24958,16,'Mário Eustáquio','31','3264-0899','31','3264-0999','suprimentos@patrimar.com.br',4538),
(62769,24958,49,'Lucas Couto','31','3378-1394','31','3264-9999','',12912),
(62770,24958,20,'Renato Feliciano','31','3378-1394','31','3264-0899','',12912),
(62774,24960,16,'Edmar Lucas','31','3497-3862','31','3497-3862','compras@cmrconstrutora.com',12901),
(62775,24960,49,'Antônio Fernando','31','3497-3862','31','3497-3862','cmrconstrutora@yahoo.com',12901),
(62776,24960,20,'Antunes Braga (Comercial)','31','3497-3862','31','3497-3862','engenharia@cmrconstrutora.com',12901),
(62786,24964,16,'Fábio dos Santos','11','3168-1788','11','3168-1788','fabio.santos@anfab.net',12916),
(62787,24964,49,'Marçal Moreira Prentel','11','3081-3211','11','3088-0518','marcal@cozman.com.br',302),
(62788,24964,20,'Arlene (Recepção)','11','3081-32111','11','3088-0518','cozman@cozman.com.br',302),
(62795,24969,16,'Valdir Almeida','61','3345-9000','61','3345-9057','valdir@jcgontijo.com.br',5177),
(62796,24969,49,'José Roberto','61','3345-9000','61','3345-9057','',5177),
(62797,24969,20,'Gláucia (Engenharia)','61','3345-9000','61','3345-9057','',5177),
(69188,25012,49,'Flávio Tomas / Amauri Montes','11','4195-4898','11','4195-3174','suprimentos@diase.com.br',4357),
(69189,25012,16,'Milton Guerzone','11','4195-4898','11','4195-3174','suprimentos@diase.com.br',4357),
(62895,25015,16,'Maria Aparecida','11','4095-7500','11','4095-7503','cidinha@planoeplano.com.br',2209),
(62896,25015,21,'Arnaldo / Arão','11','4095-7500','11','4095-7503','',2209),
(62897,25015,20,'Ana Paula Soares (Coord. Projetos)','11','4095-7500','11','4095-7503','anapaula.soares@planoeplano.com.br',2209),
(69493,25016,16,'Maria Aparecida','11','4095-7500','11','4095-7503','cidinha@planoeplano.com.br',2209),
(69494,25016,20,'Ana Paula Soares (Coordenadora de Projeto)','11','4095-7500','11','4095-7503','anapaula.soares@planoeplano.com.br',2209),
(69495,25016,21,'Plácido Olivatti / Cláudio / Gustavo','11','4095-7500','11','4095-7503','placido@planoeplano.com.br',2209),
(62935,25033,16,'Andréia','21','2283-5887','21','2283-5887','candidocampos@superig.com.br',12938),
(62936,25033,7,'Luis C. G. Campos','21','2283-5887','21','2283-5887','candidocampos@superig.com.br',12938),
(62937,25033,20,'Sr. Renato','21','2283-5887','21','2283-5887','',12938),
(62947,25037,16,'Roney do Espírito Santo','27','3200-3456','27','3200-3456','roneycompras@ibeza.com.br',7919),
(62948,25037,49,'Alice Beliza','27','3200-3456','27','3200-3456','alice@dacaza.com.br',7919),
(62949,25037,20,'Flávio Zamborlin (Marketing)','27','3200-3456','27','3200-3456','flavio@dacaza.com.br',7919),
(62961,25043,49,'Sra. Alice','27','3200-3456','27','3325-6937','',7919),
(62962,25043,16,'Roney do Espírito Santo','27','3200-3456','27','3325-6937','roney.compras@ibeza.com.br',7919),
(62998,25067,16,'Engª Marileide Siqueira','11','4612-3339','11','4612-3339','mari@blmempreendimentos.com.br',12947),
(62999,25067,49,'Marco Aurélio','11','4612-3339','11','4612-3339','marcoaurelio@blmempreendimentos.com.br',12947),
(63000,25067,20,'Marco Aurélio (Engenheiro)','11','4612-3339','11','4612-3339','marcoaurelio@blmempreendimentos.com.br',12947),
(63003,25069,16,'Felippe França','11','5536-0005','11','5533-9898','suprimentos@msbsanchez.com.br',3331),
(71430,25069,20,'Rodrigo Sanches','11','5093-9016','11','5536-0005','sl@msbsanchez.com.br',3331),
(71484,25069,21,'Silvio Sanchez','11','5536-0005','11','5536-0005','sl@msbsanchez.com.br',3331),
(86514,25069,49,'Rodrigo Sanchez','11','5536-0005','11','5533-9898','rl@msbsanchez.com.br',3331),
(63039,25085,16,'Marcelo Andrade','21','2621-5853','21','2621-5853','luxorconstrucoes@hotmail.com',6785),
(63040,25085,49,'Eng. Yvan Fattori Pimenta','21','2621-5853','21','2621-5853','luxorconstrucoes@hotmail.com',6785),
(63041,25085,20,'Alexandre Telles (Arquiteto)','21','2621-5853','21','2621-5853','luxorconstrucoes@hotmail.com',6785),
(63045,25088,16,'Mário Eustáquio','31','3264-9999','31','3264-0899','mario@patrimar.com.br',4538),
(63046,25088,49,'Mauro Lucas','31','3286-4612','31','3264-9999','obra053@patrimar.com.br',4538),
(63047,25088,20,'Mauro Lucas','31','3286-4612','31','3264-9999','obra053@patrimar.com.br',4538),
(63137,25125,16,'Sra. Nerces','54','3455-7100','54','3455-7100','nerces@vinocap.com.br',12969),
(63138,25125,49,'Ângelo Rossi','54','3455-7100','54','3455-7100','',12969),
(63139,25125,20,'Sra. Nerces','54','3455-7100','54','3455-7100','nerces@vinocap.com.br',12969),
(63173,25138,16,'Geraldo Henrique','81','3244-8186','81','3244-8186','geraldo@gusmaopl.com.br',12966),
(63174,25138,49,'Engº Antônio Nunes','81','9708-4226','81','3244-8186','antonionunes@gusmaopl.com.br',12966),
(63175,25138,20,'Engº Antônio Nunes','81','9708-4226','81','3244-8186','antonionunes@gusmaopl.com.br',12966),
(63177,25139,16,'Flávio de Oliveira','11','5061-2725','11','5062-1466','construtoratropical@terra.com.br',781),
(63178,25139,49,'Lino Antônio Gonçalves','11','5061-2725','11','5062-1466','construtoratropical@terra.com.br',781),
(63179,25139,20,'Sandra Xavier (Financeiro)','11','5061-2725','11','5062-1466','construtoratropical@terra.com.br',781),
(63180,25140,16,'Flávio de Oliveira','11','5061-2725','11','5062-1466','construtoratropical@terra.com.br',781),
(63181,25140,49,'Lino Antônio Gonçalves','11','5061-2725','11','5062-1466','construtoratropical@terra.com.br',781),
(63182,25140,20,'Flávio de Oliveira','11','5061-2725','11','5062-1466','construtoratropical@terra.com.br',781),
(63183,25141,16,'Márcio Grigolon','11','4502-3000','11','4502-3000','marcio.grigolon@cyrela.com.br',1),
(63184,25141,21,'Paulo Nazar','11','4502-3000','11','4502-3001','paulon@cyrela.com.br',1),
(63185,25141,20,'Grasiele Silva (Marketing) / Manuela Vieira','11','4502-3000','11','4502-3000','manuela.v@cyrela.com.br',1),
(63189,25143,16,'Juliana Santos','11','4815-0501','11','4153-9826','gng@gng.com.br',12491),
(63190,25143,49,'Juliana Santos','11','4815-0501','11','4153-9826','gng@gng.com.br',12491),
(63191,25143,20,'Juliana Santos','11','4815-0501','11','4153-9826','gng@gng.com.br',12491),
(63270,25180,16,'Valdeci / Ivan Lira','11','3707-8180','11','3707-8194','ivan@grupovia.com.br',4209),
(63271,25180,49,'Fábio Teixeira','11','2441-9566','11','3707-8180','fabio.teixeira@grupovia.com.br',4209),
(63272,25180,20,'Andréia Silva','11','2441-9566','11','3707-8180','andreia.silva@grupovia.com.br',4209),
(68526,25192,49,'Carlos Suzuki','11','3321-6253','11','3311-2700','csuzuki@tejofran.com.br',7341),
(68527,25192,16,'Jair Ribeiro','11','3311-2700 R: 228','11','3311-2700 R: 220','jribeiro@tejofran.com.br',7341),
(68528,25192,20,'Jair Ribeiro','11','3311-2700 R: 228','11','3311-2700 R: 220','jribeiro@tejofran.com.br',7341),
(63309,25197,49,'Alessandra Xisto','31','3275-1689','31','3343-8000','alessandra@agmar.com.br',4457),
(72060,25197,20,'Valdeci Soares (Comercial)','31','3275-1689','31','3343-8000','xlxsoares@hotmail.com',4457),
(72062,25197,16,'Cláudia Monti','31','3343-8000','31','3343-8032','suprimentos@agmar.com.br',4457),
(63340,25212,16,'Caio Carneiro da Cunha','81','3482-0720','81','3482-0720','ccestrada@ig.com.br',12995),
(63341,25212,49,'Fernando Barreto','81','3482-0720','81','3482-0720','ccestrada@ig.com.br',12995),
(63342,25212,20,'Fernando Barreto','81','3482-0720','81','3482-0720','ccestrada@ig.com.br',12995),
(63427,25247,16,'Adalberto Feres','11','3054-8500','11','3054-8501','adalberto@ryazbek.com.br',653),
(63428,25247,21,'Eduardo Pereira / Renato Tuono','11','3054-8500','11','3054-8501','epereira@ryazbek.com.br,rtuono@ryazbek.com.br',653),
(63429,25247,20,'Washington Lobo (Incorporação)','11','3054-8500','11','3054-8501','wlobo@ryazbek.com.br',653),
(63433,25250,20,'Ricardo (Diretor de Obras)','11','3146-7009','11','3146-7470','',9093),
(63437,25253,16,'Nelson Muniz','11','3176-1486','11','3296-0150','nelson.muniz@pdg.com.br',13009),
(99206,25253,20,'Nelson Muniz','11','3176-1486','11','3296-0150','nelson.muniz@pdg.com.br',13009),
(63446,25256,20,'Stanley Faccin Moreira','28','8111-0535','28','3542-2115','sath@sath.com.br',13011),
(71992,25256,16,'Stanley Faccin Moreira','28','8111-0535','28','3542-2115','sath@sath.com.br',13011),
(71993,25256,49,'Marcos Aurélio Santos','28','8111-0535','28','3542-2115','sath@sath.com.br',13011),
(63517,25281,20,'Setor de Licitação','41','3330-3636','41','3330-3340','',463),
(63538,25289,16,'Bartolomeu','75','2101-4771','75','2101-4777','bartolomeu@rcarvalho.com.br',12997),
(63539,25289,49,'José Luís Carneiro de Souza','75','2101-4777','75','2101-4777','joseluis@rcarvalho.com.br',12997),
(63540,25289,20,'Suely Mota (Imobiliária)','75','2101-4777','75','2101-4777','suely@rcarvalho.com.br',12997),
(63541,25290,16,'Bartolomeu','75','2101-4771','75','2101-4777','bartolomeu@rcarvalho.com.br',12997),
(63542,25290,49,'José Luís Carneiro de Souza','75','2101-4777','75','2101-4777','joseluis@rcarvalho.com.br',12997),
(63543,25290,20,'Suely Mota (Imobiliária)','75','2101-4771','75','2101-4777','suely@rcarvalho.com.br',12997),
(63550,25293,16,'Arq. Sônia Regina Damigo','22','2665-7913','22','2665-0227','srd_damigo@hotmail.com',1007),
(63551,25293,7,'Arq. Sônia Regina Damigo','22','2665-7913','22','2665-0227','srd_damigo@hotmail.com',1007),
(63552,25293,20,'Sr. Amarildo','22','2665-7913','22','2665-0227','',1007),
(71561,25295,16,'Alberto Brito','11','4890-0020','11','4890-0022','alberto.brito@grupogmr.com.br',5995),
(71562,25295,20,'Alberto Brito','11','4890-0020','11','4890-0022','alberto.brito@grupogmr.com.br',5995),
(71563,25295,106,'Marcos Teixeira','11','4890-0020','11','4890-0022','marcos.cunha@grupogmr.com.br',5995),
(93655,25295,21,'Klaus Weimer','11','4890-0020','11','4890-0022','klaus.weimer@grupogmr.com.br',5995),
(63559,25296,16,'Daniel Oswaldo Ramos','65','3627-7073','65','3627-7073','diazulhotel@hotmail.com',13023),
(63560,25296,7,'Nelson Nastás','45','3225-1116','45','3225-1116','nastas@nbcarquitetura.com.br',13024),
(63561,25296,20,'Daniel Oswaldo Ramos','65','9605-6480','65','3627-7073','diazulhotel@hotmail.com',13023),
(63581,25306,16,'João Carlos','27','3314-1177','27','3314-1491','joao@tumaconstrutora.com.br',10102),
(63582,25306,49,'Ciro Tuma','27','3314-1177','27','3314-1491','',10102),
(63583,25306,20,'Valtair Nonato (Mestre de Obras)','27','3317-4704','27','3314-1177','',10102),
(63587,25308,16,'Setor de Compras','21','3535-4000','','','',1035),
(63588,25308,49,'Marcelo Silva Neto','21','3535-4000','','','msn@concremat.com.br',1035),
(63589,25308,20,'Cristiane Cardoso (Controle)','21','3535-4000','','','cristiane.cardoso@concremat.com.br',1035),
(63590,25309,20,'Engº Arnaldo Cruz','11','4449-5588','11','4449-5588','arnaldocruz@sabesp.com.br',13027),
(63702,25355,16,'Paulo Henrique','79','3225-6600','79','3225-6601','suprimentos@laredo.com.br',8801),
(63703,25355,49,'Clara Carvalho','79','3225-6600','79','3225-6601','suprimentos@laredo.com.br',8801),
(63704,25355,20,'Aurea Ávila','79','3225-6600','79','3225-6601','aureaavila@laredo.com.br',8801),
(63713,25359,16,'Luciana Andrade','81','3465-8033','81','3465-8033','compras@conlar.com',3069),
(63714,25359,49,'Sandro Serra','81','3427-0331','81','3465-8033','sandroserra@conlar.com',3069),
(63715,25359,20,'Jeani Fernandes','81','3427-0331','81','3465-8033','conlar@conlar.com',3069),
(63744,25375,16,'Fernando Purves','11','5501-0000','11','5501-0102','fernando.purves@metodo.com.br',875),
(63745,25375,49,'Caio Machado','11','3171-1463','11','5501-0000','caio.machado@metodo.com.br',875),
(63746,25375,20,'Durvalino Teodoro (Adm.)','11','3171-1463','11','5501-0102','durvalino.teodoro@metodo.com.br',875),
(63756,25381,20,'Adenilson Demarchi','19','3545-9969','19','3545-9993','demarchi@buschinelli.com.br',4851),
(63757,25381,16,'Adenilson Demarchi','19','3545-9969','19','3545-9993','demarchi@buschinelli.com.br',4851),
(63816,25404,20,'Flávio Müller (Secret. de Obras)','24','9993-1565','24','3332-1698','pmrc.rj@ig.com.br',9641),
(63875,25431,16,'Wando Couto Rodrigues','22','2643-3610','22','2643-3610','fegcf@globo.com',9177),
(63876,25431,49,'Engº Euclides Tarrer','22','2643-3610','22','2643-3610','fegcf@globo.com',9177),
(63877,25431,20,'Sr. Carlos','22','2643-3610','22','2643-3610','',9177),
(63887,25437,16,'Renato Bolsas','31','3339-5800','31','3339-5801','compras@habitare.com.br',12244),
(63888,25437,70,'Cézar Augusto','31','3319-8110','31','3339-5801','cezaraugusto@habitare.com.br',12244),
(71768,25437,20,'Cézar Augusto','31','3319-8110','31','3339-5801','cezaraugusto@habitare.com.br',12244),
(88676,25437,49,'Júlio Monteiro','31','3339-5800','31','3339-5801','julio.monteiro@habitare.com.br',12244),
(71339,25438,49,'Daniel Volpini','31','2516-3452','31','3339-5800','danielv@habitare.com.br',12244),
(85216,25438,20,'Mariana Passos','31','3339-5800','31','3339-5801','marianapassos@habitare.com.br',12244),
(63896,25444,20,'Jaqueline Pimenta (Engenharia)','85','3101-4387','85','3181-9675','jaqueline@seduc.ce.gov.br',15593),
(100387,25446,20,'Nilberto Lang Jr. (Sup. Obras de geração)','41','3331-2373','41','3331-4704','nilbertojr@copel.com',889),
(86134,25448,21,'Cláudio Falcão (Superint. Gestão de Implantação)','41','3310-5615','41','3331-3588','claudio.falcao@copel.com',889),
(86135,25448,20,'Cláudio Falcão (Superint. Gestão de Implantação)','41','3310-5615','41','3331-3588','claudio.falcao@copel.com',889),
(97061,25448,21,'Nelson Saks (Gestão de Implantação)','41','3310-5499','','','',889),
(63916,25456,16,'Renato Bolsas','31','3339-5800','31','3339-5801','compras@habitare.com.br',12244),
(63917,25456,20,'Cézar Augusto','31','3339-8106','31','3339-5801','cezaraugusto@habitare.com.br',12244),
(71767,25456,70,'Cézar Augusto','31','3339-8106','31','3339-5801','cezaraugusto@habitare.com.br',12244),
(88673,25456,49,'Glauber Hollervach','31','3339-5800','31','3339-5801','glauber.hollervach@habitare.com.br',12244),
(63959,25471,16,'Dilson','21','2637-3943','','','idealmarica@hotmail.com',13066),
(63960,25471,49,'Jaline Lima','21','9412-6254','','','',13066),
(63961,25471,20,'Sr. Antônio','21','2637-3943','','','',13066),
(63962,25472,16,'Valdir Martins','11','3165-3400','11','3165-8910','valdir@lucianowertheim.com.br',334),
(63963,25472,29,'Oswaldo Wertheim','11','3165-3400','11','3078-8910','',334),
(63964,25472,20,'Valdir Martins','11','3165-3400','11','3078-8910','valdir@lucianowertheim.com.br',334),
(63980,25479,16,'Rogério Campos','11','3131-1100','11','3131-1101','rogeriocampos@qgdi.com.br',8881),
(63981,25479,20,'Regina Silva (Pós Obra)','11','3131-1100','11','3131-1101','regina.silva@qgdi.com.br',8881),
(63982,25479,103,'Mauro Rego (Obras)','11','3131-1100','11','3131-1101','mauro.rego@qgdi.com.br',8881),
(83829,25479,16,'Gláucia Espanha','11','3131-1100','11','3131-1101','glaucia@qgdi.com.br',8881),
(64027,25498,70,'Rodrigo Ugioni','48','3461-8100','48','3461-8100','rodrigo@construtorafontana.com.br',3509),
(64028,25498,20,'Diórgia Barbosa (Marketing)','48','3461-8100','48','3461-8100','diorgia.barbosa@construtorafontana.com.br',3509),
(64029,25498,16,'Marcos Ritta / Fábio Steiner','48','3461-8100','48','3461-8100','compras@construtorafontana.com.br',3509),
(91278,25498,49,'Richard Vagner Bruch','48','3461-8100','48','3461-8100','richard@construtorafontana.com.br',3509),
(64039,25502,16,'Elaine Paes Leme','21','2620-2212','21','2620-2212','compras@placon-construcao.com.br',650),
(64040,25502,49,'Eng. Gilberto Gonçalves','21','2620-2212','21','2620-2212','',650),
(64041,25502,20,'Engº Gilberto Gonçalves','21','2620-2212','21','2620-2212','diretoria@placon-construcao.com.br',650),
(71256,25509,49,'José Guilherme','44','3224-8557','44','3224-8557','construtorapatamar@irapida.com.br',7320),
(71257,25509,20,'Jeferson Januário','44','3224-8557','44','3224-8557','construtorapatamar@irapida.com.br',7320),
(71258,25509,16,'Jeferson Januário','44','3224-8557','44','3224-8557','construtorapatamar@irapida.com.br',7320),
(64053,25510,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(64058,25512,16,'Márcio Augusto','24','2255-2797','24','2252-1779','marcio@consel.com.br',5630),
(64059,25512,49,'Ricardo Chartuni Bandeira','24','2255-2797','24','2252-1779','ricardo@consel.com.br',5630),
(64060,25512,20,'Nara Neves (Adm.)','24','2255-2797','24','2252-1779','nara@consel.com.br',5630),
(64103,25530,16,'Denise Vitor','11','3025-9000','11','3025-9111','dvitor@gafisa.com.br',433),
(64104,25530,49,'Lucas Geremias','11','7812-4167','11','3025-9000','',433),
(64105,25530,20,'Daniele Viana (Adm)','11','3025-9000','11','3025-9111','dsviana@gafisa.com.br',433),
(64114,25533,16,'Ângelo Augusto','16','4009-9499','16','4009-9499','angelo@stefaninogueira.com.br',3351),
(64115,25533,49,'Rafael Peres','16','3972-0623','16','4009-9499','',3351),
(64116,25533,20,'Rafael Peres','16','3972-0623','16','4009-9499','',3351),
(64117,25535,16,'Eng. Sérgio Carpi Guimarães','21','2620-1956','21','2620-1956','sergiocarpi@contese.com.br',13100),
(64118,25535,49,'Sérgio Carpi Guimarães','21','2620-1956','21','2620-1956','sergiocarpi@contese.com.br',13100),
(64119,25535,20,'Sr. Roberto','21','2620-1956','21','2620-1956','',13100),
(64128,25539,16,'Francisco Salvatore','11','4191-6457','11','4195-4696','somaengecon@terra.com.br',14237),
(72954,25539,20,'Francisco Salvatore','11','4191-6457','11','4195-4696','somaengecon@terra.com.br',14237),
(72955,25539,49,'Marco Aurélio','11','4191-6457','11','4195-4696','marco@jsn.eng.br',14237),
(64142,25546,16,'Victor Leles','11','7869-4195','11','2625-2685','victorleles@yahoo.com.br',13102),
(64143,25546,20,'Victor Leles','11','7869-4195','11','2625-2685','victorleles@yahoo.com.br',13102),
(64158,25551,16,'Engº Leandro Pedrosa','22','7835-5619','22','2661-6313','leandropedrosa@hotmail.com',10358),
(64159,25551,49,'Engº Leandro Pedrosa','22','7835-5619','22','2661-6313','leandropedrosa@hotmail.com',10358),
(64160,25551,20,'Sr. Antônio','11','2661-6313','11','2661-6313','',10358),
(64165,25554,20,'Paulo Firmo Souza (Manutenção)','67','3378-2595','67','3378-2500','firmo_souza@ibest.com.br',13106),
(64176,25558,16,'Engº Adelir Lima Correa','21','9512-3014','21','2648-3158','adelir@bol.com.br',3950),
(64177,25558,49,'Engº Adelir Lima Correa','21','9512-3014','21','2648-3158','adelir@bol.com.br',3950),
(64178,25558,20,'Sr. Carlos','21','2648-3158','21','2637-4020','',3950),
(64179,25559,20,'João Aparício / Luciana Pereira (Licitação)','61','3411-3742','61','3326-3025','aparicio.costa@planalto.gov.br',13469),
(70484,25563,16,'Célia Soares','19','3709-1212','19','3709-1250','celia.soares@rossiresidencial.com.br',1683),
(70485,25563,20,'Maria Angela Silva','19','3709-1212','19','3709-1250','mariaangelasilva@rossiresidencial.com.br',1683),
(70486,25563,70,'Emerson Pompeu','11','3759-8600','11','3759-8600','',366),
(64191,25564,20,'Camila Daniel (Marketing)','15','3353-8490','15','3353-8439','camila.daniel@splice.com.br',11445),
(66331,25564,49,'José Bauad','15','3353-8300','15','3353-8489','josebauad@splice.com.br',11445),
(66332,25564,20,'Shirlei Ribeiro','15','3759-8639','15','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(64192,25565,16,'Shirlei Ribeiro','15','3759-8639','15','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(66328,25565,49,'José Bauad','15','3353-8300','15','3353-8439','josebauad@splice.com.br',11445),
(66329,25565,20,'Camila Daniel (Marketing)','15','3353-8490','15','3353-8439','camiladaniel@splice.com.br',11445),
(75564,25568,16,'Célia Soares','19','3709-1212','19','3709-1250','celiasoares@rossiresidencial.com.br',1683),
(75565,25568,20,'Maria Ângela Silva (DAC)','19','3709-1212','19','3709-1250','mariangela@rossiresidencial.com.br',1683),
(75566,25568,70,'Edson Campos','19','3709-1212','19','3709-1250','edsoncampos@rossiresidencial.com.br',1683),
(64201,25569,49,'Huiver Rodrigues','38','9962-0701','38','3671-4553','ciconptu@uol.com.br',11595),
(64202,25569,16,'Simone Noriko','38','3671-4553','38','3671-4553','cicon.simone@gmail.com',11595),
(64203,25569,20,'Huiver Rodrigues','38','9962-0701','38','3671-4553','ciconptu@uol.com.br',11595),
(64204,25570,20,'Vinícius Bassan (Engenharia)','44','8844-4155','44','3234-3535','construhab@visaonet.com.br',11374),
(64205,25570,49,'Vinícius Bassan','44','8844-4155','44','3234-3535','construhab@visaonet.com.br',11374),
(64206,25570,16,'Francisco Benetti','44','3234-3535','44','3234-3535','construhab@visaonet.com.br',11374),
(64214,25578,20,'Daniela Segarra (Licitação)','14','3711-2507','14','3711-2500','licitapmavare@ig.com.br',13118),
(64217,25580,16,'José Maria Júnior','91','4005-3700','91','4005-3701','junior.aranha@portalsintese.com',9057),
(64218,25580,49,'Francisco Nunes','91','3241-0318','91','4005-3700','francisco.nunes@portalsintese.com',9057),
(64219,25580,20,'Francisco Nunes','91','4005-3700','91','4005-3701','francisco.nunes@portalsintese.com',9057),
(64236,25589,16,'Ronaldo Freitas (Engenharia)','11','4799-0008','11','4726-5065','jbianchi@jbianchi.com.br',1277),
(64237,25589,49,'Juliano Bianchi','11','4799-0008','11','4726-5065','jbianchi@jbianchi.com.br',1277),
(64238,25589,20,'Ronaldo Freitas (Engenharia)','11','4799-0008','11','4726-5065','ronaldo.freitas@jbianchi.com.br',1277),
(64260,25598,20,'Eduardo Salim H.','19','3885-7600','19','3885-7624','diretoria@ripbr.com.br',13133),
(64261,25598,121,'Eduardo Salim H.','19','3885-7600','19','3885-7624','diretoria@ripbr.com.br',13133),
(76578,25609,16,'Alessandro Resende','92','3194-1656','92','3236-5518','alessandro.resende@agnet.com.br',8978),
(76579,25609,49,'José Antônio Grajedo','92','3194-1638','92','3194-1630','jose.grajedo@agnet.com.br',8978),
(76580,25609,20,'Roberta Barbosa (Compras)','92','3194-1638','92','3194-1600','roberta.barbosa@agnet.com.br',8978),
(64291,25610,16,'Eliner Torres','11','3736-0050','','','torres@incores.com.br',13134),
(64292,25610,49,'A definir','11','3736-0050','','','',13134),
(64293,25610,20,'Eliner Torres','11','3736-0050','','','torres@incores.com.br',13134),
(70478,25612,20,'Fabiano Bedin','46','3543-4302','46','3543-3093','fabianobedin@yahoo.com.br',13926),
(70479,25612,16,'Sr. Rosângela Centenaro','46','3543-4302','46','3543-3093','irreoloconstrucoes@hotmail.com',13926),
(70480,25612,49,'Fabiano Bedin','46','3543-4302','46','3543-3093','fabianobedin@yahoo.com.br',13926),
(64298,25614,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(64303,25617,16,'Valéria Burkhardt','11','3842-6363','11','3842-9696','valeria@octaengenharia.com.br',13137),
(64304,25617,49,'Ricardo Jabor','11','3842-6363','11','3842-9696','engenharia@octaengenharia.com.br',13137),
(64305,25617,20,'Valéria Burkhardt','11','3842-6363','11','3842-9696','valeria@octaengenharia.com.br',13137),
(64306,25618,16,'David Toufic','21','2132-8210','21','2132-8210','david@novadimensao.com.br',1998),
(64307,25618,49,'A definir','21','2132-8210','21','2132-8210','',1998),
(64308,25618,20,'Julio Nigri (Diretor)','21','2132-8210','21','2132-8210','novadimensao@novadimensao.com.br',1998),
(64312,25620,20,'Juliano Rigatti (Comunicação)','51','3349-4541','51','3349-4442','jrigatti@wmsul.com.br',8269),
(64316,25622,20,'Aparecido Ruiz (Engenharia)','17','4009-6800','17','4009-6857','',13144),
(74403,25622,21,'Carlos Nigro','17','4009-6800','17','4009-6857','nigro@facchini.com.br',13144),
(64317,25623,21,'Aparecido Paulo Felippe','64','3411-8519','64','3411-8500','paulofelippe@mmcb.com.br',13148),
(79649,25623,21,'Wanderlei Pereira','64','3441-7856','64','3411-8500','wanderleipereira@mmcb.com.br',13148),
(97894,25623,49,'Rogério Matidas','34','3236-8600','34','3236-8600','rogeriomatidas@conel.com.br',6339),
(97895,25623,16,'José Alberto','64','8132-8039','64','3411-1814','josealberto@conel.com.br',6339),
(100877,25623,20,'José Alberto','64','8132-8039','64','3411-1814','josealberto@conel.com.br',6339),
(64318,25624,20,'Celso Pinto','46','3524-6060','46','3524-6060','',11494),
(64319,25624,49,'Celso Pinto','46','3524-6060','46','3524-6060','',11494),
(64320,25624,16,'Nilton Rodrigues','46','3523-4519','46','3523-4519','empremac@wln.com.br',11494),
(64330,25628,16,'Marcelo Martinelli','27','3026-8090','27','3026-8090','engenharia@conmar-es.com.br',7303),
(64331,25628,49,'Marcelo Martinelli','27','3026-8090','27','3026-8090','engenharia@conmar-es.com.br',7303),
(64332,25628,20,'Alex (Auxiliar)','27','3026-2840','27','3026-8090','engenharia@conmar-es.com.br',7303),
(64335,25630,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(64336,25630,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(64337,25630,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(64338,25631,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(64339,25631,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(64340,25631,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(64341,25632,16,'Norton C. Maia Júnior','21','3396-0593','21','3975-0031','nortonarquitetos@uol.com.br',983),
(64342,25632,7,'Norton C. Maia Júnior','21','3396-0593','21','3975-0031','nortonarquitetos@uol.com.br',983),
(64343,25632,20,'Norton C. Maia Junior','21','3396-0593','21','3975-0031','nortonarquitetos@uol.com.br',983),
(64344,25633,16,'Antonio Carlos','11','3043-8888','11','3043-8888','carlos@pgg.com.br',16223),
(64345,25633,49,'Berco Michailovici','11','3043-8888','11','3043-8888','meg@pgg.com.br',16223),
(64346,25633,20,'Meg Dalla Costa (Atendimento)','11','3043-8888','11','3043-8888','meg@pgg.com.br',16223),
(64347,25634,16,'Gaston','47','3363-6959','47','3363-6959','s2construtora@s2construtora.com.br',12736),
(64348,25634,49,'Edgar Santos','47','3363-6959','47','3363-6959','edgarsantos02@hotmail.com',12736),
(64349,25634,20,'Edgar Santos','47','3363-6959','47','3363-6959','edgarsantos02@hotmail.com',12736),
(64350,25635,16,'Fábio Dutra','24','3322-0668','24','3322-0668','fabio@s2construtora.com.br',13152),
(64351,25635,49,'Antônio Carlos Couto','24','3322-0668','24','3322-0668','',13152),
(64352,25635,20,'Leandro Martins','24','3322-0668','24','3322-0668','leandromartins_engenharia@yahoo.com.br',13152),
(64353,25636,16,'Amanda Rotta','19','3795-4777','19','3795-4777','amanda.rotta@pdg.com.br',10897),
(72944,25636,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@pdg.com.br',10897),
(72945,25636,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@pdg.com.br',10897),
(64354,25637,16,'Gelson Boss','54','3225-2202','54','3225-2202','gelson@bonauer.com.br',3662),
(64355,25637,49,'Eduardo Niederauer','54','3225-2202','54','3225-2202','eduardo@bonauer.com.br',3662),
(64356,25637,20,'Eduardo Niederauer','54','3225-2202','54','3225-2202','eduardo@bonauer.com.br',3662),
(64357,25638,16,'Gilson Boss','54','3225-2202','54','3225-2202','bonauer@bonauer.com.br',3662),
(64358,25638,49,'Eduardo Niederauer','54','3225-2202','54','3225-2202','bonauer@bonauer.com.br',3662),
(64359,25638,20,'Eduardo Niederauer','54','3225-2202','54','3225-2202','bonauer@bonauer.com.br',3662),
(64360,25639,16,'Antônio Mendes','85','3248-1179','85','3248-1179','antoniomendes@queirozgalvao.com.br',13153),
(64361,25639,49,'Cláudio Vasconcelos','85','3248-1179','85','328-1179','claudio@galvao.com',13153),
(64362,25639,20,'Rodrigo Monteiro','85','3248-1179','85','3248-1179','romonteiro@galvao.com',13153),
(64374,25644,16,'Lucicélia Sarturi','11','3094-1855','11','3813-6447','luci.c@chemin.com.br',3452),
(64375,25644,29,'Eraldo Osele','11','3094-1855','11','3813-6447','osele@chemin.com.br',3452),
(64376,25644,20,'Gleisa (Comercial)','11','3094-1855','11','3813-6447','chemin@chemin.com.br',3452),
(64377,25645,16,'Lucicélia Sarturi','11','3094-1855','11','3813-6447','luci.c@chemin.com.br',3452),
(64378,25645,29,'Eraldo Osele','11','3094-1855','11','3813-6447','osele@chemin.com.br',3452),
(64379,25645,20,'Tatiana Santos (Administrativa)','11','3094-1855','11','3813-6447','tatiana@chemin.com.br',3452),
(64476,25680,21,'Wagner Aleluia','62','3092-6464','62','3092-6464','wagneraleluia@yahoo.com.br',7757),
(70742,25680,20,'Pedro Sousa (Comercial)','62','3092-6464','62','3092-6464','pedro@eneverde.com.br',7757),
(64504,25693,16,'Ernesto Santos','81','3092-6800','81','3092-6801','ernesto@grupocm.com.br',11788),
(64505,25693,49,'Álvaro Meira / Larissa','81','3092-6800','81','3092-6801','',11788),
(64506,25693,20,'Eulina Ferraz (Engenharia)','81','3092-6800','81','3092-6801','eulinaferraz@grupocm.com.br',11788),
(72881,25702,92,'Bernado Bitencourt','47','8805-8198','47','3351-3060','',12218),
(72882,25702,20,'Bernado Bitencourt','47','8805-8198','47','3351-3060','',12218),
(64612,25735,16,'Fernando Guedes','31','3225-2122','31','3225-2122','fernando@becker.com.br',13194),
(64613,25735,49,'Maurício Becker','31','3225-2122','31','3225-2122','',13194),
(64614,25735,20,'Jaqueline Coutinho','31','3225-2122','31','3225-2122','becker@becker.com.br',13194),
(64622,25737,20,'Júlio César Roberti V.','11','2681-3892','11','2681-3879','',12315),
(64625,25739,20,'Juraci (Licitação)','41','3221-6117','41','3221-6117','',4155),
(64626,25740,20,'Hemerson Albuquerque (Licitação)','11','3293-4665','11','3293-4689','',2268),
(64628,25742,20,'Wallace Gomes ( Adm. de obras)','11','3947-1700/01/06','11','5504-5050','',1442),
(106838,25742,16,'Celso Beloti','11','3947-1700/01/06','11','5504-5050','celsoantonio@hfc.com.br',1442),
(106839,25742,49,'Flávio Barbosa','11','3947-1700/01/06','11','5504-5050','flaviob@hfc.com.br',1442),
(64647,25749,16,'Mariana','31','3488-5000','31','3488-9023','compras@angloengenharia.com.br',13201),
(64648,25749,49,'Antonio Carlos','31','3488-5000','31','3488-9023','anglo@angloengenharia.com.br',13201),
(64649,25749,20,'Meire Lustosa','31','3488-5000','31','3488-9023','anglo@angloengenharia.com.br',13201),
(64768,25793,16,'José Augusto','98','3235-8536','98','3235-8536','escudo.geral@terra.com.br',9730),
(64769,25793,49,'Roberto Dualib','98','3235-8536','98','3235-8536','',9730),
(64770,25793,20,'Joilma Farias (Comercial)','98','3235-8536','98','3235-8536','escudo.geral@terra.com.br',9730),
(64794,25802,20,'André Aherzog (Infra Estrutura)','21','2563-2571','21','2563-4061','aherzog@firjan.org.br',2081),
(64798,25804,16,'Luiz Carlos Nunes','11','3041-2700','11','3041-5601','luiz.nunes@ldisa.com.br',586),
(64799,25804,20,'Thalyta Gianesella (Estagiária de Engenharia)','13','3223-1358','11','3041-2700','thalyta.gianesella@lindenberg.com.br',586),
(85230,25804,49,'Sandra Estevez','13','3223-1358','11','3041-2700','sandra.estevez@lindenberg.com.br',9224),
(64821,25812,16,'Simone Viana','81','3465-3877','81','3465-3877','comprasrecife@falcaoempreendimentos.com.br',12821),
(64822,25812,49,'Fernando Porto','81','3465-3877','81','3465-3877','',12821),
(64823,25812,20,'Ana Paula','81','3228-1364','81','3465-3877','',12821),
(64845,25820,16,'Karina Sabino','31','2108-1959','31','2108-1981','ksabino@egesa.com.br',7465),
(74047,25820,49,'Weber Chaves','96','3521-1681','31','2108-1959','wchaves@egesa.co.br',7465),
(74048,25820,20,'Karina Sabino','31','2108-1959','31','2108-1981','ksabino@egesa.com.br',7465),
(64930,25859,16,'Gilson Miranda','11','3509-6024','11','5504-7556','suprimentos@dmoeng.com.br',289),
(64931,25859,20,'Érica (Atendimento)','11','3509-6024','11','5504-7556','dmo@dmoeng.com.br',289),
(64932,25859,20,'Valdeir (Incorp./Marketing)','11','3509-6000','11','5504-7556','dmo@dmoeng.com.br',289),
(94945,25859,70,'Thomas Barthel','11','3509-6024','11','5504-7556','thomas.barthel@dmoeng.com.br',289),
(64952,25867,49,'José Henrique','48','3234-0040','48','3234-0040','henrique@gpinheiro.com.br',4825),
(64953,25867,20,'Gabriela Cardoso (Atendimento)','48','3234-0040','48','3234-0040','contato@gpinheiro.com.br',4825),
(80462,25867,16,'Alessandro Ávila','48','3234-0040','48','3234-0040','compras@gpinheiro.com.br',4825),
(65151,25943,16,'Julioney Antunes','31','3490-4395','31','3490-4395','julioney.antunes@construtoradinamo.com.br',13278),
(65152,25943,49,'Francisco Carlos Gonçalves Prates','31','8421-4566','31','3491-4395','francisco@construtoradinamo.com.br',13278),
(65153,25943,20,'Francisco Carlos Gonçalves Prates','31','8421-4566','31','3490-4395','francisco@construtoradinamo.com.br',13278),
(65163,25947,16,'Rafael de Souza','48','3632-0006','48','3632-0006','rafael@athena.com.br',13279),
(65164,25947,67,'Conrado Fausti (Gerente Técnico)','48','3632-0006','48','3632-0006','conrado@athena.com.br',13279),
(65165,25947,20,'Carla Custódio (Relacionamento)','48','3632-0006','48','3632-0006','relacionamento@athena.com.br',13279),
(88967,25947,16,'Luciane Pereira','48','3632-0006','48','3632-0006','luciane@athena.com.br',13279),
(65206,25963,16,'Lúcia Ono / Kelly Guilherme','11','5589-6000','11','5589-6539','lucia@tarjab.com.br,kelly@tarjab.com.br',800),
(65207,25963,42,'Carlos Alberto Borges','11','5589-6000','11','5589-6539','carlos.borges@tarjab.com.br',800),
(65208,25963,20,'Ricardo Campane (Marketing)','11','5589-6000','11','5589-6539','campane@tarjab.com.br',800),
(87851,25963,21,'Sérgio Fernando','11','5589-600','11','5589-6539','sergio@tarjab.com.br',800),
(65212,25965,20,'Paula Pesareli','11','6370-0917','','','paula.pesareli@globo.com',13289),
(65213,25965,31,'João Antônio Pesareli','11','3563-1556','11','3563-1556','',13289),
(65224,25971,20,'Stênia Araujo (Financeiro)','81','3439-1547','81','3439-1547','',6998),
(72603,25971,49,'Georgi Scavuzzi','81','3439-1547','81','3439-1547','',6998),
(72604,25971,16,'Ladjane Damião','81','3439-1547','81','3439-1547','ladjaned@dornellasengenharia.com.br',6998),
(65351,26019,20,'André Cabral','41','9916-3313','41','3051-9500','eng.cabral@hamirisi.com.br',14251),
(73063,26019,49,'André Cabral','41','9916-3313','41','3051-9500','eng.cabral@hamirisi.com.br',14251),
(73064,26019,16,'André Cabral','41','9916-3313','41','3051-9500','eng.cabral@hamirisi.com.br',14251),
(65446,26056,20,'Paulo Lauermann (Engenharia)','55','3512-9600','','','paulo.lauermann@alibem.com.br',13316),
(65460,26060,16,'Alceu Trevisan','49','3621-0314','49','3621-0314','compras@macodesc.com.br',1641),
(65461,26060,20,'Irinês Provence (Comercial)','49','3621-0314','49','3621-0314','irines@macodesc.com.br',1641),
(65462,26060,49,'Eduardo Bedin','49','3621-0314','49','3621-0314','eduardobedin@macodesc.com.br',1641),
(65501,26075,16,'Engº Celso Luiz L. Daflon','22','2559-1121','','','',13327),
(65502,26075,49,'Engº Luiz L. Daflon','22','2559-1121','','','',13327),
(65503,26075,20,'Sr. Antônio','22','2559-1121','','','',13327),
(65504,26076,16,'Engº Marcus V. Ferreira','21','7898-7870','21','9539-0803','',13328),
(65505,26076,20,'Sr. Roberto','21','7898-7870','21','9539-0803','',13328),
(65506,26076,49,'Engº Marcus V. Ferreira','21','7898-7870','21','9539-0803','',13328),
(65511,26078,20,'Clayton Lanza','19','3862-4619','19','3862-5587','construtoralanza@uol.com.br',14123),
(72394,26078,49,'Cleber Lanza','19','3862-4619','19','3862-5587','construtoralanza@uol.com.br',14123),
(72395,26078,16,'Clayton Lanza','19','3862-4619','19','3862-5587','construtoralanza@uol.com.br',14123),
(65512,26079,20,'Mauro (Atendente)','16','3703-4733','16','3703-4733','dikaservicos@zipmail.com.br',14284),
(73294,26079,49,'Emílio Freitas','16','3703-4733','16','3703-4733','dikaservicos@zipmail.com.br',14284),
(65522,26082,16,'Edinelson Durante','41','3262-1010','41','3262-1876','compras@fontanive.com.br',4549),
(65523,26082,49,'Fabricio Fontanive','41','3262-1010','41','3262-1876','',4549),
(65524,26082,20,'Marli Grubla','41','3262-1010','41','3262-1876','financeiro@fontanive.com.br',4549),
(94675,26108,16,'Maria Inácio','11','4193-2333','11','4193-6555','maria@opcional.com.br',16418),
(94676,26108,49,'Adriene / Valter','11','4193-2333','11','4193-6555','valter@opcional.com.br',16418),
(94677,26108,20,'Maria Inácio','11','4193-2333','11','4193-6555','maria@opcional.com.br',16418),
(65655,26131,49,'Rogério Hossu','31','3348-7100','31','3348-7101','rogerio.hossu@mrv.com.br',3009),
(65656,26131,16,'Fernando Dias','31','3348-7100','31','3348-7119','fernando@mrv.com.br',3009),
(65657,26131,20,'Ana Paula Passos (Engenharia)','31','3348-7100','31','3348-7101','ana.passos@mrv.com.br',3009),
(65654,26132,49,'Herasmo Furtado Júnior','49','3225-2800','','','herasmofurtado@gmail.com',15635),
(85955,26132,16,'Antônio Wiggers','49','3225-2800','','','awiggers@brturbo.com.br',15635),
(85956,26132,16,'Herasmo Furtado Júnior','49','3225-2800','','','herasmofurtado@gmail.com',15635),
(93657,26132,16,'Tarcísio Peruzzo','49','3225-2800','49','3223-1469','tarcisio@peruzzo.com.br',13363),
(93658,26132,49,'Fábio Zhiorzi','49','3225-2800','','','fabio_z_valente@hotmail.com',15635),
(102470,26132,20,'Camila (Adm. de Obra)','49','3225-2800','','','',15635),
(65661,26135,20,'Berlan Cabral (Projetos)','85','3391-5240','85','3288-5100','berlan.cabral@denocs.gov.br',259),
(72869,26135,21,'Antônio Rebouça','85','3288-5100','85','3288-0100','antonio.sampaio@dnocs.gov.br',259),
(72870,26135,53,'Getúlio Maia','85','3288-5100','85','3288-0100','',259),
(88768,26154,20,'Elizeu Conz (Gerente Projetos)','19','3874-5800 - R. 7580','','','elizeu.conz@syngenta.com',13377),
(65740,26165,49,'Oscar Caetano','41','3381-2550','41','3381-2591','',13366),
(65741,26165,16,'Lisandro da Silva','41','3381-2550','41','3381-2591','lisandro@fmm.com.br',13366),
(65742,26165,20,'Denise Borges (Comercial)','41','3381-2550','41','3381-2591','denise@fmm.com.br',13366),
(65749,26169,16,'Cipriano Caporal','11','2196-2450','11','2196-2470','cipriano@paulitec.com.br',4048),
(65750,26169,49,'Mário de Souza','11','2196-2450','11','2196-2470','mario@paulitec.com.br',4048),
(65751,26169,20,'Alexandre Matos','12','3941-1852','12','3941-1391','alexandre@tecsul.ind.br',1314),
(74391,26169,16,'Alexandre Matos','12','3941-1852','12','3941-1392','alexandre@tecsul.ind.br',1314),
(65762,26172,20,'Paulo Ventura (Marketing)','11','2029-7217','11','2029-7220','marketing@saocristovao.com.br',12664),
(65765,26175,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(65777,26181,16,'Marcelo Gomes','11','3848-4300','11','3848-4301','marcelo.gomes@tecnum.com.br',323),
(65778,26181,49,'A definir','11','3848-4300','11','3848-4301','',323),
(65779,26181,20,'Marcelo Gomes (Compras)','11','3848-4300','11','3848-4301','marcelo.gomes@tecnum.com.br',323),
(65904,26228,16,'Maria Aparecida','11','5501-1234','11','5501-2133','cidinha@planoeplano.com.br',2209),
(65905,26228,49,'Carlos Aquati','11','5501-1234','11','5501-2133','',2209),
(65906,26228,20,'Lívia Dias','11','5501-1234','11','5501-2133','recepcao@planoeplano.com.br',2209),
(65914,26231,16,'Vivian Moreira','65','3028-5000','65','3028-8501','vivian@lotufoeng.com.br',13396),
(65915,26231,49,'Luiz Lotufo','65','3028-5000','65','3028-8501','lotufoengenharia@terra.com.br',13396),
(65916,26231,20,'Tatiani Tamazini','65','3028-5000','65','3028-8501','tatiani@lotufoeng.com.br',13396),
(66022,26275,20,'Antônio Manuel','44','3221-3266','44','3221-3476','antonio.manuel@cocamar.com.br',2581),
(66023,26275,21,'Antônio Manuel','44','3221-3266','44','3221-3476','antonio.manuel@cocamar.com.br',2581),
(84057,26275,16,'José Roberto Zirondi','44','3221-3451','44','3221-3476','jose.zirondi@cocamar.com.br',2581),
(84058,26275,49,'Aurindo Fraga Junior (Compras)','44','3221-3266','44','3221-3476','aurindo.junior@cocamar.com.br',2581),
(66081,26295,20,'Fuad Júnior (Licitação)','61','3315-4892','61','3315-4055','cgcl@dnit.gov.br',4868),
(66095,26301,20,'Setor de Licitação','81','3421-9000','81','3421-9000','',2908),
(66123,26311,16,'Roberto Butura','16','3512-4500','16','3512-4530','suprimentos.rp@mrv.com.br',4203),
(66125,26311,21,'Ricardo Carrenha','16','8114-1454','16','3512-4500','ricardo.carrenha@mrv.com.br',4203),
(66127,26311,20,'Ricardo Carrenha','16','8114-1454','16','3512-4500','ricardo.carenha@mrv.com.br',4203),
(66124,26312,16,'Departamento de Suprimentos','16','3512-4500','16','3512-4530','',4203),
(66126,26312,20,'Murilo Gomes','16','8119-3175','16','3512-4500','murilo.gomes@mrv.com.br',4203),
(66128,26312,21,'Murilo Gomes','16','8119-3175','16','3512-4500','murilo.gomes@mrv.com.br',4203),
(66129,26313,16,'Departamento de Suprimentos','16','3512-4500','16','3512-4530','',4203),
(66130,26313,20,'Murilo Gomes','16','8119-3175','16','3512-4500','murilo.gomes@mrv.com.br',12539),
(66131,26313,21,'Murilo Gomes','16','8119-3175','16','3512-4500','murilo.gomes@mrv.com.br',4203),
(66132,26314,16,'Lilian Rezende','16','3635-3402','16','3535-3402','griffoca@terra.com.br',13418),
(66133,26314,49,'Cristovão Griffo','16','3635-3402','16','3635-3402','griffoca@terra.com.br',13418),
(66134,26314,20,'Cristovão Griffo','16','3635-3402','16','3635-3402','griffoca@terra.com.br',13418),
(66135,26315,16,'Lilian Rezende','16','3635-3402','16','3635-3402','griffoca@terra.com.br',13418),
(66136,26315,49,'Cristovão Griffo','16','3635-3402','16','3635-3402','griffoca@terra.com.br',13418),
(66137,26315,20,'Cristovão Griffo','16','3635-3402','16','3635-3402','griffoca@terra.com.br',13418),
(66152,26321,20,'Mariluci da Cunha','11','3258-2155','11','3258-1781','mariluci@augustovelloso.com.br',819),
(73575,26321,16,'Mariluci da Cunha','11','3258-2155','11','3258-1781','mariluci@augustovelloso.com.br',819),
(73576,26321,49,'Roberto Silveira','11','3258-2155','11','3258-1781','roberto@augustovelloso.com.br',819),
(66191,26335,16,'Ivanilton','17','3216-2652','17','3216-2652','construtorapezatti@construtorapezatti.com.br',10056),
(66192,26335,49,'Mário Cézar Fernando','17','3216-2652','17','3216-2652','construtorapezatti@construtorapezatti.com.br',10056),
(66193,26335,20,'Roberto José da Costa','17','3216-2652','17','3216-2652','construtorapezatti@construtorapezatti.com.br',10056),
(66194,26336,16,'Arq. Raimundo S. Moraes','21','8225-6675','21','3732-8614','moraesarquiteto@yahoo.com.br',10818),
(66195,26336,7,'Arq. Raimundo S. Moraes','21','8225-6675','21','3732-8614','moraesarquiteto@yahoo.com.br',10818),
(66196,26336,20,'Arq. Raimundo S. Moraes','21','8225-6675','21','3732-8614','moraesarquiteto@yahoo.com.br',10818),
(66201,26337,20,'Maria Stella (Planejamento)','17','3203-1230','','','stella@empro.com.br',6267),
(66277,26365,16,'Clodoaldo André','19','3512-1832','19','3512-1831','clodoaldo@mrv.com.br',4066),
(66279,26365,21,'Celso Cardoso','15','7834-6506','19','3512-1832','celsoh@mrv.com.br',4066),
(66280,26365,20,'Celso Cardoso','15','7834-6506','19','3512-1832','celsoh@mrv.com.br',4066),
(66297,26368,16,'Sueli Bueno','11','4158-4525','11','4158-6627','fazer.compras@uol.com.br',2629),
(66298,26368,49,'Fabiano Manegália','11','4158-4525','11','4158-6627','',2629),
(66299,26368,20,'Engº Fabiano Manegália','11','4158-4525','11','4158-6627','',2629),
(66305,26371,20,'Sra. Ofélia Willmersdorf (Planejamento)','15','3459-9220','15','3459-9220','ofelia.willmersdorf@icmbio.gov.br',9049),
(66317,26375,20,'Marcelo Pinheiro','67','4009-7599','67','4009-7500','marcelo.pinheiro@cgr.jbs.com.br',13431),
(66318,26375,16,'Oelton Nascimento','67','4009-7597','67','4009-7500','oeltonvnascimento@cgr.jbs.com.br',13431),
(78249,26375,21,'Marcelo Pinheiro','67','4009-7599','67','4009-7500','marcelo.pinheiro@cgr.jbs.com.br',13431),
(66372,26396,16,'Célia Soares','19','3709-1212','19','3709-1250','celiasoares@rossiresidencial.com.br',1683),
(66373,26396,49,'A definir','19','3709-1289','19','3709-1250','',1683),
(66374,26396,20,'Elaine Oliveira','19','3709-1289','19','3709-1250','elaineoliveira@rossiresidencial.com.br',1683),
(66413,26413,16,'Sr. Emyus Moreira','62','3215-1754','62','3215-1754','emyus.moreira@primeconstrucoes.com.br',13439),
(66414,26413,106,'Alex Lima Soero','62','3215-1754','62','3215-1754','alex.lima@primeconstrucoes.com.br',13439),
(66415,26413,20,'Reinaldo Gomide (Incorporações)','62','3215-1754','62','3215-1754','reinaldo.gomide@primeconstrucoes.com.br',13439),
(66429,26417,16,'Sérgio Cardoso','15','3231-0639','15','3231-0639','engecardoso@ig.com.br',7492),
(66430,26417,49,'Sérgio Cardoso','15','3231-0639','15','3231-0639','engecardoso@ig.com.br',7492),
(66431,26417,20,'Ana Cardoso (Adm.)','15','3231-0639','15','3231-0639','engecardoso@ig.com.br',7492),
(66530,26450,16,'José Vilter Santos','85','3133-2400','85','3133-2400','vilter@scopa.com.br',12299),
(66531,26450,49,'Dario Barrozo','85','3224-6060','85','3133-2400','',12299),
(66532,26450,20,'Tony (Almoxarifado)','85','3224-6060','85','3133-2400','',12299),
(66552,26457,16,'Edinaldo Sebastião Góis','61','3410-0000','61','3410-0033','edinaldogois@caenge.com.br',3785),
(66553,26457,49,'João Neto','61','3383-1609','61','3410-0000','joaoneto@caenge.com.br',3785),
(66554,26457,20,'João Neto','61','3383-1609','61','3410-0000','joaoneto@caenge.com.br',3785),
(66563,26462,16,'Eng. Aram Mardirossian','21','3978-0987','21','3978-0994','',11514),
(66564,26462,49,'Aram Mardirossian','21','3978-0987','21','3978-0994','',11514),
(66565,26462,20,'Sr. Leonardo','21','3978-0987','21','3978-0987','',11514),
(66632,26482,20,'Sr. Waldeck Andrade','21','3513-9903','','','compras@tecnosolo.com.br',8816),
(73878,26482,16,'Sr. Waldeck Andrade','21','3513-9903','','','compras@tecnosolo.com.br',8816),
(99889,26482,49,'Júlio Lima','21','98161-0910','21','3513-9903','jsobreiralima@gmail.com',8816),
(66647,26489,16,'Leonir Ambrosi','55','3744-3322','55','3744-3322','compras@tieturbo.com.br',12143),
(66648,26489,7,'Luciano Albarello','55','3744-3322','55','3744-3322','luciano@construtoramilani.com.br',12143),
(66649,26489,20,'Luciano Albarello','55','3744-3322','55','3744-3322','luciano@construtoramilani.com.br',12143),
(66707,26517,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(66713,26520,16,'Alexandre Pereira / Moacir','62','3946-2441','62','3281-6101','alexandre.pereira@borgeslandeiro.com.br',4611),
(66714,26520,49,'Erick Albuquerque','62','3946-2441','62','3281-6101','borgeslandeiro@borgeslandeiro.com.br',4611),
(66715,26520,20,'Alexandre Pereira (Compras)','62','3039-1000','62','3946-2441','alexandre.pereira@borgeslandeiro.com.br',4611),
(97407,26520,92,'Lúcio Soares','62','3946-2441','62','3281-6101','lucio.soares@borgeslandeiro.com.br',4611),
(66747,26535,21,'Gisele Pereira Teixeira (Engenharia)','32','3690-3502 R:3529','32','3690-3511','gisele@demlurb.pjf.mg.gov.br',1765),
(110502,26535,20,'Marco Aurélio (Engenharia)','32','3690-3502 R:3529','32','3690-3511','maurelio@demlurb.pjf.mg.gov.br',1765),
(66757,26539,16,'Vanderlei da Silva','62','3255-5100','62','3255-5228','suprimentos@toctao.com.br',7862),
(66758,26539,20,'Vanderlei da Silva (Suprimentos)','62','3255-5100','62','3255-5228','suprimentos@toctao.com.br',7862),
(90264,26539,49,'Iury Romano','62','3247-3146','62','3091-4560','iury.romano@toctao.com.br',7862),
(66768,26543,16,'Alexandre Pereira / Moacir','62','3946-2441','62','3281-2121','alexandre.pereira@borgeslandeiro.com.br',4611),
(66769,26543,49,'Erick Albuquerque','62','3946-2441','62','3281-2121','borgeslandeiro@borgeslandeiro.com.br',4611),
(66770,26543,20,'Alexandre Pereira (Compras)','62','3946-2441','62','3281-2121','alexandre.pereira@borgeslandeiro.com.br',4611),
(97409,26543,92,'Lúcio Soares','62','3946-2441','62','3281-2121','lucio.soares@borgeslandeiro.com.br',4611),
(66806,26561,16,'Francisco Chagas','84','3213-6506','84','3213-6604','contato@montanaconstrucoes.com.br',6432),
(66807,26561,92,'Benvenuto Guimarães','84','3213-6506','84','3213-6604','',6432),
(66808,26561,20,'Arq. Anchella Lopes','84','3213-6506','84','3213-6604','anchelarq@montanaconstrucoes.com.br',6432),
(66815,26565,16,'Ana Maria','21','2523-0140','21','2522-1896','suprimentos@sig.eng.br',1005),
(66816,26565,49,'A definir','21','2523-0140','21','2522-1896','',1005),
(66817,26565,20,'Ana Maria','21','2523-0140','21','2522-1896','suprimentos@sig.eng.br',1005),
(66829,26570,16,'Francisco Chagas','84','3213-6506','84','3213-6604','contato@montanaconstrucoes.com.br',6432),
(66830,26570,49,'Benvenuto Guimarães','84','3213-6506','84','3213-6604','contato@montanaconstrucoes.com.br',6432),
(66831,26570,20,'Arqª Anchella Lopes','84','3213-6506','84','3213-6604','anchellarq@montanaconstrucoes.com.br',6432),
(74994,26573,16,'Laurício Gomes','32','3441-1562','','','lauricio.gomes@pavia.com.br',14481),
(74995,26573,49,'Marcus Albuquerque','32','3441-1562','','','marcus.albuquerque@fidens.com.br',14481),
(74996,26573,20,'Marcus Albuquerque','32','3441-1562','','','marcus.albuquerque@fidens.com.br',14481),
(74997,26573,49,'Luciano Luneli','32','3441-1562','','','luciano.luneli@pavia.com.br',14481),
(66833,26574,20,'Adalto Farias (Projetos)','85','3311-7589','85','4009-3599','adalto@mdb.com.br',514),
(66834,26574,21,'Adalto Farias (Projetos)','85','3311-7589','85','4009-3599','adalto@mdb.com.br',514),
(66853,26584,16,'Eno Meireles','71','3453-6300','71','3453-6301','eno.meireles@qgdi.com.br',13495),
(66854,26584,49,'Bruno Passos / Pedro Henrique','71','3453-6300','71','3453-6301','bruno.passos@qgdi.com.br',13495),
(66855,26584,20,'Politana Silva (Engenharia)','71','3453-6300','71','3453-6301','politana.silva@qgdi.com.br',13495),
(66867,26591,20,'Débora de Fátima','31','3282-7844','31','3282-7844','topoeng@terra.com.br',2905),
(75252,26591,49,'Wilton de Assis Araújo','31','3282-7844','31','3282-7844','topoeng@terra.com.br',2905),
(75253,26591,16,'Setor de Compras','31','3282-7844','31','3282-7844','topo.compras@terra.com.br',2905),
(66982,26633,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(67001,26641,16,'Gabriel Gregoleto','51','3233-1542','51','3233-1542','gabriel@valpi.com.br',13507),
(67002,26641,49,'Gabriel Gregoleto','51','3233-1542','51','3233-1542','gabriel@valpi.com.br',13507),
(67003,26641,20,'Gabriel Gregoleto','51','4063-8404','51','3233-1542','gabriel@valpi.com.br',13507),
(67113,26686,16,'André Zaidan (Diretor Suprimentos)','11','3377-3777','11','3377-3778','azaidan@even.com.br',730),
(67114,26686,20,'Renato Arbulu (Engenharia) / Mariana Brito (Mark)','11','3377-3777','11','3377-3778','rarbulu@even.com.br,mbrito@even.com.br',730),
(85998,26686,29,'Marcelo Zapparoli','11','3377-3777','11','3377-7778','mzapparoli@even.com.br',730),
(67125,26691,20,'Simone da Cruz (Engenharia)','41','3306-0900','41','3309-0909','simone@catedral.eng.br',5550),
(67126,26691,16,'Jorge Omar Gonzalez','41','9154-1819','41','3306-0900','jorge@catedral.eng.br',5550),
(74501,26691,49,'Jorge Omar Gonzalez','41','9154-1819','41','3306-0900','jorge@catedral.eng.br',5550),
(67180,26714,20,'Alice Miranda (Compras)','81','2129-0330','81','2129-0350','alice.miranda@elcoma.com.br',13530),
(67284,26755,16,'Sr. Manoel Muniz','92','2101-5800','92','3633-5106','muniz@construtoracapital.com.br',9025),
(67285,26755,49,'Sérgio Avelino','92','2101-5800','92','3633-5106','sergio@construtoracapital.com.br',9025),
(67286,26755,20,'Lorena Tavares (Planejamento)','92','2101-5800','92','3633-5106','lorena@construtoracapital.com.br',9025),
(67311,26764,16,'Cíntia Gomes Moreira','62','3216-4272','62','3216-4229','suprimentos@cmoconstrutora.com.br',6696),
(67312,26764,49,'Roberto Inácio Junqueira','62','3216-4272','62','3216-4229','projetos@cmoconstrutora.com.br',6696),
(92452,26764,20,'Elaine ( Rec.Engª )','62','3216-4272','62','3216-4229','engenharia@cmoconstrutora.com.br',6696),
(92453,26764,21,'Dawilla Batista','62','3216-4272','62','3216-4229','coordenacao@cmoconstrutora.com.br',6696),
(67313,26765,16,'Clara Odaira / Elizete Rodrigues','11','3811-5700','11','3811-5700','clara@incons.com.br,compras@taruma.com.br',10356),
(67314,26765,20,'Clara Odaira','11','3811-5700','11','3811-5700','clara@incons.com.br',10356),
(67315,26765,21,'Alexandre Vieira','11','3811-5700','11','3811-5700','alexandre@incons.com.br',10356),
(67317,26766,20,'Cézar Augusto','81','9933-5950','81','3449-9868','comissao.patrimonial@santacruzpe.com.br',13552),
(165020,26766,16,'Cézar Augusto','81','9933-5950','81','3449-9868','comissao.patrimonial@santacruzpe.com.br',13552),
(165021,26766,49,'Restrito','81','9933-5950','81','3449-9868','',13552),
(67318,26767,20,'Paulo Bicalho (Gerente do Centro Cultural)','21','2211-7529','21','2211-4420','paulo.bicalho@light.com.br',7443),
(67328,26771,20,'Edna Sandra (Licitação)','62','3201-7824','62','3201-7896','goiasparcerciasgyn@gmail.com',13550),
(67333,26773,21,'Danilo Torres','18','3529-9200','18','3528-4660','danilo.torres@granol.com.br',6581),
(72663,26773,20,'Danilo Torres','18','3529-9200','18','3528-4660','danilo.torres@granol.com.br',6581),
(95109,26773,49,'Engº Elivelton Marcos da Silva','11','9465-8257','16','3951-9340','elivelton@siner.com.br',16572),
(95110,26773,16,'Lucilene Santos','11','4181-6999','11','4181-6626','lucilene.santos@siner.com.br',15455),
(67334,26775,20,'Mário Mendes (Diretor Operacional)','31','9192-9350','31','3227-7558','mario@ferrobahia.com.br',9561),
(82400,26775,21,'Mário Mendes','31','9192-9350','31','3227-7558','mario@ferrobahia.com.br',9561),
(67337,26776,16,'Helson Antônio','11','4799-0088','11','4726-5065','suprimentos@jbianchi.com.br',2117),
(67338,26776,49,'Maurício Pagoto','11','4799-0008','11','4726-5065','mauricio@jbianchi.com.br',1277),
(67339,26776,20,'Ricardo Darcin (Comercial)','11','4994-8322','11','4994-8322','ricardo@grupogrotta.com.br',2117),
(67374,26788,16,'Gilberto Luis S. Teixeira','22','9958-1817','22','2760-6162','gilbertoluisteixeira@gmail.com',5728),
(67375,26788,49,'Gilberto Luis S. Teixeira','22','9958-1817','22','2760-6162','gilbertoluisteixeira@gmail.com',5728),
(67376,26788,20,'Gilberto Luis S. Teixeira','22','9958-1817','22','2760-6162','gilbertoluisteixeira@gmail.com',5728),
(67380,26790,16,'Gilberto Luis S. Teixeira','22','9958-1817','22','2760-6162','gilbertoluisteixeira@gmail.com',5728),
(67381,26790,49,'Gilberto Luis S. Teixeira','22','9958-1817','22','2760-6162','gilbertoluisteixeira@gmail.com',5728),
(67382,26790,20,'Gilberto Luis S. Teixeira','22','9958-1817','22','2760-6162','gilbertoluisteixeira@gmail.com',5728),
(67389,26793,20,'Sr. Antônio Borges (Dir. Geral)','31','3369-0204','31','3369-0219','aasborges@uol.com.br',13565),
(67393,26795,16,'Setor de Compras','51','3327-0800','51','3327-0807','zaffarilora@zaffarilora.com.br',13556),
(67394,26795,49,'Restrito','51','3327-0800','51','3327-0807','',13556),
(67395,26795,20,'Daise Lima','51','3327-0800','51','3327-0807','zaffarilora@zaffarilora.com.br',13556),
(67405,26799,16,'Reginaldo Assunção','27','3361-0400','27','3361-0195','reginaldo@gotardoconstrutora.com.br',13566),
(67406,26799,49,'Reginaldo Assunção','27','3361-0400','27','3361-0195','reginaldo@gotardoconstrutora.com.br',13566),
(67407,26799,20,'Márcia Lembrante','27','3361-0400','27','3361-0195','gotardo@gotardoconstrutora.com.br',13566),
(67408,26800,16,'Jefferson','41','3452-2758','41','3452-2758','hjconstrutora@hjconstrutora.com.br',6142),
(67409,26800,49,'Huber da Guia','41','3452-2758','41','3452-2758','hjconstrutora@hjconstrutora.com.br',6142),
(67410,26800,20,'Elis Almeida (Adm)','41','3452-2758','41','3452-2758','hjconstrutora@hjconstrutora.com.br',6142),
(67411,26801,16,'Huber da Guia','41','3452-2758','41','3452-2758','hjconstrutora@hjconstrutora.com.br',6142),
(67412,26801,49,'Huber da Guia','41','3452-2758','41','3452-2758','hjconstrutora@hjconstrutora.com.br',6142),
(67413,26801,20,'Elis Almeida','41','3452-2758','41','3452-2758','hjconstrutora@hjconstrutora.com.br',6142),
(67417,26803,16,'Jaime Masson','47','3368-4368','','','jmasson@jmasson.com.br',13568),
(67418,26803,49,'Jaime Masson','47','3368-4368','','','jmasson@jmasson.com.br',13568),
(67419,26803,20,'Glaúcia Flor (Administrativo)','47','3368-4368','','','jmasson@jmasson.com.br',13568),
(67425,26805,16,'Rafael Matias','31','3355-1811','31','2519-9303','compras@conserconconstrutora.com.br',9784),
(76882,26805,49,'Magno Nazareno','31','3355-1811','31','2519-9303','engenharia@conserconconstrutora.com.br',9784),
(76883,26805,20,'Edivaldo Rosa (Mestre de Obras)','31','3355-1811','31','2519-9303','edivaldomais@yahoo.com.br',9784),
(67426,26806,20,'Adriano Santos Oliveira','33','8825-2521','33','3521-6616','adrianoalcance@hotmail.com',6859),
(78247,26806,49,'Adriano Santos Oliveira','33','8825-2521','33','3521-6616','adrianoalcance@hotmail.com',6859),
(78248,26806,16,'Shirley Bispo','33','3521-6616','33','3521-6616','shirleyalcance@hotmail.com',6859),
(67428,26808,16,'Maria de Fátima','11','4195-1960','11','4195-1960','fatima@scopusconstrutora.com.br',3410),
(76671,26808,49,'Patrícia Milena','11','9614-6645','11','4195-1960','patricia@scopusconstrutora.com.br',3410),
(76672,26808,20,'Patrícia Milena','11','9614-6645','11','4195-1960','patricia@scopusconstrutora.com.br',3410),
(67429,26809,20,'Débora Gusma (Administrativo)','11','4721-2884','11','4721-4212','deboragusma.obra@liderconstrucoes.com.br',14533),
(75463,26809,16,'Luiz Aquino','11','4721-2884','11','4721-4212','luizaquino.obra@liderconstrucoes.com.br',14533),
(75464,26809,49,'Luiz Aquino','11','4721-2884','11','4721-4212','luizaquino.obra@liderconstrucoes.com.br',14533),
(67433,26811,20,'Sr. Willian Augusto (Ger. Obra)','31','3491-4022','31','3491-4000','administracao@durapack.ind.br',13570),
(67434,26811,21,'Sr. Willian Augusto','31','3491-4022','31','3491-4000','administracao@durapack.ind.br',13570),
(67447,26818,16,'Waldemiro Fernandes','24','2252-3906','24','2252-3906','waldemiro.fernandes@grupomil.com.br',8049),
(67448,26818,21,'André Saggioro','24','2252-3906','24','2252-3906','construtora@grupomil.com.br',8049),
(67449,26818,20,'Rodrigo Mello','24','2252-3906','24','2252-3906','rodrigomello@grupomil.com.br',8049),
(67453,26820,16,'Carlos Alberto','11','2832-4200','11','2232-4233','compras@genea.com.br',3510),
(67454,26820,49,'Cláudio Matsuo','11','4721-3705','11','2832-4200','claudio@genea.com.br',3510),
(67455,26820,20,'Ademar Lisboa','11','4721-3705','11','2832-4200','vidabella.obra2@genea.com.br',3510),
(67456,26821,20,'Ricardo Cirillo','11','4725-7785','11','2832-4200','ricardo.cirillo@genea.com.br',3510),
(67457,26821,16,'Carlos Alberto','11','2832-4200','11','2232-4233','compras@genea.com.br',3510),
(67458,26821,49,'Cláudio Matsuo','11','4725-7785','11','2832-4200','claudio@genea.com.br',3510),
(67465,26823,16,'César Levy','13','3219-4688','','','csm-msc@bol.com.br',17002),
(88590,26823,20,'Engª Cristina S. Meira','13','3219-4688','','','csm-msc@bol.com.br',17002),
(98712,26823,49,'César Levy / Cristina S. Meira','13','3219-4688','','','csm-msc@bol.com.br',17002),
(67469,26825,20,'Natália (Licitação)','16','3362-1162','16','3362-1162','licitacao@saocarlos.sp.gov.br',2788),
(67470,26827,20,'Monica (Licitação)','11','3146-7059','','','',9093),
(67471,26828,16,'Carlos Alberto','11','2832-4200','11','2232-4233','compras@genea.com.br',3510),
(67472,26828,20,'Martinho Yasura (Planejamento)','11','2832-4200','11','2232-4233','martinho@genea.com.br',3510),
(67473,26828,49,'Cláudio Matsuo','11','2832-4200','11','2232-4233','claudio@genea.com.br',3510),
(67491,26835,20,'Vanessa Santos (Secretária)','17','3274-5740','17','3274-5740','vsantos@aguarani.com.br',1546),
(67492,26835,21,'João Varalonga','17','3274-5740','17','3274-5740','jvaralonga@aguarani.com.br',1546),
(67493,26835,16,'Antônio Crepaldi','17','3274-5740','17','3274-5740','acrepaldi@aguarani.com.br',1546),
(67509,26840,16,'Carla Sanches','22','2523-9756','22','2523-9756','formato@formatoconstrucoes.com.br',5337),
(67510,26840,49,'Engº Alexandre T Resende','22','2523-9756','22','2523-9756','formato@formatoconstrucoes.com.br',5337),
(67511,26840,20,'Luana Pimenta','22','2523-9756','22','2523-9756','luanapimenta@formatoconstrucoes.com.br',5337),
(67512,26841,16,'Carla Sanches','22','2523-9756','22','2523-9756','formato@formatoconstrucoes.com.br',5337),
(67513,26841,49,'Engº Alexandre T. Resende','22','2523-9756','22','2523-9756','formato@formatoconstrucoes.com.br',5337),
(67514,26841,20,'Luana Pimenta','22','2523-9756','22','2523-9756','luanapimenta@formatoconstrucoes.com.br',5337),
(67520,26844,16,'Gilson Sampaio','27','3149-2400','27','3149-2400','compras@barbosabarros.com.br',9688),
(67521,26844,49,'Joelma','27','3149-2400','27','3149-2404','joelma@barbosabarros.com.br',9688),
(67522,26844,20,'Jéssica Delpuppo (Engenharia)','27','3149-2400','27','3149-2400','arquitetura@barbosabarros.com.br',9688),
(74697,26847,20,'Elzebio Almeida (Manutenção Geral)','43','3033-4018','44','3622-3599','euzebio.almeida@uol.com.br',7145),
(74698,26847,16,'Aparecida Godói','44','3622-3599','44','3622-3599','aparecida.godoi@gmail.com',7145),
(74699,26847,49,'Edno Mitsuo Kami','43','3033-4018','44','3622-3599','edno.mitsuo@gmail.com',7145),
(67537,26851,16,'Renato Oliveira','19','3255-5304','19','3255-5304','repar@repar.com.br',13579),
(67538,26851,49,'Renato Oliveira','19','3255-5304','19','3255-5304','repav@repav.com.br',13579),
(67539,26851,20,'Renato Oliveira','19','3255-5304','19','3255-5304','repav@repav.com.br',13579),
(67544,26853,16,'Lorena Quinquin','21','2172-1800','21','2172-1845','compras@calper.com.br',310),
(67545,26853,20,'Roberto Santos','21','2411-7567','21','2172-1832','roberto.santos@calper.com.br',310),
(98367,26853,49,'João Gilberto','21','2411-7567','21','2172-1800','joao.gilberto@calper.com.br',310),
(67551,26857,16,'Rejane Farias','31','3492-2996','31','3490-9700','rejane@muschioni.com.br',4826),
(67552,26857,20,'Warley Bauer (Comercial)','31','3427-1273','31','3427-3821','comercial@muschioni.com.br',4826),
(67553,26857,49,'Adriano Muschioni','31','3492-2996','31','3492-9700','rejane@muschioni.com.br',4826),
(67555,26859,16,'Rejane Faria','31','3492-2996','31','3492-9700','rejane@muschioni.com.br',4826),
(67556,26859,49,'Adriana Muschioni','31','3492-2996','31','3492-9700','rejane@muschioni.com.br',4826),
(67557,26859,20,'Warley Bauer','31','3427-1273','31','3427-3821','comercial@muschioni.com.br',4826),
(78387,26860,20,'Renato Vidal (Administração)','41','3322-8840','41','3322-8840','nato@natoconstrutora.com.br',6948),
(78388,26860,16,'Gilnei Zanella','41','3322-8840','41','3322-8840','gilnei@natoconstrutora.com.br',6948),
(78389,26860,49,'Osni Fernando Mouro Rios','41','3322-8840','41','3322-8840','',6948),
(67561,26862,16,'Alexandre Matos','11','2950-4422','11','2950-4422','admmatos@ig.com.br,amatos@ospeconstrutora.com.br',1197),
(67562,26862,20,'André Teixeira','11','2950-4422','11','2950-4422','andre@ospeconstrutora.com.br',1197),
(67563,26862,49,'André Teixeira','11','2950-4422','11','2950-4422','andre@ospeconstrutora.com.br',1197),
(67573,26870,20,'Carlos Eduardo Cabanas (Diretor de Obras)','11','3146-7053','11','3146-7060','cabanas@sesisenaisp.org.br',9093),
(67586,26873,20,'Ana Paula','21','2332-3831','21','2332-3831','pregaoeletronico@cedae.com.br',2858),
(67588,26875,16,'Roberta Almeida','11','3683-2996','11','3023-6003','engenharia@zafir.com.br',13586),
(67589,26875,21,'Paulo Sérgio','11','3023-6003','11','3022-4759','engenharia@zafir.com.br',13586),
(67590,26875,20,'Roberta Almeida','11','3683-2996','11','3023-6003','engenharia@zafir.com.br',13586),
(67591,26876,16,'Gislaine Barbosa','27','3361-5473','27','3361-5473','gislaine@aguiardepaula.com.br',13585),
(67592,26876,49,'Engº Luciano Moura','27','3361-5473','27','3361-5473','luciano@aguiardepaula.com.br',13585),
(67593,26876,20,'Gislaine Barbosa','27','3361-5473','27','3361-5473','gislaine@aguiardepaula.com.br',13585),
(67594,26877,16,'Jenifer Gomes','27','3361-5473','','','jenifer@aguiardepaula.com.br',13585),
(67595,26877,20,'Jenifer Gomes','27','3361-5473','','','jenifer@aguiardepaula.com.br',13585),
(77252,26877,49,'Luciano Aguiar (Proprietário)','27','3361-5473','','','luciano@aguiardepaula.com.br',13585),
(150288,26877,49,'Renzo Conde','27','3361-5473','','','renzo@aguiardepaula.com.br',13585),
(67596,26878,16,'Luciano Aguiar','27','3361-5473','27','3361-5473','gislaine@aguiardepaula.com.br',13585),
(67597,26878,49,'Engº Luciano Moura','27','3361-5473','27','3361-5473','luciano@aguiardepaula.com.br',13585),
(67598,26878,20,'Gislaine Barbosa','27','3361-5473','27','3361-5473','gislaine@aguiardepaula.com.br',13585),
(67605,26881,16,'Juliana Navas','15','3211-4076','15','3211-4076','juliananavas@construtoraplaneta.com.br',5403),
(67606,26881,49,'Guilherme Vieira','15','3211-4076','15','3211-4076','guilherme@construtoraplaneta.com.br',5403),
(67607,26881,20,'Ellen Rodrigues (Comercial)','15','3211-4076','15','3211-4076','ellen@construtoraplaneta.com.br',5403),
(67616,26884,20,'Ricardo Pereira (Licitação)','11','3146-7059','11','3146-7097','',9093),
(67618,26886,20,'José Moacir','67','9963-1515','67','3291-1822','josemoacir@projetandoarquitetura.com.br',14682),
(76730,26886,49,'José Moacir','67','9963-1515','67','3291-1822','josemoacir@projetandoarquitetura.com.br',14682),
(76731,26886,49,'Erica Prado','67','3291-1822','67','3291-1822','ericabprado@hotmail.com',14682),
(67624,26889,20,'Renata Pesoni (Financeiro)','51','3221-7344','51','3224-8022','renata@araupel.com.br',13592),
(67625,26889,21,'Enio Marodin (Sócio e Diretor Comercial)','51','3221-7344','51','3224-8022','',13592),
(67626,26890,16,'Maria Yara Coelho','22','3058-2000','22','2645-2435','yaracoelho@volendam.com.br',5188),
(67627,26890,20,'Maria Yara Coelho','22','3058-2000','22','2645-2435','yaracoelho@volendam.com.br',5188),
(67663,26890,49,'Luiz Cláudio','22','3058-2000','22','2645-2435','claudio@volendam.com.br',5188),
(67633,26891,16,'Reinaldo Teixeira','22','2643-1707','22','2643-1707','compras@pontual.eng.br',7370),
(67634,26891,49,'Arq. Raul A. Lora L','22','2643-1707','22','2643-1707','construtora@pontual.eng.br',7370),
(67637,26891,20,'Reinaldo Teixeira','22','2643-1707','22','2643-1707','compras@pontual.eng.br',7370),
(67648,26894,16,'João Paulo Packer','47','3361-8714','47','3361-8714','comercial@silvapacker.com.br',13594),
(67649,26894,49,'João Paulo Packer','47','3361-8714','47','3361-8714','comercial@silvapacker.com.br',13594),
(67650,26894,20,'Juliano Bif','47','3361-8714','47','3361-8714','comercial@silvapacker.com.br',13594),
(67654,26896,16,'João Paulo Packer','47','3361-8714','47','3361-8714','joaopaulo@redel.com.br',13594),
(67655,26896,49,'João Paulo Packer','47','3361-8714','47','3361-8714','joaopaulo@redel.com.br',13594),
(67656,26896,20,'João Paulo Packer','47','3361-8714','47','3361-8714','joaopaulo@redel.com.br',13594),
(67657,26897,16,'João Paulo Packer','47','3361-8714','47','3361-8714','joaopaulo@redel.com.br',13594),
(67658,26897,49,'João Paulo Packer','47','3361-8714','47','3361-8714','joaopaulo@redel.com.br',13594),
(67659,26897,20,'João Paulo Packer','47','3361-8714','47','3361-8714','joaopaulo@redel.com.br',13594),
(67660,26898,16,'Márcio Grigolon','11','4502-3000','11','4502-3000','marcio.grigolon@cyrela.com.br',1),
(67661,26898,21,'Paulo Nazar','11','4502-3000','11','4502-3001','paulon@cyrela.com.br',1),
(67662,26898,20,'Grasiele Silva (Marketing) / Manuela Veira','11','4502-3000','11','4502-3000','manuela.v@cyrela.com.br',1),
(67664,26899,16,'Roberto Moura de Paula','21','9733-2031','21','2601-0521','rmpd@terra.com.br',2981),
(67665,26899,49,'Roberto Moura de Paula','21','9733-2031','21','2601-0521','rmpd@terra.com.br',2981),
(67666,26899,20,'Roberto Moura de Paula','21','9733-2031','21','2601-0521','rmpd@terra.com.br',2981),
(67670,26901,16,'Getúlio Florencio','62','9641-3246','62','3215-9511','getuliodragao@gmail.com',13593),
(67671,26901,20,'Getúlio Florencio','62','9637-9702','62','3215-9511','getuliodragao@gmail.com',13593),
(67672,26901,49,'Luis Sebba','62','9637-9702','62','3215-9511','luizsebba@uol.com.br',13593),
(67673,26902,20,'Rosemarie Reis (Licitação)','12','3947-8000','12','3947-8540','drm@sjc.gov.br',502),
(67674,26903,16,'Marily Almeida','11','2672-7733','11','2672-7733','marilyalmeida@gmail.com',4710),
(67675,26903,49,'José Roberto','11','2672-7733','11','2672-7733','',4710),
(67676,26903,20,'Marily Almeida','11','2672-7733','11','2672-7733','marilyalmeida@gmail.com',4710),
(67705,26911,16,'Carlos Eduardo Goulart','22','2643-3341','22','2643-3341','construtora-jlm@ig.com.br',2735),
(67706,26911,49,'Cristiano Goulart Duarte','22','2643-3341','22','2643-3341','construtora-jlm@ig.com.br',2735),
(67707,26911,20,'Carlos Eduardo Goulart','22','2643-3341','22','2643-3341','construtora-jlm@ig.com.br',2735),
(67719,26914,16,'Gelson Mocelin','27','3361-0202','27','3361-1488','mocelin@mocelinengenharia.com.br',13598),
(67720,26914,49,'Gelson Mocelin','27','3361-0202','27','3361-1488','mocelin@mocelinengenharia.com.br',13598),
(67721,26914,20,'Nalva Pinto (Comercial)','27','3361-0202','27','3361-1488','mocelin@mocelinengenharia.com.br',13598),
(67722,26915,16,'Amanda Fernandes','41','3343-7980','41','3343-7988','amandaf@bauconstrutora.com.br',11551),
(67723,26915,21,'Gilson Pereira da Silva','41','3343-7980','41','3343-7988','gilson@bauconstrutora.com.br',11549),
(67724,26915,20,'Regina San Gil (Planejamento e Controle)','41','3343-7980','41','3343-7988','reginasg@bauconstrutora.com.br',11551),
(92548,26915,49,'Gilson Pereira da Silva','41','3343-7980','41','3343-7988','gilson@bauconstrutora.com.br',11549),
(67727,26916,20,'Adilson Bagatin (Engenharia)','41','3274-8966','41','3274-9574','gennan@ig.com.br',13545),
(76264,26916,49,'Luis Afonso','41','3274-8966','41','3274-9574','gennan@ig.com.br',13545),
(76265,26916,16,'Nadine Albuquerque','41','3274-8966','41','3274-9574','gennan@ig.com.br',13545),
(67731,26919,16,'Vitor Wosniak / Gilnei','41','3557-5353','41','3557-5345','vitor@mmarruda.com.br,gilnei@mmarruda.com.br',13602),
(67732,26919,49,'José Augusto','41','3557-5353','41','3557-5345','mmarruda@mmarruda.com.br',13602),
(67733,26919,20,'Pamela Pádio','41','3557-5353','41','3557-5345','mmarruda@mmarruda.com.br',13602),
(67737,26921,16,'Marcel','21','2294-0395','21','2339-2493','terracosolinda@elvasempreendimentos.com.br',1308),
(67738,26921,49,'Marcelo Nascimento','21','2294-0395','21','2339-2493','terracosolinda@elvasempreendimentos.com.br',1308),
(67739,26921,20,'Cláudia Bittencourt','21','2294-0395','21','2339-2493','terracosolinda@elvasempreendimentos.com.br',1308),
(67743,26924,16,'Márcio Pardini','37','3221-8332','37','3221-8332','marciopardini@yahoo.com.br',9080),
(67744,26924,49,'Nelson Resende','37','3221-8332','37','3221-8332','marciopardini@yahoo.com.br',9080),
(67745,26924,20,'Fernanda Canedo','37','3221-8332','37','3221-8332','marciopardini@yahoo.com.br',9080),
(67767,26931,16,'Lacerda','44','3226-6203','44','3226-6203','construtoracasaverde@hotmail.com',13600),
(67768,26931,49,'Antônio Nakazima','44','7811-0303','44','3226-6203','engenharia@construtoracasaverde.com.br',13600),
(67769,26931,20,'Rejane','44','9853-2600','44','3226-6203','engenhariacasaverde@gmail.com',13600),
(67780,26936,16,'Henrique Van Hout Sorria','44','3226-6203','44','3226-6203','contato@construtoracasaverde.com.br',13600),
(67781,26936,49,'Antônio Nakazima','44','3226-6203','44','3226-6203','',13600),
(67782,26936,20,'Antônio Lopes (Mestre de Obras)','44','9932-0118','44','3226-6203','',13600),
(67789,26941,16,'Rafael Araújo','84','3231-9075','84','3231-9075','rafael.compras@escolengenharia.com.br',7718),
(67791,26941,29,'Ednaldo Silva','84','3231-9075','84','3231-9075','',7718),
(111558,26941,20,'Rafael Araújo','84','3231-9075','84','3231-9075','rafael.compras@escolengenharia.com.br',7718),
(67794,26943,20,'Setor de Licitações','27','2127-5119','27','2127-5151','licitacoes@cesan.com.br',6540),
(67796,26944,20,'Wariston Ricardo (Gerente de Manutenção)','31','3689-9200','31','3689-9200','wariston.prod@marangoni.com',13604),
(85557,26944,16,'Leonardo Araújo','31','3689-9200 - R. 9238','31','3689-9236','leonardo.compras@marangoni.com',13604),
(67800,26945,16,'Regia Kaline','84','3231-9075','84','3231-9075','kaline.compras@escolengenharia.com.br',7718),
(67801,26945,49,'Pedro Henrique','84','3231-9075','84','3231-9075','pedro@escolengenharia.com.br',7718),
(67802,26945,20,'Sr. Ednaldo Silva (Dir. Técnico)','84','3231-9075','84','3231-9075','ednaldo@escolengenharia.com.br',7718),
(67809,26948,16,'Rosemeire Rocha','84','3231-9075','84','3231-9075','rose@escolengenharia.com.br',7718),
(67810,26948,49,'Ulliana Guerra','84','3231-9075','84','3231-9075','',7718),
(67811,26948,20,'Sr. Ednaldo Silva (Dir. Técnico)','84','3231-9075','84','3231-9075','ednaldo@escolengenharia.com.br',7718),
(67818,26951,16,'Irlene Gouvêa','31','3443-7319','31','3443-7319','compras@construtoragouvea.com.br',13609),
(67819,26951,20,'Cristiane Gouvêa','31','3443-7319','31','3443-7319','construtoragouvea@gmail.com',13609),
(67820,26951,49,'Frederico Belini','31','3443-7319','31','3443-7319','construtoragouvea@gmail.com',13609),
(67854,26963,16,'Engª Rosângela Frazão','22','2759-1210','22','2770-6767','rosangelafrazao@uol.com.br',7359),
(67855,26963,49,'Engª Rosângela Frazão','22','2759-1210','22','2770-6767','rosangelafrazão@uol.com.br',7359),
(67856,26963,20,'Sr. Roberto','22','2759-1210','22','2770-6767','rosangelafrazao@uol.com.br',7359),
(67857,26966,16,'Elias Juventino de Souza','84','3219-0797','84','3219-0797','compras@ssempreendimentos.com.br',8283),
(67858,26966,49,'Diana Almeida','84','3219-0797','84','3219-0797','',8283),
(67859,26966,20,'Sérgio Freire','84','3219-0797','84','3219-0797','gerencia@ssempreendimentos.com.br',8283),
(67927,26984,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(67932,26987,20,'Luiz Roberto','11','3040-2027','11','3048-2021','lroberto@atuaconstrutora.com.br',13629),
(67933,26987,16,'Luiz Roberto','11','3048-2027','11','3048-2021','lroberto@atuaconstrutora.com.br',13629),
(67934,26987,49,'Roberto Jesus','11','3040-2020','11','3048-2021','rjesus@atuaconstrutora.com.br',13629),
(74190,26995,16,'Paulo Campos','11','3176-1000','11','3176-1270','paulo.campos@pdg.com.br',316),
(74191,26995,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(74192,26995,20,'Cínthia (Pós-Venda)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(67949,26996,16,'Paulo Campos','11','3176-1000','11','3176-1270','paulo.campos@pdg.com.br',316),
(67950,26996,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(67951,26996,20,'Cínthia (Pós-Venda)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(67972,27004,20,'Sr. José Eugênio da Fonseca (Dir. Comercial)','31','2191-4100','31','2191-4100','diretoria@teartextil.com.br',13636),
(68001,27011,16,'Michele Lima','38','3215-6575','38','3215-6575','',13630),
(68002,27011,49,'Denilson Rêgo Arruda','38','3215-6575','38','3215-6575','denilsonarruda@hotmail.com',13630),
(68003,27011,20,'Wesley Souto','38','9151-6814','38','3215-6575','arrudaimoveis@gmail.com',13630),
(80042,27013,16,'Luiz Roberto','11','3048-2027','11','3048-2021','lroberto@atuaconstrutora.com.br',13629),
(80043,27013,20,'Cláudio Pace','11','3048-2020','11','3048-2021','cpace@atuaconstrutora.com.br',13629),
(80044,27013,21,'Cláudio Pace','11','3048-2020','11','3048-2021','cpace@atuaconstrutora.com.br',13629),
(80039,27017,16,'Raphael Ramiro','11','3048-2020','11','3048-2021','rramiro@econconstrutora.com.br',2868),
(89087,27017,49,'Fabricio Toso','11','5666-0721','11','3048-2020','ftoso@econconstrutora.com.br',2868),
(110649,27017,20,'Wando Oliveira','11','5666-0721','11','3048-2020','interlagos@econconstrutora.com.br',2868),
(68012,27020,16,'Mário Clarimundo','21','3543-4000','21','3890-1633','mario.gomes@concremat.com.br',1035),
(68013,27020,49,'Marcelo Silva Neto','21','2610-4901','21','3543-4000','',1035),
(68014,27020,20,'Liza Erling','21','2610-4901','21','3543-4000','lizaerling@concremat.com.br',1035),
(68050,27029,16,'Antonio Pires','51','3025-8073','51','3025-8080','antonio@bolognesi.com.br',13637),
(68051,27029,20,'Anderson Soares','51','3222-1750','51','3025-8073','andersonsoares@bolognesi.com.br',13637),
(68052,27029,49,'Danilo Cartelan','51','3222-1750','51','9679-4780','danilocartelan@bolognesi.com.br',13637),
(68053,27030,16,'Antonio Pires','51','3025-8042','51','3025-8025','antonio@bolognesi.com.br',13637),
(68054,27030,20,'Antônio Pires','51','3025-8042','51','3025-8025','antonio@bolognesi.com.br',13637),
(68055,27030,49,'Lucas Reis','51','9933-1210','51','3025-8080','lucasreis@bolognesi.com.br',13637),
(68056,27031,16,'Antonio Pires','51','3025-8073','51','3025-8080','antonio@bolognesi.com.br',13637),
(68057,27031,20,'Marcos Antonio','51','3465-7383','51','3025-8080','marcosantonio@bolognesi.com.br',13637),
(68058,27031,49,'Marcos Antonio','51','3465-7383','51','3025-8080','marcosantonio@bolognesi.com.br',13637),
(68094,27043,16,'Luana Faria','11','3176-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(68095,27043,20,'Alglécio Silva (Marketing)','62','3541-7779','62','3541-7779','alglecio.silva@pdg.com.br',15188),
(81484,27043,21,'Fernando Grinberg','62','3541-7779','62','3541-7779','fernando.grinberg@pdg.com.br',15188),
(92812,27043,16,'Priscylla Nunes','62','3541-7779','62','3541-7779','priscylla.nunes@pdg.com.br',15188),
(92813,27043,21,'Natã Gonçalves','62','3541-7779','62','3541-7779','nata.goncalves@pdg.com.br',15188),
(68101,27047,20,'Setor de Licitação','41','3336-3330','41','3336-3344','',463),
(68127,27056,16,'Adenúbia Suzi de Oliveira','27','3421-4900','27','3421-4905','nubia@orionengenharia.com.br',10279),
(68128,27056,20,'Fernando  (Almoxarifado)','27','3421-4900','27','3421-4905','fernando@orionengenharia.com.br',10279),
(68129,27056,49,'João Marcelo / Luiz Claudio','27','3389-6868','27','3421-4900','orlandocoser@orionengenharia.com.br',10279),
(75723,27056,16,'Rodrigo Silva','27','3421-4900','27','3421-4905','rodrigo@orionengenharia.com.br',10279),
(68164,27072,16,'Roney de Souza','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(68165,27072,49,'Taís Donato','31','3263-7600','31','3263-7600','somar@construtorasomar.com.br',13650),
(68166,27072,20,'Roney de Souza','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(68167,27073,16,'Roney de Souza','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(68168,27073,49,'Thais','31','3263-7600','31','3263-7600','somar@construtorasomar.com.br',13650),
(68169,27073,20,'Roney de Souza','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(68170,27074,16,'Roney de Souza','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(68171,27074,49,'Taís Donato','31','3263-7600','31','3263-7600','somar@construtorasomar.com.br',13650),
(68172,27074,20,'Rubens Freitas','31','3263-7600','31','3263-7600','rubens@construtorasomar.com.br',13650),
(68173,27075,16,'Roney de Souza','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(68174,27075,49,'Thaís Donato','31','3263-7600','31','3263-7600','somar@construtorasomar.com.br',13650),
(68175,27075,20,'Rubens Freitas','31','3263-7600','31','3263-7600','rubens@construtorasomar.com.br',13650),
(68176,27076,16,'Roney de Souza','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(68177,27076,49,'Taís Donato','31','3263-7600','31','3263-7600','somar@construtorasomar.com.br',13650),
(68178,27076,20,'Rubens Freitas','31','3263-7600','31','3263-7600','rubens@construtorasomar.com.br',13650),
(68179,27077,16,'Márcio Morelli','18','3654-2030','18','3654-2031','morelli@ferreiraengenharia.com.br',10627),
(68180,27077,20,'Paulo Edson Zanella','18','9629-1509','18','3564-2030','obra64@ferreiraengenharia.com.br',10627),
(85540,27077,49,'Paulo Edson Zanella','18','9629-1509','18','3564-2030','obra64@ferreiraengenharia.com.br',10627),
(68181,27078,20,'Tomás Basse','11','5103-0362','11','3025-9000','tbasse@gafisa.com.br',433),
(68182,27078,16,'Maria de Lourdes','11','3025-9000','11','3025-9217','mfabre@gafisa.com.br',433),
(78087,27078,49,'Tomás Basse','11','5103-0362','11','3025-9000','tbasse@gafisa.com.br',433),
(68183,27080,20,'Walquiria Mafra (Telefonista)','11','3025-9307','11','3025-9217','telefonista.sp@gafisa.com.br',433),
(68184,27080,16,'Maria de Lourdes Fabre','11','3025-9000','11','3025-9217','mfabre@gafisa.com.br',433),
(78199,27080,49,'Diego Esteves','11','3071-4149','11','3025-9000','desteves@gafisa.com.br',433),
(68237,27100,16,'Luana Faria','11','3176-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(68238,27100,20,'Juliana Barreto (Marketing)','11','3176-1000','11','3176-1000','juliana.barreto@pdg.com.br',316),
(68239,27100,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(68246,27105,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(68269,27108,16,'Shirlei Ribeiro','11','3759-8639','11','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(68270,27108,70,'Emerson Pompeu','11','3759-8639','11','3759-8649','emersonpompeu@rossiresidencial.com.br',366),
(68271,27108,20,'Martin Daniel (Gestor Negócio)','11','3759-8639','11','3759-8649','martindaniel@rossiresidencial.com.br',366),
(68374,27134,16,'Rodrigo Cordasso','19','3432-3551','19','3432-3551','rodrigo.cordasso@supricelconstrutora.com.br',13675),
(68375,27134,49,'Flávio Souza','19','3432-3551','19','3432-3551','flavio.souza@supricelconstrutora.com.br',13675),
(68376,27134,20,'Rodrigo Cordasso','19','3432-3551','19','3432-3551','rodrigo.cordasso@supricelconstrutora.com.br',13675),
(68377,27135,16,'Rodrigo Cordasso','19','3282-1999','19','3432-3551','rodrigo.cordasso@supricelconstrutora.com.br',13675),
(68378,27135,49,'Flávio Souza','19','3432-3551','19','3432-3551','flavio.souza@supricelconstrutora.com.br',13675),
(68379,27135,20,'Rodrigo Cordasso','19','3282-1999','19','3432-3551','rodrigo.cordasso@supricelconstrutora.com.br',13675),
(68383,27137,16,'Eugênio Maciel','21','2621-5600','21','2620-4422','eugenio@fernandesmaciel.com.br',971),
(68384,27137,49,'Marcelo Barrozo','21','2611-2458','21','2621-5600','marcelobarrozo@fernandesmaciel.com.br',971),
(68385,27137,20,'Belizario (Apontador)','21','2704-7908','21','2621-5600','belizario@fernandesmaciel.com.br',971),
(68386,27138,16,'Dionathan Santos Rodrigues','27','3329-1466','27','3329-1466','dionathan@decottigniesconstrutora.com.br',10344),
(68387,27138,20,'Dionathan Santos Rodrigues','27','3329-1466','27','3329-1466','dionathan@decottigniesconstrutora.com.br',10344),
(68388,27138,49,'Dionathan Santos Rodrigues','27','3329-1466','27','3329-1466','dionathan@decottigniesconstrutora.com.br',10344),
(68423,27153,16,'Lisandra Almeida','12','3923-6030','12','3923-6030','lisandra@construtoracostanorte.com.br',5086),
(68424,27153,49,'Rodrigo Almeida','12','3942-1550','12','3923-6030','rodrigo@construtoracostanorte.com.br',5086),
(68425,27153,20,'Roberta Fernandes (Almoxarife)','12','3942-1550','12','3923-6030','roberta@construtoracostanorte.com.br',5086),
(68429,27155,16,'Adenúbia Suzi de Oliveira','27','3421-4900','27','3421-4905','nubia@orionengenharia.com.br',10279),
(68430,27155,20,'Mário Antônio','27','3421-4900','27','3421-4905','mario@orionengenharia.com.br',10279),
(68431,27155,49,'A definir','27','3421-4900','27','3421-4905','',10279),
(68432,27156,16,'Adenúbia Suzi de Oliveira','27','3421-4900','27','3421-4905','nubia@orionengenharia.com.br',10279),
(68433,27156,49,'Rodrigo Ferreira / Eduardo Verbone','27','3208-7169','27','3421-4900','goldenstar@orionengenharia.com.br',10279),
(106287,27156,20,'Ezequiel Azevedo','27','3208-7169','27','3421-4900','goldenstar@orionengenharia.com.br',10279),
(68434,27157,16,'José Carlos Fagundes','22','9254-1537','22','2762-9750','annalety@yahoo.com.br',5625),
(68435,27157,20,'José Carlos Fagundes','22','9254-1537','22','2762-9750','annalety@yahoo.com.br',5625),
(68436,27157,49,'Arq. Alexandre dos S. Dumas','22','2762-9750','22','2762-9750','',5625),
(68437,27158,16,'José Carlos F. S. Lima','22','9986-0827','22','2762-9750','annalety3@yahoo.com.br',5625),
(68438,27158,49,'José Carlos F. S. Lima','22','9986-0827','22','2762-9750','annalety3@yahoo.com.br',5625),
(68439,27158,20,'José Carlos F. S. Lima','22','9986-0827','22','2762-9750','annalety3@yahoo.com.br',5625),
(68452,27161,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(68453,27161,29,'Marcos Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(80094,27161,20,'Bianca Cruz (Marketing)','19','3578-0525','19','3234-1828','bianca.cruz@hmengenharia.com.br',14421),
(68459,27164,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(68460,27164,29,'Marcos Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(68461,27164,20,'Consuelo Miranda (Compras)','19','3578-0525','19','3234-1828','consuelo.miranda@hmengenharia.com.br',14421),
(68467,27169,16,'Alexandra Locks','48','2102-5100','48','2102-5120','xanda@construtoralocks.com.br',13686),
(68468,27169,49,'Fabiana Locks','48','2102-5100','48','2102-5120','fabi@construtoralocks.com.br',13686),
(68469,27169,20,'Alexandra Locks','48','2102-5100','48','2102-5120','xanda@construtoralocks.com.br',13686),
(68477,27173,21,'Giórgio Carvalho (Proprietário)','81','3445-3377','81','3445-3377','giorgio@tupanet.com.br',13688),
(68478,27173,20,'Ney Marques (Gerente)','81','3445-3377','81','3445-3377','gerencia@tupanet.com.br',13688),
(68480,27174,16,'Leandro Mendes','82','3231-8550','82','3231-8550','compras@reycon.com.br',13684),
(68481,27174,49,'Thiago Fabro','82','3355-1093','82','3231-8550','renover.engenharia@reycon.com.br',13684),
(68482,27174,20,'Eng. Osman Mendes','82','3355-1093','82','3231-8550','engenharia@reycon.com.br',13684),
(68489,27178,16,'Alexandra Locks','48','2102-5100','48','2102-5120','xanda@construtoralocks.com.br',13686),
(68490,27178,49,'Fabiana Fabrícia Locks','48','2102-5100','48','2102-5120','fabi@construtoralocks.com.br',13686),
(68491,27178,20,'Alexandra Locks','48','2102-5100','48','2102-5120','xanda@construtoralocks.com.br',13686),
(68501,27182,16,'Engº Luís Saraiva','51','3211-6444','51','3211-6444','projetos@isdra.com.br',13694),
(68502,27182,49,'Engº Luís Saraiva','51','3211-6444','51','3211-6444','projetos@isdra.com.br',13694),
(68503,27182,20,'Engº Luís Saraiva','51','3211-6444','51','3211-6444','projetos@isdra.com.br',13694),
(68575,27208,49,'Gilberto Barcala','11','2215-4040','11','2215-4040','gilberto.barcala@enprin.com.br',13699),
(68576,27208,16,'Edna da Costa','11','2215-4040','11','2215-4040','edna@enprin.com.br',13699),
(68577,27208,20,'Edna da Costa','11','2215-4040','11','2215-4040','edna@enprin.com.br',13699),
(68582,27211,16,'Roberto Rodrigues da Silva','79','3216-5000','79','3216-5093','roberto@celi.com.br,suprimentos@celi.com.br',427),
(68583,27211,49,'Sérgio Vasconcelos','79','3248-5001','79','3216-5000','vasconcelos@celi.com.br',427),
(68584,27211,20,'Israel Dantas (Administrativo)','79','3216-5000','79','3216-5093','alnox.ponteriopoxim@celi.com.br',427),
(68615,27221,16,'Alex Vicente','47','3367-2366','47','3367-2366','alex@essege.com.br',13706),
(68616,27221,49,'Rafael','47','3367-2366','47','3367-2366','',13706),
(68617,27221,20,'Michele Silva','47','3367-2366','47','3367-2366','recepcao@essege.com.br',13706),
(68645,27232,16,'José Carlos dos Santos','82','3296-3000','','','jose.santos@salinas.com.br',9133),
(68646,27232,49,'Amadeu Paulo','82','3296-3044','','','manutencao.sup@salinasmaragogi.com.br',9133),
(144093,27232,20,'Amadeu Paulo (engenheiro)','82','3296-3044','','','manuntencao.sup@salinamaragogi.com.br',9133),
(68659,27238,16,'Graziela Malafaia','82','3231-7300','82','3231-7300','compras.placic@ofm.com.br',9159),
(68660,27238,49,'Luis Henrique','82','3231-7300','82','3231-7300','placic@ofm.com.br',9159),
(68661,27238,20,'Paula Bisi','82','3231-7300','82','3231-7300','placic@ofm.com.br',9159),
(68699,27245,20,'Conceição Aparecida Alves','65','3317-7128','65','3317-7130','cmtasup@eln.gov.br',13720),
(68769,27267,16,'João Tarifa','48','3221-0400','48','3221-0400','compras@hantei.com.br',9300),
(68770,27267,49,'Lucília Ortega','48','3221-0400','48','3221-0400','engenharia@hantei.com.br',9300),
(68771,27267,20,'Bruna Pereira (Engenharia)','48','3221-0400','48','3221-0400','bruna@hantei.com.br',9300),
(68878,27308,16,'Divino Aparecido Almeida','62','9143-9175','62','3612-6518','divino@matherconstrutora.com.br',13738),
(68879,27308,49,'Jackson Luiz Alves de Souza','62','9921-4666','62','3612-6518','jackson@matherconstrutora.com.br',13738),
(68880,27308,20,'Jackson Luiz Alves de Souza','62','9921-4666','62','3612-6518','jackson@matherconstrutora.com.br',13738),
(68895,27315,20,'Rhalisson Dutra','61','8134-5252','61','3326-0003','engenharia@hgconstrutora.com.br',12891),
(68896,27315,49,'Ralhisson Dutra','61','8134-5252','61','3326-0003','engenharia@hgconstrutora.com.br',12891),
(68897,27315,16,'Fernando Alves (Depto Pessoal)','61','3326-0003','61','3326-0003','compras@hgconstrutora.com.br',12891),
(68907,27319,16,'Cassandra Rolim','85','3388-5800','85','3388-5833','cassandra@magis.com.br',12660),
(68908,27319,103,'Sérgio Macedo','85','3388-5800','85','3388-5833','magis@magis.com.br',12660),
(68909,27319,20,'Paulo Roberto (Engenharia)','85','3388-5800','85','3388-5833','paulorodrigues@magis.com.br',12660),
(68929,27323,16,'Shirley Bispo','33','3521-6616','31','3521-6616','shirleyalcance@hotmail.com',6859),
(77311,27323,49,'Fernando Toledo Lorentz','33','3521-6616','31','3521-6616','fernandoalcance@hotmail.com',6859),
(77312,27323,20,'Cleuber Santos Ferreira (Compras)','33','3521-6616','31','3521-6616','cleuberalcance@hotmail.com',6859),
(68996,27345,20,'Leandro Prime (Manutenção)','21','3545-5400','21','3545-5401','leandro.prime@goldentulip.com.br',13752),
(75394,27351,16,'Guilherme Freiitas','16','3703-4733','16','3703-4733','dikaengenharia@yahoo.com.br',14284),
(75395,27351,49,'Emílio Freitas','16','3703-4733','16','3703-4733','dikaengenharia@yahoo.com.br',14284),
(69041,27354,16,'Vagner Ribeiro','31','3222-9426','31','3222-9426','alternativa@alternativa.eng.br',13755),
(69042,27354,49,'Evandro Batista','31','3296-4688','31','3296-4688','vex@vexengenharia.com.br',13756),
(69043,27354,20,'Felipe Pablo (Estagiário)','31','2516-3965','31','3296-4688','vex@vexengenharia.com.br',13756),
(69111,27375,16,'Paulo Ronaldo','11','5087-9350','11','5087-9332','paulo@inovats.com.br',13764),
(69112,27375,49,'Daniel Bertolluti','11','7866-5784','11','5087-9350','daniel@inovats.com.br',13764),
(69113,27375,20,'Daniel Bertolluti','11','7866-5784','11','5087-9350','daniel@inovats.com.br',13764),
(69224,27415,16,'Gustavo Drumond','11','3512-4500','11','3512-4503','suprimentos@mrv.com.br',1504),
(69225,27415,21,'José Roberto','11','3512-4500','11','3512-4503','',1504),
(69226,27415,20,'Fabiano Bocardo','11','3512-4500','11','3512-4503','fabiano@mrv.com.br',1504),
(69275,27433,20,'Leandro Abreu (Comercial)','11','3811-1818','11','3815-2209','leandro.abreu@ideazarvos.com.br',957),
(69524,27524,20,'Adriana Pedroso','11','3147-7405','11','3251-2471','adriana.pedroso@maquina.inf.br',1724),
(77310,27524,20,'Renata Asprino','11','3147-7405','11','3251-2471','renata.asprino@maquina.inf.br',1724),
(69563,27537,16,'Katharina Rosa','11','3724-9500','11','3724-9518','katharina@exto.com.br',227),
(69564,27537,20,'Camila Luize (Marketing)','11','3724-9500','11','3724-9518','camila@exto.com.br',227),
(69565,27537,21,'Roger Miotto / Willian Gilheta','11','3724-9500','11','3724-9518','roger@exto.com.br,willian@exto.com.br',227),
(69576,27539,20,'Fuad Júnior (Licitação)','61','3315-4892','61','3315-4055','cgs@dnit.gov.com.br',4868),
(69650,27570,16,'Ueldon Gomes','71','3444-1400','71','3444-1400','ugomes@arcengenharia.com.br',2923),
(69651,27570,21,'Roberto Tanajura','71','3444-1400','71','3444-1400','tecnico@arcengenharia.com.br',2923),
(69652,27570,20,'Teliane de Cruz (Atendimento)','71','3444-1400','71','3444-1400','decruz@arcengenharia.com.br',2923),
(70041,27701,49,'Vitor Klisys','16','2102-7479','16','2102-7566','vklisys@santaursulanet.com.br',13892),
(70042,27701,49,'Paula Bredariol','16','2102-7400','16','2102-7566','pbredariol@santaursulanet.com.br',13892),
(78412,27701,20,'Robson Barizza','16','2102-7479','16','2102-7566','r.barizza@santaursulanet.com.br',13892)


;

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

VALUES
(24523,'RE020361'),
(24634,'IN000499'),
(24639,'RE020382'),
(24659,'RE020390'),
(24697,'IN000516'),
(24709,'RE020406'),
(24720,'CO202663'),
(24726,'CO202665'),
(24728,'CO202664'),
(24730,'CO202661'),
(24732,'CO202662'),
(24733,'CO202660'),
(24748,'IN000525'),
(24824,'IN000539'),
(24832,'RE020462'),
(24833,'RE020461'),
(24859,'RE020464'),
(24875,'RE020488'),
(24876,'CO202747'),
(24877,'RE020489'),
(24878,'CO202746'),
(24880,'CO202745'),
(24881,'RE020490'),
(24884,'RE020486'),
(24887,'RE020485'),
(24900,'CO202753'),
(24902,'CO202744'),
(24905,'CO202748'),
(24928,'CO202774'),
(24929,'CO202775'),
(24930,'CO202770'),
(24931,'CO202769'),
(24934,'CO202778'),
(24935,'CO202779'),
(24940,'RE020521'),
(24943,'CO202773'),
(24944,'CO202768'),
(24945,'CO202771'),
(24946,'CO202772'),
(24951,'RE020546'),
(24953,'RE020545'),
(24955,'RE020541'),
(24958,'RE020542'),
(24960,'RE020543'),
(24964,'RE020540'),
(24969,'RE020579'),
(25012,'RE020527'),
(25015,'CO202776'),
(25016,'CO202777'),
(25033,'RE020528'),
(25037,'IN000541'),
(25043,'IN000573'),
(25067,'IN000583'),
(25069,'IN000584'),
(25085,'RE020595'),
(25088,'RE020594'),
(25125,'RE020622'),
(25138,'RE020630'),
(25139,'CO202818'),
(25140,'IN000602'),
(25141,'IN000603'),
(25143,'IN000601'),
(25180,'RE020650'),
(25192,'RE020678'),
(25197,'RE020672'),
(25212,'CO202830'),
(25247,'RE020726'),
(25250,'RE020725'),
(25253,'RE020724'),
(25256,'RE020710'),
(25281,'RE020736'),
(25289,'RE020738'),
(25290,'RE020737'),
(25293,'IN000624'),
(25295,'RE020741'),
(25296,'RE020742'),
(25306,'RE020748'),
(25308,'CO202852'),
(25309,'RE020749'),
(25355,'CO202873'),
(25359,'CO202872'),
(25375,'RE020814'),
(25381,'RE020815'),
(25404,'RE020806'),
(25431,'RE020823'),
(25437,'RE020825'),
(25438,'RE020824'),
(25444,'RE020834'),
(25446,'RE020833'),
(25448,'RE020832'),
(25456,'IN000652'),
(25471,'RE020844'),
(25472,'RE020854'),
(25479,'CO202904'),
(25498,'RE020858'),
(25502,'CO202905'),
(25509,'CO202908'),
(25510,'RE020874'),
(25512,'RE020878'),
(25530,'RE020885'),
(25533,'RE020886'),
(25535,'CO202918'),
(25539,'RE020889'),
(25543,'RE020891'),
(25546,'RE020902'),
(25551,'RE020901'),
(25554,'RE020903'),
(25558,'RE020899'),
(25559,'RE020900'),
(25563,'RE020905'),
(25564,'RE020904'),
(25565,'RE020897'),
(25568,'RE020898'),
(25569,'RE020895'),
(25570,'RE020907'),
(25578,'RE020908'),
(25580,'RE020910'),
(25589,'IN000670'),
(25598,'IN000674'),
(25609,'RE020930'),
(25610,'RE020931'),
(25612,'RE020932'),
(25614,'RE020933'),
(25617,'RE020918'),
(25618,'RE020934'),
(25620,'RE020935'),
(25622,'RE020936'),
(25623,'RE020937'),
(25624,'RE020938'),
(25628,'CO202951'),
(25630,'RE020941'),
(25631,'RE020942'),
(25632,'RE020943'),
(25633,'RE020944'),
(25634,'RE020945'),
(25635,'RE020946'),
(25636,'RE020947'),
(25637,'RE020948'),
(25638,'RE020949'),
(25639,'RE020950'),
(25644,'CO202953'),
(25645,'CO202952'),
(25680,'RE020964'),
(25693,'CO202976'),
(25702,'RE020973'),
(25735,'RE020990'),
(25737,'RE020992'),
(25739,'RE020989'),
(25740,'RE020991'),
(25742,'RE020988'),
(25749,'RE020993'),
(25793,'RE021012'),
(25802,'CO203014'),
(25804,'RE021023'),
(25812,'CO203011'),
(25820,'RE021024'),
(25859,'IN000721'),
(25867,'IN000723'),
(25943,'RE021100'),
(25947,'RE021099'),
(25963,'RE021109'),
(25965,'RE021107'),
(25971,'RE021110'),
(26019,'IN000748'),
(26056,'CO203102'),
(26060,'CO203097'),
(26075,'RE021166'),
(26076,'RE021164'),
(26078,'RE021165'),
(26079,'RE021163'),
(26082,'IN000757'),
(26108,'CO203113'),
(26131,'RE021210'),
(26132,'RE021208'),
(26135,'RE021209'),
(26154,'IN000774'),
(26165,'RE021226'),
(26169,'RE021221'),
(26172,'RE021240'),
(26175,'RE021239'),
(26181,'IN000775'),
(26224,'IN000782'),
(26228,'IN000783'),
(26231,'IN000784'),
(26267,'RE021297'),
(26275,'CO203147'),
(26295,'RE021314'),
(26301,'RE021317'),
(26311,'IN000809'),
(26312,'IN000803'),
(26313,'IN000804'),
(26314,'IN000810'),
(26315,'IN000811'),
(26321,'CO203154'),
(26335,'RE021328'),
(26336,'RE021330'),
(26337,'RE021329'),
(26365,'RE021337'),
(26368,'RE021336'),
(26371,'RE021338'),
(26375,'RE021347'),
(26379,'IN000825'),
(26396,'RE021355'),
(26413,'RE021365'),
(26417,'RE021366'),
(26450,'RE021390'),
(26457,'RE021391'),
(26462,'RE021392'),
(26482,'RE021411'),
(26489,'RE021412'),
(26517,'RE021426'),
(26520,'RE021427'),
(26535,'RE021429'),
(26539,'RE021430'),
(26543,'RE021431'),
(26561,'RE021437'),
(26565,'RE021440'),
(26570,'RE021441'),
(26573,'CO203252'),
(26574,'RE021439'),
(26584,'RE021456'),
(26591,'RE021465'),
(26633,'RE021504'),
(26641,'RE021505'),
(26686,'RE021524'),
(26690,'RE021526'),
(26691,'RE021523'),
(26714,'RE021525'),
(26736,'RE021532'),
(26755,'RE021546'),
(26764,'RE021554'),
(26765,'IN000867'),
(26766,'CO203337'),
(26767,'IN000868'),
(26771,'IN000869'),
(26773,'RE021556'),
(26775,'CO203335'),
(26776,'IN000865'),
(26788,'IN000873'),
(26790,'CO203342'),
(26793,'RE021570'),
(26795,'RE021564'),
(26799,'RE021569'),
(26800,'RE021567'),
(26801,'CO203341'),
(26803,'CO203345'),
(26805,'RE021563'),
(26806,'CO203340'),
(26808,'RE021565'),
(26809,'CO203343'),
(26811,'CO203347'),
(26818,'CO203250'),
(26820,'CO203354'),
(26821,'RE021575'),
(26823,'CO203251'),
(26825,'CO203352'),
(26827,'CO203351'),
(26828,'RE021574'),
(26835,'CO203353'),
(26840,'RE021582'),
(26841,'RE021583'),
(26844,'RE021624'),
(26847,'RE021594'),
(26851,'IN000885'),
(26853,'RE021595'),
(26857,'RE021596'),
(26859,'IN000887'),
(26860,'RE021597'),
(26862,'IN000886'),
(26864,'RE021598'),
(26870,'RE021621'),
(26873,'RE021601'),
(26875,'RE021603'),
(26876,'RE021622'),
(26877,'RE021602'),
(26878,'RE021623'),
(26881,'RE021625'),
(26884,'CO203362'),
(26886,'RE021629'),
(26889,'CO203370'),
(26890,'RE021627'),
(26891,'CO203369'),
(26894,'CO203368'),
(26896,'CO203367'),
(26897,'RE021628'),
(26898,'RE021632'),
(26899,'CO203366'),
(26901,'CO203365'),
(26902,'RE021626'),
(26903,'CO203364'),
(26911,'CO203378'),
(26914,'RE021636'),
(26915,'RE021634'),
(26916,'CO203379'),
(26919,'CO203377'),
(26921,'CO203384'),
(26924,'CO203375'),
(26926,'CO203382'),
(26931,'CO203376'),
(26936,'CO203383'),
(26941,'RE021657'),
(26943,'RE021647'),
(26944,'CO203389'),
(26945,'RE021662'),
(26948,'CO203390'),
(26951,'CO203391'),
(26963,'RE021658'),
(26965,'RE021661'),
(26966,'RE021650'),
(26984,'RE021689'),
(26987,'IN000864'),
(26995,'IN000912'),
(26996,'IN000913'),
(27004,'RE021694'),
(27011,'RE021695'),
(27013,'CO203403'),
(27017,'RE021692'),
(27020,'RE021691'),
(27029,'RE021698'),
(27030,'RE021697'),
(27031,'RE021696'),
(27043,'RE021711'),
(27047,'IN000914'),
(27056,'CO203415'),
(27072,'CO203416'),
(27073,'CO203418'),
(27074,'CO203424'),
(27075,'CO203417'),
(27076,'CO203419'),
(27077,'CO203420'),
(27078,'CO203421'),
(27079,'CO203422'),
(27080,'CO203423'),
(27100,'IN000915'),
(27101,'RE021746'),
(27105,'RE021745'),
(27108,'RE021744'),
(27134,'RE021753'),
(27135,'RE021750'),
(27137,'RE021751'),
(27138,'RE021754'),
(27141,'RE021755'),
(27145,'RE021792'),
(27153,'RE021779'),
(27155,'RE021796'),
(27156,'RE021798'),
(27157,'RE021780'),
(27158,'RE021781'),
(27161,'RE021782'),
(27164,'RE021797'),
(27165,'RE021783'),
(27169,'RE021784'),
(27173,'CO203457'),
(27174,'RE021799'),
(27175,'RE021794'),
(27178,'CO203458'),
(27182,'RE021788'),
(27208,'IN000921'),
(27211,'IN000920'),
(27221,'RE021820'),
(27232,'CO203478'),
(27238,'CO203470'),
(27245,'RE021830'),
(27267,'RE021842'),
(27308,'CO203498'),
(27315,'CO203500'),
(27319,'CO203499'),
(27323,'CO203496'),
(27345,'RE021909'),
(27351,'RE021898'),
(27354,'RE021910'),
(27375,'IN000926'),
(27415,'IN000929'),
(27433,'IN000933'),
(27521,'CO203558'),
(27524,'IN000936'),
(27537,'RE022002'),
(27539,'RE022038'),
(27570,'IN000940'),
(27701,'CO203615')

;

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