execute("CREATE TABLE manutencao.vinculo_corretores_comerciais_rollback AS SELECT * FROM sistema.corretores_comercial "); $this->execute("CREATE TABLE manutencao.vinculo_corretores_comerciais ( id_corretor INTEGER, id_comercial_1 INTEGER, id_comercial_2 INTEGER, id_comercial_3 INTEGER, id_comercial_4 INTEGER, id_comercial_5 INTEGER, id_comercial_6 INTEGER, id_comercial_7 INTEGER ) WITH ( OIDS=FALSE ) "); $table = $this->table('manutencao.vinculo_corretores_comerciais'); $rows = [ ['id_corretor' => 2371, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3454, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3388, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3100, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2639, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2678, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3289, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 1438, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3016, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3391, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2809, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4337, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4337, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3964, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3097, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 4011, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3851, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3170, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 333, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3532, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3963, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3745, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 336, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3503, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3266, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 328, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 338, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3393, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3443, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2519, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 340, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3886, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3455, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3875, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3172, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4118, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4118, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 1987, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3280, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2740, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2960, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2643, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3229, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 2832, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3069, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 1686, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3649, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4207, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4207, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4207, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3103, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2816, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3274, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 346, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3390, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3426, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3480, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2899, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3500, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3766, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 2607, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3287, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4214, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3974, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3974, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3392, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4205, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2778, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3788, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 368, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3382, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2532, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2605, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3085, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3174, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2932, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3167, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3965, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3965, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3457, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3746, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3406, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3572, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3263, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 373, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3075, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2776, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4140, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4140, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3081, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3297, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 374, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2810, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3137, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 361, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 1621, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3897, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 1779, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 1284, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4332, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4332, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2334, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3961, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2399, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2880, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4060, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3786, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2127, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3305, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4064, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 4064, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3458, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3126, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2977, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2630, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3416, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3553, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 385, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3498, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2818, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3243, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4199, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4199, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 388, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3403, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3995, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3178, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3844, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 2640, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3228, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3068, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2291, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3763, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2520, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3421, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3861, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3635, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3952, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3952, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3952, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 395, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3662, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 1448, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3340, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2337, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2753, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3205, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3288, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 390, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2128, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2243, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3027, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 398, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3849, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 405, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3333, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4307, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4307, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3879, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3098, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3762, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 2582, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2837, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3769, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 1309, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 403, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2785, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2130, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3671, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2943, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3798, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3089, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3000, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3469, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3282, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 415, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 417, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3130, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4314, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3675, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2076, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 419, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3545, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3418, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 389, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 424, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2359, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3001, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 427, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3226, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3494, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4194, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 426, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4216, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4318, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2770, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 437, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3423, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3493, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2786, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3749, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 431, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4088, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4088, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4088, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3562, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 432, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 1776, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 441, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2292, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 1307, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3048, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 1396, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 436, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4095, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3283, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3522, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3950, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4359, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4258, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4258, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2536, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2838, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3684, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 379, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2608, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3862, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2780, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2471, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3953, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 446, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3951, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 2500, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 1795, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4099, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 447, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3456, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4212, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4212, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3087, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 453, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2149, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2350, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3850, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3146, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3299, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 449, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 1337, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3548, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3336, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 457, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 458, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 1877, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3191, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2354, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 464, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2514, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3854, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3227, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3315, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2703, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3366, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4075, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2499, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3559, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2247, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3470, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4089, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4089, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4287, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4287, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3481, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2779, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 2401, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3636, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3032, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4062, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2180, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2308, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3362, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3759, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3389, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2028, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4045, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 4045, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 1986, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2356, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2502, 'id_comercial_1' => 3708, 'id_comercial_2' => 3785, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 4240, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3173, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2482, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2756, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2692, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 478, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 468, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3207, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2808, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3321, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2521, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2467, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3831, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3244, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4331, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 470, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4343, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 471, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3554, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3760, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 480, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3092, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 482, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2316, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2798, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 484, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 4313, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3273, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3496, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3563, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 1331, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3499, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 1748, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 489, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 490, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2944, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2784, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3128, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3129, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3090, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2333, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2679, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 2727, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 327, 'id_comercial_1' => 1036, 'id_comercial_2' => 3667, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 496, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4311, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3176, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3108, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3028, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 4306, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 2544, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3017, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3338, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3856, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 4293, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3335, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 498, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3395, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3235, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2043, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 3547, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 3642, 'id_comercial_1' => 3785, 'id_comercial_2' => 3708, 'id_comercial_3' => 1548, 'id_comercial_4' => 1063, 'id_comercial_5' => 1036, 'id_comercial_6' => 3667, 'id_comercial_7' => 1037], ['id_corretor' => 3291, 'id_comercial_1' => 1063, 'id_comercial_2' => 1548, 'id_comercial_3' => 3785, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3708, 'id_comercial_7' => 1037], ['id_corretor' => 3487, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785], ['id_corretor' => 2681, 'id_comercial_1' => 1548, 'id_comercial_2' => 1063, 'id_comercial_3' => 3708, 'id_comercial_4' => 3667, 'id_comercial_5' => 1036, 'id_comercial_6' => 3785, 'id_comercial_7' => 1037], ['id_corretor' => 501, 'id_comercial_1' => 3667, 'id_comercial_2' => 1036, 'id_comercial_3' => 1037, 'id_comercial_4' => 1063, 'id_comercial_5' => 1548, 'id_comercial_6' => 3708, 'id_comercial_7' => 3785] ]; $table->insert($rows) ->save(); $this->execute("CREATE OR REPLACE FUNCTION manutencao.vinculo_corretores_comerciais() RETURNS VOID AS $$ DECLARE stSQL VARCHAR; reRecord RECORD; dtCriacao TIMESTAMP; idCorretor INTEGER; BEGIN stSQL := ' SELECT * FROM manutencao.vinculo_corretores_comerciais ; '; FOR reRecord IN EXECUTE stSQL LOOP SELECT corretores.id INTO idCorretor FROM sistema.corretores WHERE corretores.id_usuario = reRecord.id_corretor ; PERFORM 1 FROM sistema.corretores_comercial WHERE id_corretor = idCorretor ; IF FOUND THEN SELECT MIN(dt_criacao) INTO dtCriacao FROM sistema.corretores_comercial WHERE id_corretor = idCorretor ; DELETE FROM sistema.corretores_comercial WHERE id_corretor = idCorretor ; INSERT INTO sistema.corretores_comercial ( id_usuario_criacao , dt_criacao , id_corretor , id_comercial ) VALUES ( 2068 , dtCriacao , idCorretor , reRecord.id_comercial_1 ); INSERT INTO sistema.corretores_comercial ( id_usuario_criacao , dt_criacao , id_corretor , id_comercial ) VALUES ( 2068 , NOW() + ('1 minutes') , idCorretor , reRecord.id_comercial_2 ); INSERT INTO sistema.corretores_comercial ( id_usuario_criacao , dt_criacao , id_corretor , id_comercial ) VALUES ( 2068 , NOW() + ('2 minutes') , idCorretor , reRecord.id_comercial_3 ); INSERT INTO sistema.corretores_comercial ( id_usuario_criacao , dt_criacao , id_corretor , id_comercial ) VALUES ( 2068 , NOW() + ('3 minutes') , idCorretor , reRecord.id_comercial_4 ); INSERT INTO sistema.corretores_comercial ( id_usuario_criacao , dt_criacao , id_corretor , id_comercial ) VALUES ( 2068 , NOW() + ('4 minutes') , idCorretor , reRecord.id_comercial_5 ); INSERT INTO sistema.corretores_comercial ( id_usuario_criacao , dt_criacao , id_corretor , id_comercial ) VALUES ( 2068 , NOW() + ('5 minutes') , idCorretor , reRecord.id_comercial_6 ); INSERT INTO sistema.corretores_comercial ( id_usuario_criacao , dt_criacao , id_corretor , id_comercial ) VALUES ( 2068 , NOW() + ('6 minutes') , idCorretor , reRecord.id_comercial_7 ); END IF; END LOOP; END; $$ LANGUAGE 'plpgsql'; "); $this->execute("SELECT manutencao.vinculo_corretores_comerciais()"); } public function down(): void { $delete = $this->getQueryBuilder(); $delete->delete('sistema.corretores_comercial') //->where(['fl_ativo' => 'TRUE']) //->orwhere(['fl_ativo' => 'FALSE']) ->execute(); $prodQuery = $this->getQueryBuilder(); $prodQuery->select(['id_usuario_criacao'// => 'col1AS' , 'dt_criacao' // => 'col2AS' , 'fl_ativo' // => 'col3AS' , 'fl_del' // => 'col4AS' , 'id_corretor' // => 'col5AS' , 'id_comercial' // => 'col6AS' ]) ->from('manutencao.vinculo_corretores_comerciais_rollback'); //->where(['cond >' => valor]); $insere = $this->getQueryBuilder(); $st = $insere ->insert(['id_usuario_criacao' , 'dt_criacao' , 'fl_ativo' , 'fl_del' , 'id_corretor' , 'id_comercial' ]) ->into('sistema.corretores_comercial') ->values($prodQuery) ->execute(); var_dump($st->lastInsertId('id_corretor', 'id_comercial')); } }