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

(79739,31238,16,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occl.com.br',821),
(79740,31238,20,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occl.com.br',821),
(79741,31238,49,'Marcelo A. Teixeira Monsanto','22','2665-9009','22','2665-9009','monsanto@occl.com.br',821),
(79742,31239,16,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occ.com.br',821),
(79743,31239,49,'Marcelo A. Teixeira Monsanto','22','2665-9009','22','2665-9009','monsanto@occ.com.br',821),
(79744,31239,20,'Carlos Henrique','22','2665-9009','22','2665-9009','chenrique@occ.com.br',821),
(79745,31240,16,'Célia Rochele','84','3331-2506','84','3331-2506','conpasfalcompras@uol.com.br',15033),
(79746,31240,49,'Ivaldo Amorim','84','3331-2506','84','3331-2506','conpasfal@hotmail.com',15033),
(79747,31240,20,'Lilia Viviane (Licitação)','84','3331-2506','84','3331-2506','liliaviviane@msn.com',15033),
(79748,31241,16,'Vicente Gonçalves','15','3221-9511','15','3221-9511','compras@magnumconst.com.br',9),
(79749,31241,20,'Marcos Galiazzo (Arquiteto)','15','3221-9511','15','3221-9579','arq.marcos@magnumconst.com.br',9),
(79758,31242,21,'José Carlos Novaes','31','3499-8322','31','3499-8381','jose.novaes@usiminas.com',58),
(97103,31242,16,'Sra. Mônia','31','3824-7300','31','3824-7300','049administracao@integralonline.com.br',3789),
(97104,31242,20,'Sra. Mônia','31','3824-8400','31','3824-7300','049administracao@integralonline.com.br',3789),
(97105,31242,49,'Wagner Costa','31','3217-8400','31','3217-7300','wagnercr@integralonline.com.br',3789),
(79764,31243,20,'Mário Schlickmann (Diretor Comercial)','48','8842-5251','48','3333-1770','mario.henrique@mg.copobras.com.br',15034),
(79765,31244,20,'Mário Schlickmann (Diretor Comercial)','48','8842-5251','37','3333-1770','mario.henrique@mg.copobras.com.br',15034),
(85524,31244,21,'Jânio Dinart','48','3657-3000','','','janio@copobras.com.br',15034),
(79766,31245,16,'Paulo Antônio','81','2128-4700','81','2128-4708','obra.polaris@gmail.com',846),
(79767,31245,20,'Paulo Antônio','81','9741-3433','81','2128-4708','obra.polaris@gmail.com',846),
(79768,31245,49,'Décio Milano','81','2128-4700','81','2128-4708','obra.polaris@gmail.com',846),
(79769,31246,16,'Cristina Maria','81','2128-4700','81','2128-4708','caminhaeng@caminha.com.br',846),
(79770,31246,20,'Ingrid Cristina (Vendas)','81','2128-4700','81','2128-4708','caminhaeng@caminha.com.br',846),
(79771,31246,49,'Décio Milano','81','2128-4700','81','2128-4708','caminhaeng@caminha.com.br',846),
(100517,31247,16,'Cida Dias','11','3051-9999','11','3885-1237','cida@tiberio.com.br',1096),
(100518,31247,20,'Luiza Belini (Marketing)','11','3051-9999','11','3885-1237','luiza@tiberio.com.br',1096),
(100519,31247,21,'Luciano Hass','11','3051-9999','11','3885-1237','luciano.hass@tiberio.com.br',1096),
(79772,31248,16,'Wellington Alves','31','2128-3700','31','2128-3770','wellington@masb.com.br',14036),
(79773,31248,21,'José Eduardo','31','2128-3700','31','2128-3770','joseeduardo@masb.com.br',14036),
(79774,31248,20,'Tatiana Linses (Relacionamento)','31','2128-3700','31','2128-3770','relacionamento@masb.com.br',14036),
(79775,31249,16,'Rodrigo Cordasso','19','3432-3551','19','3432-3551','rodrigocordasso@supricelconstrutora.com.br',13675),
(79776,31249,49,'Murilo Coimbra','19','3432-3551','19','3432-3551','murilo.coimbra@supricelconstrutora.com.br',13675),
(79777,31249,20,'Murilo Coimbra (Engenheiro)','19','3422-3158','19','3432-3551','murilo.coimbra@supricelconstrutora.com.br',13675),
(79778,31250,16,'Ricardo Perriraz da Silva','21','9769-5885','21','2609-8769','ricardoperriraz@ig.com.br',15038),
(79779,31250,49,'Ricardo Perriraz da Silva','21','9769-5885','21','2609-8769','ricardoperriraz@ig.com.br',15038),
(79780,31250,20,'Alexandre Rodrigues (Projetista)','21','2609-8769','','','',15038),
(79781,31251,16,'Adelson Vieira','21','3505-9300','21','3114-2083','compras@primelafem.com.br',15037),
(79782,31251,49,'Engº Fred Mendes','21','3505-9300','21','3114-2083','fred@primelafem.com.br',15037),
(79783,31251,20,'Luiz Pimenta (Gerente Adm)','21','3505-9300','21','3114-2083','fred@primelafem.com.br',15037),
(79784,31252,16,'Adilson Vieira','21','3505-9300','21','3505-9333','compras@primelafem.com.br',15037),
(79785,31252,49,'Engº Fred Mendes','21','3505-9333','21','3505-9333','fred@primelafem.com.br',15037),
(79786,31252,20,'Luiz Pimenta (Gerente Adm.)','21','3114-2038','21','3505-9333','fred@primelafem.com.br',15037),
(79790,31253,16,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79791,31253,49,'Diogo Cabral de M. Filho','21','2220-9051','21','2220-9051','diogocmfilho@yahoo.com.br',14804),
(79792,31253,20,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79793,31254,16,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79794,31254,20,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79795,31254,49,'Diogo Cabral de M. Filho','21','2220-9051','21','2220-9051','diogocmfilho@yahoo.com.br',14804),
(79796,31255,16,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79797,31255,20,'Raphaella Farias','21','2220-9051','21','2220-9051','raphaella@asmconstrucoes.com',14804),
(79798,31255,49,'Diogo Cabral de M. Filho','21','2220-9051','21','2220-9051','diogocmfilho@yahoo.com.br',14804),
(79799,31256,16,'Elizângela Diniz Alves','11','3884-2466','11','3885-9471','compras@zogbiengenharia.com.br',2846),
(79800,31256,20,'Osvaldo Júnior (Estagiário de Engenharia)','11','3052-3756','11','3884-2466','sppremium@zogbiengenharia.com.br',2846),
(79801,31256,49,'Raphael Gavião','11','3052-3756','11','3884-2466','projeto2@zogbiengenharia.com.br',2846),
(79802,31257,16,'Renata Lucreto / Afonso Gianetti','11','3539-7455','11','3539-7455','compras@kaslik.com.br',15039),
(79803,31257,20,'Alexandre Farias','11','2825-1770','11','3539-7455','alexandre.farias@kaslik.com.br',15039),
(79804,31257,49,'Alexandre Farias','11','2825-1770','11','3539-7455','alexandre.farias@kaslik.com.br',15039),
(79805,31258,16,'Gisela Portelo','21','3416-9001','21','2421-1346','compras@montserrat.com.br',3380),
(79806,31258,49,'Camilo Rebelo Pinto','21','3416-9001','21','2421-1346','crebelo@montserrat.com.br',3380),
(79807,31258,20,'Lílian Mendes (Adm.)','21','3416-9001','21','2421-1346','atendimento@montserrat.com.br',3380),
(79808,31259,20,'Poliane Bastos (Comunicação)','31','3316-8138','31','3316-8454','comunicacao@teksid.com.br',1202),
(79809,31260,20,'Artur Carlos (Dir. financeiro)','47','3436-0355','47','3465-6829','',15041),
(93629,31260,121,'Jacson Nassa (Diretor Infraestrutura)','47','3436-0355','47','3465-6829','jacson@cajadan.com.br',15041),
(79818,31261,16,'Juliana Morais','62','3096-1150','62','3096-1174','compras@enecengenharia.com.br',15019),
(79819,31261,49,'Murilo Santana','62','3215-2724','62','3096-1150','murilo@enecengenharia.com.br',15019),
(79820,31261,20,'Silvio de Almeida (Almoxarifado)','62','3215-2724','62','3096-1150','',15019),
(79821,31262,16,'Edemir Ern','47','3340-2080','47','3340-2080','edemir@speranzini.eng.br',15042),
(79822,31262,20,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79823,31262,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(92217,31262,49,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79824,31263,16,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79825,31263,49,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79826,31263,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79827,31264,16,'André Belk','47','3340-2080','47','3340-2080','andre@speranzini.eng.br',15042),
(79828,31264,20,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79829,31264,49,'André Belk','47','3340-2080','47','3340-2080','andre@speranzini.eng.br',15042),
(79830,31265,16,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79831,31265,20,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79832,31265,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79833,31266,16,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79834,31266,20,'Eng° Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79835,31266,49,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79842,31267,16,'Shirlei Ribeiro','11','3759-8639','11','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(79843,31267,20,'Andreza Costa (Planejamento)','11','3759-8500','11','3759-8600','andrezacosta@rossiresidencial.com.br',366),
(79844,31267,49,'Carlos Marciano','11','3759-8500','11','3759-8600','carlosmarciano@rossiresidencial.com.br',366),
(79845,31268,16,'Shirlei Ribeiro','11','3759-8639','11','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(79846,31268,20,'Andreza Costa (Planejamento)','11','3759-8500','11','3759-8600','andrezacosta@rossiresidencial.com.br',366),
(79847,31268,49,'Carlos Marciano','11','3759-8500','11','3759-8600','carlosmarciano@rossiresidencial.com.br',366),
(79851,31269,49,'Carlos Marciano','11','4058-2000','11','4058-2001','carlosmarciano@rossiresidencial.com.br',366),
(79852,31269,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(89897,31269,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79848,31270,49,'Carlos Marciano','11','4058-2000','11','4058-2001','carlosmarciano@rossiresidencial.com.br',366),
(79849,31270,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(79850,31270,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79853,31271,49,'Carlos Marciano','11','4058-2000','11','4058-2001','carlosmarciano@rossiresidencial.com.br',366),
(79854,31271,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79855,31271,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(79856,31272,16,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79857,31272,49,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79858,31272,20,'Carlos (Atendente)','22','2764-1699','','','',8412),
(79859,31273,16,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79860,31273,49,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79861,31273,20,'Carlos (Atendente)','22','2764-1699','','','',8412),
(79862,31274,16,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79863,31274,49,'Laila Figueiró','22','2764-1699','','','lailafigui@ostras.net',8412),
(79864,31274,20,'Carlos (Atendente)','22','2764-1699','','','',8412),
(79865,31275,16,'Dionísio Cabral Júnior','22','7835-2770','22','2771-3355','tempoespaco@hotmail.com',5743),
(79866,31275,49,'Dionísio Cabral Júnior','22','7835-2770','22','2771-3355','tempoespaco@hotmail.com',5743),
(79867,31275,20,'Ana Paula (Recepção)','22','2771-3355','','','tempoespaco@hotmail.com',5743),
(79868,31276,16,'Arq. Gerson Araújo','21','2791-3924','21','2791-3924','engefato@hotmail.com',494),
(79869,31276,7,'Arq. Gerson Araújo','21','2791-3924','21','2791-3924','engefato@hotmail.com',494),
(79870,31276,20,'Arq. Gerson Araújo','21','2791-3924','21','2791-3924','engefato@hotmail.com',494),
(79871,31277,16,'Sônia Gama','21','3411-3881','21','2138-9618','agprima@hotmail.com',15044),
(79872,31277,49,'Andréia','21','3411-3881','21','2138-9618','agprima@hotmail.com',15044),
(79873,31277,20,'César Martins (Financeiro)','21','3411-3881','21','2138-9618','agprima@hotmail.com',15044),
(79877,31278,16,'Juliana Morais','62','3096-1150','62','3096-1177','compras@enecengenharia.com.br',15019),
(79878,31278,20,'Izael Cavalcante (Adm)','62','3215-7354','62','3096-1150','izaelcavalcante@hotmail.com',15019),
(96540,31278,49,'Murilo Silva','62','9347-5778','62','3215-7354','murilo.silva@enecengenharia.com.br',15019),
(79879,31279,16,'Renata Fernanda','11','3284-0752','11','3289-0109','suprimentos@jfengenharia.com.br',3049),
(79880,31279,49,'Adilson Ferreira','11','2801-6660','11','3284-0752','jfeng@jfengenharia.com.br',3049),
(79881,31279,20,'Adilson Ferreira','11','2801-6660','11','3284-0752','jfeng@jfengenharia.com.br',3049),
(79882,31280,20,'Engº José Teixeira','19','3633-8015','19','3633-3197','zeteixeira@sequoia.imb.br',7861),
(79883,31281,20,'Engº José Teixeira','19','3633-8015','19','3633-3197','zeteixeira@sequoia.imb.br',7861),
(79884,31282,20,'Engº José Teixeira','19','3633-8015','19','3633-3197','zeteixeira@sequoia.imb.br',7861),
(79885,31283,20,'Engº José Teixeira','19','3633-8015','19','3633-3197','zeteixeira@sequoia.im.br',7861),
(79886,31284,49,'Fábio Gradowski','41','3373-2966','41','3373-1942','cnnfabio@terra.com.br',7384),
(87840,31284,16,'Nicolas Gradowski / Fábio Gradowski','41','3373-2966','41','3373-1942','cnnfabio@terra.com.br',7384),
(87841,31284,20,'Nicolas Gradowski / Fábio Gradowski','41','3373-2966','41','3373-1942','cnnfabio@terra.com.br',7384),
(79887,31285,20,'Luciano Pereira','92','4009-1094','','','luciano.p@samsung.com',9180),
(79888,31285,21,'Luciano Pereira','92','4009-1094','','','luciano.p@samsung.com',9180),
(79889,31286,20,'Carlos Bernardi (Financeiro)','54','3293-1935','54','3293-1935','financeiro@maisfruta.com.br',15046),
(79890,31286,21,'Giovan Giulian','54','3293-1935','54','3293-1935','giovan@maisfruta.com.br',15046),
(79894,31287,49,'Viviane Chagas','11','4058-2000','11','4058-2001','vivianechagas@rossiresidencial.com.br',366),
(79895,31287,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79896,31287,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(79897,31288,16,'Shirlei Ribeiro','11','3759-8639','11','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(79898,31288,49,'Cristian Siqueira','11','3759-8500','11','3759-8600','cristiansiqueira@rossiresidencial.com.br',366),
(79899,31288,20,'Andreza Costa (Planejamento)','11','3759-8500','11','3759-8600','andrezacosta@rossiresidencial.com.br',366),
(79900,31289,49,'Viviane Chagas','11','4058-2000','11','4058-2001','vivianechagas@rossiresidencial.com.br',366),
(79901,31289,20,'Andreza Castro (Planejamento)','11','4058-2000','11','4058-2001','andrezacastro@rossiresidencial.com.br',366),
(79902,31289,16,'Celso Ribeiro','11','4058-2000','11','4058-2001','celsoribeiro@rossiresidencial.com.br',366),
(79903,31290,16,'Maycon Gasda','47','3340-2080','47','3340-2080','maycon@speranzini.eng.br',15042),
(79904,31290,49,'Maycon Gasda','47','3340-2080','47','3340-2080','maycon@speranzini.eng.br',15042),
(79905,31290,20,'Eng° Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79906,31291,16,'Maycon Gasda','47','3340-2080','47','3340-2080','maycon@speranzini.eng.br',15042),
(79907,31291,49,'Maycon Gasda','47','3340-2080','47','3340-2080','maycon@speranzini.eng.br',15042),
(79908,31291,20,'Eng° Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79909,31292,16,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79910,31292,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79911,31292,20,'Eng° Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79912,31293,16,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79913,31293,49,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79914,31293,20,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79915,31294,16,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79916,31294,49,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79917,31294,20,'Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79918,31295,49,'Carlos Marciano','11','3759-8500','11','3759-8600','carlosmarciano@rossiresidencial.com.br',366),
(79919,31295,16,'Shirlei Ribeiro','11','3759-8639','11','3759-8649','shirleiribeiro@rossiresidencial.com.br',366),
(79920,31295,20,'Andreza Costa (Planejamento)','11','3759-8500','11','3759-8600','andrezacosta@rossiresidencial.com.br',366),
(79941,31296,16,'Ângelo Augusto','16','4009-9499','16','4009-9499','angelo@stefaninogueira.com.br',3351),
(79942,31296,49,'Nilo Stefani','16','4009-9499','16','4009-9499','',3351),
(79943,31296,20,'Nilo Stefani','16','4009-9499','16','4009-9499','',3351),
(79944,31297,16,'Thiago Silva','11','3025-7777','11','3025-7503','thiagosilva@odebrecht.com',14250),
(79945,31297,49,'Otávio Azevedo','11','3025-7777','11','3025-7503','oazevedo@odebrecht.com',14250),
(79946,31297,20,'Dário Ávila (Adm)','11','3025-7777','11','3025-7503','davila@odebrecht.com',14250),
(79947,31298,16,'Regina de Fátima','21','7838-1609','21','2487-8475','reginafbatista@oi.com.br',771),
(79948,31298,49,'Luiz Claudio Pereira Batista','21','2487-8475','21','2487-8475','karapitoengenharia@yahoo.com.br',771),
(79949,31298,20,'Maria Lopes (Adm.)','21','2487-8475','21','2487-8475','',771),
(79950,31299,16,'Wilson Benjamin','21','2242-9606','21','2242-9606','compras@seel.com.br',6870),
(79951,31299,49,'Paulo Henrique Vieira Dias','21','2242-9606','21','2242-9606','',6870),
(79952,31299,20,'Elaine Martins (Cadastro)','21','2242-9606','21','2242-9606','',6870),
(79957,31300,49,'Edilson Correa','54','3520-2000','54','3520-2001','edilson@viero.com.br',7962),
(79958,31300,21,'Nilson Leal','47','3331-2187','47','3331-2222','nilson.leal@bunge.com',641),
(84937,31300,16,'Ademir Pilotto','54','3520-2000','54','3520-2001','compras@viero.com.br',7962),
(84938,31300,20,'Nilson Leal','47','3331-2187','47','3331-2222','nilson.leal@bunge.com',641),
(85273,31301,20,'Manuel Neves Maria (Diretor Industrial)','14','3811-8000 - R. 8021','14','3811-8001','manuel@irizar.com.br',15049),
(85274,31301,21,'Manuel Neves Maria (Diretor Industrial)','14','3811-8000 - R. 8021','14','3811-8001','manuel@irizar.com.br',15049),
(79965,31302,20,'Marcia Santos (Sup. Compras e Projetos)','34','3325-0078','34','3326-0100','ubsuporte@naqglobal.com',15050),
(79966,31302,21,'Fernanda Dias (Gerente Geral)','51','3246-0901','51','3246-0901','operations@naqglobal.com',15050),
(120063,31302,16,'Marcia Santos (Sup. Compras e Projetos)','34','3325-0078','34','3326-0100','ubsuporte@naqglobal.com',15050),
(79967,31303,16,'Carlos Henrique','21','2218-4805','21','2218-4805','revolutionengenharia.carlos@gmail.com',15052),
(79968,31303,49,'Leandro Soares Pereira','21','2218-4805','21','2218-4805','',15052),
(79969,31303,20,'Leandro Soares Pereira','21','2218-4805','21','2218-4805','',15052),
(79970,31304,16,'Ricardo Hirata','43','3371-1000','43','3371-1001','compras@ayoshii.com.br',2900),
(79971,31304,49,'Fernando Bulaty','43','3371-1000','43','3371-1001','f.bulaty@ayoshii.com.br',2900),
(79972,31304,21,'Leonardo Schibelsky','43','3371-1000','43','3371-1001','leonardo@ayoshii.com.br',2900),
(90086,31304,20,'Fernanda Zambroti (Marketing)','43','3371-1000','43','3371-1001','marketing@ayoshii.com.br',2900),
(79974,31305,16,'Cláudio Godoy','19','3807-7050','19','3808-3137','claudio.fksengenharia@gmail.com',15053),
(79975,31305,49,'Luis Peterlini','19','3807-7050','19','3807-3137','luispeterlini.fksengenharia@gmail.com',15053),
(79976,31305,20,'Cláudio Godoy (Compras)','19','3807-7050','19','3808-3137','claudio.fksengenharia@gmail.com',15053),
(79977,31306,16,'Cláudio Godoy','19','3807-7050','19','3808-3137','claudio@fksengenharia.com.br',15053),
(79978,31306,49,'Luis Peterlini','19','9797-3202','19','3807-7050','',15053),
(79979,31306,20,'Luis Peterlini','19','9797-3202','19','3807-7050','',15053),
(79980,31307,16,'Ângelo Henrique / Claudomiro Gomes','16','4009-9480','19','4009-9499','angelo@stefaninogueira.com.br',3351),
(79981,31307,49,'Luis Fernando','16','3916-3774','19','4009-9499','',3351),
(79982,31307,20,'Aderval Mendes (Almoxarifado)','16','3916-3774','19','4009-9499','aderval@stefaninogueira.com.br',3351),
(79984,31308,16,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79985,31308,20,'Eng° Fábio Mena Barreto','47','9938-3181','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79986,31308,49,'Edenir Ern','47','3340-2080','47','3340-2080','edenir@speranzini.eng.br',15042),
(79987,31309,16,'Alan Wadika','47','3340-2080','47','3340-2080','alan@speranzini.eng.br',15042),
(79988,31309,20,'Kamila Marcon (Engenharia)','47','3340-2080','47','3340-2080','eng.kamila@speranzini.eng.br',15042),
(79989,31309,49,'Alan Wadika','47','3340-2080','47','3340-2080','alan@speranzini.eng.br',15042),
(79990,31310,16,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79991,31310,49,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79992,31310,20,'Kamila Marcon (Engenheira)','47','3340-2080','47','3340-2080','eng.kamila@speranzini.eng.br',15042),
(79993,31311,16,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.com.br',15042),
(79994,31311,49,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.com.br',15042),
(79995,31311,20,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.com.br',15042),
(79996,31312,16,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79997,31312,49,'Fábio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.eng.br',15042),
(79998,31312,20,'Fabio Mena Barreto','47','3340-2080','47','3340-2080','fabio.mena@speranzini.com.br',15042),
(79999,31313,49,'A definir','51','3228-4855','','','',15054),
(80000,31313,16,'Evandro Solidame','51','3228-4855','','','compras@equipeng.com.br',15054),
(99383,31313,20,'Evandro Solidame','51','3228-4855','','','compras@equipeng.com.br',15054),
(80001,31314,49,'Paulo Galvani','51','3228-4855','','','recepcao@equipeng.com.br',15054),
(80002,31314,16,'Andréia Stasinski','51','3228-4855','51','3228-4855','andreia@equipeng.com.br',15054),
(99382,31314,20,'Náthali (Recepção)','51','3228-4855','','','recepcao@equipeng.com.br',15054),
(80003,31315,16,'Andréia Stasinski','51','3228-4855','51','3228-4855','andreia@equipeng.com.br',15054),
(80004,31315,49,'Paulo Galvani','51','3228-4855','51','3228-4855','recepcao@equipeng.com.br',15054),
(99384,31315,20,'Roberta Galvani','51','3228-4855','51','3228-4855','equipe@equipeng.com.br',15054),
(80006,31316,20,'Juarez Sá','11','97708-7764','12','3042-0155','juarezsa@mpd.com.br',1432),
(122391,31316,16,'Juarez Sá','11','97708-7764','12','3042-0155','juarezsa@mpd.com.br',1432),
(122392,31316,49,'Adriano José','12','3042-0155','11','2149-4877','ajsantos@mpd.com.br',1432),
(80007,31317,16,'Joamir Nascimento Maia','21','8696-6472','21','2621-1574','comercial.rj@joama.com.br',3523),
(80008,31317,49,'Antônio Aparecido D. Amaral','21','8696-6472','21','2621-1574','comercial.rj@joama.com.br',3523),
(80009,31317,20,'Joamir Nascimento Maia','21','8696-6472','21','2621-1574','comercial.rj@joama.com.br',3523),
(80010,31318,16,'Sylvio Pinto','21','2431-6828','21','2431-6828','sylvio@fabiobruno.com',15057),
(80011,31318,49,'Carlos Roberto','21','2431-6828','21','2431-6828','fabiobruno@fabiobruno.com',15057),
(80012,31318,20,'Sylvio Pinto (Compras)','21','2431-6828','21','2431-6828','sylvio@fabiobruno.com',15057),
(80013,31319,16,'Mauro César Gama Peres','21','9985-6260','','','maurocesar@dh.com.br',15058),
(80014,31319,49,'Mauro César Gama Peres','21','9985-6260','','','maurocesar@dh.com.br',15058),
(80015,31319,20,'Mauro César Gama Peres','21','9985-6260','','','maurocesar@dh.com.br',15058),
(85992,31321,20,'José Luksas (Dir. Industrial)','11','3186-8921','11','3186-8922','jose.luksas@saint-gobain.com',15059),
(85993,31321,21,'José Luksas (Dir. Industrial)','11','3186-8921','11','3186-8922','jose.luksas@saint-gobain.com',15059),
(80019,31323,20,'Fernanda Monteiro (Assessoria de Imprensa)','11','3165-9596','11','3165-9596','fernanda.monteiro@fsb.com.br',11274),
(80020,31323,16,'José Malaquias','71','2107-6605','71','2107-6762','josemalaquias@jmacedo.com.br',15061),
(80021,31324,16,'Sebastião Araújo Mangabeira','21','2495-7695','21','2495-7695','cmodelar@ig.com.br',7817),
(80022,31324,49,'Alexandre Szyfman','21','2495-7695','21','2495-7695','szyfman@ig.com.br',7817),
(80023,31324,20,'Thiago Firmino (Adm.)','21','2495-7695','21','2495-7695','cmodelar@ig.com.br',7817),
(80024,31325,16,'Vitor Friedrich','55','3322-6870','55','3322-6870','construtora@construtorafriedrich.com.br',5462),
(80025,31325,49,'Vitor Friedrich','55','3322-6870','55','3322-6870','construtora@construtorafriedrich.com.br',5462),
(80026,31325,20,'Eliane Souza (RH)','55','3322-6870','55','3322-6870','construtora@construtorafriedrich.com.br',5462),
(80027,31326,16,'Vitor Friedrich','55','3322-6870','55','3322-6870','construtora@construtorafriedrich.com.br',5462),
(80028,31326,49,'Vitor Friedrich','55','3322-6870','55','3322-6870','construtora@construtorafriedrich.com.br',5462),
(80029,31326,20,'Eliane Souza (RH)','55','3322-6870','55','3322-6870','construtora@construtorafriedrich.com.br',5462),
(80030,31327,16,'José Cláudio','62','3933-0000','62','3933-0028','joseclaudio@lourencoconstrutora.com.br',13403),
(80031,31327,49,'Rafael Zamelate','62','3258-7813','62','3933-0000','rafael@lourencoconstrutora.com.br',13403),
(80032,31327,20,'Rafael Zamelate','62','3258-7813','62','3933-0000','rafael@lourencoconstrutora.com.br',13403),
(80033,31328,16,'José Cláudio','62','3933-0000','62','3933-0028','joseclaudio@lourencoconstrutora.com.br',13403),
(80034,31328,49,'João Paulo','62','3933-0000','62','3933-0028','joaopaulo@lourencoconstrutora.com.br',13403),
(80035,31328,20,'Valdirene Santos (Adm.)','62','3933-0000','62','3933-0028','contato@lourencoconstrutora.com.br',13403),
(80036,31329,16,'Luiz Roberto','11','3048-2027','11','3048-2021','lroberto@atuaconstrutora.com.br',13629),
(80037,31329,20,'Luiz Roberto','11','3048-2027','11','3048-2021','lroberto@atuaconstrutora.com.br',13629),
(80038,31329,21,'Cláudio Pace','11','3048-2020','11','3048-2021','cpace@atuaconstrutora.com.br',13629),
(89081,31329,49,'Ronald Perez','11','3048-2020','11','3048-2021','rperez@atuaconstrutora.com.br',13629),
(80050,31330,16,'Tarcísio Fonseca','21','2172-1800','21','2172-1845','tarcisio@calper.com.br',310),
(80051,31330,20,'Roberto Santos','21','2172-1832','21','2172-1845','roberto.santos@calper.com.br',310),
(80052,31330,21,'Damásia Gonzales','21','2172-1800','21','2172-1845','damasia@calper.com.br',310),
(98368,31330,49,'João Gilberto','21','2172-1800','21','2172-1845','joão.gilberto@calper.com.br',310),
(96305,31331,16,'Márcio Grigolon','11','4502-3000','11','4502-2321','marcio.grigolon@cyrela.com.br',1),
(96306,31331,20,'Cristiano Silva (Planejamento)','21','3523-4137','21','3550-2000','cristianosilva@rjzcyrela.com.br',1598),
(96307,31331,21,'Ricardo Azevedo','21','3523-4137','21','3550-2000','ricardoazevedo@rjzcyrela.com.br',1598),
(80056,31332,20,'Rodrigo Souza (Operações)','21','3525-7763','21','3525-7777','rodrigo.souza@ancarivanhoe.com.br',9000),
(80070,31339,16,'Jefferson Holz','47','3348-2030','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80071,31339,49,'Jefferson Holz','47','3348-2030','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80072,31339,20,'Eduardo Neri (Mestre de Obras)','47','3268-6828','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80073,31340,16,'Jefferson Holz','47','3348-2030','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80074,31340,49,'Jefferson Holz','47','3348-2030','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80075,31340,20,'Marilú (Administrativo)','47','3264-0704','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80076,31341,16,'Jefferson Holz','47','3348-2030','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80077,31341,49,'Jefferson Holz','47','3348-2030','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80078,31341,20,'Jefferson Holz','47','3348-2030','47','3348-2030','administracao@construtoraholz.com.br',15067),
(80081,31342,16,'Joamir Nascimento Maia','21','8696-6472','21','2621-1574','comercial.rj@joama.com.br',3523),
(80082,31342,49,'Antônio A. Domingues Amaral','21','2621-1574','21','2621-1574','comercial.rj@joama.com.br',3523),
(80083,31342,20,'Evellin','21','8696-6472','21','2621-1574','comercial.rj@joama.com.br',3523),
(80084,31343,16,'Marcelo Cunha','21','2184-9700','21','2187-9710','compras@efer.com.br',30),
(80085,31343,49,'Josimar Araújo','21','2184-9700','21','2187-9710','josimar@efer.com.br',30),
(80086,31343,20,'Josimar Araújo','21','2184-9700','21','2187-9710','josimar@efer.com.br',30),
(80087,31344,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(80088,31344,20,'Consuelo Miranda (Compras)','17','3578-0525','17','3234-1828','consuelo.miranda@hmengenharia.com.br',7816),
(80089,31344,29,'Marcos Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(80090,31345,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(80091,31345,20,'Consuelo Miranda (Compras)','17','3321-0777','17','3321-0777','consuelo.miranda@hmengenharia.com.br',7816),
(85649,31345,29,'Marcos Antônio Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(80095,31346,16,'Marcelo Cunha / Raquel','21','2187-9700','21','2187-9710','marcelo.cunha@efer.com.br',30),
(80096,31346,20,'Wilson Teixeira (Almoxarifado)','21','2620-2112','21','2187-9700','obra.thepoint@efer.com.br',30),
(80097,31346,49,'Dr. Luiza Pereira','21','2620-2112','21','2187-9700','luiza.pereira@efer.com.br',30),
(80101,31348,16,'Diógenes Luiz','11','3809-3899','11','3846-8416','compras@freis.com.br',1686),
(80102,31348,49,'Renato da Rocha Sousa','11','3044-0387','11','3809-3899','renato@freis.com.br',1686),
(105017,31348,20,'Renato da Rocha Sousa','11','3044-0387','11','3809-3899','renato@freis.com.br',1686),
(80103,31349,16,'Diógenes Luiz','11','3809-3899','11','3846-8416','compras@freis.com.br',1686),
(80104,31349,49,'Fernando Caballeiro','11','5505-1704','11','3809-3899','caballeiro@freis.com.br',1686),
(104290,31349,20,'Fernando Caballeiro','11','5505-1704','11','3809-3899','berrinejw@uol.com.br',1686),
(80105,31350,16,'Genildo Izidoro','21','2220-1296','21','2220-1220','genildo@focusconstrucoes.com.br',8712),
(80106,31350,49,'Engº. Fábio Ferreira','21','2220-1296','21','2220-1220','fabio@focusconstrucoes.com.br',8712),
(80107,31350,20,'Engº. Fábio Ferreira','21','2220-1296','21','2220-1220','fabio@focusconstrucoes.com.br',8712),
(80108,31351,16,'Renata Soares','21','3435-9967','21','3325-5349','yorkenegenharia@gmail.com',15069),
(80109,31351,49,'Engº Augusto José Campos','21','3435-9967','21','3325-5349','yorkenegenharia@gmail.com',15069),
(80110,31351,20,'Bruno Campos (Adm.)','21','3435-9967','21','3325-5349','bcampos@atmoscapital.com.br',15069),
(80111,31352,16,'Frank Wellington','61','3202-1533','61','3202-1533','frank@faenge.com.br',9936),
(80112,31352,16,'Alexandre Brandão','61','3202-1533','61','3202-1533','alexandre.brandao@faenge.com.br',9936),
(80113,31352,49,'Jader Crema','61','8271-1213','61','3202-1533','jader.crema@faenge.com.br',9936),
(100917,31352,20,'Jader Crema','61','8271-1213','61','3202-1533','jader.crema@faenge.com.br',9936),
(85440,31353,21,'Sr. Yusseph Tacla (Analista de Suprimentos)','31','3503-8724','','','yusseph.tacla@ferrous.com.br',11848),
(120919,31353,16,'Sr. Yusseph Tacla (Analista de Suprimentos)','31','3503-8724','','','yusseph.tacla@ferrous.com.br',11848),
(120920,31353,20,'Maísa Alves (Ass. Imprensa)','31','99824-6781','31','3503-8724','maisa.alves@ferrous.com.br',11848),
(110823,31354,20,'Maísa Alves (Ass. Imprensa)','31','3503-8724','','','maisa.alves@ferrous.com.br',11848),
(120917,31354,21,'Sr. Yusseph Tacla (Analista de Suprimentos)','31','99824-6781','31','3515-8953','yusseph.tacla@ferrous.com.br',11848),
(120918,31354,16,'Sr. Yusseph Tacla (Analista de Suprimentos)','31','99824-6781','31','3515-8953','yusseph.tacla@ferrous.com.br',11848),
(110824,31355,20,'Fernando Tiradentes (Suprimentos)','31','3503-8724','','','fernando.tiradentes@ferrous.com.br',11848),
(148414,31355,121,'Cristiano Monteiro Parreiras','31','3515-8956','','','cristiano.parreiras@ferrous.com.br',11848),
(80116,31356,16,'Ronaldo Sampaio','79','3304-3030','79','3304-3035','ronaldo@ffb.com.br',8630),
(80117,31356,49,'Rodrigo Barreto','71','3342-7400','71','3342-7400','rodrigo@ffb.com.br',15070),
(80118,31356,20,'Ronaldo Sampaio','79','3304-3030','79','3304-3035','ronaldo@ffb.com.br',8630),
(80119,31357,16,'Ronaldo Sampaio','79','3304-3030','79','3304-3035','ronaldo@ffb.com.br',8630),
(80120,31357,49,'Saulo Barbosa','71','3014-3391','71','3342-7400','saulo@ffb.com.br',15070),
(80121,31357,20,'Antônio (Almoxarifado Obra)','79','3304-3030','79','3304-3035','',8630),
(80122,31358,16,'Ronaldo Sampaio','79','3304-3030','79','3304-3035','ronaldo@ffb.com.br',8630),
(80123,31358,49,'Ana Raquel','79','3231-6113','79','3304-3030','gardenville@ffb.com.br',8630),
(80124,31358,20,'Engª Ana Raquel','79','3231-6113','79','3304-3030','gardenville@ffb.com.br',8630),
(80127,31359,16,'Rodolfo Araújo','71','3353-7075','71','3353-7075','rodolfo@souzanetto.com.br',13842),
(80128,31359,49,'Rodolfo Araújo','71','3353-7075','71','3353-7075','rodolfo@souzanetto.com.br',13842),
(80129,31359,20,'Rodolfo Araújo','71','3353-7075','71','3353-7075','rodolfo@souzanetto.com.br',13842),
(80130,31360,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(80131,31360,20,'Consuelo Miranda (Compras)','17','3321-0777','17','3321-0777','consuelo.miranda@hmengenharia.com.br',7816),
(80132,31360,29,'Marcos Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(80133,31361,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(80134,31361,20,'Consuelo Miranda (Compras)','17','3321-0777','17','3321-0777','consuelo.miranda@hmengenharia.com.br',14421),
(80135,31361,29,'Marcos Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(80136,31362,16,'Dejair Ferreira','17','3321-0777','17','3321-0777','dejair.ferreira@hmengenharia.com.br',7816),
(80137,31362,20,'Consuelo Miranda (Compras)','17','3321-0777','17','3321-0777','consuelo.miranda@hmengenharia.com.br',14421),
(80138,31362,29,'Marcos Feliciani','19','3234-1828','19','3234-1828','marcos.feliciani@hmengenharia.com.br',14421),
(99742,31362,49,'Rodrigo Rezende','17','3321-0777','17','3321-0777','',7816),
(80144,31363,16,'Valter Pinho','11','2144-5700','11','2144-5704','fornecedor@tduarte.com.br',11842),
(80145,31363,49,'Alessandro','11','2144-5700','11','2144-5704','fornecedor@tduarte.com.br',11842),
(80146,31363,20,'Silene Silva (Adm.)','11','2144-5700','11','2144-5704','svirginia@tduarte.com.br',11842),
(80147,31364,20,'Alice Pontes (Secretária Diretoria)','21','3970-1294','21','3970-1294','alice.pontes@setal.com.br',13823),
(80148,31364,8,'Alberto Padila','11','5525-4703','11','5525-4701','apadila@setal.com.br',3870),
(80149,31364,21,'Eduardo Nunes (Diretor Geral)','21','3970-1294','21','3970-1294','',13823),
(80150,31365,21,'Carlos Michelleto (Dir. Projetos)','11','3062-9730','11','3062-9730','cmichelleto@br.gestamp.com',15073),
(86227,31365,16,'Ana Claudia','12','3903-1183','12','3903-1183','compras1@prazzoengenharia.com.br',10867),
(86228,31365,49,'Benedito Santos','12','3903-1183','12','3903-1183','',10867),
(85359,31367,45,'Mr. Hong (Encarreago da Obra)','19','3412-2820','','','',15428),
(80152,31368,20,'Antônio Resende (Diretor de Obras)','17','3321-1309','17','3321-1309','acr_engenharia@ig.com.br',7815),
(80153,31369,16,'Jorge Tadeu','21','3325-0005','21','3325-0005','compras@riosengenharia.com.br',2500),
(80154,31369,49,'Renato Brasil','21','8201-2951','21','3325-0005','renato@riosengenharia.com.br',2500),
(80155,31369,20,'Renato Brasil','21','8201-2951','21','3325-0005','renato@riosengenharia.com.br',2500),
(80156,31370,16,'Jorge Tadeu','21','3325-0005','21','3325-0005','compras@riosengenharia.com.br',2500),
(80157,31370,49,'Renato Brasil','21','8201-2951','21','3325-0005','renato@riosengenharia.com.br',2500),
(80158,31370,20,'Renato Brasil','21','8201-2951','21','3325-0005','renato@riosengenharia.com.br',2500),
(80159,31371,16,'Fernando Pereira','21','3433-1314','21','3433-1314','senpro40@senproengenharia.com.br',14792),
(80160,31371,49,'José Renato','21','2732-6873','21','3433-1314','joserenato@senproengenharia.com.br',14792),
(80161,31371,20,'Fábio José Correia (Administrativo)','21','2732-6873','21','3433-1314','senpro10@senproengenharia.com.br',14792),
(80162,31372,20,'Sirlei Girão (Arquitetura)','21','2176-7272','21','2176-7273','sirlei.girao@aliansce.com.br',10782),
(80163,31373,16,'Letícia Camejo','51','3061-6665','51','3061-6685','leticia@clave.com.br',4280),
(80164,31373,20,'Letícia Camejo (Compras)','51','3061-6665','51','3061-6685','leticia@clave.com.br',4280),
(80165,31373,49,'Paulo Itamar','51','3061-6665','51','3061-6685','itamartelli@gmail.com',4280),
(80166,31374,16,'Flávia Carneiro / Carlos Gonçalves','51','3268-2495','51','3737-1689','phd@cpovo.net,carlosphd@terra.com.br',15946),
(80167,31374,49,'Carlos Gonçalves','51','3268-2495','51','3737-1689','carlosphd@terra.com.br',15946),
(80168,31374,20,'Flávia Carneiro','51','3268-2495','51','3737-1689','phd@cpovo.net',15946),
(80170,31375,16,'Paulo Campos','11','3175-1000','11','3176-1270','paulo.campos@pdg.com.br',316),
(80171,31375,20,'Alexandra (Atendimento)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80172,31375,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80173,31376,16,'Paulo Campos','11','3176-1000','11','3176-1270','paulo.campos@pdg.com.br',316),
(80174,31376,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(87738,31376,20,'Alexandra (Atendimento)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80175,31377,16,'Rafael De Toni','54','3451-3314','54','3451-3314','rafael@construtoradetoni.com.br',15076),
(80176,31377,49,'Daniel de Toni','54','3451-3314','54','3451-3314','daniel@construtoradetoni.com.br',15076),
(80177,31377,20,'Augusto Bellé de Freitas','54','9926-7586','54','3451-3314','augusto@construtoradetoni.com.br',15076),
(80178,31378,16,'Engº Marcelo Zeitone','21','2493-1044','21','2493-1044','mgz@mgz.com.br',613),
(80179,31378,49,'Engº Marcelo Zeitone','21','2493-1044','21','2493-1044','mgz@mgz.com.br',613),
(80180,31378,20,'Aparecida Paranhos (Adm.)','21','2493-1044','21','2493-1044','mgz@mgz.com.br',613),
(80181,31379,16,'Engº Marcelo Zeitone','21','2493-1044','21','2493-1044','mgz@mgz.com.br',613),
(80182,31379,49,'Engº Marcelo Zeitone','21','2493-1044','21','2493-1044','mgz@mgz.com.br',613),
(80183,31379,20,'Aparecida Paranhos (Adm)','21','2493-1044','21','2493-1044','mgz@mgz.com.br',613),
(80184,31380,16,'Marcelo Zeitone','21','2493-1044','','','mgz@mgz.com.br',613),
(80185,31380,49,'Marcelo Zeitone','21','2493-1044','','','mgz@mgz.com.br',613),
(80186,31380,20,'Aparecida Paranhos (Administração)','21','2493-1044','','','mgz@mgz.com.br',613),
(80191,31381,16,'Eduardo Martins','21','2025-1736','','','eduardo.martins@encalso.com.br',15077),
(80192,31381,49,'Bruno Priolli','21','2025-1736','','','bruno.priolli@encalso.com.br',15077),
(80193,31381,20,'Fernanda Neves (Administrativo)','21','2025-1736','','','fernanda.neves@encalso.com.br',15077),
(80194,31382,16,'Alexandre Ferreira','48','3525-8800','48','3525-8801','compras@construtoracarlessi.com.br',9179),
(80195,31382,49,'Maurício Soares','48','3525-8800','48','3525-8801','engenharia@construtoracarlessi.com.br',9179),
(80196,31382,20,'Alexandre Ferreira','48','3525-8800','48','3525-8801','compras@construtoracarlessi.com.br',9179),
(80197,31383,16,'Alexandre Ferreira','48','3525-8800','48','3525-8801','compras@carlessi.net',9179),
(80198,31383,49,'Ângelo Burigo Neto','48','3525-8800','48','3525-8801','engenharia@carlessi.net',9179),
(80199,31383,20,'Alexandre Ferreira','48','3525-8800','48','3525-8801','compras@carlessi.net',9179),
(80200,31384,16,'João Luis / Abraão Jorge','19','3705-2222','19','3705-2222','compras@nogueiraporto.com.br',6327),
(80201,31384,20,'João Luís','19','3705-2222','19','3705-2222','compras@nogueiraporto.com.br',6327),
(80202,31384,49,'Eduardo Silva','19','3705-2222','19','3705-2222','eduardo@nogueiraporto.com.br',6327),
(80203,31385,16,'Celso André','51','3330-9433','51','3029-9433','celso@ardeckon.com.br',15078),
(80204,31385,49,'Rogério Pompermayer','51','3330-9433','51','3029-9433','rogerio@ardeckon.com.br',15078),
(80205,31385,20,'Beatriz Santos (Financeiro)','51','3330-9433','51','3029-9433','ardeckon@ardeckon.com.br',15078),
(80215,31386,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(80216,31387,20,'Renato Moreno (Fábrica)','31','9167-6244','31','2103-5499','renato.moreno@ge.com',15081),
(87706,31387,21,'Renato Moreno','31','9167-6244','31','2103-5499','renato.moreno@ge.com',15081),
(87707,31387,16,'Robson Moreira','31','3241-3877','31','3241-4417','moreira@paineira.eng.br',8690),
(87708,31387,49,'Leonardo Sérgio Ferreira','31','3241-3877','31','3241-4417','leoferreira@paineira.eng.br',8690),
(80217,31388,20,'Márcia Gomes (Relações com o Governo)','31','2103-5283 - R. 5300','','','marcia.gomes@ge.com',15081),
(80218,31389,16,'João Carlos Melo','67','2107-3535','67','2107-3551','joaocarlos@egelte.com.br',863),
(80219,31389,49,'Itamar Silva','67','2107-3535','67','2107-3551','itamar.silva@egelte.com.br',863),
(80220,31389,20,'João Carlos Melo','67','2107-3535','67','2107-3551','joaocarlos@egelte.com.br',863),
(80225,31390,16,'Luana Faria','11','3176-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(80226,31390,20,'Alexandra (Atendendimento)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80227,31390,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80228,31391,16,'Luana Faria','11','3175-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(80229,31391,20,'Juliana Barreto (Marketing)','11','3176-1000','11','3176-1000','juliana.barreto@pdg.com.br',316),
(80230,31391,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80231,31392,16,'Arq. Fernando Miranda','21','8118-6303','','','fernando.miranda1968@gmail.com',15082),
(80232,31392,49,'Arq. Fernando Miranda','21','8118-6303','','','fernando.miranda1968@gmail.com',15082),
(80233,31392,20,'Arq. Fernando Miranda','21','8118-6303','','','fernando.miranda1968@gmail.com',15082),
(80234,31393,16,'Eng. Armando Fischer','21','9217-0865','22','2644-8486','estrutural@uol.com.br',729),
(80235,31393,49,'Eng. Armando Fischer','21','9217-0865','22','2644-8486','estrutural@uol.com.br',729),
(80236,31393,20,'Neuza Moreira (Adm.)','22','2644-8486','22','2647-2151','structengenharia@uol.com.br',729),
(80237,31394,16,'Christiane Borges dos Santos','22','9904-9315','22','2760-0599','chris-borges@uol.com.br',11886),
(80238,31394,49,'Christiane Borges dos Santos','22','9904-9315','22','2760-0599','chris-borges@uol.com.br',11886),
(80239,31394,20,'Christiane Borges dos Santos','22','9904-9315','22','2760-0599','chris-borges@uol.com.br',11886),
(80240,31395,16,'Christiane Borges dos Santos','22','9904-9315','22','2760-0599','chris-borges@uol.com.br',11886),
(80241,31395,49,'Christiane Borges dos Santos','22','9904-9315','22','2760-0599','chris-borges@uol.com.br',11886),
(80242,31395,20,'Christiane Borges dos Santos','22','9904-9315','22','2760-0599','chris-borges@uol.com.br',11886),
(80243,31396,16,'Rosane Santos','21','2523-3649','21','2287-5593','nhrosa@ig.com.br',479),
(80244,31396,20,'Rosane Santos','21','2523-3649','21','2287-5593','nhrosa@ig.com.br',479),
(80245,31396,49,'Dario Antônio Chiaradia','21','2523-3649','21','2287-5593','',479),
(80246,31397,16,'Fred Lowndes','24','3383-1590','24','3383-1590','siceronefred@hotmail.com',15084),
(80247,31397,49,'Fred Lowndes','24','3383-1590','24','3383-1590','siceronefred@hotmail.com',15084),
(80248,31397,20,'Fred Lowndes','24','3383-1590','24','3383-1590','siceronefred@hotmail.com',15084),
(80249,31398,16,'José Willian','62','3278-1180','62','3278-1180','compras@metricaconstrutora.com.br',14138),
(80250,31398,20,'Luciana Corrêa (Atendimento)','62','3278-1180','62','3278-1180','vera@metricaconstrutora.com.br',14138),
(80251,31398,49,'Antônio Pires','94','3278-1180','94','3278-1180','contato@metricaconstrutora.com.br',14138),
(80252,31399,20,'Délio Barreto (Coordenador de Obras)','84','3645-7221','84','3645-5049','deliobarreto@parnamirim.rn.gov.br',15083),
(80253,31400,16,'Manoel de Mesquita','11','4502-3000','11','4502-3000','manoel.mesquita@cyrela.com.br',1),
(80254,31400,20,'Amarildo Reis (Adm. de obras)','11','5102-2268','11','4502-3000','amarildo.reis@cyrela.com.br',1),
(80255,31400,49,'Marcelo Mazza','11','5102-2268','11','4502-3001','marcelo.mazza@cyrela.com.br',1),
(93102,31401,16,'Maria Gorete','98','3311-0800','98','3311-0800','maria.roma@cyrela.com.br',16398),
(93103,31401,49,'André Doria','91','3241-1214','98','3311-0800','andre.doria@cyrela.com.br',16398),
(93104,31401,20,'Carla Pollo (Planejamento)','98','3311-0834','98','3311-0800','carla.pollo@cyrela.com.br',16398),
(80256,31402,20,'João Carlos Melo (Compras)','67','3348-3535','67','3348-3500','joaocarlos@egelte.com.br',863),
(80257,31402,49,'Itamar Silva','67','3348-3535','67','3348-3500','itamar.silva@egelte.com.br',863),
(80260,31403,20,'André Lautert (Ger. Financiamento)','51','3230-4002','51','3230-4002','andre.lautert@multilab.com.br',7646),
(80261,31403,21,'Hilton Cavedon (Diretor)','51','3230-4002','51','3230-4002','hilton@multilab.com.br',7646),
(80262,31404,20,'Marcelo Rigão (Engenharia)','92','3616-1036','92','3616-4195','mrigao@petrobras.com.br',439),
(85375,31405,49,'Cid Meira','65','3624-3835','65','3624-3835','cid@gutierrezengenharia.com.br',16054),
(85376,31405,16,'Tony Cappeleto','65','8150-0474/8452','65','3624-3835','tony@gutierrezengenharia.com.br',16054),
(93723,31405,20,'Tony Cappeleto','65','8150-0474/8452','65','3624-3835','tony@gutierrezengenharia.com.br',16054),
(80264,31406,16,'Carlos Pinheiro','31','3427-2401','31','3427-2401','carlos@betonengenharia.com.br',15085),
(80265,31406,20,'Adriano Alves de Oliveira (Financeiro)','31','3427-2401','31','3427-2401','financeiro@betonengenharia.com.br',15085),
(80266,31406,49,'Carlos Pinheiro','31','3427-2401','31','3427-2401','carlos@betonengenharia.com.br',15085),
(80267,31407,16,'Maurício Dellagüistina','48','3243-7575','48','3243-7575','mauricio@spindola.com.br',15087),
(80268,31407,49,'Maurício Dellagüistina','48','3243-7575','48','3243-7575','mauricio@spindola.com.br',15087),
(80269,31407,20,'Paulo Floriano (Vendas)','48','3262-8183','48','3243-7575','vendas@spindola.com.br',15087),
(80270,31408,16,'Ivonete Ferreira Queiroz','63','3215-1212','63','3215-1212','logos@logos.to',15086),
(80271,31408,20,'Ivonete Ferreira Queiroz','63','3215-1212','63','3215-1212','logos@logos.to',15086),
(80272,31408,49,'Eduardo César Dutra','63','3215-1212','63','3215-1212','logos@logos.to',15086),
(80274,31409,16,'Norton Cerveira Maia','21','3396-0593','21','3396-1063','nortonarquitetos@uol.com.br',983),
(80275,31409,49,'Norton Cerveira Maia','21','3396-0593','21','3396-1063','nortonarquitetos@uol.com.br',983),
(80276,31409,20,'Ivani Gomes (Adm.)','21','3396-0593','21','3396-1063','nortonarquitetos@uol.com.br',983),
(80278,31410,16,'Maria Fernanda','21','3079-9619','21','3079-9619','compras@mozak.com.br',3970),
(80279,31410,49,'Paulo Leite','21','2540-5507','21','3079-9619','paulo@mozak.com.br',3970),
(80280,31410,20,'Cleiton Soares','21','2540-5507','21','3079-9619','lexclusif@mozak.com.br',3970),
(80281,31411,16,'Michel Rabelo','37','3213-8737','37','3222-8048','atendimento@rbhconstrutora.com.br',14024),
(80282,31411,49,'Nelson Francisco Resende','37','3213-8737','37','3222-8048','nelsonresilva@yahoo.com.br',14024),
(80283,31411,20,'Michel Rabelo','37','3213-8737','37','3222-8048','atendimento@rbhconstrutora.com.br',14024),
(80287,31413,16,'josé Américo Merline','43','3328-1113','43','3328-1113','joseamerico.merline@almanary.com.br',11787),
(80288,31413,49,'Michael Rodrigues','43','3328-1113','43','3328-1113','engenharia@almanary.com.br',11787),
(80289,31413,20,'Vanessa Oliveira','43','3328-1113','43','3328-1113','almanary@almanary.com.br',11787),
(80290,31414,16,'A definir','43','3323-9000','43','3323-9000','',11787),
(80291,31414,49,'Nelson Sanches','43','3323-9000','43','3323-9000','diretoria@almanary.com.br',11787),
(80292,31414,20,'Nelson Sanches (Diretor)','43','3323-9000','43','3323-9000','diretoria@almanary.com.br',11787),
(80293,31415,16,'Paulo Campos','11','3176-1000','11','3176-1270','paulo.campos@pdg.com.br',316),
(80294,31415,20,'Cinthia (Pós-Venda)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80295,31415,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@goldfarb.com.br',316),
(80296,31416,16,'Luana Faria','11','3176-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(80297,31416,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80298,31416,20,'Alexandra (Atendimento)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80299,31417,16,'Marcos Couto','11','3176-1483','11','3176-1270','marcos.santos@pdg.com.br',316),
(80300,31417,20,'Marcos Couto','11','3176-1483','11','4003-3734','marcos.santos@pdg.com.br',316),
(80301,31417,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80302,31418,16,'Luana Faria','11','3176-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(80303,31418,20,'Alexandra (Atendimento)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80304,31418,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80305,31419,16,'Arq. Thais Martinelli','19','3673-1716','19','3673-1417','construmart-@hotmail.com',15088),
(80306,31419,49,'Eteore Martinelli','19','3673-1716','19','3673-1417','construmart-@hotmail.com',15088),
(80307,31419,20,'Arq. Thais Martinelli','19','3673-1716','19','3673-1417','construmart-@hotmail.com',15088),
(80308,31420,16,'Wilson Kaluz','42','3646-3352','42','3646-3352','cwconstrucoes@uol.com.br',15089),
(80309,31420,49,'A definir','42','3646-3352','42','3646-3352','',15089),
(80310,31420,20,'Wilson Kaluz','42','3646-3352','42','3646-3352','cwconstrucoes@uol.com.br',15089),
(80311,31421,16,'Fred Lowndes','24','3383-1590','24','3383-1590','cicerone@hotmail.com',15084),
(80312,31421,49,'Fred Lowndes','24','3383-1590','24','3383-1590','cicerone@hotmail.com',15084),
(80313,31421,20,'Fred Lowndes','24','3383-1590','24','3383-1590','cicerone@hotmail.com',15084),
(80314,31422,16,'Ivonete Ferreira Queiroz','63','3215-1212','63','3215-1212','logos@logos.to',15086),
(80315,31422,49,'Eduardo César Dutra','63','3215-1212','63','3215-1212','logos@logos.to',15086),
(80316,31422,20,'Ivonete Ferreira Queiroz','63','3215-1212','63','3215-1212','logos@logos.to',15086),
(80317,31423,16,'Letícia Menezes','31','3364-7000','31','3318-9785','suprimentos@construtorasaba.com.br',13247),
(80318,31423,49,'Roberto Alves Silva','31','3364-7000','31','3318-9785','robertoalves@construtorasaba.com.br',13247),
(80319,31423,20,'Thamires da Mata (Estagiário)','31','3398-0666','31','3364-7000','aimores@construtorasaba.com.br',13247),
(80320,31424,16,'Gustavo Auras','48','3433-1240','48','3433-1241','compras@construtoraviseu.com.br',10433),
(80321,31424,49,'Jetro Barbosa','47','3433-1240','47','3433-1241','jetro@construtoraviseu.com.br',10433),
(118174,31424,20,'Ana Paula da Rosa (Incorporação)','47','3433-1240','47','3433-1241','anapaula@construtoraviseu.com.br',10433),
(80326,31425,20,'Engº Márcio de Abreu','48','9963-1475','48','3243-3136','marcio@sulcatarinense.com.br',5386),
(80327,31425,16,'Roberth Meinert','48','3279-7100','48','3243-3136','compras@sulcatarinense.com.br',5386),
(80328,31426,16,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(94033,31426,20,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(80329,31427,20,'Guilherme Vieira (Comercial)','21','2718-9090','21','2718-9080','guilherme.vieira@stxosv.com',3262),
(80330,31427,16,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(80331,31427,21,'Dail Cardoso','21','2718-9070','21','2718-9080','dail.cardoso@stxosv.com',3262),
(80332,31428,16,'Nilton Santos','31','3263-7600','31','3263-7600','compras@construtorasomar.com.br',13650),
(80333,31428,49,'Thaís Donato','31','3263-7600','31','3263-7600','somar@construtorasomar.com.br',13650),
(80334,31428,20,'Mislene Rodrigues (Atendente)','31','3263-7600','31','3263-7600','recepcao@construtorasomar.com.br',13650),
(80335,31429,16,'Luíz Magno','79','3251-3183','79','3251-3183','suprimentos@construtoraimpacto.com.br',8844),
(80336,31429,49,'Henrique Vagner','79','3251-3183','79','3251-3183','impacto@construtoraimpacto.com.br',8844),
(80337,31429,20,'Engº Marcos Cortes','79','3251-3183','79','3251-3183','marcos@construtoraimpacto.com.br',8844),
(80338,31430,16,'Artur Jorge','21','2492-1610','21','2492-1610','casenge@casenge.com',2351),
(80339,31430,49,'Sérgio M. B. de Mello','21','2492-1610','21','2492-1610','casenge@casenge.com',2351),
(80340,31430,20,'Joana Vasconcelos (Adm)','21','2492-1610','21','2492-1610','casenge@casenge.com',2351),
(80341,31431,16,'Marco Aurélio','12','3933-4916','12','3933-4916','financeiro02@costavituzzo.com.br',15092),
(80342,31431,49,'Marco Aurélio Costa','12','3933-4916','12','3933-4916','financeiro02@costavituzzo.com.br',15092),
(80343,31431,20,'Roberta Bauman (Compras) Aux.','12','3933-4916','12','3933-4916','financeiro02@costavituzzo.com.br',15092),
(80344,31432,16,'Vânia Walter','21','2484-4688','','','rprados@construtoraprados.com.br',774),
(80345,31432,49,'Renato Fernandes Prado','21','2484-4688','','','rprados@construtoraprados.com.br',774),
(80346,31432,20,'Vânia Walter','21','2484-4688','','','rprados@construtoraprados.com.br',774),
(80347,31433,16,'Marcos Couto','11','3176-1483','11','3176-1270','marcos.santos@pdg.com.br',316),
(80348,31433,20,'Marcos Couto','11','3176-1483','11','3176-1270','marcos.santos@pdg.com.br',316),
(80349,31433,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80350,31434,16,'Paulo Campos','11','3176-1000','11','3176-1270','paulo.campos@pdg.com.br',316),
(80351,31434,20,'Cínthia (Pós-Venda)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80352,31434,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@@pdg.com.br',316),
(80353,31435,20,'Ricardo Pereira (Licitação)','11','3146-7059','11','3146-7097','licitaobras@sesisenaisp.org.br',9093),
(80360,31436,16,'Mário Márcio','31','3505-3000','31','3505-3024','mario@epo.com.br',11584),
(80361,31436,20,'Alaérson José','31','8396-7727','31','3505-3000','alaerson@epo.com.br',11584),
(80362,31436,49,'Alaérson José','31','8396-7727','31','3505-3000','alaerson@epo.com.br',11584),
(80363,31437,16,'Mário Márcio','31','3505-3000','31','3505-3024','mario@epo.com.br',11584),
(80364,31437,49,'Alaérson José','31','8396-7727','31','3505-3000','alaerson@epo.com.br',11584),
(80365,31437,20,'Alaérson José','31','8396-7727','31','3505-3000','alaerson@epo.com.br',11584),
(80366,31438,16,'Wendel Marques','31','3505-3000','31','3505-3024','wendel@epo.com.br',11584),
(80367,31438,49,'Clovis Ladeira','31','3377-0312','31','3505-3000','clovis.ladeira@epo.com.br',11584),
(109021,31438,20,'Clovis Ladeira','31','3377-0312','31','3505-3000','clovis.ladeira@epo.com.br',11584),
(80368,31439,20,'Alex Sander Ribeiro','34','3691-7000 - R. 7053','34','3691-3675','meioambiente@ipdsa.org.br',6016),
(80369,31439,21,'Alex Sander Ribeiro','34','3691-7000 - R. 7053','34','3691-3675','meioambiente@ipdsa.org.br',6016),
(80371,31440,16,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(94032,31440,20,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(80372,31441,16,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(94034,31441,20,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(80373,31442,20,'Esteban Gdikian','11','2162-7788 R: 7733','11','3468-7733','esteban.gdikian@mcassab.com.br',7958),
(91148,31442,49,'Wilson Leir Teslenco','67','3028-4567','67','3028-4559','teslenco.arq@htomail.com',15594),
(91149,31442,16,'Nilson Pereira','67','3028-4567','67','3028-4559','compras@teslenco.com.br',15594),
(80374,31443,16,'Josiane Stroschoen','51','3018-1700','51','3018-1700','josiane@rottaely.com.br',13035),
(80375,31443,20,'Martina Morsch (Marketing)','51','3018-1700','51','3018-1700','martina@rottaely.com.br',13035),
(80376,31443,49,'Diego Gomes','51','3018-1700','51','3018-1700','diego@rottaely.com.br',13035),
(80377,31444,16,'Josiane Stroschoen','51','3018-1700','51','3018-1700','josiane@rottaely.com.br',13035),
(80378,31444,20,'Martina Morsch (Marketing)','51','3018-1700','51','3018-1700','martina@rottaely.com.br',13035),
(80379,31444,49,'Leandro Pacheco','51','3018-1700','51','3018-1700','leandro@rottaely.com.br',13035),
(80380,31445,16,'Luana Faria','11','3176-1000','11','3176-1270','luana.faria@pdg.com.br',316),
(80381,31445,20,'Juliana Barreto (Marketing)','11','3176-1000','11','3176-1000','juliana.barreto@pdg.com.br',316),
(80382,31445,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80383,31446,16,'Marcos Couto','11','3176-1483','11','3176-1270','marcos.santos@pdg.com.br',316),
(80384,31446,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(87933,31446,20,'Marcos Couto','11','3176-1483','11','3176-1270','marcos.santos@pdg.com.br',316),
(80385,31447,16,'Paulo Campos','11','3176-1000','11','3176-1270','paulo.campos@pdg.com.br',316),
(80386,31447,20,'Janaina (Relacionamento)','11','4003-3734','11','3176-1270','relacionamento@pdg.com.br',316),
(80387,31447,29,'Fernando Pozetti','11','3176-1000','11','3176-1270','fernando.pozetti@pdg.com.br',316),
(80388,31448,16,'Carla Lima','16','3236-1331','16','3236-1331','carla.lima@goldfarb.com.br',13177),
(80389,31448,49,'Paulo Silva','16','3236-1331','16','3236-1331','paulo.silva@goldfarb.com.br',13177),
(80390,31448,20,'Giovana Oliveira (Marketing)','16','3236-1331','16','3236-1331','giovana.oliveira@avanceimovel.com.br',13177),
(80391,31449,16,'Marcos Henrique','62','3267-1316','62','3267-1300','marcos@gplincorporadora',7747),
(80392,31449,49,'Fernando Valadares','62','3267-1316','62','3267-1300','fernando@gplincorporadora.com.br',7747),
(80393,31449,20,'Daniel (Engenharia)','62','3267-1316','62','3267-1300','daniel@gplincorporadora.com.br',7747),
(80396,31450,16,'Letícia Menezes','31','3364-7000','31','3318-9985','suprimentos@construtorasaba.com.br',13247),
(80397,31450,20,'José Carlos','31','3364-7000','31','3318-9985','contratos@construtorasaba.com.br',13247),
(80398,31450,49,'Roberto Alves','31','3364-7000','31','3318-9985','robertoalves@construtorasaba.com.br',13247),
(80399,31451,16,'Letícia Menezes','31','3364-7000','31','3368-9785','suprimentos@construtorasaba.com.br',13247),
(80400,31451,20,'Nayara Mansur (Estagiário)','31','3398-1351','31','3368-9785','edificiocoimbra@construtorasaba.com.br',13247),
(80401,31451,49,'Roberto Alves','31','3364-7000','31','3368-9785','robertoalves@construtorasaba.com.br',13247),
(80405,31452,20,'Engº Gustavo Macedo','41','3641-1079','41','3643-1084','gung@novozymes.com',15097),
(80406,31453,20,'Arq. Renato Dal Pian','11','3822-1218','11','3822-5186','dalpian@dalpian.arq.br',12616),
(80407,31454,16,'Ludimila Amaral','44','3253-6324','44','3246-5279','administrativo@crengenharia.com.br',15274),
(82459,31454,49,'Artur Tunes Silva','44','9986-6730','44','3267-6778','artur@crengenharia.com.br',15274),
(82464,31454,20,'Artur Tunes Silva','44','9986-6730','44','3267-6778','artur@crengenharia.com.br',15274),
(80408,31455,20,'Antônio Pegoraro (Licitação)','41','3221-6117','41','3323-2018','seop@pr.gov.br',4155),
(80409,31456,20,'Antônio Pegoraro (Licitação)','41','3221-6117','41','3323-2018','seop@pr.gov.br',4155),
(80410,31457,20,'Marcos Zampol (Gerente de Compras)','11','4344-9247','11','4344-9199','marcos.zampol@scania.com',9556),
(80415,31458,20,'Guilherme Vieira (Comercial)','21','2718-9090','21','2718-9080','guilherme.vieira@stxosv.com',3262),
(80416,31458,16,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxosv.com',3262),
(84558,31458,21,'Dail Cardoso','21','2718-9070','21','2718-9080','dail.cardoso@stxosv.com',3262),
(80417,31459,20,'Guilherme Vieira (Comercial)','21','2718-9090','21','2718-9080','guilherme.vieira@stxeurope.com',3262),
(80418,31459,16,'Renivaldo Granja','21','2718-9090','21','2718-9080','renivaldo.granja@stxeurope.com',3262),
(80419,31460,20,'Leonardo Lins Albuquerque (Dir. de Planej. e Exp)','21','2514-4835','21','2514-5166','leonardo.lins@eletrobras.com',15098),
(80420,31461,16,'Eugênio Gandes','31','3281-0203','31','3281-0220','eugenio.sande@construtoravesper.com.br',9646),
(80421,31461,49,'Gêner Sabino','31','3281-0203','31','3281-0220','gener.sabino@construtora.com.br',9646),
(80422,31461,20,'Gleiciane Evangelista','31','3476-6057','31','3281-0203','tecnico@construtoravesper.com.br',9646),
(80423,31462,16,'Eugênio Sandes','31','3281-0203','31','3281-0220','eugenio.sandes@construtoravesper.com.br',9646),
(80424,31462,20,'Eugênio Sandes (Compras)','31','3281-0203','31','3281-0220','eugenio.sandes@construtoravesper.com.br',9646),
(88763,31462,49,'Andrei Cardoso','31','3496-9473','31','3281-0203','andrei.cardoso@construtoravesper.com.br',9646),
(80425,31463,16,'Eugênio Sandes','31','3281-0203','31','3281-0203','eugenio.sandes@construtoravesper.com.br',9646),
(80426,31463,49,'Eng. Flávio Freitas','31','3377-0379','31','3281-0203','flavio.freitas@construtoravesper.com.br',9646),
(80427,31463,20,'Artur Oliveira (Almoxarife)','31','3377-0379','31','3281-0203','artur.oliveira@construtoravesper.com.br',9646),
(80428,31464,16,'Rafael Lupges','45','3225-8182','45','3225-8182','compras@saraivaderezende.com.br',12022),
(80429,31464,49,'Jadir Saraiva de Rezende','45','3225-8182','45','3225-8182','jadir1000@hotmail.com',12022),
(80430,31464,20,'Edna Sankauser (Projetos)','45','3225-8182 R:5','45','3225-8182','projetosaraivarezende@gmail.com',12022),
(80431,31465,16,'Rafael Lupges','45','3225-8182','45','3225-8182','compras@saraivaderezende.com.br',12022),
(80432,31465,49,'Jadir Saraiva de Rezende','45','3225-8182','45','3225-8182','jadir1000@hotmail.com',12022),
(80433,31465,20,'Edna Sankauser (Projetos)','45','3225-8182','45','3225-8182','projetossaraivaderezende@gmail.com',12022),
(80442,31466,16,'Kátia','85','3066-7777','85','3066-7777','compras@diasdesousa.com.br',15099),
(80443,31466,49,'Adelino / Regis','85','3066-7777','85','3066-7777','adelino@diassousa.com.br',15099),
(80444,31466,20,'Antonio Jacleilson','85','3046-3860','85','3066-7777','almoxarife.terrasse@diasdesousa.com.br',15099),
(80445,31467,16,'Kátia','85','3066-7777','85','3066-7777','compras@diasdesousa.com.br',15099),
(80446,31467,49,'Romildo Coelho','85','3241-1300','85','8749-0041/9928-9451','romildo@diasdesousa.com.br',15099),
(80447,31467,20,'Romildo Coelho','85','3241-1300','85','8749-0041/9928-9451','romildo@diasdesousa.com.br',15099),
(80448,31468,16,'Amanda Rotta','19','3176-1111','19','3176-1111','amanda.rotta@pdg.com.br',10897),
(80449,31468,20,'Ivonete (Relacionamento)','19','4003-3734','19','3176-1111','vendas@pdg.com.br',10897),
(80450,31468,21,'Levy Monteiro','19','3176-1111','19','3176-1111','levy.monteiro@pdg.com.br',10897),
(80451,31469,16,'Amanda Rotta','11','3176-1111','11','3176-1111','amanda.rotta@pdg.com.br',10897),
(80452,31469,20,'Cíntia (Pós-Vendas)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80453,31469,21,'Levy Monteiro','11','3176-1111','11','3176-1111','levy.monteiro@pdg.com.br',10897),
(80454,31470,16,'Amanda Rotta','19','3176-1111','19','3176-1111','amanda.rotta@pdg.com.br',10897),
(80455,31470,20,'Cíntia (Pós-Venda)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80456,31470,21,'Levy Monteiro','19','3176-1111','19','3176-1111','levy.monteiro@pdg.com.br',10897),
(80457,31471,20,'Cíntia (Pós-Venda)','11','4003-3734','11','4003-3734','relacionamento@pdg.com.br',316),
(80458,31471,21,'Levy Monteiro','19','3176-1111','19','3176-1111','levy.monteiro@pdg.com.br',10897),
(98565,31471,16,'Amanda Rotta','19','3176-1111','19','3176-1111','amanda.rotta@pdg.com.br',10897),
(80459,31472,16,'Amanda Rotta','19','3176-1111','19','3176-1111','amanda.rotta@pdg.com.br',10897),
(80460,31472,20,'Amanda Rotta','11','4003-3734','11','4003-3734','amanda.rotta@pdg.com.br',316),
(80461,31472,21,'Levy Monteiro','19','3176-1111','19','3176-1111','levy.monteiro@pdg.com.br',10897),
(80466,31473,20,'Fágner Viana','31','3075-8324','31','3075-8324','compras@talentconstrutora.com.br',13940),
(80467,31473,49,'Marlus Washington','31','8332-7054','31','3075-8324','marlus@talentconstrutora.com.br',13940),
(125417,31473,16,'Fágner Viana','31','3075-8324','31','3075-8324','compras@talentconstrutora.com.br',13940),
(80468,31474,16,'Mauro Barros','11','3081-4533','11','3083-6019','suprimentos@stcsa.com.br',817),
(80469,31474,21,'Felipe Tadeu Toledo (Coord. Obras)','11','3081-4533','11','3083-6019','stc@stcsa.com.br',817),
(80470,31474,20,'Danilo de Aguiar Garciz','11','3081-4533','11','3083-6019','danilo@stcsa.com.br',817),
(103785,31474,49,'Danilo de Aguiar Garciz','11','3081-4533','11','3083-6019','danilo@stcsa.com.br',817),
(80471,31475,16,'Marcos Henrique','62','3267-1316','62','3267-1316','marcos@gplincorporadora.com.br',7747),
(80472,31475,20,'Roberto Messias (Adm. de Obra)','62','3267-1316','62','3267-1316','roberto.messias@gplincorporadora.com.br',7747),
(80473,31475,49,'André Jânio','62','3920-0050','62','3267-1316','andre@gplincorporadora.com.br',7747),
(80474,31476,16,'Daniel Sobral','11','5081-7811','11','5081-7811','daniel@uniaoeng.com.br',788),
(80475,31476,20,'Tomoda (Adm.)','11','2634-3329','11','5081-7811','tomoda@uniaoeng.com.br',788),
(80476,31476,49,'Osmar Yoshuo','11','5081-7811','11','5081-7811','osmar@uniaoeng.com.br',788),
(85734,31477,20,'Danilo Nyitray (Engenharia)','11','4366-1001','11','4368-4897','danilo.nyitray@bombril.com.br',11313),
(122514,31477,21,'Christian McMullin (Ger. Melhoria Contínua)','11','4366-1001','11','4368-4897','christian.mcmullin@bombril.com.br',11313),
(122515,31477,21,'Valdemar Michalani (Ger. Engenharia)','11','4366-1001','11','4368-4897','valdemar.michalani@bombril.com.br',11313),
(85326,31478,20,'Marcos Shimojo (Coordenador)','11','3523-0800','35','3214-9117','marcos.shimojo@dexcom.com.br',15557),
(80483,31479,21,'Vanderlei Braun','43','9961-6754','','','cooperativa.copran@bol.com.br',15104),
(85178,31479,20,'Vanderlei Braun','43','9961-6754','','','cooperativa.copran@bol.com.br',15104),
(80486,31480,16,'Marcela Ferreira','81','3312-6464','81','3312-6464','marcelasilva@renel.com.br',13935),
(80487,31480,49,'Luis Orácio','81','3312-6464','81','3312-6464','renel@renel.com.br',13935),
(80488,31480,20,'Cícero Carlos (Almoxarifado)','81','3034-6284','81','3312-6464','',13935),
(80489,31481,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(80490,31481,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(80491,31481,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(80492,31482,16,'Ana Cristina Santos','19','3795-4777','19','3795-4777','ana.santos@goldfarb.com.br',10897),
(80493,31482,20,'Mariana Mazarella (Relacionamento)','19','3795-4777','19','3795-4777','mariana.mazarella@goldfarb.com.br',10897),
(80494,31482,21,'Levy Monteiro','19','3795-4777','19','3795-4777','levy.monteiro@goldfarb.com.br',10897),
(80509,31488,16,'Cristiane Souza','85','4012-1255','85','3241-5447','cristiane@idibra.com.br',15108),
(80510,31488,49,'Cristiano Barcelo','85','4012-1255','85','3241-5447','cristiano.barcelo@idibra.com.br',15108),
(80511,31488,20,'Giovana Garcia','85','4005-5522','85','3241-5447','giovana.garcia@idibra.com.br',15108),
(80519,31493,20,'Henrique Camello (Superintendente)','81','3727-5000','81','3727-5000','henriquecamello@polocaruaru.com',15107),
(80523,31495,20,'Monaliza Demenighi (RH)','51','3457-6000','','','monalizademenighi@guimar.com.br',11092),
(80524,31496,20,'Gilson Piovezan (Engº e Diretor Geral)','55','3028-6996','55','3028-6996','gilson@gr2residuos.com.br',15110),
(80525,31496,21,'Gilson Piovezan','55','3028-6996','55','3028-6996','gilson@gr2residuos.com.br',15110),
(80550,31504,49,'Júlio César','85','3251-1414','85','3272-7055','acopi@acopi.com.br',15114),
(80551,31504,16,'Layon Thiago','85','3251-1414','85','3272-7055','acopi@acopi.com.br',15114),
(92706,31504,20,'Layon Thiago','85','3251-1414','85','3272-7055','acopi@acopi.com.br',15114),
(80552,31505,16,'Luis Camilo','21','3325-4408','21','3325-4408','j.psantos@ig.com.br',15113),
(80553,31505,49,'Luis Camilo','21','3325-4408','21','3325-4408','j.psantos@ig.com.br',15113),
(80554,31505,20,'Jaqueline Rival (Adm.)','21','3325-4408','21','3325-4408','administrativo@granrioengenharia.com.br',15113),
(80562,31507,20,'Luiz Loberdan (Superintendente Institucional)','11','5576-0888','11','5576-0884','loberdan@aacd.org.br',14774),
(89115,31511,123,'Hugo Passos','47','3326-8977','47','3322-1314','hugo@hsarquitetos.com.br',15118),
(110255,31511,16,'Gustavo Andrade','86','8148-2871','86','8156-9790','gsnunes@gposolvi.com.br',18253),
(110256,31511,49,'Gustavo Andrade','86','8148-2871','86','8156-9790','gsnunes@gposolvi.com.br',18253),
(110257,31511,67,'Gustavo Andrade (Ger. Contratos)','86','8148-2871','86','8156-9790','gsnunes@gposolvi.com.br',18253),
(110258,31511,20,'Hugo Passos','47','9173-0790','47','3326-8977','hugo@hsarquitetos.com.br',15118),
(80571,31513,20,'Elaine Viana da Rosa','48','3877-7100 R:7151','','','elaine.rosa@statkraft.com',12738)

;

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

VALUES

(31328,'CO204763'),
(31329,'CO204762'),
(31330,'RE024099'),
(31331,'CO204761'),
(31332,'CO204765'),
(31339,'CO204769'),
(31340,'CO204771'),
(31341,'IN001573'),
(31342,'IN001572'),
(31343,'CO204770'),
(31344,'CO204772'),
(31345,'IN001571'),
(31346,'RE024110'),
(31348,'IN001570'),
(31349,'RE024100'),
(31350,'IN001569'),
(31351,'IN001566'),
(31352,'RE024109'),
(31353,'IN001568'),
(31354,'RE024108'),
(31355,'CO204773'),
(31356,'IN001574'),
(31357,'RE024107'),
(31358,'RE024115'),
(31359,'IN001575'),
(31360,'RE024106'),
(31361,'CO204774'),
(31362,'CO204774'),
(31363,'RE024116'),
(31364,'RE024104'),
(31365,'RE024111'),
(31366,'RE024103'),
(31367,'RE024102'),
(31368,'IN001567'),
(31369,'RE022721'),
(31370,'CO204772'),
(31371,'RE024100'),
(31372,'RE024112'),
(31373,'RE024113'),
(31374,'RE024114'),
(31375,'CO204776'),
(31376,'CO204775'),
(31377,'RE024119'),
(31378,'RE024120'),
(31379,'CO204777'),
(31380,'CO204778'),
(31381,'CO204779'),
(31382,'RE024128'),
(31383,'RE022733'),
(31384,'RE024129'),
(31385,'IN001579'),
(31386,'RE024130'),
(31387,'RE024121'),
(31388,'IN001578'),
(31389,'RE024118'),
(31390,'RE024122'),
(31391,'IN001577'),
(31392,'RE024117'),
(31393,'RE024123'),
(31394,'IN001576'),
(31395,'RE024124'),
(31396,'RE024126'),
(31397,'RE024125'),
(31398,'RE024127'),
(31399,'RE024147'),
(31400,'CO204781'),
(31401,'RE024141'),
(31402,'CO204780'),
(31403,'RE024142'),
(31404,'CO204782'),
(31405,'RE024140'),
(31406,'RE024143'),
(31407,'RE024131'),
(31408,'RE024139'),
(31409,'RE024144'),
(31410,'RE024138'),
(31411,'RE024132'),
(31413,'CO204790'),
(31414,'RE024152'),
(31415,'RE024133'),
(31416,'RE024135'),
(31417,'RE024151'),
(31418,'CO204783'),
(31419,'RE024134'),
(31420,'RE024150'),
(31421,'RE024149'),
(31422,'RE024146'),
(31423,'RE024135'),
(31424,'IN001580'),
(31425,'RE024136'),
(31426,'CO204786'),
(31427,'CO204785'),
(31428,'CO204787'),
(31429,'RE024153'),
(31430,'CO204788'),
(31431,'RE024154'),
(31432,'RE024155'),
(31433,'CO204789'),
(31434,'RE024156'),
(31435,'CO204784'),
(31436,'RE024148'),
(31437,'CO204803'),
(31438,'CO204804'),
(31439,'CO204798'),
(31440,'CO204805'),
(31441,'CO204802'),
(31442,'RE024173'),
(31443,'CO204806'),
(31444,'CO204801'),
(31445,'IN001581'),
(31446,'RE024172'),
(31447,'RE024168'),
(31448,'CO204799'),
(31449,'IN001582'),
(31450,'CO204807'),
(31451,'RE024167'),
(31452,'RE024171'),
(31453,'CO204800'),
(31454,'IN001583'),
(31455,'RE024166'),
(31456,'IN001584'),
(31457,'RE024165'),
(31458,'RE024169'),
(31459,'CO204791'),
(31460,'IN001585'),
(31461,'RE024164'),
(31462,'IN001586'),
(31463,'RE024170'),
(31464,'RE024163'),
(31465,'CO204797'),
(31466,'RE024174'),
(31467,'RE024175'),
(31468,'RE024162'),
(31469,'RE024160'),
(31470,'CO204808'),
(31471,'RE024176'),
(31472,'RE024161'),
(31473,'CO204809'),
(31474,'CO204796'),
(31475,'RE024177'),
(31476,'RE024158'),
(31477,'RE024159'),
(31478,'RE024157'),
(31479,'CO204792'),
(31480,'CO204793'),
(31481,'CO204794'),
(31482,'CO204795'),
(31488,'RE024197'),
(31493,'RE024203'),
(31495,'RE024203'),
(31496,'CO204822'),
(31504,'RE024204'),
(31505,'CO204819'),
(31507,'RE024183'),
(31511,'IN001590'),
(31513,'RE024186')

;

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