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

(51837,20728,16,'João Maria','91','3246-7100','91','3246-6805','gerencia@realengenharia.com',11290),
(71148,20728,20,'Rodolfo Carvalho','91','9114-5908','91','3222-6615','rodolfooplima@hotmail.com',11290),
(71149,20728,49,'Rodolfo Carvalho','91','9114-5908','91','3222-6615','rodolfooplima@hotmail.com',11290),
(51847,20732,16,'Angelino Leite da Cruz','61','3363-8166','61','3234-0305','multicondco@multiconengenharia.com.br',7276),
(51848,20732,49,'Jorge Cunha','61','9148-5110','61','3234-1514','multiconrd@gmail.com',7276),
(51849,20732,20,'Angelino Leite da Cruz','61','3234-1514','61','3365-1308','multicondco@multiconengenhariacom.br',7276),
(51903,20753,20,'Luciana Marques (Operacional)','21','2488-1355','21','2488-1355','luciana.marques@madureirashopping.com.br',11310),
(52096,20821,20,'Adhemar Pinheiro','31','3891-3694','31','3891-3694','adhemarpds@yahoo.com.br',12606),
(60503,20821,16,'Adhemar Pinheiro','31','3891-3694','31','3891-3694','adhemarpds@yahoo.com.br',12606),
(60504,20821,49,'Arnaldo Dias / Aldair Pinheiro','31','3891-3694','31','3891-3694','',12606),
(52338,20906,20,'José Loureiro (Dir. Industrial)','37','3214-1140','37','3214-1188','loureiro@jano.ind.br',11391),
(67977,20906,21,'José Loureiro (Dir. Industrial)','37','3214-1140','37','3214-1188','loureiro@jano.ind.br',11391),
(73123,20906,16,'Helena Maria','37','3214-1140','37','3214-1188','jano@jano.ind.br',11391),
(52353,20913,16,'Ivânio Santos','81','3442-8454','81','3442-8454','compras@projest.com.br',652),
(52354,20913,49,'César Pinheiro de Andrade Lima','81','3442-8454','81','3442-8454','projest@hotlink.com.br',652),
(52355,20913,20,'Viviane','81','3442-8454','81','3442-8454','projest@hotlink.com.br',652),
(52381,20922,16,'José Amilse','21','2620-2233','21','2719-7137','compras@soter.com.br',2009),
(52382,20922,21,'Engº José Geraldo Tavares','21','2716-9393','21','2719-7137','',2009),
(52383,20922,20,'Heloisa','21','2716-9393','21','2719-7137','helo@soter.com.br',2009),
(52387,20924,16,'Patrícia Canhete','21','3936-0657','21','3936-0657','patriciacanhete@hotmail.com',10506),
(52388,20924,7,'Marcos C. dos S. Barbosa','21','9975-7130','21','3839-7832','marcosbarbosarq@bol.com.br',772),
(52389,20924,20,'Patrícia Canhete','21','3936-0657','21','3936-0657','patriciacanhete@hotmail.com',10506),
(87260,20924,49,'Marcos C. dos S. Barbosa','21','9975-7130','21','3839-7832','marcosbarbosarq@bol.com.br',772),
(52464,20951,16,'Juliana Santana','21','3388-0899','21','2438-8228','compras@tecnocohrp.com.br',4888),
(52465,20951,49,'Engº Israel Ronald Btechs','21','3388-0899','21','2438-8228','tecnocohrp@terra.com.br',4888),
(52466,20951,20,'Juliana Santana','21','3388-0899','21','2438-8228','compras@tecnocohrp.com.br',4888),
(70408,20952,16,'Celso Ribeiro','11','3759-8639','11','3759-8639','celsoribeiro@rossiresidencial.com.br',366),
(70409,20952,20,'André Fogaça','11','3759-8600','11','3759-8600','andrefogaca@rossiresidencial.com.br',366),
(70410,20952,70,'Emerson Pompeu','11','3759-8600','11','3759-8600','',366),
(52478,20955,16,'Carlos Alberto Franco / Marli','11','3074-7674','11','3074-7676','marli@matraengenharia.com.br',11404),
(52479,20955,49,'Carlos Alberto Franco','11','3884-8478','11','3074-7674','mantra@mantraengenharia.com.br',11404),
(52480,20955,20,'Carlos Alberto Franco','11','3074-7674','11','3074-7676','mantra@mantraengenharia.com.br',11404),
(52487,20958,16,'Adelson Vieira ou Denise','21','3505-9300','21','3505-9333','compras@lafem.com.br',3652),
(52488,20958,49,'Engº Fernando M. O. Lima','21','3505-9300','21','3505-9333','',3652),
(52489,20958,20,'Leonardo Souza','21','3505-9300','21','3505-9333','',3652),
(52542,20977,20,'Renato Gomes','11','3660-9700','11','3392-7588','renato@servtec.com.br',11401),
(52544,20978,16,'Andréia Gonçalves / Mário / Francisco e Bruno','21','3823-7699','21','3823-7555','andreia.goncalves@br.brookfield.com',3269),
(70343,20978,20,'Roberto Soares','21','3823-7699','21','2483-1908','robertoaraujo@br.brookfield.com',3269),
(70344,20978,21,'Gui Alexandre Ferreira','21','3823-7699','21','3823-7555','gui.alexandre@br.brookfield.com',3269),
(76992,20978,49,'Allan Carlos Steffanello','21','2483-1908','21','3823-7699','allan.steffanello@br.brookfield.com',3269),
(52561,20984,49,'Carlos Eduardo Brasil (Gerente Industrial)','21','3282-0400 - R. 0480','21','3282-0401','cebrasil@marko.com.br',11420),
(96337,20984,20,'Carlos Eduardo Brasil (Gerente Industrial)','21','3282-0400 - R. 0480','21','3282-0401','cebrasil@marko.com.br',11420),
(96338,20984,16,'Carlos Eduardo Brasil (Gerente Industrial)','21','3282-0400 - R. 0480','21','3282-0401','cebrasil@marko.com.br',11420),
(110826,20986,16,'Diego','34','3225-4382','34','3233-6000','diego@calu.com.br',11419),
(110827,20986,20,'Mário (Adm. Obra)','34','3225-4382','','','guilherme.aguilar@conel.com.br',6339),
(110828,20986,49,'Ana Luiza','34','9236-5703','','','analuiza@conel.com.br',6339),
(119428,20986,16,'Marlos','34','3233-6000','','','marlose@calu.com.br',11419),
(52632,21016,16,'Guilherme Lima','31','3235-4600','31','3235-4600','guilherme.lima@direcional.com.br',4566),
(52633,21016,20,'Wellington Souza','19','3238-7864','31','3235-4600','wellington.souza@direcional.com.br',4566),
(60555,21016,49,'Giovanne','19','3238-7864','31','3235-4600','',0),
(60556,21016,49,'Giovanne Mendes Lino','19','3238-7864','31','3235-4600','giovannne.mendes@direcional.com.br',4566),
(52634,21017,16,'Célia Soares','19','3794-3300','19','3794-3339','celiasoares@rossiresidencial.com.br',1683),
(52635,21017,20,'Maria Angela Silva (DAC)','19','3256-6609','19','3709-1212','mariaangela@rossiresidencial.com.br',1683),
(66587,21017,29,'Edison Campos','19','3709-1212','19','3709-1212','edisoncampos@rossiresidencial.com.br',1683),
(52837,21102,20,'Setor de Licitações','41','3330-3636','41','3330-3344','',463),
(71348,21121,49,'Washington Luís','85','3257-1432','85','3257-1432','okempreendimentos@gmail.com',12964),
(71349,21121,16,'Olirio Teixeira Júnior','85','3257-1432','85','3257-1432','oliriojr@hotmail.com',12964),
(71350,21121,20,'Olirio Teixeira Júnior','85','3257-1432','85','3257-1432','oliriojr@hotmail.com',12964),
(53053,21187,16,'Fernando Aquino','82','3327-6347','82','3327-6347','compras@marroquim.com.br',9926),
(53054,21187,49,'Patrick','82','3346-0330','82','3346-0330','imperiali@marroquim.com.br',9926),
(53055,21187,20,'Márcia (Compras)','82','3346-0330','82','3327-6347','aux.compras@marroquim.com.br',9926),
(53067,21191,16,'Engº Domizett J. dos Santos','21','9514-5345','21','3637-7058','domizett.cefetq@terra.com.br',11509),
(53068,21191,49,'Engº Domizett J. dos Santos','21','9514-5345','21','3637-7058','domizett.cefetq@terra.com.br',11509),
(53069,21191,20,'Engº Domizett J. dos Santos','21','3637-7058','21','2691-1811','domizett.cefetq@terra.com.br',11509),
(53100,21202,16,'Flávio H. Pinto','31','3280-3200','31','3261-2229','compras@clv.com.br',9368),
(53101,21202,49,'Alex Nascimento','31','3264-9468','31','3280-3200','alex@clv.com.br',9368),
(53102,21202,20,'Gláucia (Estagiária)','31','3264-9468','31','3280-3200','',9368),
(53111,21206,20,'Carlos Abdalla - (Comunicação)','19','2103-1954','19','2103-2260','relacoes.corporativas@br.bosch.com.br',5334),
(53112,21206,34,'Diretoria Industrial','71','2107-4000','71','2107-4274','',11508),
(53126,21210,20,'Elcio Munhai - (Contador)','11','4526-1140','11','4526-2281','elcio@dubar.com.br',765),
(53141,21218,20,'Suprimentos','51','3094-6510','51','3323-2080','',1273),
(53195,21237,16,'Engº Ricardo B. Vasconcelos','21','2635-3319','21','2639-0425','rbvengenharia@hotmail.com',8882),
(53196,21237,49,'Engº Ricardo B. Vasconcelos','21','2635-3319','21','2639-0425','',8882),
(53197,21237,20,'Telma Tako','21','2635-3319','21','2639-0425','rbvengenharia@hotmail.com',8882),
(53206,21243,16,'Tarcísio Fonseca','21','2172-1800','21','2172-1845','tarcisio@calper.com.br',310),
(53207,21243,20,'Karen Pereira','21','3592-5431','21','2172-1832','karen.pereira@calper.com.br',310),
(98369,21243,49,'Eduardo Veretta','21','3592-5431','21','2172-1800','eduardoveretta@calper.com.br',310),
(53211,21245,20,'José Roberto Dalbem (Suprimentos)','19','3809-6600','19','3809-6607','jdalbem@gonvarri.com',2333),
(53283,21273,16,'Roberto / Ricardo M. Caúla','21','2243-3314','21','2243-3314','engenharia.freeservice@gmail.com',10525),
(53284,21273,49,'Engº Ricardo Murilo Caúla','21','2243-3314','21','2243-3314','freeservice@oi.com.br',10525),
(53285,21273,20,'Fernando Mendes Júnior','21','2243-3314','21','2243-3314','',10525),
(53288,21275,49,'Rogério Romeiro','11','2823-1900','11','2823-1900','rogerioromeiro@setinengenharia.com.br',39),
(53289,21275,20,'Luciana Brunelli (Engenharia)','11','2823-1900','11','2823-1900','luciana.brunelli@setinengenharia.com.br',39),
(59313,21275,16,'Ana Cristina','11','2823-1900','11','2823-1900','anacristina.eng@setin.com.br',39),
(53290,21276,49,'Sandro Gazotti','11','3392-3527','11','3041-1150','sandro.gazotti@grupoagre.com.br',14788),
(53291,21276,20,'Edmilson Souza (Administração)','11','3392-3527','11','3041-1150','edmilson.souza@grupoagre.com.br',14788),
(59400,21276,16,'Ana Cristina','11','3392-3527','11','3041-1150','anacristina@agreconstrutora.com.br',14788),
(53332,21299,16,'Patrícia Guedes Camargo','21','3511-5574','21','3511-5574','',11538),
(53333,21299,49,'Patrícia Guedes Camargo','21','3511-5574','21','3511-5574','',11538),
(53334,21299,20,'Sr. Vilamar','21','3511-5574','21','3511-5574','',11538),
(53494,21360,16,'Aline Flegler','27','3329-6788','27','3200-4748','aline@lattorr.com.br',2216),
(53495,21360,49,'Almir Simões','27','3329-6788','27','3329-6170','lattorre@lattorre.com.br',2216),
(53496,21360,20,'Elane Domingues','27','3329-6788','27','3200-4748','lattorre@lattorre.com.br',2216),
(53497,21361,16,'Engª Rita Zaner','21','3507-2461','21','8866-9339','info@ndeus.com.br',1127),
(53498,21361,49,'Nelson da Rocha Deus','21','3507-2461','21','8844-2458','info@ndeus.com.br',1127),
(53499,21361,20,'Roberto Luiz','21','3507-2461','21','3507-2462','info@ndeus.com.br',1127),
(53500,21362,20,'Welton Almeida (Administração)','61','3333-7878','61','3333-7878','sac.snt@embrapa.br',11553),
(53501,21362,62,'José Roberto (Ger. Geral)','61','3448-4510','61','3347-1041','',11553),
(53600,21404,20,'Valter Queiroz','31','3499-8322','31','3499-8381','walter.almeida@usiminas.com',58),
(53601,21404,21,'Marco Paulo Pena Cabral','31','3499-8110','31','3499-8473','',58),
(53604,21405,16,'Fábio Steiner / Marcos Ritta','48','3461-8100','48','3461-8100','compras@construtorasfontana.com.br',3509),
(53605,21405,70,'Rodrigo Ugioni','48','3461-8100','48','3461-8100','rodrigo@construtorafontana.com.br',3509),
(53606,21405,20,'Naiara Silvano (Marketing)','48','3461-8100','48','3461-8100','naiara.silvano@construtorafontana.com.br',3509),
(91119,21405,49,'Ricardo Martins','48','3461-8100','48','3461-8100','ricardo.martins@construtorafontana.com.br',3509),
(53798,21483,16,'Rogério Murrieta','61','3363-9270','61','3363-9270','rogerio@construtoraargus.com.br',5797),
(53799,21483,49,'André Antônio Carneiro','61','3363-9270','61','3363-9270','andre@construtoraargus.com.br',5797),
(53800,21483,20,'Jairo','61','3363-9270','61','3363-9270','',5797),
(53801,21484,16,'Rogério Murrieta','61','3363-9270','61','3363-9270','rogerio@construtoraargus.com.br',5797),
(53802,21484,49,'André Antônio Carneiro','61','3363-9270','61','3363-9270','andre@construtoraargus.com.br',5797),
(53803,21484,20,'Jairo','61','3363-9270','61','3363-9270','',5797),
(53821,21493,20,'Sr. Benevides (Ger. Administrativo) R: 4284','31','3279-4477','31','3279-4476','',11607),
(53822,21493,21,'Sr. Antônio Ribeiro (Ger. Projetos)','31','3279-4473','31','3279-4476','',11607),
(53830,21496,16,'Setor Compras','31','3343-8000','31','3343-8001','suprimentos@agmar.com.br',4457),
(53831,21496,49,'Alessandra Xisto','31','3291-8000','31','3343-8000','alessandra@agmar.com.br',4457),
(53832,21496,20,'Alessandra Xisto','31','3291-8000','31','3343-8000','alessandra@agmar.com.br',4457),
(72063,21496,20,'Luiz Carlos (Projetos)','31','3291-8000','31','3343-8000','construtora@agmar.com.br',4457),
(53836,21498,16,'Edvaldo Xisto','31','3285-0353','31','3343-8000','suprimentos@agmar.com.br',4457),
(53837,21498,49,'Agmar Antônio Xisto Júnior','31','3285-0353','31','3343-8000','construtora@agmar.com.br',4457),
(53838,21498,20,'Vanderson Soares','31','3285-0353','31','3343-8000','construtora@agmar.com.br',4457),
(53839,21499,16,'Francisco Gonçalves','11','4721-5045','','','',11599),
(53840,21499,20,'Francisco Gonçalves','11','4721-5045','','','',11599),
(53894,21521,16,'Roberto Muragushi','43','3371-1000','43','3371-1001','roberto@ayoshii.com.br',2900),
(53895,21521,49,'Roberto Muraguchi','43','3371-1000','43','3371-1001','roberto@ayoshii.com.br',2900),
(53896,21521,21,'Leonardo Schibelski','43','9993-5507','43','3371-1000','leonardo@ayoshii.com.br',2900),
(69789,21521,20,'Leonardo Schibelski','43','9993-5507','43','3371-1000','leonardo@ayoshii.com.br',2900),
(53909,21526,16,'Engº Maurício Santiago','21','2719-1020','21','2719-1020','mauriciosantiago@terra.com.br',11618),
(53910,21526,49,'Engº Maurício Santiago','21','2719-1020','21','2719-1020','',11618),
(53911,21526,20,'Sr. Leandro','21','2719-1020','21','2719-1020','',11618),
(53918,21529,16,'André Luiz','17','3234-2468','17','3234-2468','contato@prp.org.br',11617),
(53919,21529,49,'Ovasco Resende','17','3234-2468','17','3234-2468','contato@prp.org.br',11617),
(53920,21529,20,'André Luiz','17','3234-2468','17','3234-2468','contato@prp.org.br',11617),
(53945,21536,16,'Andrea Fraga','11','4692-1006','','','deiafraga@hotmail.com',11621),
(53946,21536,20,'Andrea Fraga','11','4692-1006','','','deiafraga@hotmail.com',11621),
(53962,21542,16,'Alberto','11','3071-2299','11','3071-2299','alberto@fraiha.com.br',2039),
(53963,21542,49,'Alberto','11','3071-2299','11','3071-2299','alberto@fraiha.com.br',2039),
(53964,21542,20,'Alberto','11','3071-2299','11','3071-2299','alberto@fraiha.com.br',2039),
(54002,21563,16,'Ricardo Magalhães','16','3512-4500','16','3512-4500','ricardo.magalhães@mrv.com.br',4203),
(54003,21563,49,'Luciano Henrique Berto','16','3512-4500','16','3512-4500','',4203),
(54004,21563,20,'Edinelsa Santos - (Stand)','16','3335-8233','16','3512-4500','edinelsa_santos@yahoo.com.br',4203),
(54039,21576,16,'César','44','3029-0036','44','3029-0036','batelacabamento@uol.com.br',11629),
(54040,21576,49,'Lupércio','44','3029-0036','44','3029-0036','',11629),
(54041,21576,49,'Manuel','44','3029-0036','44','3029-0036','',11629),
(54055,21581,20,'Setor CPL','69','3216-4011','69','3224-7861','cpl@ceron.com.br',4749),
(54137,21610,16,'Marcelo Neves Senna','24','9977-4200','24','2225-0797','marcelo.senna2008@yahoo.com.br',11647),
(54138,21610,7,'Arq. Marcelo Neves Senna','24','9977-4200','24','2225-0797','',11647),
(54139,21610,20,'Sr. Ironil','24','2225-0797','','','',11647),
(54195,21632,16,'Milton Neto','31','3397-5593','31','2551-0925','milton@construtoraqbhz.com.br',11650),
(54196,21632,49,'Milton Neto','31','3397-5593','31','2551-0925','milton@construtoraqbhz.com.br',11650),
(54197,21632,20,'Milton Neto','31','3397-5593','31','2551-0925','milton@construtoraqbhz.com.br',11650),
(54207,21636,16,'Luis Tabelião','11','4796-7410','11','4796-7410','luis@formattoarquitetura.com.br',11651),
(54208,21636,49,'Luis Tabelião','11','4796-7410','11','4796-7410','luis@formattoarquitetura.com.br',11651),
(54209,21636,20,'Luis Tabelião','11','4796-7410','11','4796-7410','luis@formattoarquitetura.com.br',11651),
(54219,21642,20,'Cleuza (Adm.)','11','2972-9777','11','2281-8870','',11654),
(54299,21677,16,'Engº Leonardo Muniz','21','7820-1959','21','2425-0233','',11669),
(54300,21677,49,'Engº Leonardo Muniz','21','7820-1959','21','2425-0233','',11669),
(54301,21677,20,'Leonardo César','21','2425-0233','21','2425-0233','',11669),
(54309,21680,16,'Arq. Robson D. Jeovani','22','2665-7905','22','2665-7905','rdjeovani@hotmail.com',8678),
(54310,21680,7,'Arq. Robson D. Jeovani','22','2665-7905','22','2665-7905','rdjeovani@hotmail.com',8678),
(54311,21680,20,'Sr. Sérgio','22','2665-7905','22','2665-7905','rdjeovani@hotmail.com',8678),
(54321,21686,20,'Luis Octávio','21','2602-4400','21','2109-4475','',11671),
(54322,21686,49,'Luis Octávio','21','2602-4400','21','2109-4475','loctavio@aloes.com.br',11671),
(54323,21686,21,'Luis Octávio','21','2602-4400','21','2109-4475','loctavio@aloes.com.br',11671),
(54324,21686,37,'Altomir Régis da Cunha','21','2602-4400','21','2109-4475','',11671),
(54334,21687,16,'Yolanda Ribeiro','11','4153-9828','11','4153-9826','yolanda@gng.com.br',9501),
(54335,21687,49,'Cláudio Gomes','11','4153-9828','11','4153-9828','claudio.gomes@gng.com.br',9501),
(54336,21687,20,'Yolanda Ribeiro','11','4153-9828','11','4153-9828','yolanda@gng.com.br',9501),
(54341,21690,16,'Adair Lopes','21','2173-8000','21','2173-8119','adair@klabinsegall.com.br',10354),
(54342,21690,49,'Madruga','21','2173-8000','21','2173-8119','',10354),
(54343,21690,20,'Adair Lopes','21','2173-8000','21','2173-8119','adair@klabinsegall.com.br',10354),
(79935,21690,16,'Sr. Adair Lopes','21','2173-8100','21','2173-8119','adair.lopes@agreconstrutora.com.br',12345),
(79936,21690,49,'Sérgio Caruso','21','2767-4847','21','2173-8100','sergio.caruso@agreconstrutora.com.br',12345),
(79937,21690,20,'Edgar Pereira de Almeida (Técnico)','21','2767-4847','21','2173-8100','edgar.almeida@agreconstrutora.com.br',12345),
(54390,21708,16,'Geraldo B. Domingo','11','4651-3566','','','',11677),
(54391,21708,20,'Geraldo B. Domingo','11','4651-3566','','','',11677),
(54392,21709,49,'José Roberto Teixeira de Carvalho','21','2438-4504','21','2438-4504','jtweng@visar.com.br',1792),
(54393,21709,20,'José Henrique','21','2438-4504','21','2438-4504','jtweng@visar.com.br',1792),
(54397,21709,16,'José Davi Neto','21','2438-4504','21','2438-4504','jtweng@visar.com.br',1792),
(54394,21710,16,'José Davi Neto','21','2438-4504','21','2438-4504','jtweng@visar.com.br',1792),
(54395,21710,49,'Engº José Roberto Teixeira de Carvalho','21','2438-4504','21','2438-4504','jtweng@visar.com.br',1792),
(54396,21710,20,'Silvio Davi','21','2438-4504','21','2438-4504','jtweng@visar.com.br',1792),
(54424,21721,20,'Helena Porfírio (Gerente)','31','3551-1488','31','3551-5028','helena@grandehotelop.com.br',11683),
(89046,21721,16,'Sr. Jarbas Avelar (Proprietário)','31','3551-1488','31','3551-5028','grandehotel@veloxmail.com.br',11683),
(89047,21721,49,'Sr. Jarbas Avelar','31','3551-1488','31','3551-5028','grandehotel@veloxmail.com.br',11683),
(54441,21728,16,'Macelo ou Eliseu','21','2112-1600','21','2112-1636/28','',4073),
(54442,21728,49,'Rojes Felício M. Ferreira','21','2112-1600','21','2112-1636/28','limpatech@openlink.com.br',4073),
(54443,21728,20,'Amauri Cunha (Planejamento)','21','2112-1605','21','2112-1636/28','',4073),
(54448,21729,16,'Ruy Celso da Silva','11','3258-2155','11','3258-1781','ruy@augustovelloso.com.br',819),
(54449,21729,49,'Renato / Levon','11','4996-2462','11','3258-2155','',819),
(54450,21729,20,'Márcio','11','4996-2462','11','3258-2155','construtora@augustovelloso.com.br',819),
(54454,21731,16,'Fred A. Scanduzi','11','4196-9900','','','fred@ccam.com.br',11693),
(54455,21731,49,'Reyolando Brasil','11','4193-3877','','','ar.brasil@terra.com.br',11692),
(54456,21731,20,'Reyolando Brasil','11','4193-3877','','','ar.brasil@terra.com.br',11692),
(54463,21734,16,'Patrícia Freitas','11','4787-3519','11','4787-3519','coopvidanova@terra.com.br',7717),
(54464,21734,49,'José Aprígio','11','4787-3519','11','4787-3519','coopvidanova@terra.com.br',7717),
(54465,21734,20,'Claudete Ferreira','11','4787-3519','11','4787-3519','coopvidanova@terra.com.br',7717),
(54494,21745,20,'Sr. Sevan Naves (Presidente - Licenças Ambientais)','61','3327-0124','','','triton.energia@terra.com.br',11700),
(54502,21749,16,'Luiz Ferreira Pinto','71','3334-2567','71','3334-2567','luizpinto60@hotmail.com',11709),
(54503,21749,49,'Luiz Neto','71','3334-2567','71','3334-2567','luizneto@andrademendonca.com.br',11709),
(54504,21749,20,'Adriana Bastos','71','3334-2567','71','3334-2567','adriana.lodge@gmail.com',11709),
(54505,21750,16,'A definir','41','3373-1022','41','3373-1022','compras@arce.com.br',5652),
(54506,21750,49,'A definir','41','3373-1022','41','3373-1022','',5652),
(54507,21750,20,'Leandra','41','3373-1022','41','3373-1022','',5652),
(54508,21750,20,'Rodrigo Conter','55','3278-7199','','','',11708),
(54550,21765,16,'Adalberto Feres','11','3084-8500','11','3054-8501','adalberto@ryazbek.com.br',653),
(54551,21765,21,'Eduardo Pereira / Renato Tuono','11','3054-8500','11','3054-8501','epereira@ryazbek.com.br,rtuono@ryazbek.com.br',653),
(54552,21765,20,'Ricardo Timotheo','11','2339-2030','11','3054-8500','timotheo@ryazbek.com.br',653),
(90616,21765,49,'Thiago Benício','11','2339-2030','11','3054-8500','benicio@ryazbek.com.br',653),
(54600,21787,20,'Departamento de Licitações','31','3250-1607','31','3250-1670','',206),
(54663,21813,16,'Edson José','84','3221-3369','84','3222-7070','edson@metroquadrado.com.br',4373),
(54664,21813,49,'Bruno Alberto','84','3221-3369','84','3222-7070','comercial@metroquadra.com.br',4373),
(54665,21813,20,'Rafael Oliveira (Administrativo)','84','3221-3369','84','3222-7070','',4373),
(54667,21815,20,'Marcos Goldenstein (Engenharia)','21','2555-5661','21','2555-5670','marcos.goldenstein@llx.com.br',11730),
(54690,21830,20,'Mariana Fiori','11','2182-0400','11','2182-0401','gggeral.qja@atlanticahotels.com.br',11735),
(54782,21861,16,'Marly / Maria Alves Silva','11','4538-1615','','','',11749),
(54783,21861,20,'Marly','11','4538-1615','','','',11749),
(54835,21882,16,'Gilberto Cardoso','11','4192-7972','11','4192-7972','projetistagilberto@bol.com.br',1895),
(54836,21882,20,'Gilberto Cardoso','11','4192-7972','11','4192-7972','osvaldofloriano@terra.com.br',1895),
(54837,21882,49,'Osvaldo Floriano Vieira','11','4192-7972','','','projetistagilberto@bol.com.br',1895),
(75590,21894,20,'Silvia Cuaglio','14','3102-4504','14','3102-4509','silvia@sendi.com.br',0),
(75591,21894,49,'Bruno Hortêncio','14','3102-4507','14','3102-4509','bruno@sendi.com.br',13904),
(75592,21894,16,'Jaqueline Satiro','14','3102-4507','14','3102-4509','jaqueline@sendi.com.br',13904),
(84933,21894,20,'Jaqueline Satiro','14','3102-4507','14','3102-4509','jaqueline@sendi.com.br',13904),
(54888,21901,16,'Juliana Moyano','12','3934-2652','12','3934-2652','juliana.moyano@mrv.com.br',4205),
(54889,21901,21,'Maurício Razza','12','3934-2652','12','3934-2652','',4205),
(54890,21901,20,'Lúcia Machado - (Stand de Vendas)','12','3931-7305','12','3934-2652','',4205),
(54891,21902,16,'Juliana Moyano','12','3934-2652','12','3934-2652','juliana.moyano@mrv.com.br',4205),
(54892,21902,21,'Maurício Razza','12','3934-2652','12','3934-2652','',4205),
(54893,21902,20,'Fábio Correia Lima','12','3934-2652','12','3934-2652','fabio.correia@mrv.com.br',4205),
(54924,21914,20,'Felipe Diogo (Engenharia)','84','3646-5000 R.7767','','','obrafortedosreis@rifoles.com.br',11778),
(79354,21914,16,'Aristides da Silveira','84','8846-1062','84','3646-5000','obrafortedosreis@rifoles.com.br',11778),
(79355,21914,49,'Herbert Paulo','84','3646-5000','','','engenharia@rifoles.com.br',11778),
(54925,21915,20,'Cláudio Batista (Diretor Industrial)','27','2121-9852','27','2121-9848','',11769),
(54926,21915,65,'Luciano Neves','27','2121-9882','27','2121-9848','luciano@poltex.com.br',11769),
(54927,21915,63,'Wellington Alves de Souza','27','2121-9858','27','2121-9848','',11769),
(54928,21915,49,'Wagner Rocha','27','2121-9800','27','2121-9848','wagner.rocha@poltex.com.br',11769),
(54945,21919,16,'Severino Dantas','84','3206-6352','84','3206-6352','sdantas@sdantas.com.br',89),
(54946,21919,20,'Sr. José Ananias Dantas','84','9987-9885','84','3206-6352','joseananias@sdantas.com.br',89),
(69110,21919,92,'Sr. José Ananias Dantas','84','9987-9885','84','3206-6352','joseananias@sdantas.com.br',89),
(54947,21920,16,'Severino Dantas','84','3206-6352','84','3206-6352','sdantas@sdantas.com.br',89),
(54948,21920,21,'José Ananias Dantas Neto','84','3206-6352','84','3206-6352','sdantas@sdantas.com.br',89),
(54949,21920,20,'Fernanda Líder','84','3206-6352','84','3206-6352','sdantas@sdantas.com.br',89),
(54950,21921,16,'Sr. Bruno Vidal','21','2247-4422','21','2247-6092','',615),
(54951,21921,49,'Leonardo Alessandro Ozenda','21','2247-4422','21','2247-6092','',615),
(54952,21921,20,'Adalto Souza','21','2247-4422','21','2247-6092','',615),
(54953,21922,16,'Roberto Moraes Silva','11','4192-3691','','','',11780),
(54954,21922,49,'Roberto Moraes Silva','11','4192-3691','','','',11780),
(54955,21922,20,'Lúcia Cássia','11','4192-3691','','','ecfos@terra.com.br',11780),
(55074,21968,49,'Murilo Casarim','11','5061-0046','11','3025-9000','mcasarim@gafisa.com.br',433),
(64886,21968,16,'Departamento de Compras','11','3025-9000','11','3025-9217','',433),
(64887,21968,20,'Cícero Souza','11','5061-0046','11','3025-9000','obra759@gafisa.com.br',433),
(78479,21968,29,'Glaico Araújo','11','3025-9000','11','3025-9111','',433),
(55095,21976,16,'Cristiane','67','3331-2159','67','3331-1412','compras@enccon.com.br',2067),
(55096,21976,49,'Luís Afonso','67','3331-2159','67','3331-1412','compras@enccon.com.br',2067),
(55097,21976,20,'Marco','67','3331-2159','67','3331-1412','compras@enccon.com.br',2067),
(55185,22011,16,'Elaine Arnaldi','11','2099-4171','11','2099-4171','maduempreendimentos@terra.com.br',11812),
(55186,22011,49,'Leonardo Pontes','11','2099-4171','11','2099-4171','maduempreendimentos@terra.com.br',11812),
(55187,22011,20,'Fernanda Costa (Compras)','11','2099-4171','11','2099-4171','fernanda.madu@terra.com.br',11812),
(79181,22011,16,'Fernanda Costa','11','2099-4171','11','2099-4171','fernanda.madu@terra.com.br',11812),
(55188,22012,16,'Guilherme Lima','31','3235-4600','31','3235-4600','guilherme.lima@direcional.com.br',4566),
(55189,22012,29,'Lucas Rocha','31','3235-4600','31','3235-4600','lucas.rocha@direcional.com.br',4566),
(55190,22012,20,'Mônica (Comercial) / Luciana Costa','31','3235-4600','31','3235-4600','luciana.costa@direcional.com.br',4566),
(55197,22015,16,'Warley Neves','92','3133-1850','92','3133-1890','warley.neves@direcional.com.br',10608),
(55198,22015,20,'Sérgio Mendes','31','9284-0890','92','3133-1850','sergio.mendes@direcional.com.br',10608),
(76300,22015,21,'Sérgio Mendes / Eduardo Junqueira','92','3133-1850','92','3133-1860','sergio.mendes@direcional.com.br',10608),
(76301,22015,21,'Osmar Souza Lopes','92','3133-1850','92','3133-1860','osmarlopes@direcional.com.br',10608),
(55207,22018,49,'Reinaldo José Gigo','16','3251-9060','16','3251-9060','',2549),
(61431,22018,16,'Rozi Camargo','16','3251-9960','16','3251-9060','rozi@parametrosaneamento.com.br',2549),
(74264,22018,20,'Reinaldo José Gigo','16','3251-9054','16','3251-9060','',2549),
(55208,22020,20,'Elisabete Andrade','11','3388-6452','11','3388-9000','',441),
(61254,22021,16,'Rogério Alves','11','3168-9400','11','3078-9401','ralves@saenge.com.br',2553),
(61255,22021,49,'Eng. Luiz Mayer Filho','11','3071-2794','11','3078-9401','saenge@saenge.com.br',2553),
(79119,22021,20,'Rogério Alves','11','3071-2794','11','3078-9401','ralves@saenge.com.br',2553),
(55218,22024,16,'Alex Bernardes','16','3625-8129','16','3625-8129','enge.bad@universe.com.br',11813),
(55219,22024,49,'Celso Roberto Lopes Badaró','16','3625-8129','16','3625-8129','',11813),
(55220,22024,20,'Alex Bernardes','16','3625-8129','16','3625-8129','enge.bad@universe.com.br',11813),
(55264,22039,16,'Sr. Vicente Gonçalves','15','3221-9511','15','3221-9579','compras@magnumconstcom.br',9),
(55265,22039,49,'José Messias','15','3221-9511','15','3221-9579','messias@magnumconst.com.br',9),
(55266,22039,20,'Carlos Eduardo (Gerente Comercial)','15','3221-9511','15','3221-9579','vendas@magnumconst.com.br',9),
(55270,22041,20,'Luiz Gonzaga Alves - (Proprietário)','63','9224-6020','63','3312-8033','',10480),
(55271,22042,20,'Simone Moura (Operações)','31','3594-4055','31','3594-4054','simone@betimshopping.com.br',11821),
(152483,22042,20,'Camila Fernandes (Recepção)','31','3594-4055','31','3594-4054','recepcao@betimshopping.com.br',11821),
(55289,22048,21,'Leandro Bonfim','11','3378-3029','11','3378-3149','enge.civil@suzukimotos.com.br',11824),
(55290,22048,20,'Leandro Bonfim','11','3378-3029','11','3378-3149','enge.civil@suzukimotos.com.br',11824),
(55291,22048,20,'Geandre Sá Colares','92','9601-8260','92','2101-1300','geandre.colares@rdenge.com.br',5893),
(55292,22048,49,'Geandre Sá Colares','92','9601-8260','92','2101-1300','geandre.colares@rdenge.com.br',5893),
(55293,22048,16,'Sebastião Esteves','92','2101-1300','92','2101-1306','sebastiao.esteves@rdenge.com.br',5893),
(55311,22055,16,'Júlio Silva / Nivaldo','11','3046-9696','11','3046-9690','cury@cury.net',1493),
(55312,22055,49,'A definir','11','3046-9696','11','3046-9690','',1493),
(55313,22055,20,'Alessandra (Engenharia)','11','3046-9696','11','3046-9690','cury@cury.net',1493),
(55350,22070,16,'Setor Compras','21','9176-1607','21','2220-9004','otamir@vilella.com.br',11837),
(55351,22070,7,'Arq. Otamir Figueiredo','21','9176-1607','21','2220-9004','otamir@vilella.com.br',11837),
(55352,22070,20,'Sr. Pedro','21','2220-9004','21','2220-9004','',11837),
(55358,22073,20,'Jairo Lima','31','3486-7283','31','3486-7283','jairo.perdigao@ig.com.br',13172),
(64518,22073,16,'Jairo Lima','31','3486-7283','31','3486-7283','jairo.perdigao@ig.com.br',13172),
(64519,22073,49,'Alexandre Torquete','31','9801-4618','31','3486-7283','alexago@superig.com.br',13172),
(55480,22110,20,'Morgan Moura (Engenharia)','85','3101-3000','85','3101-2999','morgan_moura@yahoo.com.br',11870),
(55484,22112,49,'Osmar Júnior','31','3375-3004','31','3375-3004','engerais@engerais.com.br',12684),
(61014,22112,16,'Osmar Shffer Júnior','31','3375-3004','31','3375-3004','engerais@engerais.com.br',12684),
(71470,22112,20,'Osmar Shffer Júnior','31','3375-3004','31','3375-3004','engerais@engerais.com.br',12684),
(71471,22112,49,'Osmar Shffer Júnior','31','3375-3004','31','3375-3004','engerais@engerais.com.br',12684),
(55486,22115,16,'Ricardo de Siqueira Drumond','24','2221-3024','24','2221-3024','encotec@compuland.com.br',11874),
(55487,22115,49,'Ricardo de Siqueira Drumond','24','2221-3024','24','2221-3024','encotec@compuland.com.br',11874),
(55488,22115,20,'Ricardo de Siqueira Drumond','24','2221-3024','24','2221-3024','encotec@compuland.com.br',11874),
(55511,22124,7,'Lourdes Santiago','11','9124-6505','','','',11878),
(55512,22124,16,'Carlos A. Pereira','11','3903-0685','','','ppeir@uol.com.br',11877),
(55513,22124,20,'Patrícia Mendes','11','3903-0685','','','ppeir@uol.com.br',11877),
(55526,22131,16,'Fabiana Luz dos Santos','11','4221-3188','11','4221-3188','fabiana@lorenzini.com.br',923),
(55527,22131,49,'Sr. Numa Alberto','11','4221-3188','11','4221-3188','',923),
(55528,22131,20,'Maurício Michelleti','11','4221-3188','11','4221-3188','mauricio@lorenzini.com.br',923),
(55539,22133,16,'José Orlando','11','4195-2446','11','4195-2446','trida@tritom.com.br',11882),
(55540,22133,49,'José Orlando','11','4195-2446','11','4195-2446','trida@tritom.com.br',11882),
(55541,22133,20,'José Orlando','11','4195-2446','11','4195-2446','trida@tritom.com.br',11882),
(55542,22134,16,'Patrícia Duarte','85','3524-1413','85','3521-1600','compras@sisaempreendimentos.com.br',3953),
(55543,22134,49,'A definir','85','3524-1413','85','3521-1600','',3953),
(55544,22134,20,'Ana Paula','81','3524-1413','81','3521-1600','',3953),
(55545,22135,16,'Elias José','31','3497-1103','31','3497-1103','elias@construtoratecplus.com',11884),
(55546,22135,49,'Marcelo Paiva','31','9854-4598','31','3497-1103','mpaivac2@gmail.com',11884),
(73383,22135,20,'Marcelo Paiva','31','9854-4598','31','3497-1103','mpaivac2@gmail.com',11884),
(55547,22136,16,'Arcio','48','3465-2900','48','3465-2900','contato@construtorafolchini.com.br',11885),
(55548,22136,49,'Fábio Capetti','48','3465-2900','48','3465-2900','contato@construtorafolchini.com.br',11885),
(55549,22136,20,'Fábio Capetti','48','3465-2900','48','3465-2900','contato@construtorafolchini.com.br',11885),
(55550,22137,16,'Eduardo Silvestre','12','3633-5599','12','3633-5599','compras@ladeiramiranda.com.br',11883),
(55551,22137,49,'Pedro de Moraes','12','3633-5599','12','3633-5599','ladeiramiranda@ladeiramiranda.com.br',11883),
(55552,22137,20,'Eduardo Silvestre','12','3633-5599','12','3633-5599','compras@ladeiramiranda.com.br',11883),
(55577,22146,16,'Patrícia','81','3524-1413','81','3521-1600','compras@sisaempreendimentos.com.br',3953),
(55578,22146,49,'A definir','81','3524-1413','81','3521-1600','',3953),
(55579,22146,20,'Ana Paula','81','3524-1413','81','3521-1600','',3953),
(55586,22149,16,'Roberta Caciatore','11','3120-3654','11','3120-3654','roberta@akauan.com.br',11887),
(55587,22149,20,'Paulo Porfírio - (Plantão de Vendas)','11','3120-3654','11','4191-3429','porfiriopor@yahoo.com.br',11887),
(55588,22149,49,'Wagner','11','3120-3654','11','3120-3654','wagner@akauan.com.br',11887),
(55591,22151,49,'Jonas Jorge','17','9619-2884','17','3522-4123','jonas@wkj.com.br',11240),
(55592,22151,16,'Leandro Machado','17','3522-4123','17','3531-1100','leandro@wkj.com.br',11240),
(95031,22151,20,'Leandro Machado','17','3522-4123','17','3531-1100','leandro@wkj.com.br',11240),
(55634,22167,16,'Mirian Cerqueira','11','3246-3300','11','3246-3301','compras@sanca.com.br',1846),
(55635,22167,20,'Cida Lopes','11','3246-3300','11','3246-3301','sanca@sanca.com.br',1846),
(55636,22167,49,'A definir','11','3246-3300','11','3246-3301','',1846),
(55643,22171,16,'Arq. Veriano Ferreira','22','9253-7690/9932-6087','22','2653-2693','verianof@yahoo.com.br,verianof@hotmail.com',10342),
(55644,22171,7,'Arq. Veriano Ferreira','22','9253-7690/9932-6087','22','2653-2693','verianof@yahoo.com.br,verianof@hotmail.com',10342),
(55645,22171,20,'Arq. Veriano Ferreira','22','9253-7690/9932-6087','22','2653-2693','verianof@yahoo.com.br,verianof@hotmail.com',10342),
(55669,22180,16,'Ester Antunes','49','3664-3144','49','3664-3144','compras@construtoraantunes.com.br',7599),
(55670,22180,49,'Vilmar B. Moreno','49','3664-3144','49','3664-3144','vilmar@construtoraantunes.com.br',7599),
(55671,22180,20,'Luís Marques - (Escritório)','44','3361-1500','44','3361-1500','contato@construtoraantunes.com.br',7599),
(55674,22182,16,'Roberto/ Renata','11','4195-0861','11','4195-0861','renata@liengenharia.com.br',8397),
(55675,22182,49,'Waldemar Roberto Pagliori','11','4195-0861','11','4195-0861','',8397),
(55676,22182,20,'Mônica/ Talita (financeiro)','11','4195-0861','11','4195-0861','monica@liengenharia.com.br',8397),
(55831,22244,20,'Diego Dandolini (Depto. de Eng. de Geração)','49','3242-1386/1305','48','3231-7611','ddandolini@eletrosul.gov.br',5942),
(55842,22247,16,'Luciano Tinoco','21','3541-9000','21','3541-9001','l.tinoco@gafisa.com.br',9292),
(55843,22247,49,'Walmir Calegari','21','3541-9000','21','3541-9001','walmir.calegari@tenda.com.br',10977),
(55844,22247,20,'Viviane Carvalho (Obras)','21','3541-9000','21','3541-9001','viviane.carvalho@tenda.com',9292),
(55849,22250,16,'Ana Maria Gomes','11','4221-6363','11','4221-6363','ana.aeg@terra.com.br',5520),
(55850,22250,49,'Paulo Abraham','11','4226-0305','11','4221-6363','paulo.aeg@terra.com.br',5520),
(55851,22250,20,'Raimundo dos Santos (Encarregado da Construção)','11','4226-0305','11','4221-6363','',5520),
(55883,22263,16,'Luzia Fonseca','21','3724-8000','21','3724-8100','luzia.fonseca@chl.com.br',473),
(55884,22263,20,'Luiza Lima (Marketing)','21','3724-8000','21','3724-8100','luiza.lima@chl.com.br',473),
(68636,22263,29,'José Barreiros Júnior','21','3724-8000','21','3724-8100','jjunior@chl.com.br',473),
(55929,22284,16,'Lucas Feitosa','11','4229-2277','11','4229-2277','compras@cardenuto.com.br',4503),
(55930,22284,49,'Marcos Antônio Cardenuto','11','4229-2277','11','4229-2277','engenharia@cardenuto.com.br',4503),
(55931,22284,20,'Lucas Feitosa','11','4229-2277','11','4229-2277','compras@cardenuto.com.br',4503),
(55998,22309,16,'João Batista do Carmo','85','3208-1100','85','3208-1112','batista@motamachado.com.br',2744),
(55999,22309,49,'Marcan Penha','85','3208-1100','85','3208-1112','',2744),
(56000,22309,20,'Renata Milerio (Relacionamento)','85','3208-1100','85','3208-1112','renata.milerio@motamachado.com.br',2744),
(85712,22309,29,'Flávio Lima','85','3208-1100','85','3208-1112','flavio@motamachado.com.br',2744),
(56053,22327,16,'Ângelo Augusto','16','4009-9499','16','4009-9499','angelo@stefaninogueira.com.br',3351),
(71290,22327,20,'Malver Cerralha','16','3491-3192','16','4009-9499','aroeira@stefaninogueira.com.br',3351),
(79983,22327,49,'Malver Cerralha','16','3491-3192','16','4009-9499','aroeira@stefaninogueira.com.br',3351),
(56066,22332,49,'Caio Pignataro da Silva','19','3258-2324','19','3258-7287','',6857),
(56067,22332,16,'Engº Marcel Antônio de Tomy','19','3258-2324','19','3258-7287','',6857),
(56068,22332,20,'Débora Lima','19','3258-2324','19','3258-7287','logicamp@logicamp.com.br',6857),
(56088,22341,16,'Paulo Bandeira','82','3325-4520','82','3025-9121','pbandeira@gafisa.com.br',433),
(56089,22341,49,'Phillip Gois','82','3359-1859','82','3217-2200','phillip.gois@tenda.com',4513),
(56090,22341,20,'Camila de Souza Lima (Plantão de Vendas)','82','3359-1859','82','3217-2200','souzalimaufal@hotmail.com',4513),
(56125,22356,20,'Paulo Duarte (Encarregado Adm. de Obras)','11','4198-8113','11','4198-8113','adm.obras@basfer.com.br',6415),
(65345,22356,16,'Marcelo Freitas','11','4198-8113','11','4198-7466','suprimentos@basfer.com.br',6415),
(65346,22356,49,'José Mário','11','4198-8113','11','4198-8113','jmario@basfer.com.br',6415),
(64924,22358,20,'Edson Nolasco','71','3332-1061','71','3332-1061','rodengesc@yahoo.com.br',13244),
(64925,22358,16,'Edson Nolasco','71','3332-1061','71','3332-1061','rodengesc@yahoo.com.br',13244),
(64926,22358,49,'Edson Nolasco','71','3332-1061','71','3332-1061','rodengesc@yahoo.com.br',13244),
(56136,22360,16,'Luciana Andrade','17','2137-1700','17','2137-1725','lsandrade@rodobens.com.br',1423),
(56137,22360,49,'Paulo Roberto','34','3232-1640','31','3232-1370','',11968),
(56138,22360,20,'Joaquim (Aux. Adm.)','34','3232-1640','31','3232-1370','jsfilho@rodobens.com.br',11968),
(56142,22362,16,'Luciana Andrade','17','2137-1700','17','2137-1725','lsandrade@rodobens.com.br',1423),
(56143,22362,49,'Artur','12','3905-2731','17','2137-1700','',1423),
(56144,22362,20,'Letícia (Depto de Obras)','12','3905-3129','17','2137-1700','sistemafacil@sistemafacil.com.br',1423),
(56152,22365,16,'Arq. Flávio Fonte Vieira','22','9983-2119','22','2771-3355','arquitetos.associados@oi.com.br',5702),
(56153,22365,7,'Arq. Flávio Fonte Vieira','22','9983-2119','22','2771-3355','arquitetos.associados@oi.com.br',5702),
(56154,22365,20,'José Milton','22','9983-2119','22','2771-3355','',5702),
(56163,22370,20,'Adriano Vieira','11','4152-9991','11','4152-9992','adriano@construtorahudson.com.br',4898),
(65975,22370,16,'Adriano Vieira','11','4152-9991','11','4152-9992','adriano@construtorahudson.com.br',4898),
(65976,22370,49,'Marcelo Henrique','11','4152-9991','11','4152-9992','marcelo@construtorahudson.com.br',4898),
(73384,22370,16,'Ronaldo Pereira','11','4152-9991','11','4152-9992','ronaldop@construtorahudson.com.br',4898),
(56186,22384,16,'Gustavo Medeiros','84','4006-0900','84','4006-0910','gustavo@colmeia.com.br',5051),
(56187,22384,49,'Emanuel Domingos','84','3642-2585','84','4006-0900','emanuel@colmeia.com.br',5051),
(56188,22384,20,'Emanuel Domingos','84','3642-2585','84','4006-0900','emanuel@colmeia.com.br',5051),
(56189,22385,16,'Gustavo Medeiros','84','4006-0900','84','4006-0910','gustavo@colmeia.com.br',5051),
(56190,22385,49,'Emanuel Domingos','84','4006-0900','84','4006-0910','emanuel@colmeia.com.br',5051),
(56191,22385,20,'Gustavo Medeiros','84','9121-0447','84','4006-0900','gustavo@colmeia.com.br',5051),
(56215,22397,20,'Depto de Licitação','31','3250-1607','31','3250-1600','',206),
(56227,22403,16,'Engº Natan S. Rodrigues','22','8802-3892','22','2778-1907','natan_adv@msn.com',11982),
(56228,22403,49,'Engº Natan S. Rodrigues','22','8802-3892','22','2778-1907','natan_adv@msn.com',11982),
(56229,22403,20,'Sr. Marcos','22','2778-1907','22','2778-1907','',11982),
(56240,22408,16,'Adriano Justino','62','3250-0400','62','3250-0402','adriano.justino@opusincorporadora.com.br',9483),
(56241,22408,49,'Adriano Justino','62','3250-0400','62','3250-0402','adriano.justino@opusincorporadora.com.br',9483),
(56242,22408,20,'Lailson de Souza','62','3093-1605','62','3093-1605','lailson@laterengenharia.com.br',1498),
(62286,22441,20,'Daniel Oliveira (Engenharia de projetos)','11','3357-8018/7980','11','3159-5100','restrito',630),
(101396,22441,49,'Serafim Botolli','21','3357-8018/7980','11','3017-8000','sbotolli@construcap.com.br',630),
(101397,22441,16,'Samuel Marques','21','3357-8018/7980','11','3017-8000','scmarques@construcap.com.br',630),
(56320,22443,16,'Luiz Eugênio Costa','34','3217-3348','34','3215-0598','luiz@mcaengenharia.com.br',11861),
(56321,22443,49,'Luiz Eugênio Costa','34','3217-3348','34','3215-0598','luiz@mcaengenharia.com.br',11861),
(56322,22443,20,'Luiz Eugênio Costa','34','3217-3348','34','3215-0598','luiz@mcaengenharia.com.br',11861),
(56325,22445,16,'Sérgio Dahan','21','3639-2257','21','3639-2257','itaimoveis@terra.com.br',11991),
(56326,22445,49,'Marcos Dahan','21','9904-4488','21','3639-2257','',11991),
(56327,22445,20,'Sr. Edson','21','3639-2257','21','3639-2257','',11991),
(56343,22450,16,'Engº Alan Ginzberg / Engº Marcelo Ginzberg','11','3023-4636','11','3023-3275','arquiplan@arquiplan.com.br',5721),
(56344,22450,49,'Engº Alan Ginzberg','11','3023-4636','11','3023-3275','arquiplan@arquiplan.com.br',5721),
(56345,22450,20,'Engº Alan Ginzberg','11','3023-4636','11','3023-3275','arquiplan@arquiplan.com.br',5721),
(56346,22451,16,'Jorge Luís','75','2102-8988','75','2102-8988','compras@donelisa.com.br',11992),
(56347,22451,49,'Luis Alberto','75','2102-8988','75','2102-8988','',11992),
(56348,22451,20,'Ronaldo Conceição','75','8102-6092','75','2102-8988','administrativo@donelisa.com.br',11992),
(56367,22457,20,'Sr. Fábio Fernandes','48','9978-0053','48','3433-9343','fabiofernandes@cyber.com.br',13332),
(65516,22457,49,'Sr. Fábio Fernandes','48','9978-0053','48','3433-9343','fabiofernandes@cyber.com.br',13332),
(65517,22457,16,'Sr. Marcos','48','3433-5001','48','3433-5001','compras@conferconstrutora.com.br',13332),
(56372,22461,16,'Austry França da Silva','21','3501-4900','21','3501-4800','austryfranca@joaofortes.com.br',839),
(56373,22461,49,'José Luis','21','7856-7331','21','3501-4900','josenate@joaofortes.com.br',839),
(56374,22461,70,'Breno Modolo','21','3501-4900','21','3501-4800','brenomodolo@joaofortes.com.br',839),
(73546,22461,20,'José Luis','21','7856-7331','21','3501-4900','josenate@joaofortes.com.br',839),
(56393,22469,16,'Décio Abdo Filho','11','3078-9771','','','',12001),
(56394,22469,7,'Alexandre','11','4148-4252','','','',12001),
(56395,22469,20,'Décio Abdo Filho','11','3078-9711','','','',12001),
(56414,22476,16,'Claudineia Gonçalves','44','3025-5380','44','3025-5380','claudineianovaum@hotmail.com',12003),
(56415,22476,49,'Renato de Oliveira','44','9126-1700','44','3025-5380','renatonovaum@hotmail.com',12003),
(56416,22476,20,'Renato de Oliveira','44','9126-1700','44','3025-5380','renatonovaum@hotmail.com',12003),
(56421,22477,20,'Roberto Prata','34','9116-8493','34','3319-0000','roberto@rcg.eng.br',9272),
(65304,22477,16,'Valdir José dos Santos','31','3319-0000','31','3319-0000','valdir@rcg.eng.br',9272),
(65305,22477,49,'Roberto Prata','34','9116-8493','34','3319-0000','roberto@rcg.com.br',9272),
(56443,22486,16,'Welton Salvador','61','3315-8684','61','3315-8687','welton.salvador@paulooctavio.com.br',1690),
(56444,22486,20,'Arq. Mônica Fukuda','61','3315-8600','61','3315-8687','monica.fukuda@paulooctavio.com.br',1690),
(56445,22486,21,'Marcílio Bione','61','3315-8600','61','3315-8687','marcilio.bione@paulooctavio.com.br',1690),
(56450,22488,16,'Dalmo','31','3222-9426','31','3222-9426','dalmo@alternativa.eng.br',12006),
(56451,22488,49,'Engº Oswaldo Pinheiro','31','3281-0515','31','3281-0515','apis@apisengenharia.com',12006),
(56452,22488,20,'Gessi Laureano Barbosa','31','3281-0515','31','3281-0515','',12006),
(56453,22489,16,'Dalmo','31','3222-9426','31','3222-9426','dalmo@alternativa.eng.br',12006),
(56454,22489,49,'Engº Oswaldo Pinheiro','31','3281-0515','31','3281-0515','apis@apisengenharia.com',12006),
(56455,22489,20,'Gessi Laureano Barbosa','31','3281-0515','31','3281-0515','',12006),
(56559,22528,20,'Felipe Caballero (Diretoria)','11','3544-0444','11','3544-0444','felipe.caballero@locaweb.com.br',12030),
(56565,22529,16,'Claudionor Duarte','41','3025-3333','41','3025-3333','duarte@castilho.com.br',8347),
(62125,22529,49,'José Euclair','41','3025-3333','41','3025-3333','',8347),
(56695,22570,16,'Valter Fantini','14','3604-1400','14','3604-1421','compras@barrabonita.com.br',12042),
(56696,22570,49,'Valter Fantini','14','3604-1400','14','3604-1421','compras@barrabonita.com.br',12042),
(56697,22570,20,'Valter Fantini','14','3604-1400','14','3604-1421','compras@barrabonita.com.br',12042),
(56712,22578,16,'Andréia Cristina','48','3039-9208','48','3029-1919','compras@magnomartins.com.br',3152),
(56713,22578,49,'Gilson Mendes','48','9104-5402','48','3029-1919','gilson@magnomartins.com.br',3152),
(56714,22578,20,'Elaine Cristina','48','3039-9208','48','3029-1919','elaine@magnomartins.com.br',3152),
(56718,22580,16,'Paulo Mesquita','11','8272-5722','11','4795-1129','tania@mastria.com.br',10844),
(56719,22580,49,'Paulo Mesquita','11','8272-5722','11','4795-1129','tania@mastria.com.br',10844),
(56720,22580,20,'Paulo Mesquita','11','8272-5722','11','4795-1129','tania@mastria.com.br',10844),
(92884,22584,16,'Oscar Favero','11','5571-0666','11','5571-0666','oscar@afonsofranca.com.br',3702),
(92885,22584,49,'Oscar Favero','11','5083-4006','11','5571-0666','oscar@afonsofranca.com.br',3702),
(106646,22584,16,'Valter','11','5571-0666','11','5571-0666','valter@afonsofranca.com.br',3702),
(106647,22584,20,'Cauê Silva Costa (Engenheiro)','11','5083-4006','11','5571-0666','caue@afonsofranca.com.br',3702),
(56729,22585,3,'Gustavo  Parente','21','2507-2200','21','2232-4198','gustavo.parente@kreimer.com.br',320),
(56730,22585,7,'Arq. Roberto Kreimer','21','2507-2200','21','2232-4198','kreimer@kreimer.com.br',320),
(56733,22585,20,'Sr. Luiz','21','2507-2200','22','2232-4198','kreimer@kreimer.com.br',320),
(56757,22601,16,'Maria do Carmo','27','2104-7400','27','2104-7440','mariadocarmo@metronengenharia.com.br',7567),
(56758,22601,21,'João Miranda','27','2104-7400','27','2104-7440','joaomiranda@metronengenharia.com.br',7567),
(56759,22601,20,'Fernanda Almeida (Marketing)','27','2104-7400','27','2107-7440','fernanda@metronengenharia.com.br',7567),
(82890,22601,21,'Antônio Moreira','27','2104-7400','27','2104-7440','antonio@metronengenharia.com.br',7567),
(56828,22625,20,'Arqº Gilberto Sibemberg','85','3351-3131','51','3338-0440','arquitetos@sibemberg.com.br',12063),
(56829,22625,7,'Stefano Sibemberg','51','3338-0440','51','3338-0440','arquitetos@sibemberg.com.br',12063),
(56866,22636,16,'Graça Matias','84','3203-3100','84','3203-3140','graca@capuche.com.br',2413),
(56867,22636,20,'Lui Saldanha (Projetos)','84','3203-3100','84','3203-3140','lui.saldanha@capuche.com.br',2413),
(56868,22636,49,'Rosilene Crespin','84','3203-3100','84','3203-3140','rosilene.crespim@capuche.com.br',2413),
(56926,22661,16,'Tamaroni Neto','21','2437-8593','21','2437-8593','compras@espimenta.com.br',6133),
(56927,22661,49,'Eduardo Pimenta','21','2437-8593','21','2437-8593','engenharia@espimenta.com.br',6133),
(56928,22661,20,'Eduardo Pimenta','21','2437-8593','21','2437-8593','engenharia@espimenta.com.br',6133),
(56943,22666,20,'Maria Augusta Saraiva - (Secretária)','21','3299-0500','21','2132-8200','maria.saraiva@gordianenergy.com.br',12081),
(56944,22666,21,'Diomedes Christodoulou','21','3299-0500','21','2132-8201','',12081),
(69024,22669,16,'Ícaro Depoli','11','2177-1333','11','3887-5999','suprimentos@sincoengenharia.com.br',742),
(69025,22669,20,'Simone Nemoto (Planejamento / Orçamento)','11','2177-1333','11','3887-5999','simone@sincoengenharia.com.br',742),
(69026,22669,21,'Cléber Marques','11','2177-1333','11','3887-5999','cleber@sincoengenharia.com.br',742),
(69027,22669,29,'Paulo Sanchez','11','2177-1333','11','3887-5999','paulosanchez@sincoengenharia.com.br',742),
(81333,22669,20,'Cassiana Macena (Diretoria)','11','2177-1333','11','3887-5999','cassiana.macena@sincoengenharia.com.br',742),
(56982,22685,16,'Setor de Compras','21','2263-8788','21','2283-0741','tecnosonda@uol.com.br',6123),
(56983,22685,49,'Ernesto Ferreira Medijo','21','2263-8788','21','2283-0741','tecnosonda@uol.com.br',6123),
(56984,22685,20,'Sr. Anestor','21','2263-8788','21','2283-0741','tecnosonda@uol.com.br',6123),
(56985,22686,20,'Sra. Dema Posimar dos Santos (Administração)','65','3314-3550','65','3322-6539','demaa@cefetmt.br',12087),
(56989,22690,16,'Jairo Filho','79','3255-2036','79','3255-2842','realclassic@redereal.com.br',12096),
(56990,22690,49,'Serafim','79','3255-2036','79','3255-2842','',12096),
(56991,22690,20,'Adria Almeida','79','3255-2036','79','3255-2842','almeida.adria@hotmail.com',12096),
(56992,22690,7,'Sr. Alberto','79','3255-2036','79','3255-2842','',12096),
(57052,22712,20,'Maria da Silva','45','3218-5000','45','3218-5000','marias@coopavel.com.br',1337),
(57053,22712,16,'Maria da Silva','45','3218-5000','45','3218-5000','marias@coopavel.com.br',1337),
(57122,22743,16,'Antônio / Daniel Pinheiro','11','3371-6500','11','3285-4874','savoy.compras@terra.com.br',5558),
(57123,22743,49,'Sr. Rami Ali Chehau','11','3371-6500','11','3285-4874','rchehau@uol.com.br',5558),
(57124,22743,20,'Sr. Rami Ali Chehau','11','3371-6500','11','3285-4874','rchehau@uol.com.br',5558),
(57135,22749,16,'Nicolau Mandia','11','3046-3089','11','3046-3046','suprimentossp@viverinc.com.br',170),
(57136,22749,49,'A definir','11','3046-3089','11','3049-3046','',170),
(57137,22749,20,'Cláudia Falk (Construção)','11','3046-3000','11','3046-3046','claudia.falk@viverinc.com.br',170),
(57141,22751,16,'Cida Dias','11','3051-9999','11','3885-1237','cida@tiberio.com.br',1096),
(57142,22751,21,'Luciano Hass','11','3051-9999','11','3051-9998','luciano.hass@tiberio.com.br',1096),
(57143,22751,20,'Vivian Gomes (Marketing)','11','3051-9999','11','3051-9998','vivian.gomes@tiberio.com.br',1096),
(57147,22753,16,'Juliano Cardoso','31','3547-3851','31','3547-3837','juliano.cardoso@inpar.com.br',11365),
(57148,22753,49,'Mário Zanforlin','31','3515-0431','31','3547-3851','mario.zanforlin@viverinc.com.br',11365),
(57149,22753,20,'Mário Zanforlin (Engº)','31','3515-0431','31','3547-3851','mario.zanforlin@viverinc.com.br',11365),
(57173,22765,20,'Luara Lopes (Atendimento)','11','3069-3970','11','3069-3970','luara.lopes@edalco.com.br',2615),
(65036,22765,16,'Alberto Carvalho','11','3069-3970','11','3069-3970','alberto.carvalho@edalco.com.br',13847),
(71392,22765,49,'Sidney Janot','11','3069-3970','11','3069-3970','sidney.janot@edalco.com.br',13847),
(57344,22821,20,'Roberto Niquini','31','8447-8788','','','',12142),
(57345,22821,21,'Roberto Niquini','31','8447-8788','','','',12142),
(57347,22823,16,'Márcia Bregano  / Alex Daniel','11','3708-1011','11','3708-1093','gr-sup@tecnisa.com.br',444),
(57348,22823,29,'Rubens Nakano','11','3708-1000','11','3708-1000','rubens@tecnisa.com.br',444),
(57349,22823,20,'Maria Teresa Milano','11','3708-1010','11','3708-1000','teresamilano@tecnisa.com.br',444),
(57353,22825,16,'Márcia Bregano Vasconcelos / Alex Daniel','11','3708-1000','11','3708-1093','gr_sup@tecnisa.com.br',444),
(57354,22825,29,'Rubens Nakano','11','3708-1000','11','3708-1093','rubens@tecnisa.com.br',444),
(57355,22825,20,'Fernanda Silva (Marketing)','11','3708-1000','11','3708-1093','fernanda.silva@tecnisa.com.br',444),
(89294,22825,49,'Emerson Paraguassu','11','3708-1000','11','3708-1093','',444),
(57549,22887,16,'Osmar Oliveira','11','3040-6030','11','3040-6030','osmar@tenda.com.br',1377),
(57550,22887,49,'Anibal Mendes','61','3701-6100','61','3701-6122','',12185),
(57551,22887,20,'Sr. Celso','61','3701-6100','61','3701-6122','',12185),
(57558,22892,16,'Paulo Régis','51','3027-1900','51','3027-1999','compras@hoteiscontinental.com.br',12187),
(57559,22892,21,'Júlia Hahn','51','3027-1942','51','3027-1942','comercial@hoteiscontinental.com.br',12187),
(57560,22892,20,'Júlia Hahn','51','3027-1942','51','3027-1942','comercial@hoteiscontinental.com.br',12187),
(57571,22897,16,'Gustavo Drumond / Vagner Xavier','11','3512-4500','11','3512-4532','varner.xavier@mrv.com.br',1504),
(57572,22897,49,'Arnaldo Hideki Nonaka','11','4735-2326','11','3512-4500','arnaldo@mrv.com.br',1504),
(57573,22897,20,'Lucinéia Assuti Mariano','11','4735-2326','11','3512-4500','',1504),
(57612,22915,20,'Paulo Henrique - (Licitação)','31','3235-6223','31','3235-6190','',2816),
(57613,22916,16,'Reginaldo','31','3507-6000','31','3507-6002','compras@abrilcs.com.br',16069),
(89202,22916,49,'Leonardo Moisés da Rocha','31','3507-6000','31','3507-6002','leonardo@yahoo.com.br',16069),
(89203,22916,20,'Aline Queiroz (Adm.)','31','3507-6000','31','3507-6002','abril@abrilcs.com.br',16069),
(57620,22919,16,'Raimundo Nonato Vidal','61','3274-2524','61','3274-2524','raimundo@mtdengenharia.com.br',4085),
(57621,22919,49,'Márcio','61','3274-2524','61','3274-2524','mtd@mtdeng.com.br',4085),
(57622,22919,20,'Raimundo Nonato Vidal','61','3274-2524','61','3274-2524','raimundo@mtdengenharia.com.br',4085),
(87294,22920,16,'Luiz Paolini','48','2102-4100','48','2102-4100','luizpaolini@criciumaconstrucoes.com',3593),
(87295,22920,49,'Robson Antunes','48','2102-4100','48','2102-4101','robson@criciumaconstrucoes.com',3593),
(87296,22920,106,'Patrícia Montagna Allen','48','2102-4100','48','2102-4101','patricia@criciumaconstrucoes.com',3593),
(95164,22920,20,'Patrícia Montagna Allen (Engenheira)','48','2102-4100','48','2102-4101','patricia@criciumaconstrucoes.com',3593),
(57628,22921,16,'Elen Marcelo','48','2102-4100','48','2102-4100','compras@criciumaconstrucoes.com.br',3593),
(57629,22921,20,'Richard William Schmidt','48','2102-4100','48','2102-4100','richard@criciumaconstrucoes.com.br',3593),
(57630,22921,49,'André Luiz Magagnin','48','2102-4100','48','2102-4100','andre@criciumaconstrucoes.com.br',3593),
(87133,22921,106,'Richard William Schmidt','48','2102-4100','48','2102-4100','richard@criciumaconstrucoes.com.br',3593),
(57699,22948,16,'Eduardo Pereira','69','3224-2599','69','3224-2599','eduardo.gm.eng@hotmail.com',12196),
(57700,22948,49,'César Marques','69','3224-2599','69','3224-2599','cmarques@gafisa.com.br',13006),
(57701,22948,20,'Arq. Camila Barbosa','69','3224-2599','69','3224-2599','cbsilva@gafisa.com.br',13006),
(63447,22948,7,'Arq. Camila Barbosa','69','3224-2599','69','3224-2599','',13006),
(57712,22952,20,'Christianne Fullin','45','9117-1973','45','3264-1943','christianne@cbear.com.br',12198),
(57713,22952,21,'Christianne Fullin','45','9117-1973','45','3264-1943','christianne@cbear.com.br',12198),
(57732,22956,16,'Tarcísio Fonseca','21','2172-1800','21','2172-1845','tarcisio@calper.com.br',310),
(57733,22956,20,'Letícia Thaís (Marketing)','21','2172-1800','21','2172-1845','leticia.thais@calper.com.br',310),
(79430,22956,21,'Damásia Gonzales','21','2172-1800','21','2172-1845','damasia@calper.com.br',310),
(57750,22964,20,'Gilmar Santos - (Setor de Projetos)','75','3603-7019','75','3603-7035','gilmar.santos@pirelli.com',12200),
(83244,22964,21,'Gilmar Santos - (Setor de Projetos)','75','3603-7019','75','3603-7035','gilmar.santos@pirelli.com',12200),
(57764,22969,16,'Roberto Dutra','51','3247-3030','','','beto@edisul.com.br',3559),
(57765,22969,49,'Rodrigo Porto Castro','51','3247-3030','','','rodrigo@edisul.com.br',3559),
(57766,22969,20,'Marcio Coutinho (Administrativo Financeiro)','51','3247-3030','','','marcio@edisul.com.br',3559),
(164438,22969,7,'Juliana Hessel','51','3247-3030','','','Restrito',3559),
(57778,22972,16,'Cláudio Cardoso','11','3528-3528','11','3528-3566','claudio.cardoso@ecoesfera.com.br',6087),
(57779,22972,42,'Cláudio Oliveira','11','3528-3528','11','3528-3566','claudio.oliveira@ecoesfera.com.br',6087),
(57780,22972,20,'Rafael Dias (Relacionamento)','11','2141-1636','11','3528-3566','sac@ecolifecampestre.com.br',6087),
(57787,22975,16,'Cláudio Cardoso','11','3528-3528','11','3528-3566','claudio.cardoso@ecoesfera.com.br',6087),
(57788,22975,49,'Daniel Donateli','11','3851-2021','11','3847-3522','restrito',10911),
(57789,22975,20,'Ademir Santos (Obra)','11','3851-2021','11','3847-3522','asantos@rma.com.br',10911),
(57794,22977,42,'Cláudio Oliveira','11','3528-3528','11','3528-3566','claudio.oliveira@ecoesfera.com.br',6087),
(57795,22977,20,'Rafael Dias (Relacionamento)','11','2141-1636','11','3528-3566','sac@ecolifecampestre.com.br',6087),
(64835,22977,16,'Tiago Arruda','21','2132-9000','21','2132-9045','tiago@dominus.com.br',6),
(57797,22979,16,'A definir','21','2005-6474','21','2005-6474','',12204),
(57798,22979,49,'José Antônio da Silva','21','7857-0058','21','2005-6474','jose.silva@ecoesfera.com.br',12204),
(57799,22979,20,'José Antônio da Silva','21','2005-6474','21','2005-6474','jose.silva@ecoesfera.com.br',12204),
(57808,22982,16,'Achiles Malheiros','11','3841-4100','11','3841-4145','amalheiros@fitresidencial.com.br',10977),
(57809,22982,21,'Marcelo Silva','11','3841-4100','11','3841-4145','fit@fitresidencial.com.br',10977),
(57810,22982,20,'Camila de Oliveira - (Vendas)','11','3841-4100','11','0800-6000-348','fit@fitresidencial.com.br',10977),
(57825,22988,20,'Fernanda Pannunzio - (Assessora de Imprensa)','11','3044-6300','11','3044-6300','fernanda.pannunzio@investtur.com',11891),
(57848,22999,16,'Carlos Alberto da Silva','48','3433-4044','48','3433-4044','carlos@corbetta.com.br',6047),
(57849,22999,49,'Gilberto Cardoso / Sérgio Okumura','48','3433-4044','48','3433-4044','sergio@corbetta.com.br',6047),
(57850,22999,20,'Mirela Macarini (Projetos)','48','3433-4044','48','3433-4044','projetos@corbetta.com.br',6047),
(57975,23045,16,'Paulo Raimundo','21','2719-1369','21','2719-1368','pauloraimundo@growconstrutora.com.br',3548),
(57976,23045,49,'Engº Jeferson','21','2719-1369','21','2719-1368','',3548),
(57977,23045,20,'Sr. Paulo Raimundo','21','2719-1369','21','2719-1368','pauloraimundo@growconstrutora.com.br',3548),
(58060,23078,120,'Riedo Osvaldo (Vendas)','19','3796-9200','19','3796-9209','riedo@pratec.com.br',12252),
(58106,23098,16,'Vander Batista','31','3291-3919','31','3291-3919','vander.alves@valadaresgontijo.com.br',6302),
(58107,23098,49,'Silvio Ferraz','31','3291-3919','31','3291-3919','',6302),
(58108,23098,20,'Fernanda','31','3291-3919','31','3291-3919','',6302),
(58121,23104,20,'José Albino (Licitação)','32','3379-2307','32','3379-2307','',12255),
(58122,23105,20,'Rogério Filho - (Gerente Geral)','85','3466-4400','85','3466-4400','gerencia.jangada@bristolhoteis.com.br',12259),
(58123,23106,16,'Elida Manhãs','22','2722-6561','22','2722-6561','futuraengenharia36@yahoo.com.br',12258),
(58124,23106,49,'Eduardo Pedra','22','2722-6561','22','2722-6561','futuraengenharia36@yahoo.com.br',12258),
(58125,23106,20,'Elida Manhãs','22','2722-6561','22','2722-6561','futuraengenharia36@yahoo.com.br',12258),
(78338,23107,16,'Eduardo Augusto Leandro','48','3224-0005','48','3224-0005','eduardo@domo.com.br',14890),
(78339,23107,49,'Arq. Eduardo Augusto Leandro','48','3224-0005','48','3224-0005','eduardo@domo.com.br',14890),
(78340,23107,20,'Silvia Barboza (Gerente Administrativo)','48','3224-0005','48','3224-0005','silvia@domo.com.br',14890),
(71564,23122,16,'Rodrigo Lima','11','4890-0086','11','4890-0022','rodrigo.lima@grupogmr.com.br',5995),
(71565,23122,20,'Bruno Neves (Gerente Regional GMR Vendas)','11','9748-7671','11','7888-9963','bruno.neves@creci.org.br',5995),
(71566,23122,49,'Marcelo Sahade','11','4890-0086','11','4890-0022','secretaria@grupogmr.com.br',5995),
(58164,23124,20,'Thiago Apolônio Morais A. (Diretor Comercial)','31','3361-8101','31','3343-8125','thiago@elloengenharia.com.br',12265),
(58170,23128,21,'Carlos Obregon','34','2108-2200','34','2108-2211','carlosobregon@mataboi.com',10739),
(58171,23128,20,'Carlos Obregon','34','2108-2291','34','2108-2211','carlosobregon@mataboi.com',10739),
(58172,23129,20,'Priscila Solto Maior - (Engenharia de Projetos)','81','3543-7505/7500','81','3543-7521','priscila.maior@unilever.com.br',4034),
(58182,23133,16,'Tiago Arruda','21','2132-9066','21','2132-9020','tiago@dominus.com.br',6),
(58183,23133,20,'Ricardo Fraga','21','3139-3690','21','2132-9066','dominusrj@dominus.com.br',6),
(58185,23133,29,'Ricardo Fraga','21','3139-3690','21','2132-9066','dominusrj@dominus.com.br',6),
(58208,23145,16,'Clodoaldo André','19','3512-1832','19','3512-1831','clodoaldo@mrv.com.br',4066),
(58209,23145,49,'Miguel','19','4607-0601','19','3512-1805','spazio.solare@mrv.com.br',4066),
(58210,23145,20,'Itálo Márcio','19','4607-0601','19','3512-1805','spazio.solare@mrv.com.br',4066),
(58211,23146,16,'Clodoaldo André','19','3512-1832','19','3512-1831','clodoaldo@mrv.com.br',4066),
(58212,23146,21,'Celso Cardoso','15','7834-6506','19','3512-1832','celsoh@mrv.com.br',4066),
(58213,23146,20,'Celso Cardoso','15','7834-6506','19','3512-1832','celsoh@mrv.com.br',4066),
(58264,23163,16,'Francisco Filgueiras','21','9115-7086','21','2669-2648','frankfilgueiras@terra.com.br',4021),
(58265,23163,49,'Francisco Filgueiras','21','9115-7086','21','2669-2648','frankfilgueiras@terra.com.br',4021),
(58266,23163,20,'Francisco Filgueiras','21','9115-7086','21','2669-2648','frankfilgueiras@terra.com.br',4021),
(58268,23164,16,'Maria Fernanda','21','3079-9619','21','3079-9619','compras@mozak.com.br',3970),
(58269,23164,49,'Paulo Leite','21','2540-5507','21','3079-9619','paulo@mozak.com.br',3970),
(58270,23164,20,'Paulo Leite','21','3079-9619','21','3079-9619','paulo@mozak.com.br',3970),
(58284,23172,16,'Lorival Rodrigues','11','3898-1258','11','3898-1258','projetos@novaforma.com.br',2139),
(58285,23172,49,'Lorival Rodrigues','11','3898-1258','11','3898-1258','projetos@novaforma.com.br',2139),
(58286,23172,20,'Lorival Rodrigues','11','3898-1258','11','3898-1258','projetos@novaforma.com.br',2139),
(58457,23244,20,'Carlos Rassi','62','9984-8602','62','3224-0500','fernando@steel.com.br',12292),
(58458,23244,83,'Carlos Rassi','62','9984-8602','62','3224-0500','fernando@steel.com.br',12292),
(88811,23244,49,'Fernando Rassi','62','9971-7733','62','3224-0500','fernando@steel.com.br',12292),
(100337,23244,16,'Carlos Rassi','62','9971-7733','62','3224-0500','fernando@steel.com.br',12292),
(58480,23252,16,'Sérgio Balan','11','3666-2858','11','3666-2858','compras@thinkengenharia.com.br',12296),
(58481,23252,49,'Engº Marcelo Nudelman (Administração)','11','3666-2858','11','3666-2858','marcelo@thinkengenharia.com.br',12296),
(58482,23252,20,'Andressa Cazale','11','3666-2858','11','3666-2858','comercial@thinkengenharia.com.br',12296),
(58527,23268,16,'Mariza P. de Campos','21','2704-4313','21','2704-4313','mariza@jprconstrucoes.com.br',2077),
(58528,23268,49,'Jean Pierre Biot','21','2704-4313','21','2704-4313','pierre@jprconstrucoes.com.br',2077),
(58529,23268,20,'Jean Pierre Biot','21','2704-4313','21','2704-4313','pierre@jprconstrucoes.com.br',2077),
(58530,23269,20,'Maurício Rosal (Supervisor da obra)','21','2560-0762','21','2221-8752','obrastacrim@gmail.com',4722),
(63733,23269,16,'Anderson Figueiredo','21','2221-8752','21','2221-8752','anderson@lopezmarinho.com.br',4722),
(72315,23269,49,'Renê Galvão','21','2560-0762','21','2221-8752','obrastacrim@gmail.com',4722),
(58534,23271,16,'Renato Bolsas','31','3319-8119','31','3319-8117','compras@habitare.com.br',12244),
(58535,23271,49,'Saulo Amaral','31','3313-4744','31','3339-5800','rosadamontanha@habitare.com.br',12244),
(58536,23271,20,'Saulo Amaral','31','3313-4744','31','3339-5800','rosadamontanha@habitare.com.br',12244),
(58537,23272,16,'Renato Bolsas','31','3319-8117','31','3319-8119','compras@habitare.com.br',12244),
(58538,23272,20,'Emília Teixeira (Marketing)','31','3339-5810','31','3339-5801','emilia.teixeira@habitare.com.br',12244),
(58539,23272,123,'Daniel Volpini (Engº. de Novos Negócios)','31','3339-5800','31','3339-5801','danielv@habitare.com.br',12244),
(85107,23272,20,'Mariana Nunes (Marketing)','31','3339-5810','31','3339-5801','mariana.nunes@habitare.com.br',12244),
(58545,23275,20,'Sr. Wagner','64','3636-0625','64','3636-0625','',7193),
(58546,23275,49,'Sr. Wagner','64','3636-0625','64','3636-0625','',7193),
(58547,23275,16,'Bruno Gouveia','64','3636-0625','64','3636-0625','compras@engefortnet.com.br',7193),
(58556,23276,20,'Fernanda Dapra (Assesoria de Imprensa)','11','3094-2240','11','3094-2241','fernanda.dapra@bm.com',10315),
(58557,23276,21,'Fabiano Ornelas','11','5502-5000','11','5502-5788','fabiano.ornelas@bm.com',10314),
(58563,23279,16,'Mariza P. de Campos','21','2704-4313','21','2704-4319','mariza@jprconstrucoes.com.br',2077),
(58564,23279,49,'Jean  Pierre Biot','21','2704-4313','21','2704-4319','pierre@jprconstrucoes.com.br',2077),
(58565,23279,20,'Leonardo Campos (Proprietário)','21','2611-1635','21','2704-4313','jpr@jprconstrucoes.com.br',2077),
(58729,23340,20,'Setor de licitação','41','3330-3636','41','3330-3344','',463),
(58821,23376,16,'José Aparecido','16','3519-3111','16','3519-3114','compras2@cbnconstrutora.com.br',11119),
(58822,23376,49,'Rita de Cassia Gomes','16','3519-3111','16','3519-3114','',11119),
(58823,23376,20,'José Aparecido','16','3519-3111','16','3519-3114','',11119),
(58838,23383,16,'Clodoaldo André','19','3512-1805','19','3512-1882','clodoaldo@mrv.com.br',4066),
(58839,23383,49,'Engº Júnior','15','3217-5721','19','3512-1805','',4066),
(58840,23383,20,'Mário / Aline','15','3217-5721','19','3512-1805','',4066),
(58880,23397,16,'Marcelo Gonçalves','31','3503-1855','31','3503-1855','marcelo@phvengenharia.com.br',11209),
(58881,23397,49,'Maria Isabel','31','3503-1855','31','3503-1855','phv@phvengenharia.com.br',11209),
(58882,23397,20,'Luisa Moreira','31','3503-1855','31','3503-1855','luisa@phvengenharia.com.br',11209),
(58918,23409,16,'Departamento de Suprimentos','19','3512-4500','19','3512-4530','',4203),
(58919,23409,21,'Murilo Gomes','16','8119-3175','16','3512-4500','murilo.gomes@mrv.com.br',4203),
(58920,23409,20,'Murilo Gomes','16','8119-3175','16','3512-4500','murilo.gomes@mrv.com.br',4203),
(58936,23415,16,'Clodoaldo André','19','3512-1805','19','3512-1801','clodoaldo@mrv.com.br',4066),
(58937,23415,49,'Rodrigo Grazia','19','3512-1805','19','3512-1801','rodrigog@mrv.com.br',4066),
(58938,23415,20,'Letícia Ramos','31','3318-7195','31','3345-7101','leticia.ramos@mrv.com.br',3009),
(58955,23421,16,'Clodoaldo André','19','3512-1805','19','3512-1801','clodoaldo@mrv.com.br',4066),
(58956,23421,49,'Alessandro','17','3226-6738','19','3512-1805','',4066),
(58957,23421,20,'Josenilson Sirino','17','3226-6738','19','3512-1805','',4066),
(58961,23423,16,'Clodoaldo André','19','3512-1805','19','3512-1801','clodoaldo@mrv.com.br',4066),
(58962,23423,20,'Marcelo Fernandes','17','3227-8328','19','3512-1805','',4066),
(58963,23423,49,'Flávio','17','3227-8328','19','3512-1805','',4066),
(58966,23426,20,'Thaise Floriano','41','3014-1101','41','3079-9898','thaise@galvaovendas.com.br',11549),
(58971,23429,16,'Marcelo Gonçalves','31','3503-1855','31','3503-1828','marcelo@phvengenharia.com.br',11209),
(58972,23429,49,'Bruno Lopes','31','3503-1855','31','3503-1828','',11209),
(58973,23429,20,'Hélcio Neves (Projetos)','31','3503-1855','31','3503-1828','helcio@phvengenharia.com.br',11209),
(58975,23431,16,'Soania Maria da Silva','81','3426-7399','81','3426-7399','compras@bittencourt.com.br',7655),
(58976,23431,49,'Henrique Maciel','81','3426-7399','81','3426-7399','engenharia@bittencourt.com.br',7655),
(58977,23431,20,'Soania Maria da Silva','81','3426-7399','81','3426-7399','compras@bittencourt.com.br',7655),
(58978,23432,16,'Lorena Velozo','81','3426-7399','81','3426-7399','compras@bittencourt.com.br',7655),
(58979,23432,49,'Franklin Bittencourt','81','3426-7399','81','3426-7399','',7655),
(58980,23432,20,'Paula Maria','81','3426-7399','81','3426-7399','engenharia@bittencourt.com.br',7655),
(59004,23439,16,'Levi Xavier','11','3038-2000','11','3038-2029','levi@toledoferrari.com.br',1885),
(69907,23439,16,'Damião Sobrinho','11','3038-2000','11','3038-2029','damiao@toledoferrari.com.br',1885),
(69908,23439,20,'Priscila Zucon (Projetos)','11','3038-2000','11','3038-2029','priscila@toledoferrari.com.br',1885),
(69909,23439,29,'José Eduardo Toledo Ferraz','11','3038-2000','11','3038-2029','jose.eduardo@toledoferrari.com.br',1885),
(87577,23439,21,'Márcio Cistari','11','3038-2000','11','3038-2029','marcio@toledoferrari.com.br',1885),
(59015,23445,16,'Fernando de Moraes dos Reis','11','4453-8328','','','',12348),
(59016,23445,7,'Tânia Valéria','11','4158-7509','11','4158-7509','arq.taniameneng@terra.com.br',12062),
(59017,23445,20,'Cleonice - (Esposa)','11','4453-8328','','','',12348),
(59018,23446,16,'Silvestre Alvares de Rezende','62','4001-3500','62','3942-3510','compras@construtorasurya.com.br',10740),
(59019,23446,49,'Maximiliano de Paiva','62','4001-3500','62','3942-3510','',10740),
(59020,23446,20,'José Antônio de Paiva (Marketing)','62','4001-3500','62','3942-3510','peixoto@construtorasurya.com.br',10740),
(59021,23447,16,'Silvestre Alvares de Rezende','62','4001-3500','62','4001-3510','compras@construtorasurya.com.br',10740),
(59022,23447,49,'Thiago Barcelos','62','4001-3500','62','4001-3510','',10740),
(59023,23447,20,'Sra. Janny Barros','62','4001-3500','62','4001-3510','janny.barros@construtorasurya.com.br',10740),
(59024,23448,16,'Silvestre Alvares Rezende','62','4001-3500','62','4001-3510','compras@suryaconstrutora.com.br',10740),
(59025,23448,49,'Ricardo Passos','62','4001-3500','62','4001-3510','',10740),
(59026,23448,20,'Sra. Janny Barros (Comercial)','62','4001-3500','62','4001-3510','janny.barros@ebm.com.br',10740),
(59027,23449,16,'Silvestre Alvares de Rezende','62','4001-3500','62','4001-3510','compras@suryaconstrutora.com.br',10740),
(59028,23449,49,'Emerson Soares','62','4001-3500','62','4001-3510','',10740),
(59029,23449,20,'Sra. Janny Barros (Comercial)','62','4001-3500','62','4001-3510','janny.barros@ebm.com.br',10740),
(59030,23450,16,'Renato Acácio','11','3816-1198','11','3816-1190','racacio@santabarbarasa.com.br',2056),
(59031,23450,49,'Gilson Almeida','11','3816-1190','11','3816-1190','gilson.almeida@santabarbarasa.com.br',2056),
(59032,23450,20,'André Azevedo','11','2489-6610','11','2489-6610','andrelcazevedo@yahoo.com.br',12349),
(59033,23451,16,'Fábio Lima','11','2440-9169','11','2440-9169','fabiolima@sergpaulista.com.br',12352),
(59034,23451,49,'Carlos Alberto','11','2440-9169','11','2440-9169','',12352),
(59035,23451,20,'Adriana Rocha - (Custo)','11','2440-9169','11','2440-9169','adrianarocha@sergpaulista.com.br',12352),
(59043,23456,20,'Maria Cândida','42','3623-0161','42','3035-2474','guarasan@onda.com.br',9340),
(64619,23456,16,'Maria Cândida','42','3623-0161','42','3035-2474','guarasan@onda.com.br',9340),
(64621,23456,49,'Vilson Rodrigues','42','3623-0161','42','3035-2474','',9340),
(59050,23459,16,'Fabrício Coimbra','21','2719-8680','21','2719-8680','fabricio.coimbra@pinheiropereira.com.br',1094),
(59051,23459,20,'Glidia Machado (Financeiro)','21','2719-8680','21','2719-8680','glidia.machado@pinheiropereira.com.br',1094),
(59052,23459,29,'Alamaco Maciel','21','2719-8680','21','2719-8680','maciel@pinheiropereira.com.br',1094),
(59059,23462,16,'Ana Gabriela / Andressa','11','2227-7300','11','2227-7321','compras@porte.com.br',2480),
(59060,23462,20,'Simone Bezerra (Engenharia)','11','2227-7300','11','2227-7321','engenharia@porte.com.br',2480),
(84815,23462,21,'Carlos Tadeu Colonesi','11','2227-7300','11','2227-7321','tadeu@porte.com.br',2480),
(59115,23486,20,'Mônica Aguiar (Gerente Geral)','21','3202-9450','21','2287-7342','gerencia@copasul.com.br',12364),
(59232,23530,16,'Paulo Natel / Sueli Cocink','13','3222-4884','13','3222-2620','paulonatel@serlam.com.br,sueli@serlam.com.br',2355),
(59233,23530,49,'Celso Vilarinho','13','3222-4884','13','3222-2620','larte@serlam.com.br',2355),
(59234,23530,20,'Engº Celso Vilarinho','13','3349-4583','13','3222-4884','larte@serlam.com.br',2355),
(64420,23538,49,'Francisco Benetti','44','3234-3555','44','3234-3555','construhab@rsconet.com.br',11374),
(64421,23538,16,'Francisco Benetti','44','3234-3555','44','3234-3555','construhab@rsconet.com.br',11374),
(72310,23538,20,'Francisco Benetti','44','3234-3555','44','3234-3555','construhab@rsconet.com.br',11374),
(59259,23541,16,'Engº Luiz Henrique Moreira','21','2437-4849','','','lzhenrique@oi.com.br',12365),
(59260,23541,49,'Engº Luiz Henrique Moreira','21','2437-4849','','','lzhenrique@oi.com.br',12365),
(59261,23541,20,'José Luiz','21','2437-4849','','','',12365),
(59262,23542,16,'Silas Oliveira','11','5053-9033','11','5053-9037','suprimentos@fortenge.com.br',892),
(59263,23542,49,'Eduardo de Araújo','11','5053-9033','11','5053-9037','eduardo@fortenge.com.br',892),
(59264,23542,20,'José Dario (Adm. Obra)','11','3782-4850','11','5053-9033','dario@fortenge.com.br',892),
(59266,23543,16,'Engº Mário Glasberg','21','9999-6515','21','2439-1211','sacpaulo@sacpauloengenharia.com.br',2111),
(59267,23543,49,'Engº Mário Glasberg','21','9999-6515','21','2439-1211','sacpaulo@sacpauloengenharia.com.br',2111),
(59268,23543,20,'Sr. Antônio','21','2439-1211','21','2439-1211','',2111),
(59326,23562,16,'Anderson Cordeiro Santos','41','3343-3791','41','3343-3791','anderson.santos@mrv.com.br',6793),
(59327,23562,21,'Adilson Ferreira ou Marcelo Melo','41','3343-3791','41','3343-3791','adilson@mrv.com.br',6793),
(59328,23562,20,'Aline Conde','41','3012-9130','41','3343-3791','aline.conde@mrv.com.br',6793),
(59329,23563,16,'Anderson Cordeiro Santos','41','3343-3791','41','3343-3791','anderson.santos@mrv.com.br',6793),
(59330,23563,21,'Adilson Ferreira ou Marcelo Melo','41','3343-3791','41','3343-3791','adilson@mrv.com.br',6793),
(59331,23563,20,'Aline Conde','41','3012-9130','41','3343-3791','aline.conde@mrv.com.br',6793),
(59332,23564,16,'Ricardo Lima Santos','41','3012-9100','41','3012-9705','ricardo.santos@mrv.com.br',6793),
(59333,23564,20,'Alessandra Willer (Depto Controle)','41','3012-9100','41','3012-9705','alessandra.willer@mrv.com.br',6793),
(59334,23564,21,'Cícero Augusto Catac Scott Garcia','41','3012-9100','41','3012-9705','cicero.garcia@mrv.com.br',6793),
(59385,23582,16,'Ederson','21','2437-7480','21','2437-7480','pertegengenharia@veloxmail.com.br',243),
(59386,23582,20,'Mônica Gama','21','2437-7480','21','2437-7480','pertegengenharia@veloxmail.com.br',243),
(59387,23582,49,'Isaac M. Finhas','21','2437-7480','21','2437-7480','pertegengenharia@veloxmail.com.br',243),
(59405,23588,16,'Roberto Duru','11','2603-4178','11','2604-2285','roberto.duru@hersa.com.br',11047),
(59406,23588,49,'Alexandre Alves','11','2892-1505','11','2892-1505','alexandre.alves@hersa.com.br',11047),
(59407,23588,20,'Ane','11','2892-1505','11','2892-1505','',11047),
(61112,23588,21,'João Edson Rossin','11','3677-4444','11','3677-4444','coordenadordeobra.pompeia@saocamilo.com',12698),
(59455,23608,16,'Andréa Camile Miranda','31','3299-6900','31','3299-6900','espaco@espacoengenharia.com.br',6166),
(59456,23608,49,'Marcos Miranda','31','3299-6900','31','3299-6900','marcos@espacoengenharia.com.br',6166),
(59457,23608,20,'Marcos Miranda','31','3299-6900','31','3299-6900','marcos@espacoengenharia.com.br',6166),
(59461,23610,16,'Robson Greyson','92','2101-1300','92','2101-1306','robson.greyson@rdenge.com.br',12419),
(59462,23610,49,'Alexandre Cohen','92','2101-1300','92','2101-1306','',12419),
(59463,23610,20,'Daniel Barros','92','2101-1300','92','2101-1306','daniel.barros@rdenge.com.br',12419),
(67918,23614,16,'João Júnior','41','3343-2550','41','3343-2550','compras01@sial.eng.br',4400),
(67919,23614,49,'Marcelo Amaral Vasconcelos','43','3326-2972','41','3343-2550','sial.norte@sercomtel',4400),
(75570,23614,20,'Marcelo Amaral Vasconcelos','43','3326-2972','41','3343-2550','sial.norte@sercomtel',4400),
(59498,23630,16,'Tássio Rodrigues','65','3616-7133','65','3316-7149','t.rodrigues@plaenge.com.br',2107),
(59499,23630,49,'Carlos Santos','65','3316-7100','65','3616-7100','c.santos@plaenge.com.br',2107),
(59500,23630,20,'Tássio Rodrigues','65','3616-7133','65','3316-7149','t.rodrigues@plaenge.com.br',2107),
(90942,23630,21,'Carlos Santos','65','3316-7100','65','3616-7100','c.santos@plaenge.com.br',2107),
(59501,23631,16,'Tássio Rodrigues','65','3616-7133','65','3616-7149','t.rodrigues@plaenge.com.br',2107),
(59502,23631,20,'Adriano Bustamante (Engenheiro)','65','3627-5494','65','3616-7100','a.bustamante@plaenge.com.br',2107),
(59503,23631,49,'João Belini','65','3627-5494','65','3616-7100','j.belini@plaenge.com.br',2107),
(59507,23633,16,'Régis Rodrigues','65','3616-7133','65','3616-7149','regis@plaenge.com.br',2107),
(59508,23633,49,'Sérgio (Compras)','65','3616-7100','65','3616-7149','s.campos@plaenge.com.br',2107),
(59509,23633,20,'Tássio Rodrigues (Compras)','65','3616-7100','65','3616-7149','t.rodrigues@plaenge.com.br',2107),
(59513,23635,20,'Sabrina Gasparote (Chefe de Gabinete)','51','3289-8000','51','3224-5972','sabrinagasparote@smc.prefpoa.com.br',7643),
(59603,23675,16,'Nicanor','11','2236-3499','','','parcecon@gmail.com',12452),
(59604,23675,49,'Márcio','11','2236-3499','','','parcecon@gmail.com',12452),
(59605,23675,20,'Nicanor','11','2236-3499','','','parcecon@gmail.com',12452),
(59655,23698,16,'Clesio de Melo Rodrigues','48','9161-2542','48','3954-0000','clesio@ete.com.br',12466),
(59656,23698,49,'Clesio de Melo Rodrigues (Compras)','48','3214-2200','48','3214-2214','clesio@ete.com.br',0),
(59657,23698,49,'Clesio de Melo Rodrigues (Compras)','48','3214-2200','48','3214-2214','clesio@ete.com.br',0),
(59658,23698,49,'Clesio de Melo Rodrigues','48','9161-2542','48','3954-0000','clesio@ete.com.br',12466),
(65707,23698,20,'Clesio de Melo Rodrigues','48','9161-2542','48','3954-0000','clesio@ete.com.br',12466),
(59682,23704,16,'Ivan / Augusto','11','4177-3242','11','4177-3242','santospereira@santospereiraconstrutora.com.br',4392),
(59683,23704,49,'João Henrique','11','4177-3242','11','4177-3242','santospereira@santospereiraconstrutora.com.br',4392),
(59684,23704,20,'Priscila','11','4177-3242','11','4177-3242','santospereira@santospereiraconstrutora.com.br',4392),
(59701,23713,20,'Cleide Guensen (Projetos)','47','3027-1010','47','3028-1010','adm@hotel10.com.br',4962),
(59753,23729,16,'Beatriz Pierazolli','31','3282-7844','31','3282-7844','topo.compras@terra.com.br',2905),
(67530,23729,20,'Beatriz Pierazolli','31','3282-7844','31','3282-7844','topo.compras@terra.com.br',2905),
(67531,23729,49,'Wilton de Assis Araújo / Denis','31','3282-7844','31','3282-7844','topoeng@terra.com.br',2905),
(59761,23734,20,'Mônique Freitas (Ger. Relações com Investidores)','21','2272-5557','21','2272-5555','',11415),
(95638,23734,16,'Mauro Eduardo','21','2272-5512','21','2272-5555','mauroeduardo@multiner.com.br',11415),
(59778,23739,16,'Marcelo Oliveira','41','3317-1700','41','3317-1701','m.oliveira@plaenge.com.br',5194),
(59779,23739,49,'Vinícius Meyer','41','3337-3871','41','3317-1700','v.meyer@plaenge.com.br',5194),
(59780,23739,20,'Vinícius Meyer','41','3337-3871','41','3317-1700','v.meyer@plaenge.com.br',5194),
(59796,23745,16,'Marcos Paulo Dyszy','11','2677-2100','11','2677-2100','compras@raiza.com.br',7480),
(59797,23745,49,'A definir','11','2677-2100','11','2677-2100','',7480),
(59798,23745,20,'Marcos Paulo Dyszy','11','2677-2100','11','2677-2100','engenharia@raiza.com.br',7480),
(59814,23751,21,'Jaime Alexandrino','11','8187-3164','11','2142-9664','jaimea@bauducco.com.br',11999),
(100499,23751,49,'Luiz Fernando Pimentel','81','9847-0005','19','3446-8555','fernando.pimentel@rioverde.com.br',2808),
(100500,23751,20,'Luiz Fernando Pimentel','81','9847-0005','19','3446-8555','fernando.pimentel@rioverde.com.br',2808),
(59838,23759,21,'Manoel Lima','43','3379-1000','43','3379-1039','m.lima@plaenge.com.br',3459),
(79495,23759,16,'Julio Oliveira','43','3294-1015','43','3294-1039','j.oliveira@plaenge.com.br',3459),
(87044,23759,20,'Danilo Oliva','43','3037-0034','43','3294-1039','d.oliva@plaenge.com.br',3459),
(98773,23759,49,'Danilo Oliva','43','3037-0034','43','3294-1000','d.oliva@plaenge.com.br',3459),
(59885,23775,16,'Ana Luiza','11','3842-6495','11','3846-7971','jucilene@molnar.com.br',12517),
(59886,23775,49,'André Molnar','11','3842-6495','11','3846-7971','andre@molnar.com.br',12517),
(59887,23775,20,'Ana Luisa','11','3842-6495 R. 22','11','3846-7971','analuisa@molnar.com.br',12517),
(59918,23787,20,'Guido Barbelini (Ger. Manutenção)','16','9783-7830','16','3303-4000','guido@lupo.com.br',0),
(59919,23787,20,'Juliana Zacarias','16','3303-4000','16','3303-4001','guido@lupo.com.br',7274),
(59920,23787,49,'Alisson Guadelha','16','3322-7975','16','3322-7975','alisson@ytoara.com.br',11225),
(59994,23816,16,'Ana Cristina Santos','19','3705-9570','19','3897-0706','ana.santos@goldfarb.com.br',10897),
(59995,23816,21,'Levy Monteiro','19','3705-9570','19','3897-0706','levy.monteiro@goldfarb.com.br',10897),
(68072,23816,20,'Luciana Machado','19','3705-9570','19','3897-0706','luciana.machado@goldfarb.com.br',10897),
(60016,23821,20,'José Roberto (Gerente)','19','3824-1504','19','3824-1822','hotelfredy@hotelfredy.com.br',12529),
(60027,23826,16,'Adriana Soares','92','2126-9300','92','2126-9300','adriana.soares@construtoralianca.com.br',10046),
(60028,23826,16,'Adriana Soares','92','2126-9300','92','2126-9300','adriana.soares@construtoralianca.com.br',10046),
(60029,23826,49,'Vitor Fernandes','92','3642-9618','92','2126-9300','vitor.fernandes@construtoralianca.com.br',10046),
(60030,23826,20,'Tatiane Silva','92','2126-9300','92','2126-9300','tatiane.silva@construtoralianca.com.br',10046),
(68328,23829,16,'Luzia Fonseca','21','3724-8000','21','3724-8334','luzia.fonseca@chl.com.br',473),
(68329,23829,20,'Denise (Marketing)','21','3724-8000','21','3724-8334','',473),
(68330,23829,29,'José Barreiro Júnior','21','3724-8000','21','3724-8334','jjunior@chl.com.br',473),
(60044,23831,16,'Simone','41','3324-9919','41','3250-8507','invespark@invespark.com.br',9251),
(60045,23831,20,'Simone','41','3324-9919','41','3250-8507','invespark@invespark.com.br',9251),
(60046,23831,20,'Simone','41','3324-9919','41','3250-8507','invespark@invespark.com.br',9251),
(60051,23834,16,'Mariele Marcelo','11','2942-4010','11','2091-5051','mariele.marcelo@patrimonioweb.com.br',6024),
(60052,23834,70,'Mário Borges','11','2942-4010','11','2091-5051','mario.borges@patrimonioweb.com.br',6024),
(60053,23834,20,'Evelyn Oliveira (Relacionamento)','11','2942-4010','11','2091-5051','relacionamento@patrimonioweb.com.br',6024),
(68007,23841,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(74164,23841,20,'Juliana Barreto (Marketing)','11','3176-1000','11','3176-1000','juliana.barreto@pdg.com.br',316),
(74165,23841,15,'Luana Faria','11','3176-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(67952,23842,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@goldfarb.com.br',316),
(74166,23842,20,'Tatiane Prado (Marketing)','11','3176-1000','11','3176-1000','tatiane.prado@goldfarb.com.br',316),
(74167,23842,16,'Ana Maria Ribeiro','11','3176-1000','11','3176-1270','anamaria.ribeiro@goldfarb.com.br',316),
(60203,23891,16,'Dalmo Heleno','31','3222-9426','31','3222-9424','dalmo@alternativa.eng.br',12006),
(60204,23891,49,'Sanderson','11','2296-7424','11','2296-7424','',4508),
(60205,23891,20,'Felipe','11','2296-9424','11','2296-7424','',4508),
(60218,23898,16,'Engº Paulo Emanuel O. Coelho','21','9806-6940','21','2711-8231','',6130),
(60219,23898,49,'Engº Paulo Emanuel O. Coelho','21','9806-6940','21','2711-8231','',6130),
(60220,23898,20,'Sr. Júlio','21','2711-8231','21','2711-8231','',6130),
(60404,23957,16,'Armando Cunha','21','3541-9000','21','3541-9001','armando.cunha@tenda.com',9292),
(60405,23957,20,'David Oliveira','21','7849-1215','21','3541-9000','david.oliveira@tenda.com',9292),
(60406,23957,49,'David Oliveira','21','7849-1215','21','3541-9000','david.oliveira@tenda.com',9292),
(60407,23958,20,'Viviane Carvalho (Obras)','21','3541-9000','21','3541-9001','viviane.carvalho@tenda.com',9292),
(60408,23958,16,'Luciano Tinoco','21','3541-9000','21','3541-9001','l.tinoco@gafisa.com.br',9292),
(60409,23958,49,'André Tarabau','21','3541-9000','21','3541-9001','tenda@tenda.com',9292),
(60443,23973,20,'Gilberto Vieira (Atendimento)','83','3522-4682','83','3522-2693','',12605),
(60444,23973,21,'Sayonara Mendes','83','3521-2300','83','3522-2693','sayonara@grupoindamel.com.br',12605),
(60488,23989,20,'Danielly (SAC)','21','3541-9000','21','3541-9001','',9292),
(60489,23989,16,'Keyth Nascimento','21','3541-9000','21','3541-9001','keyth.nascimento@tenda.com.br',9292),
(60490,23989,49,'Carlos Felipe Portela Coutinho','21','3541-9000','21','3541-9001','',9292),
(85132,23993,16,'Rosana Aranha','11','3817-0043','11','3812-1795','rosana@mac.com.br',293),
(85133,23993,20,'Laura Brito (Marketing)','11','3817-0033','11','3812-1795','laura.brito@mac.com.br',293),
(85134,23993,29,'André Denone','11','3817-0043','11','3812-1795','andre@mac.com.br',293),
(60508,23997,21,'Elcio Carlos Foglia (Ger. de Engenharia)','99','3529-5014','','','efoglia@suzano.com.br',12608),
(83500,23997,20,'Claudia Rodrigues (Diretoria)','99','3529-5014','','','crodrigues@suzano.com.br',12608),
(97228,23997,16,'Luciano Salles / Luíz Carlos Rios','31','3298-5700','31','3298-5760','luciano.salles@paranasa.com.br',4651),
(97229,23997,67,'Arnaldo Uchoa (Gerente de Contrato)','31','3298-5700','31','3298-5760','',4651),
(60520,24001,21,'Engº Gustavo Bratis','31','3115-6098','31','3115-6098','',5184),
(60521,24001,20,'Sr. Roni (Engenharia)','31','3115-6098','31','3115-6098','',5184),
(66158,24018,49,'Ricardo Meira','71','3342-3926','71','3342-3926','',13417),
(66159,24018,16,'Denilson Gonçalves','71','3342-3926','71','3212-4947','denilson@ccpconstrucoes.com.br',13417),
(84993,24018,20,'Denilson Gonçalves','71','3342-3926','71','3212-4947','denilson@ccpconstrucoes.com.br',13417),
(60563,24020,20,'Sra. Lúcia (Setor de Licitação)','61','3429-6025','61','3429-6126','',121),
(60566,24023,20,'Sra. Sônia (Setor de Licitação)','61','3429-6071','61','3429-6126','',121),
(60567,24024,16,'Fernando Dias','11','3512-4500','11','3512-4503','fernandod@mrv.com.br',3009),
(60568,24024,49,'Alexandre Coelho','11','3512-4500','11','3512-4503','',1504),
(60569,24024,20,'Paula Fernanda','11','3512-4500','11','3512-4503','paulaf@mrv.com.br',3009),
(60657,24062,16,'Alexandre Carvalho','71','3111-4200','71','3111-4200','alexandre.carvalho@tenda.com',12620),
(60658,24062,21,'Luis Henrique','71','3111-4200','71','3111-4200','luis.henrique@tenda.com',12620),
(60659,24062,20,'Paula (Financeiro)','71','3111-4200','71','3111-4200','',12620),
(60663,24066,21,'Departamento de Atendimento','11','0800-771-0122','','','',1377),
(83032,24074,16,'Antônio Santos','21','3433-1314','21','3433-1314','antonio@senproengenharia.com.br',14792),
(83033,24074,49,'Flávio Fleuri','21','2425-0935','21','3433-1314','flavio@senproengenharia.com.br',14792),
(94827,24074,20,'Antônio Santos','21','3433-1314','21','3433-1314','antonio@senproengenharia.com.br',14792),
(60746,24111,16,'Maria da Penha','27','3361-2181','27','3361-2181','penha@realconstrutora.com.br',9129),
(60747,24111,21,'Henrique Fonseca','27','3361-2181','27','3361-2181','henrique@realconstrutora.com.br',9129),
(60748,24111,20,'Henrique Fonseca','27','3361-2181','27','3361-2181','henrique@realconstrutora.com.br',9129),
(60764,24117,16,'Isabel Oliveira','21','2742-2498','21','2742-2498','ageengenharia@uol.com.br',524),
(60765,24117,49,'Jorge Alberto','21','2742-2498','21','2742-2498','',524),
(60766,24117,20,'Suelen','21','2742-2498','21','2742-2498','',524),
(60832,24142,16,'José Amilse','21','2716-9393','21','2716-7137','compras@soter.com.br',2009),
(60834,24142,21,'José Geraldo C. Tavares','21','2716-9393','21','2716-7137','',2009),
(60835,24142,20,'José Antônio','21','2716-9393','21','2716-7137','',2009),
(60872,24160,16,'Wilhan Nunes','21','2575-9448','21','2575-9448','wilhan.nunes@lwbeng.com.br',5741),
(78866,24160,20,'Wilhan Nunes','21','2575-9448','21','2575-9448','wilhan.nunes@lwbeng.com.br',5741),
(78867,24160,49,'Luiz Wagner','21','2575-9448','21','2575-9448','luizwagner@lwbeng.com.br',5741),
(60885,24165,16,'Erika Ferreira','11','3897-3333','11','3081-8700','erikaferreira@engelux.com.br',883),
(60886,24165,29,'William Vitor Souza','11','3897-3333','11','3081-8700','williamvitor@engelux.com.br',883),
(60887,24165,20,'Jeferson Santos','11','3897-3333','11','3897-3334','suprimentos@engelux.com.br',883),
(60888,24166,16,'Cláudio Fernandes','11','3897-3333','11','3081-8700','claudiofernandes@engelux.com.br',883),
(60889,24166,29,'William Vitor Souza','11','3897-3333','11','3081-8700','williamvitor@engelux.com.br',883),
(60890,24166,20,'Clésia Leslie Calixto (DAC)','11','3897-3337','11','3897-3344','atendimentoaocliente@engelux.com.br',883),
(100088,24166,49,'Rogério Romero','11','3897-3333','11','3081-8700','rogerioromero@engelux.com.br',883),
(60910,24178,16,'Thiago Campus','21','2669-1617','21','2668-1108','thiagoorcamento@portalfoco.com.br',10737),
(60911,24178,49,'Arq. André Zichtl da Fonseca','21','2669-1617','21','2668-1108','contato@portalfoco.com.br',10737),
(60912,24178,20,'Fernando Piedade','21','2669-1617','21','2668-1108','producao.fernando@portalfoco.com.br',10737),
(60948,24197,21,'Erika Ferreira (Suprimentos)','11','3897-3333','11','3081-8700','erikaferreira@engelux.com.br',883),
(60949,24197,20,'Jeferson Santos','11','3897-3333','11','3897-3344','suprimentos@engelux.com.br',883),
(76196,24197,29,'William Vitor Souza','11','3897-3333','11','3081-8700','williamvitor@engelux.com.br',883),
(127227,24197,3,'Jeferson Santos','11','3897-3333','11','3897-3344','suprimentos@engelux.com.br',883),
(60950,24198,16,'Erika Ferreira','11','3897-3333','11','3081-8700','erikaferreira@engelux.com.br',883),
(60951,24198,20,'Jeferson Santos','11','3897-3333','11','3897-3334','suprimentos@engelux.com.br',883),
(76195,24198,29,'William Vitor Souza','11','3897-3333','11','3081-8700','williamvitor@engelux.com.br',883),
(60952,24199,16,'Francisco Campos','85','3261-4130','85','3261-3432','lotil@secrel.com.br',7739),
(60953,24199,49,'Camila Alencar','86','3262-1490','85','3261-4130','lotil@secrel.com.br',7739),
(60954,24199,20,'Francisco do Vale','86','3262-1490','85','3261-4130','lotil@secrel.com.br',7739),
(60961,24202,16,'Allan','67','3409-1900','67','3409-1900','allan_coronel@hotmail.com',12679),
(60962,24202,20,'Flávio Lorenzon','67','3409-1900','67','3409-1900','',12679),
(60963,24202,49,'Flávio Lorenzon','67','3409-1900','67','3409-1900','',12679),
(60980,24208,16,'João Rodrigues','11','4339-0678','','','',8650),
(60981,24208,20,'João Rodrigues','11','4339-0678','','','',8650),
(61016,24225,20,'Sr. Charles Oscar Ziert','48','3271-5092','48','3271-5085','charles@santarita.com.br',6493),
(67183,24225,16,'Sr. Charles Oscar Ziert','48','3271-5092','48','3271-5085','charles@santarita.com.br',6493),
(67184,24225,49,'Sr. Orestes','48','3271-5050','48','3271-5050','',6493),
(61080,24250,16,'Engº Giovanni Cabral Grisolia','21','9929-7000','21','2637-3484','giovannicg@globo.com',12696),
(61081,24250,49,'Engº Giovanni Cabral Grisolia','21','9929-7000','21','2637-3484','giovannicg@globo.com',12696),
(61083,24250,20,'Engº Giovanni Cabral Grisolia','21','9929-7000','21','2637-3484','giovannicg@globo.com',12696),
(61096,24254,16,'Rodrigo Dutra','51','3535-7800','51','3535-7800','rodrigo.dutra@tenda.com',12694),
(61097,24254,21,'Engª Bárbara','51','3535-7800','51','3535-7800','',12694),
(61098,24254,20,'Cristiano (Corretor)','51','3535-7800','51','3535-7800','',12694),
(61103,24257,16,'Rodrigo Gallinari','51','3535-7800','51','3535-7844','rodrigogallinari@gafisa.com.br',12694),
(61104,24257,70,'Reinaldo Toth','51','3535-7850','51','3535-7844','rtoth@tenda.com',12694),
(61105,24257,20,'Cristiane Gelvike (Legalizações)','51','3535-7830','51','3535-7844','cristiane.gelvike@tenda.com',12694),
(61106,24258,16,'Rodrigo Dutra','51','3535-7800','51','3535-7800','rodrigo.dutra@tenda.com',12694),
(61107,24258,70,'Luís Gustavo','51','3535-7800','51','3535-7800','lgustavo@gafisa.com.br',12694),
(61108,24258,20,'Luís Gustavo','51','3535-7850','51','3535-7844','lgustavo@gafisa.com.br',12694),
(67628,24260,16,'Ana Lúcia','11','5851-5589','11','5851-5050','analucia@freitasguimaraes.net',6418),
(67629,24260,49,'Carlos Rogério Pinitente','11','5851-5589','11','5851-5050','rogério@freitasguimaraes.net',6418),
(67630,24260,20,'Ana Lúcia','11','5851-5589','11','5851-5050','analucia@freitasguimaraes.net',6418),
(67798,24261,49,'Augusto Lima','11','2344-9500','11','2344-9500','',13603),
(91550,24261,16,'Sr. Rodrigo Sousa','11','2344-9500 - R. 225','11','2344-9500','rodrigo.sousa@cappellano.com.br',13603),
(96297,24261,20,'Sr. Rodrigo Sousa','11','2344-9500 - R. 225','11','2344-9500','rodrigo.sousa@cappellano.com.br',13603),
(61171,24286,16,'Marcos Ritta / Fábio Steiner','48','3461-8100','48','3461-8100','compras@construtorafontana.com.br',3509),
(61172,24286,70,'Rodrigo Ugioni','48','3461-8100','48','3461-8100','rodrigo@construtorafontana.com.br',3509),
(61173,24286,20,'Diórgia Barbosa (Marketing)','48','3461-8100','48','3461-8100','diorgia.barbosa@construtorafontana.com.br',3509),
(91366,24286,49,'João Paulo','48','3461-8100','48','3461-8100','joaopaulo@construtorafontana.com.br',3509),
(61174,24287,16,'Marcos Ritta / Fábio Steiner','48','3461-8100','48','3461-8100','compras@construtorafontana.com.br',3509),
(61175,24287,70,'Rodrigo Ugioni','48','3461-8100','48','3461-8100','rodrigo@construtorafontana.com.br',3509),
(61176,24287,20,'Naiara Silvano (Marketing)','48','3461-8100','48','3461-8100','naiara.silvano@construtorafontana.com.br',3509),
(61180,24289,16,'Sra. Ivani Dalla','11','4435-8484','11','4435-8480','ivani@dallaconstrutora.com.br',7697),
(61181,24289,49,'Rui Dalla','11','4435-8484','11','4435-8480','rui@dallaconstrutora.com.br',7697),
(61182,24289,20,'Sra. Ivani Dalla','11','4435-8484','11','4435-8480','ivani@dallaconstrutora.com.br',7697),
(61191,24292,16,'Luciana Galfaro','11','3791-1260','11','2296-3344','luciana@galfaro.com.br',2477),
(61192,24292,49,'Eduardo Galfaro','11','3791-1260','11','2296-3344','',2477),
(61193,24292,20,'Nilton (Corretor)','11','2091-8772','11','3791-1260','',2477),
(61215,24301,16,'Luiz Telles','81','3311-0053 R. 0046','11','2161-9900','luiztelles@alusa.com.br',5127),
(83091,24301,29,'José Marangon Borges','81','3311-0053','11','2161-9900','marcioborges@alusa.com.br',5127),
(99647,24301,20,'Luiz Telles','81','3311-0053 R. 0046','11','2161-9900','luiztelles@alusa.com.br',5127),
(61220,24302,16,'Levi Costa Silva','11','4194-2880','','','',12712),
(61221,24302,49,'Getúlio Barreto','11','4194-2880','','','',2149),
(61222,24302,20,'Getúlio Barreto','11','4194-2880','','','',2149),
(61275,24321,16,'Laila','81','3198-1000','81','3198-1000','recepcao.recife@tenda.com',12725),
(61276,24321,49,'Ana Verônica','81','3198-1000','81','3198-1000','',12725),
(61277,24321,20,'Paulo Muniz','81','3198-1000','81','3198-1000','',12725),
(61289,24326,16,'André / Rogério','16','3513-1800','16','3513-1899','compras2@pherconconstrutora.com.br',1088),
(61290,24326,49,'João Carlos Mancine','16','3513-1800','16','3513-1899','',1088),
(61291,24326,20,'André (Compras)','16','3513-1800','16','3513-1899','',1088),
(61292,24326,16,'José Roberto','16','3513-1800','16','3513-1899','jose.roberto@pherconconstrutora.com.br',1088),
(61297,24328,16,'Walter Ramos','31','3419-4600','31','3464-2856','walter@construtorauni.com.br',10079),
(61298,24328,49,'Erotides Mendes','31','3419-4600','31','3464-2856','erotides@construtorauni.com.br',10079),
(61299,24328,20,'Márcio Fontes','31','3228-4233','31','3286-2508','mfontes@bhshopping.com.br',5049),
(71016,24328,20,'Adriene Oliveira','31','3228-4435','','','bhs@ccec.com.br',10634),
(61327,24340,20,'Neocir (Licitação)','14','3402-6000','14','3402-6000','',12732),
(61342,24347,16,'Cláudio Cardoso','11','3127-9200','11','3127-9200','cguc@brascanengenharia.com.br',887),
(61343,24347,21,'Marcelo Ghitnic','11','3127-9200','11','3127-9200','mg@brascanengenharia.com.br',887),
(61344,24347,20,'Lúcia (Engenharia)','11','3127-9000','11','3127-9000','',887),
(89486,24347,20,'Mariana (Engenharia)','11','3127-9200','11','3127-9260','',430),
(61349,24349,16,'Luciene de Oliveira Silva','21','3329-0199','21','3329-0199','construtora@sqa.com.br',28),
(61350,24349,49,'Alessandro Ribeiro Corrêa','21','3329-0199','21','3329-0199','',28),
(61351,24349,20,'Roque Matias Fernandes','21','3329-0199','21','3329-0199','',28),
(61381,24360,16,'Renato Wiziack','11','3812-3699','11','3812-3699','suprimentos@jwaconstrutora.com.br',733),
(61382,24360,49,'Jorge Filho','11','3812-3699','11','3812-3699','jwaconstrucao@uol.com.br',733),
(61383,24360,20,'Rafael Almeida (Administrativo)','81','3226-0708','81','3226-0708','rafael@jwaconstrutora.com.br',14359),
(61387,24362,20,'Ronaldo Bordinhão','48','3031-2595','48','3031-2505','ronaldo.bordinhao@desenvix.com.br',12738),
(61388,24362,21,'Ronaldo Bordinhão','48','3031-2595','48','3031-2505','ronaldo.bordinhao@desenvix.com.br',12738),
(61398,24368,16,'Felipe Jerez','11','3025-9000','11','3025-9000','fjerez@tenda.com',1377),
(86706,24368,20,'Henrique Cerqueira','62','7812-9468','62','3946-6400','henrique.cerqueira@tenda.com',12733),
(86707,24368,49,'Henrique Cerqueira','62','7812-9468','62','3946-6400','henrique.cerqueira@tenda.com',12733),
(61407,24373,20,'René (Projetos e Construções)','11','4199-1907','11','4199-3589','licitacoes@barueri.sp.gov.br',3347),
(61408,24374,20,'René (Projetos e Construções)','11','4199-1907','11','4199-3589','licitacoes@barueri.sp.gov.br',3347),
(61409,24375,16,'Gabriel Junqueira','11','2894-6605','11','3088-8100','gabriel@skr.com.br',697),
(61410,24375,49,'Gabriel Junqueira','11','2894-6605','11','3088-8100','gabriel@skr.com.br',697),
(61411,24375,20,'Gabriel Junqueira','11','2894-6605','11','3088-8100','gabriel@skr.com.br',697),
(61438,24384,16,'Jânio Freitas','82','3338-3259','82','3338-3259','janio@contratoengenharia.com.br',6963),
(61439,24384,49,'Paulo Aragão','82','9643-0606','82','3338-3259','restrito',6963),
(61440,24384,20,'Rose (Secr. Jânio)','82','9643-0606','82','3338-3259','janio@contratoengenharia.com.br',6963),
(61471,24398,20,'Depto. de Licitação','31','3250-1607','31','3250-1607','',206),
(61480,24401,16,'Orlando Dognini','41','3024-5060','41','3024-5060','orlando@formulaeng.com.br',12321),
(61481,24401,49,'Carlos Roberto Nogueira','41','3024-5060','41','3024-5060','',12321),
(61482,24401,20,'Alecssandra Soares (Financeiro)','41','3024-5060','41','3024-5060','',12321),
(61488,24404,16,'Arq. Ricardo A. L. de Carvalho','22','9824-9680','22','2760-2832','rcarvalho@riodasostras.rj.gov.br',9590),
(61489,24404,7,'Arq. Ricardo A. L. de Carvalho','22','9824-9680','22','2760-2832','rcarvalho@riodasostras.rj.gov.br',9590),
(61490,24404,20,'Jorge Luiz Alves de Souza','22','2760-2832','','','',9590),
(61511,24413,20,'Márcia Nogueira (Gerente Comercial)','71','3480-4444','71','3480-4444','marcia@thomasmagnus.com.br',8857),
(61513,24415,20,'Luciano (Licitação)','48','3287-2030','48','3287-2034','',7141),
(70734,24416,49,'Daniel Palestrin','48','3621-1600','48','3621-1616','daniel@camiloeghisi.com.br',8952),
(70735,24416,20,'Daniel Palestrin','48','3621-1600','48','3621-1616','daniel@camiloeghisi.com.br',8952),
(70736,24416,16,'Sérgio Ramos','48','3621-1600','48','3621-1616','compras@camiloeghisi.com.br',8952),
(61517,24419,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(68361,24421,20,'Avelino Petrykowski','41','3668-4034','41','3668-4034','jr@engetintas.com',13654),
(68362,24421,49,'Avelino Petrykowski','41','3668-4034','41','3668-4034','jr@engetintas.com',13654),
(68363,24421,16,'Avelino Petrykowski','41','3668-4034','41','3668-4034','jr@engetintas.com',13654),
(61585,24450,16,'Adalberto da Silva Júnior','21','3418-9900','21','3418-9900','compras@conasa.com.br',1139),
(61586,24450,49,'Flávio Beserra','22','2764-1618','21','3418-9900','flaviobeserra@conasa.com.br',1139),
(61587,24450,20,'Francisco Chargas','22','2764-1618','21','3418-9900','chargas.juninho@hotmail.com',1139),
(61617,24465,16,'Cristian Cavalara','11','2346-5131','','','',12773),
(61618,24465,20,'Cristian Cavalara','11','2346-5131','','','',12773),
(61724,24506,16,'Edson Costa','11','3041-2700','11','3041-2749','edson.costa@lindenberg.com.br',12009),
(61725,24506,49,'Bertram Schayer','11','3041-2700','11','3041-2749','rep@rep.com.br',12009),
(61726,24506,20,'Bertram Schayer','11','3041-2700','11','3041-2749','rep@rep.com.br',12009),
(61727,24507,16,'Edson Costa','11','3041-2700','11','3041-2749','edson.costa@lindenberg.com.br',12009),
(61728,24507,49,'Bertram Schayer','11','3041-2700','11','3041-2749','rep@rep.com.br',12009),
(61729,24507,20,'Bertram Schayer','11','3041-2700','11','3041-2749','rep@rep.com.br',12009)


;

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

VALUES

(20728,'RE018227'),
(20732,'RE018222'),
(20753,'RE018252'),
(20821,'CO201151'),
(20906,'RE018356'),
(20913,'RE018362'),
(20922,'CO201185'),
(20924,'CO201184'),
(20951,'RE018400'),
(20952,'RE018399'),
(20955,'RE018397'),
(20958,'RE018398'),
(20977,'RE018418'),
(20978,'RE018419'),
(20984,'RE018433'),
(20986,'RE018430'),
(21016,'RE018451'),
(21017,'RE018452'),
(21102,'CO201225'),
(21121,'RE018502'),
(21187,'RE018547'),
(21191,'CO201266'),
(21202,'RE018552'),
(21206,'RE018559'),
(21210,'RE018549'),
(21218,'RE018556'),
(21237,'RE018578'),
(21243,'RE018590'),
(21245,'RE018589'),
(21273,'RE018592'),
(21275,'RE018594'),
(21276,'RE018593'),
(21299,'RE018601'),
(21360,'RE018627'),
(21361,'RE018628'),
(21362,'RE018629'),
(21404,'CO201400'),
(21405,'CO201405'),
(21473,'IN000044'),
(21483,'RE018664'),
(21484,'RE018663'),
(21493,'CO201450'),
(21496,'CO201455'),
(21498,'CO201454'),
(21499,'CO201441'),
(21521,'IN000057'),
(21526,'IN000056'),
(21529,'IN000058'),
(21536,'RE018693'),
(21542,'RE018694'),
(21544,'RE018698'),
(21563,'RE018707'),
(21576,'CO201484'),
(21581,'IN000067'),
(21610,'IN000074'),
(21632,'RE018749'),
(21636,'RE018759'),
(21642,'RE018760'),
(21677,'IN000089'),
(21680,'RE018781'),
(21686,'RE018785'),
(21687,'CO201504'),
(21690,'RE018792'),
(21708,'IN000095'),
(21709,'RE018803'),
(21710,'RE018806'),
(21721,'RE018802'),
(21728,'RE018805'),
(21729,'RE018804'),
(21731,'RE018815'),
(21734,'RE018800'),
(21745,'RE018824'),
(21749,'RE018826'),
(21750,'RE018825'),
(21765,'RE018835'),
(21787,'RE018853'),
(21813,'CO201542'),
(21815,'CO201541'),
(21830,'RE018875'),
(21861,'RE018895'),
(21882,'RE018912'),
(21894,'CO201556'),
(21901,'CO201559'),
(21902,'CO201560'),
(21914,'RE018931'),
(21915,'RE018926'),
(21919,'RE018920'),
(21920,'RE018921'),
(21921,'RE018922'),
(21922,'RE018923'),
(21965,'CO201577'),
(21968,'CO201553'),
(21976,'CO201575'),
(22011,'RE018982'),
(22012,'RE018983'),
(22015,'RE018984'),
(22018,'RE018994'),
(22020,'CO201592'),
(22021,'CO201595'),
(22024,'CO201593'),
(22039,'RE018996'),
(22041,'CO201596'),
(22042,'CO201598'),
(22048,'RE019005'),
(22055,'RE019008'),
(22070,'CO201608'),
(22073,'RE019032'),
(22110,'CO201618'),
(22112,'CO201619'),
(22115,'CO201614'),
(22124,'CO201625'),
(22131,'RE019059'),
(22133,'RE019064'),
(22134,'RE019063'),
(22135,'RE019062'),
(22136,'RE019061'),
(22137,'RE019060'),
(22146,'RE019081'),
(22149,'RE019083'),
(22151,'RE019084'),
(22167,'CO201632'),
(22171,'CO201628'),
(22180,'RE019102'),
(22182,'RE019098'),
(22244,'CO201663'),
(22247,'RE019125'),
(22250,'CO201669'),
(22263,'RE019138'),
(22284,'IN000166'),
(22309,'IN000168'),
(22317,'RE019163'),
(22327,'CO201701'),
(22332,'CO201700'),
(22341,'CO201702'),
(22356,'RE019174'),
(22358,'CO201709'),
(22360,'CO201714'),
(22362,'RE019182'),
(22365,'RE019184'),
(22370,'CO201716'),
(22384,'RE019183'),
(22385,'CO201731'),
(22397,'RE019195'),
(22403,'CO201734'),
(22408,'CO201733'),
(22441,'RE019205'),
(22443,'RE019204'),
(22445,'CO201751'),
(22450,'CO201765'),
(22451,'CO201773'),
(22457,'CO201772'),
(22461,'CO201767'),
(22469,'IN000185'),
(22476,'CO201780'),
(22477,'RE019233'),
(22486,'IN000199'),
(22488,'RE019224'),
(22489,'CO201779'),
(22528,'CO201791'),
(22529,'IN000205'),
(22570,'RE019274'),
(22578,'RE019275'),
(22580,'RE019273'),
(22584,'RE019271'),
(22585,'CO201817'),
(22601,'CO201832'),
(22625,'CO201833'),
(22636,'RE019296'),
(22661,'RE019315'),
(22666,'RE019324'),
(22669,'RE019325'),
(22685,'RE019322'),
(22686,'RE019323'),
(22690,'RE019319'),
(22712,'RE019333'),
(22743,'CO201879'),
(22749,'RE019344'),
(22751,'CO201892'),
(22753,'CO201891'),
(22765,'CO201897'),
(22821,'CO201925'),
(22823,'CO201928'),
(22825,'IN000267'),
(22887,'CO201968'),
(22892,'CO201965'),
(22897,'CO201966'),
(22915,'CO201977'),
(22916,'CO201976'),
(22919,'IN000291'),
(22920,'CO201975'),
(22921,'CO201978'),
(22948,'CO201992'),
(22952,'CO201991'),
(22956,'CO201993'),
(22964,'IN000298'),
(22969,'RE019405'),
(22972,'RE019407'),
(22975,'RE019406'),
(22977,'RE019404'),
(22979,'RE019402'),
(22982,'CO202011'),
(22988,'RE019418'),
(22999,'CO202013'),
(23045,'RE019439'),
(23078,'CO202032'),
(23098,'RE019483'),
(23104,'CO202042'),
(23105,'CO202043'),
(23106,'RE019490'),
(23107,'RE019489'),
(23122,'CO202047'),
(23124,'RE019505'),
(23128,'RE019511'),
(23129,'RE019517'),
(23133,'IN000306'),
(23145,'CO202052'),
(23146,'RE019523'),
(23163,'RE019535'),
(23164,'RE019534'),
(23172,'CO202061'),
(23244,'RE019572'),
(23252,'IN000320'),
(23268,'RE019593'),
(23269,'RE019592'),
(23271,'CO202102'),
(23272,'CO202101'),
(23275,'CO202103'),
(23276,'RE019595'),
(23279,'RE019594'),
(23340,'RE019648'),
(23376,'RE019670'),
(23383,'RE019669'),
(23397,'CO202138'),
(23409,'RE019683'),
(23415,'RE019685'),
(23421,'RE019706'),
(23423,'RE019700'),
(23426,'CO202145'),
(23429,'RE019699'),
(23431,'CO202146'),
(23432,'RE019713'),
(23439,'RE019714'),
(23445,'RE019697'),
(23446,'RE019716'),
(23447,'RE019715'),
(23448,'RE019701'),
(23449,'RE019711'),
(23450,'RE019702'),
(23451,'RE019717'),
(23456,'RE019724'),
(23459,'RE019723'),
(23462,'RE019727'),
(23486,'CO202155'),
(23530,'RE019765'),
(23538,'RE019774'),
(23541,'RE019771'),
(23542,'RE019773'),
(23543,'RE019775'),
(23562,'CO202192'),
(23563,'RE019785'),
(23564,'CO202191'),
(23582,'RE019809'),
(23588,'RE019813'),
(23608,'RE019823'),
(23610,'RE019821'),
(23614,'RE019839'),
(23630,'RE019836'),
(23631,'RE019838'),
(23633,'RE019837'),
(23635,'RE019840'),
(23675,'RE019892'),
(23698,'RE019894'),
(23704,'RE019891'),
(23713,'IN000343'),
(23729,'RE019895'),
(23734,'RE019913'),
(23739,'RE019946'),
(23745,'RE019912'),
(23751,'RE019908'),
(23759,'RE019906'),
(23775,'IN000349'),
(23787,'CO202263'),
(23816,'RE019993'),
(23821,'RE019994'),
(23826,'RE019992'),
(23829,'RE019989'),
(23831,'RE019990'),
(23834,'RE019991'),
(23841,'CO202283'),
(23842,'CO202278'),
(23891,'RE020033'),
(23898,'RE020034'),
(23957,'RE020047'),
(23958,'RE020050'),
(23973,'IN000375'),
(23989,'IN000378'),
(23993,'CO202334'),
(23997,'RE020072'),
(24001,'RE020070'),
(24018,'CO202349'),
(24020,'RE020089'),
(24023,'RE020088'),
(24024,'RE020086'),
(24062,'CO202368'),
(24066,'CO202367'),
(24074,'IN000388'),
(24111,'CO202384'),
(24117,'CO202385'),
(24142,'RE020155'),
(24160,'RE020158'),
(24165,'RE020164'),
(24166,'RE020166'),
(24178,'IN000420'),
(24197,'IN000417'),
(24198,'IN000419'),
(24199,'IN000418'),
(24202,'RE020186'),
(24208,'IN000422'),
(24225,'RE020193'),
(24250,'CO202452'),
(24254,'RE020201'),
(24257,'RE020198'),
(24258,'RE020199'),
(24260,'RE020200'),
(24261,'RE020197'),
(24286,'CO202470'),
(24287,'CO202473'),
(24289,'CO202471'),
(24292,'CO202469'),
(24301,'CO202472'),
(24302,'RE020219'),
(24321,'RE020243'),
(24326,'RE020247'),
(24328,'RE020246'),
(24340,'IN000439'),
(24347,'RE020254'),
(24349,'RE020257'),
(24360,'RE020266'),
(24362,'CO202453'),
(24368,'IN000443'),
(24373,'IN000444'),
(24374,'CO202497'),
(24375,'RE020265'),
(24384,'CO202500'),
(24398,'RE020285'),
(24401,'RE020288'),
(24404,'RE020287'),
(24413,'CO202507'),
(24415,'CO202513'),
(24416,'CO202506'),
(24419,'CO202508'),
(24421,'CO202509'),
(24450,'CO202515'),
(24465,'RE020326'),
(24506,'RE020346'),
(24507,'RE020345')

;

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