-- ======================================== -- 04-insert-hierarchy.sql -- Segunda Carga Masiva Open Insurance -- ======================================== -- IMPORTANT: CommercialStructure + AgencyLevel para agentes con parent -- CRITICAL: Usa general_agent.id (NO person.id) SET @commercial_structure_id = (SELECT COALESCE(MAX(id), 0) + 1 FROM commercial_structure); SET @agency_level_id = (SELECT COALESCE(MAX(id), 0) + 1 FROM agency_level); SET @base_agent_id = (SELECT MAX(id) - 419 FROM general_agent); SET @base_agreement_id = (SELECT MAX(id) - 419 FROM agreement); -- [2/420] Jason Wagner → parent#12048 SET @child_agent_id = @base_agent_id + 1; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 1; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [3/420] Daniel Feigenbaum → parent#12048 SET @child_agent_id = @base_agent_id + 2; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 2; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [4/420] Juan Carlos Fernandez Aleman → parent#12050 SET @child_agent_id = @base_agent_id + 3; SET @parent_agent_id = @base_agent_id + 4; SET @child_agreement_id = @base_agreement_id + 3; SET @parent_agreement_id = @base_agreement_id + 4; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [5/420] Isabel Fernandez Aleman → parent#12048 SET @child_agent_id = @base_agent_id + 4; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 4; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [6/420] La Coordinadora La Coordinadora → parent#12050 SET @child_agent_id = @base_agent_id + 5; SET @parent_agent_id = @base_agent_id + 4; SET @child_agreement_id = @base_agreement_id + 5; SET @parent_agreement_id = @base_agreement_id + 4; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [7/420] Jose Felipe Herrera Calcano → parent#12048 SET @child_agent_id = @base_agent_id + 6; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 6; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [8/420] Gonzalo Veloz → parent#12048 SET @child_agent_id = @base_agent_id + 7; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 7; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [9/420] Ricardo Salas Martinez → parent#12050 SET @child_agent_id = @base_agent_id + 8; SET @parent_agent_id = @base_agent_id + 4; SET @child_agreement_id = @base_agreement_id + 8; SET @parent_agreement_id = @base_agreement_id + 4; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [10/420] Anna Fusella → parent#12048 SET @child_agent_id = @base_agent_id + 9; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 9; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [11/420] Maria del Pilar Avendano Cisneros → parent#12048 SET @child_agent_id = @base_agent_id + 10; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 10; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [12/420] Alfredo Jose Martinez Bermudez → parent#12048 SET @child_agent_id = @base_agent_id + 11; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 11; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [13/420] Wendy Moya → parent#12048 SET @child_agent_id = @base_agent_id + 12; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 12; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [14/420] Maria Ciniglio → parent#12048 SET @child_agent_id = @base_agent_id + 13; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 13; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [15/420] Ana Teresa Fernandez Aleman → parent#12051 SET @child_agent_id = @base_agent_id + 14; SET @parent_agent_id = @base_agent_id + 5; SET @child_agreement_id = @base_agreement_id + 14; SET @parent_agreement_id = @base_agreement_id + 5; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [16/420] Ysmerai Loundior → parent#12048 SET @child_agent_id = @base_agent_id + 15; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 15; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [17/420] Raquel Munoz → parent#12048 SET @child_agent_id = @base_agent_id + 16; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 16; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [18/420] Dale Neuenschwander → parent#12048 SET @child_agent_id = @base_agent_id + 17; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 17; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [19/420] Lenny Trivino → parent#12048 SET @child_agent_id = @base_agent_id + 18; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 18; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [20/420] Luis Avila Merino → parent#12051 SET @child_agent_id = @base_agent_id + 19; SET @parent_agent_id = @base_agent_id + 5; SET @child_agreement_id = @base_agreement_id + 19; SET @parent_agreement_id = @base_agreement_id + 5; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [21/420] Guillermo Ochoa → parent#12048 SET @child_agent_id = @base_agent_id + 20; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 20; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [22/420] Paolo Nicolicchia → parent#12048 SET @child_agent_id = @base_agent_id + 21; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 21; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [23/420] Gustavo Rojas → parent#12048 SET @child_agent_id = @base_agent_id + 22; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 22; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [24/420] Gustavo Rojas → parent#12048 SET @child_agent_id = @base_agent_id + 23; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 23; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [25/420] Ainola Iturralde → parent#12048 SET @child_agent_id = @base_agent_id + 24; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 24; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [26/420] Kevin Ryan → parent#12048 SET @child_agent_id = @base_agent_id + 25; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 25; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [27/420] Ranjeeta Singh → parent#12048 SET @child_agent_id = @base_agent_id + 26; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 26; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [28/420] David Waich → parent#12048 SET @child_agent_id = @base_agent_id + 27; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 27; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [29/420] Antonio Sanchez → parent#12048 SET @child_agent_id = @base_agent_id + 28; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 28; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [30/420] Miguel Ratini → parent#12048 SET @child_agent_id = @base_agent_id + 29; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 29; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [31/420] Mark Wiersma → parent#12048 SET @child_agent_id = @base_agent_id + 30; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 30; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [32/420] Alejandro Pages → parent#12048 SET @child_agent_id = @base_agent_id + 31; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 31; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [33/420] Cesar Michelangeli Cesar Michelangeli → parent#12048 SET @child_agent_id = @base_agent_id + 32; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 32; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [34/420] Luis Cercos Ruiz → parent#12048 SET @child_agent_id = @base_agent_id + 33; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 33; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [35/420] Anabelle Fernandez Soto → parent#12048 SET @child_agent_id = @base_agent_id + 34; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 34; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [36/420] Mayda Acosta → parent#12048 SET @child_agent_id = @base_agent_id + 35; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 35; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [37/420] Mikelander Aldecoa → parent#12048 SET @child_agent_id = @base_agent_id + 36; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 36; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [38/420] Laura Tinoco de Gonzalez → parent#12048 SET @child_agent_id = @base_agent_id + 37; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 37; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [39/420] ADONIS TOMEY → parent#12048 SET @child_agent_id = @base_agent_id + 38; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 38; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [40/420] Grecia Alejandra Chacon Duran → parent#12064 SET @child_agent_id = @base_agent_id + 39; SET @parent_agent_id = @base_agent_id + 7; SET @child_agreement_id = @base_agreement_id + 39; SET @parent_agreement_id = @base_agreement_id + 7; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [41/420] Alfredo Benedettti Punceles → parent#12064 SET @child_agent_id = @base_agent_id + 40; SET @parent_agent_id = @base_agent_id + 7; SET @child_agreement_id = @base_agreement_id + 40; SET @parent_agreement_id = @base_agreement_id + 7; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [42/420] JORGE LUIS MIRELES CRESPO → parent#12048 SET @child_agent_id = @base_agent_id + 41; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 41; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [43/420] JOHAN LEAL SALGUERO → parent#12048 SET @child_agent_id = @base_agent_id + 42; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 42; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [44/420] Julio Canas → parent#12048 SET @child_agent_id = @base_agent_id + 43; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 43; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [45/420] RAFAEL CORDERO → parent#12048 SET @child_agent_id = @base_agent_id + 44; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 44; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [46/420] Oriana Marino → parent#12048 SET @child_agent_id = @base_agent_id + 45; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 45; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [47/420] Johnny Blatt → parent#12048 SET @child_agent_id = @base_agent_id + 46; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 46; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [48/420] Tony Sosa → parent#12048 SET @child_agent_id = @base_agent_id + 47; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 47; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [49/420] Ricardo Villarroel → parent#12048 SET @child_agent_id = @base_agent_id + 48; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 48; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [50/420] GUSTAVO MASSIANI → parent#12048 SET @child_agent_id = @base_agent_id + 49; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 49; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [51/420] Eduardo Montero Gonzalez → parent#12048 SET @child_agent_id = @base_agent_id + 50; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 50; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [52/420] REINALDO LAINVILLE TIRADO → parent#12048 SET @child_agent_id = @base_agent_id + 51; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 51; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [53/420] Carlos Cordero Vazquez → parent#12048 SET @child_agent_id = @base_agent_id + 52; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 52; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [54/420] Jackleny Castro → parent#12048 SET @child_agent_id = @base_agent_id + 53; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 53; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [55/420] Marisela Franzius → parent#12048 SET @child_agent_id = @base_agent_id + 54; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 54; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [56/420] John Fredy Sanchez Sepulveda → parent#12048 SET @child_agent_id = @base_agent_id + 55; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 55; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [57/420] Julio Salas Reyes → parent#12048 SET @child_agent_id = @base_agent_id + 56; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 56; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [58/420] Isidro Nava → parent#12048 SET @child_agent_id = @base_agent_id + 57; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 57; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [59/420] Walter Patricelli → parent#12048 SET @child_agent_id = @base_agent_id + 58; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 58; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [60/420] Carlos Velarde → parent#12048 SET @child_agent_id = @base_agent_id + 59; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 59; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [61/420] Sarai Tovar Martinez → parent#12051 SET @child_agent_id = @base_agent_id + 60; SET @parent_agent_id = @base_agent_id + 5; SET @child_agreement_id = @base_agreement_id + 60; SET @parent_agreement_id = @base_agreement_id + 5; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [62/420] Jose Oliveira → parent#12048 SET @child_agent_id = @base_agent_id + 61; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 61; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [63/420] John Johnson Fischel → parent#12048 SET @child_agent_id = @base_agent_id + 62; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 62; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [64/420] Andrea Sofia Reyes Arvelo → parent#32569 SET @child_agent_id = @base_agent_id + 63; SET @parent_agent_id = @base_agent_id + 62; SET @child_agreement_id = @base_agreement_id + 63; SET @parent_agreement_id = @base_agreement_id + 62; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [65/420] Servio Tulio Rangel → parent#12048 SET @child_agent_id = @base_agent_id + 64; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 64; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [66/420] Ana Clemencia Vivas → parent#12048 SET @child_agent_id = @base_agent_id + 65; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 65; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [67/420] Adriana Rivas → parent#12048 SET @child_agent_id = @base_agent_id + 66; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 66; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [68/420] Salomon Abadi → parent#12048 SET @child_agent_id = @base_agent_id + 67; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 67; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [69/420] Marysol Roca Marysol Roca → parent#12048 SET @child_agent_id = @base_agent_id + 68; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 68; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [70/420] Alvaro Sucre Guruceaga → parent#12048 SET @child_agent_id = @base_agent_id + 69; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 69; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [71/420] Sofia Alejandra Fernandez → parent#32534 SET @child_agent_id = @base_agent_id + 70; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 70; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [72/420] Angela Viviana Sanchez → parent#12048 SET @child_agent_id = @base_agent_id + 71; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 71; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [73/420] Monserrat Feliu → parent#12048 SET @child_agent_id = @base_agent_id + 72; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 72; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [74/420] Jenny Alvarado → parent#12048 SET @child_agent_id = @base_agent_id + 73; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 73; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [75/420] Andrea Figueroa Ravell → parent#32534 SET @child_agent_id = @base_agent_id + 74; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 74; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [76/420] Luis Alberto Ricaurte Chumo → parent#12048 SET @child_agent_id = @base_agent_id + 75; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 75; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [77/420] Ana Maria Chiriboga → parent#32599 SET @child_agent_id = @base_agent_id + 76; SET @parent_agent_id = @base_agent_id + 75; SET @child_agreement_id = @base_agreement_id + 76; SET @parent_agreement_id = @base_agreement_id + 75; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [78/420] Thais Moreno → parent#12048 SET @child_agent_id = @base_agent_id + 77; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 77; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [79/420] Jacob Mizrahi → parent#12048 SET @child_agent_id = @base_agent_id + 78; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 78; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [80/420] Maria Elisa Monaco → parent#12048 SET @child_agent_id = @base_agent_id + 79; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 79; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [81/420] Andreina Avellaneda → parent#12048 SET @child_agent_id = @base_agent_id + 80; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 80; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [82/420] Ascensio Cercio → parent#12048 SET @child_agent_id = @base_agent_id + 81; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 81; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [83/420] Oriana Gabriela Marino Morales → parent#32534 SET @child_agent_id = @base_agent_id + 82; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 82; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [84/420] Jennifer Tomassetti → parent#12048 SET @child_agent_id = @base_agent_id + 83; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 83; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [85/420] David Eline → parent#12048 SET @child_agent_id = @base_agent_id + 84; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 84; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [86/420] Vanessa Jimenez → parent#12048 SET @child_agent_id = @base_agent_id + 85; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 85; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [87/420] Jaime Rafael Inciarte Molero → parent#12048 SET @child_agent_id = @base_agent_id + 86; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 86; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [88/420] Jose Vargas Hungria → parent#12048 SET @child_agent_id = @base_agent_id + 87; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 87; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [89/420] Rafael Jose Urribarri → parent#12048 SET @child_agent_id = @base_agent_id + 88; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 88; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [90/420] Sandra Rodriguez → parent#12067 SET @child_agent_id = @base_agent_id + 89; SET @parent_agent_id = @base_agent_id + 8; SET @child_agreement_id = @base_agreement_id + 89; SET @parent_agreement_id = @base_agreement_id + 8; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [91/420] Adriana Yumar → parent#32577 SET @child_agent_id = @base_agent_id + 90; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 90; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [93/420] Ana Borga → parent#32577 SET @child_agent_id = @base_agent_id + 92; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 92; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [96/420] Ana Victoria Borga → parent#32577 SET @child_agent_id = @base_agent_id + 95; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 95; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [100/420] Arturo Chirinos → parent#12048 SET @child_agent_id = @base_agent_id + 99; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 99; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [101/420] Belisa Vegas → parent#32577 SET @child_agent_id = @base_agent_id + 100; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 100; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [110/420] Gladys Moros → parent#32577 SET @child_agent_id = @base_agent_id + 109; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 109; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [112/420] Hector Gonzalez Pineda → parent#12048 SET @child_agent_id = @base_agent_id + 111; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 111; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [115/420] Jenisse Arellano → parent#32577 SET @child_agent_id = @base_agent_id + 114; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 114; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [121/420] Ligia Jaimes → parent#12048 SET @child_agent_id = @base_agent_id + 120; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 120; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [126/420] Magin Rodriguez → parent#32577 SET @child_agent_id = @base_agent_id + 125; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 125; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [128/420] Maria Gabriela Vega → parent#32577 SET @child_agent_id = @base_agent_id + 127; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 127; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [137/420] Jose Rafael Ribas → parent#32577 SET @child_agent_id = @base_agent_id + 136; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 136; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [139/420] Jose Enrique Diaz → parent#32577 SET @child_agent_id = @base_agent_id + 138; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 138; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [140/420] Leonardo Lossada → parent#32577 SET @child_agent_id = @base_agent_id + 139; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 139; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [141/420] Alberto Colina → parent#32577 SET @child_agent_id = @base_agent_id + 140; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 140; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [142/420] Victor Babino → parent#32577 SET @child_agent_id = @base_agent_id + 141; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 141; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [143/420] Jesus Rondon Benaim → parent#32577 SET @child_agent_id = @base_agent_id + 142; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 142; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [144/420] Maria Gabriela Neri Luciani → parent#32651 SET @child_agent_id = @base_agent_id + 143; SET @parent_agent_id = @base_agent_id + 105; SET @child_agreement_id = @base_agreement_id + 143; SET @parent_agreement_id = @base_agreement_id + 105; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [145/420] Guillermo Marcano → parent#32577 SET @child_agent_id = @base_agent_id + 144; SET @parent_agent_id = @base_agent_id + 69; SET @child_agreement_id = @base_agreement_id + 144; SET @parent_agreement_id = @base_agreement_id + 69; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [146/420] Doris de Matattia → parent#12048 SET @child_agent_id = @base_agent_id + 145; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 145; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [147/420] Andreina Avila → parent#12091 SET @child_agent_id = @base_agent_id + 146; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 146; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [148/420] Nabis de Jesus Mendoza Garcia → parent#12048 SET @child_agent_id = @base_agent_id + 147; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 147; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [149/420] Ricardo Rafael Raven Matheus → parent#12048 SET @child_agent_id = @base_agent_id + 148; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 148; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [150/420] Faine Coromoto Hernandez Sierra → parent#32534 SET @child_agent_id = @base_agent_id + 149; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 149; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [151/420] Nadeska Carolina Pina Garrido → parent#32534 SET @child_agent_id = @base_agent_id + 150; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 150; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [152/420] Erik Dupret → parent#12064 SET @child_agent_id = @base_agent_id + 151; SET @parent_agent_id = @base_agent_id + 7; SET @child_agreement_id = @base_agreement_id + 151; SET @parent_agreement_id = @base_agreement_id + 7; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [153/420] Carlos Eduardo Boccaccini → parent#32713 SET @child_agent_id = @base_agent_id + 152; SET @parent_agent_id = @base_agent_id + 145; SET @child_agreement_id = @base_agreement_id + 152; SET @parent_agreement_id = @base_agreement_id + 145; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [154/420] Monica Cristina Lecuna → parent#32713 SET @child_agent_id = @base_agent_id + 153; SET @parent_agent_id = @base_agent_id + 145; SET @child_agreement_id = @base_agreement_id + 153; SET @parent_agreement_id = @base_agreement_id + 145; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [155/420] Hector Fernandez → parent#32713 SET @child_agent_id = @base_agent_id + 154; SET @parent_agent_id = @base_agent_id + 145; SET @child_agreement_id = @base_agreement_id + 154; SET @parent_agreement_id = @base_agreement_id + 145; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [156/420] Hilda Ballester → parent#12091 SET @child_agent_id = @base_agent_id + 155; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 155; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [157/420] Jose Humberto Barazarte → parent#12048 SET @child_agent_id = @base_agent_id + 156; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 156; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [158/420] Adrian Duque → parent#33183 SET @child_agent_id = @base_agent_id + 157; SET @parent_agent_id = @base_agent_id + 315; SET @child_agreement_id = @base_agreement_id + 157; SET @parent_agreement_id = @base_agreement_id + 315; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [159/420] Andres Marquez → parent#33183 SET @child_agent_id = @base_agent_id + 158; SET @parent_agent_id = @base_agent_id + 315; SET @child_agreement_id = @base_agreement_id + 158; SET @parent_agreement_id = @base_agreement_id + 315; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [160/420] Maria Daniela Alcala Lis → parent#12091 SET @child_agent_id = @base_agent_id + 159; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 159; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [161/420] Manuela García de Carrasquero → parent#12091 SET @child_agent_id = @base_agent_id + 160; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 160; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [162/420] Barbara Velasquez → parent#32534 SET @child_agent_id = @base_agent_id + 161; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 161; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [163/420] Luis C. Dominguez → parent#12048 SET @child_agent_id = @base_agent_id + 162; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 162; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [164/420] Juan Alvaro Lopez Hernandez → parent#32460 SET @child_agent_id = @base_agent_id + 163; SET @parent_agent_id = @base_agent_id + 33; SET @child_agreement_id = @base_agreement_id + 163; SET @parent_agreement_id = @base_agreement_id + 33; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [165/420] Luis Fernando Avila Boffil → parent#12091 SET @child_agent_id = @base_agent_id + 164; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 164; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [166/420] Antonio Sotillo Rosales → parent#32572 SET @child_agent_id = @base_agent_id + 165; SET @parent_agent_id = @base_agent_id + 64; SET @child_agreement_id = @base_agreement_id + 165; SET @parent_agreement_id = @base_agreement_id + 64; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [167/420] Maria Auxiliadora Ramirez Maria Auxiliadora Ramirez → parent#SL1014 SET @child_agent_id = @base_agent_id + 166; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 166; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [168/420] Alvaro Cesar Almaral → parent#SL1014 SET @child_agent_id = @base_agent_id + 167; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 167; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [169/420] Marisela Rincon → parent#SL1014 SET @child_agent_id = @base_agent_id + 168; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 168; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [170/420] Adriana Carolina Lorenzo Triana → parent#12050 SET @child_agent_id = @base_agent_id + 169; SET @parent_agent_id = @base_agent_id + 4; SET @child_agreement_id = @base_agreement_id + 169; SET @parent_agreement_id = @base_agreement_id + 4; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [171/420] Maria Soledad Rodriguez → parent#SL1014 SET @child_agent_id = @base_agent_id + 170; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 170; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [172/420] Rosa Perez → parent#SL1014 SET @child_agent_id = @base_agent_id + 171; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 171; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [173/420] Pilar Bello → parent#SL1014 SET @child_agent_id = @base_agent_id + 172; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 172; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [175/420] Iliana Zeppenfeldt → parent#12048 SET @child_agent_id = @base_agent_id + 174; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 174; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [176/420] Arnoldo Jimenez Canino → parent#12048 SET @child_agent_id = @base_agent_id + 175; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 175; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [177/420] Maria Eugenia Coronado Garcia → parent#12070 SET @child_agent_id = @base_agent_id + 176; SET @parent_agent_id = @base_agent_id + 11; SET @child_agreement_id = @base_agreement_id + 176; SET @parent_agreement_id = @base_agreement_id + 11; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [178/420] Jorge Enrique Zafra Ramirez → parent#12048 SET @child_agent_id = @base_agent_id + 177; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 177; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [179/420] Beatriz Lopez → parent#12048 SET @child_agent_id = @base_agent_id + 178; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 178; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [180/420] Maria Fernanda Obediente → parent#SL1014 SET @child_agent_id = @base_agent_id + 179; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 179; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [181/420] Francisco Viloria → parent#12048 SET @child_agent_id = @base_agent_id + 180; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 180; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [182/420] Karla Gamarra → parent#12048 SET @child_agent_id = @base_agent_id + 181; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 181; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [183/420] Libe Pereira de Arriola → parent#12048 SET @child_agent_id = @base_agent_id + 182; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 182; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [184/420] Carlos Alfredo Noguera Gil → parent#12048 SET @child_agent_id = @base_agent_id + 183; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 183; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [185/420] Morella Garcia → parent#12091 SET @child_agent_id = @base_agent_id + 184; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 184; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [186/420] Federica Iturriza → parent#12048 SET @child_agent_id = @base_agent_id + 185; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 185; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [187/420] Maria Alejandra Arriaga → parent#32629 SET @child_agent_id = @base_agent_id + 186; SET @parent_agent_id = @base_agent_id + 88; SET @child_agreement_id = @base_agreement_id + 186; SET @parent_agreement_id = @base_agreement_id + 88; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [188/420] Belkys Zuleta → parent#12048 SET @child_agent_id = @base_agent_id + 187; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 187; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [189/420] Pablo Luis Ramos Fuentes → parent#12048 SET @child_agent_id = @base_agent_id + 188; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 188; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [190/420] Luis Armando Cerezo Soto → parent#12048 SET @child_agent_id = @base_agent_id + 189; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 189; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [191/420] Claudia Blanco → parent#12048 SET @child_agent_id = @base_agent_id + 190; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 190; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [192/420] Maria Fernanda Zuluaga → parent#SL1014 SET @child_agent_id = @base_agent_id + 191; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 191; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [193/420] Mayerling Sayago → parent#SL1014 SET @child_agent_id = @base_agent_id + 192; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 192; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [194/420] Monica Finol Monica Finol → parent#32572 SET @child_agent_id = @base_agent_id + 193; SET @parent_agent_id = @base_agent_id + 64; SET @child_agreement_id = @base_agreement_id + 193; SET @parent_agreement_id = @base_agreement_id + 64; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [195/420] Gabriela Pernetz → parent#12048 SET @child_agent_id = @base_agent_id + 194; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 194; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [196/420] Ricardo Angles Perez → parent#12091 SET @child_agent_id = @base_agent_id + 195; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 195; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [198/420] Diana Cordero → parent#32534 SET @child_agent_id = @base_agent_id + 197; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 197; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [200/420] Jacqueline Marvez → parent#33183 SET @child_agent_id = @base_agent_id + 199; SET @parent_agent_id = @base_agent_id + 315; SET @child_agreement_id = @base_agreement_id + 199; SET @parent_agreement_id = @base_agreement_id + 315; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [201/420] Luis Manuel Vargas Marcano → parent#32762 SET @child_agent_id = @base_agent_id + 200; SET @parent_agent_id = @base_agent_id + 169; SET @child_agreement_id = @base_agreement_id + 200; SET @parent_agreement_id = @base_agreement_id + 169; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [202/420] Alains Figueroa Alains Figueroa → parent#12048 SET @child_agent_id = @base_agent_id + 201; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 201; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [203/420] Eliana Yanez Angel → parent#12091 SET @child_agent_id = @base_agent_id + 202; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 202; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [204/420] Alejandro Sandoval → parent#12050 SET @child_agent_id = @base_agent_id + 203; SET @parent_agent_id = @base_agent_id + 4; SET @child_agreement_id = @base_agreement_id + 203; SET @parent_agreement_id = @base_agreement_id + 4; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [205/420] Domingo Morales → parent#12048 SET @child_agent_id = @base_agent_id + 204; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 204; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [206/420] Pedro Luis Tineo Marcano → parent#12048 SET @child_agent_id = @base_agent_id + 205; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 205; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [207/420] Rodolfo Vera Vera → parent#12048 SET @child_agent_id = @base_agent_id + 206; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 206; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [208/420] Damelys Dadiotis → parent#33183 SET @child_agent_id = @base_agent_id + 207; SET @parent_agent_id = @base_agent_id + 315; SET @child_agreement_id = @base_agreement_id + 207; SET @parent_agreement_id = @base_agreement_id + 315; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [209/420] Carlos Scott → parent#12048 SET @child_agent_id = @base_agent_id + 208; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 208; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [210/420] Guillermo Schutte → parent#12048 SET @child_agent_id = @base_agent_id + 209; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 209; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [211/420] Mercedes Palacios → parent#32858 SET @child_agent_id = @base_agent_id + 210; SET @parent_agent_id = @base_agent_id + 203; SET @child_agreement_id = @base_agreement_id + 210; SET @parent_agreement_id = @base_agreement_id + 203; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [212/420] Maria Carolina Vega Colina → parent#12050 SET @child_agent_id = @base_agent_id + 211; SET @parent_agent_id = @base_agent_id + 4; SET @child_agreement_id = @base_agreement_id + 211; SET @parent_agreement_id = @base_agreement_id + 4; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [213/420] Noraima Colmenares → parent#SL1014 SET @child_agent_id = @base_agent_id + 212; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 212; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [214/420] Isabela Sequera → parent#12048 SET @child_agent_id = @base_agent_id + 213; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 213; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [215/420] Gustavo Bandes → parent#12048 SET @child_agent_id = @base_agent_id + 214; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 214; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [216/420] Cristian Milagro Guedez → parent#12048 SET @child_agent_id = @base_agent_id + 215; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 215; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [217/420] Regina Friedman → parent#12048 SET @child_agent_id = @base_agent_id + 216; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 216; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [218/420] Kira Kariakin → parent#12048 SET @child_agent_id = @base_agent_id + 217; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 217; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [219/420] Yasmin Mesa → parent#SL1014 SET @child_agent_id = @base_agent_id + 218; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 218; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [220/420] Yanubis Luc Yanubis Luc → parent#12048 SET @child_agent_id = @base_agent_id + 219; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 219; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [222/420] Corini Pantoja → parent#12068 SET @child_agent_id = @base_agent_id + 221; SET @parent_agent_id = @base_agent_id + 9; SET @child_agreement_id = @base_agreement_id + 221; SET @parent_agreement_id = @base_agreement_id + 9; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [224/420] Mario Leon Chirinos → parent#12048 SET @child_agent_id = @base_agent_id + 223; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 223; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [225/420] Agustin Da Silva-Diaz → parent#SL1014 SET @child_agent_id = @base_agent_id + 224; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 224; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [226/420] Larry Padron → parent#SL1014 SET @child_agent_id = @base_agent_id + 225; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 225; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [227/420] Adrian Lopez De Aguiar → parent#12048 SET @child_agent_id = @base_agent_id + 226; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 226; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [228/420] Jose Uzcategui Amare → parent#SL1014 SET @child_agent_id = @base_agent_id + 227; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 227; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [230/420] Doris Perez → parent#SL1014 SET @child_agent_id = @base_agent_id + 229; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 229; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [231/420] Johann Gomez Sanchez → parent#SL1014 SET @child_agent_id = @base_agent_id + 230; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 230; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [232/420] Valerie Obregon Aguilera → parent#12048 SET @child_agent_id = @base_agent_id + 231; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 231; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [233/420] Ivan Vezga → parent#12124 SET @child_agent_id = @base_agent_id + 232; SET @parent_agent_id = @base_agent_id + 28; SET @child_agreement_id = @base_agreement_id + 232; SET @parent_agreement_id = @base_agreement_id + 28; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [234/420] Fernando Vera Useche → parent#12091 SET @child_agent_id = @base_agent_id + 233; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 233; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [235/420] Elimar Hung Nieves → parent#32534 SET @child_agent_id = @base_agent_id + 234; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 234; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [236/420] Fabiola Tejada → parent#32563 SET @child_agent_id = @base_agent_id + 235; SET @parent_agent_id = @base_agent_id + 59; SET @child_agreement_id = @base_agreement_id + 235; SET @parent_agreement_id = @base_agreement_id + 59; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [237/420] Patricia Arriete V. → parent#12071 SET @child_agent_id = @base_agent_id + 236; SET @parent_agent_id = @base_agent_id + 12; SET @child_agreement_id = @base_agreement_id + 236; SET @parent_agreement_id = @base_agreement_id + 12; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [238/420] Luz Tarborda B. → parent#12071 SET @child_agent_id = @base_agent_id + 237; SET @parent_agent_id = @base_agent_id + 12; SET @child_agreement_id = @base_agreement_id + 237; SET @parent_agreement_id = @base_agreement_id + 12; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [239/420] Maria Mineses Contreras → parent#12071 SET @child_agent_id = @base_agent_id + 238; SET @parent_agent_id = @base_agent_id + 12; SET @child_agreement_id = @base_agreement_id + 238; SET @parent_agreement_id = @base_agreement_id + 12; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [240/420] Jorge Chacon L → parent#SL1014 SET @child_agent_id = @base_agent_id + 239; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 239; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [241/420] Andrea Leon → parent#12048 SET @child_agent_id = @base_agent_id + 240; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 240; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [242/420] Claudia De Urdaneta → parent#32535 SET @child_agent_id = @base_agent_id + 241; SET @parent_agent_id = @base_agent_id + 46; SET @child_agreement_id = @base_agreement_id + 241; SET @parent_agreement_id = @base_agreement_id + 46; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [243/420] Juan Mila de la Roca → parent#12048 SET @child_agent_id = @base_agent_id + 242; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 242; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [244/420] Jorge Ojeda → parent#12091 SET @child_agent_id = @base_agent_id + 243; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 243; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [245/420] Ricardo Gomez Otto → parent#SL1014 SET @child_agent_id = @base_agent_id + 244; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 244; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [246/420] Maribel Briceno → parent#32562 SET @child_agent_id = @base_agent_id + 245; SET @parent_agent_id = @base_agent_id + 58; SET @child_agreement_id = @base_agreement_id + 245; SET @parent_agreement_id = @base_agreement_id + 58; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [247/420] Ginett Luces → parent#12048 SET @child_agent_id = @base_agent_id + 246; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 246; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [248/420] Juan Targa → parent#SL1014 SET @child_agent_id = @base_agent_id + 247; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 247; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [249/420] Jose Narvaez → parent#12048 SET @child_agent_id = @base_agent_id + 248; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 248; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [250/420] Nerio Socorro → parent#32499 SET @child_agent_id = @base_agent_id + 249; SET @parent_agent_id = @base_agent_id + 38; SET @child_agreement_id = @base_agreement_id + 249; SET @parent_agreement_id = @base_agreement_id + 38; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [251/420] Cecilio Rodriguez → parent#32499 SET @child_agent_id = @base_agent_id + 250; SET @parent_agent_id = @base_agent_id + 38; SET @child_agreement_id = @base_agreement_id + 250; SET @parent_agreement_id = @base_agreement_id + 38; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [252/420] Tannya Lisseth Sierra Quiroga → parent#12048 SET @child_agent_id = @base_agent_id + 251; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 251; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [253/420] Lisbeth Josefina Seijas Pineda → parent#32534 SET @child_agent_id = @base_agent_id + 252; SET @parent_agent_id = @base_agent_id + 45; SET @child_agreement_id = @base_agreement_id + 252; SET @parent_agreement_id = @base_agreement_id + 45; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [254/420] Jacqueline Bali Jacqueline Bali → parent#12048 SET @child_agent_id = @base_agent_id + 253; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 253; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [255/420] MARIELYS SEMPRUN → parent#32499 SET @child_agent_id = @base_agent_id + 254; SET @parent_agent_id = @base_agent_id + 38; SET @child_agreement_id = @base_agreement_id + 254; SET @parent_agreement_id = @base_agreement_id + 38; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [256/420] Maria Jose Couri Araujo → parent#12048 SET @child_agent_id = @base_agent_id + 255; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 255; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [257/420] Oscar Freites → parent#32562 SET @child_agent_id = @base_agent_id + 256; SET @parent_agent_id = @base_agent_id + 58; SET @child_agreement_id = @base_agreement_id + 256; SET @parent_agreement_id = @base_agreement_id + 58; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [258/420] Guido Pena → parent#12048 SET @child_agent_id = @base_agent_id + 257; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 257; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [262/420] Jorge Villamizar → parent#12048 SET @child_agent_id = @base_agent_id + 261; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 261; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [264/420] Cesar Hulett → parent#12050 SET @child_agent_id = @base_agent_id + 263; SET @parent_agent_id = @base_agent_id + 4; SET @child_agreement_id = @base_agreement_id + 263; SET @parent_agreement_id = @base_agreement_id + 4; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [265/420] Maria Elvia Becerra Maria Elvia Becerra → parent#32499 SET @child_agent_id = @base_agent_id + 264; SET @parent_agent_id = @base_agent_id + 38; SET @child_agreement_id = @base_agreement_id + 264; SET @parent_agreement_id = @base_agreement_id + 38; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [266/420] Kassandra Fagundez → parent#12048 SET @child_agent_id = @base_agent_id + 265; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 265; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [267/420] Julian Gonzalez Balbo → parent#12048 SET @child_agent_id = @base_agent_id + 266; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 266; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [268/420] Omar Alfredo Gutierrez Guerrero Gutierrez Guerrero → parent#12048 SET @child_agent_id = @base_agent_id + 267; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 267; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [269/420] Ignacio Jaramillo Abondano → parent#12048 SET @child_agent_id = @base_agent_id + 268; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 268; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [270/420] Adolfo Cumana → parent#32562 SET @child_agent_id = @base_agent_id + 269; SET @parent_agent_id = @base_agent_id + 58; SET @child_agreement_id = @base_agreement_id + 269; SET @parent_agreement_id = @base_agreement_id + 58; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [271/420] Kenic Narvarro → parent#12048 SET @child_agent_id = @base_agent_id + 270; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 270; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [272/420] Carlos Montero → parent#12091 SET @child_agent_id = @base_agent_id + 271; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 271; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [273/420] Jesus Ugas → parent#12048 SET @child_agent_id = @base_agent_id + 272; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 272; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [274/420] Karelia Gomez Martinez → parent#SL1014 SET @child_agent_id = @base_agent_id + 273; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 273; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [275/420] David Waich → parent#12048 SET @child_agent_id = @base_agent_id + 274; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 274; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [276/420] Maria Alejandra Tovar Ojeda → parent#32572 SET @child_agent_id = @base_agent_id + 275; SET @parent_agent_id = @base_agent_id + 64; SET @child_agreement_id = @base_agreement_id + 275; SET @parent_agreement_id = @base_agreement_id + 64; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [277/420] Maria Idalina Rodriguez Rodriguez → parent#12048 SET @child_agent_id = @base_agent_id + 276; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 276; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [278/420] Gabriella Lopez → parent#12064 SET @child_agent_id = @base_agent_id + 277; SET @parent_agent_id = @base_agent_id + 7; SET @child_agreement_id = @base_agreement_id + 277; SET @parent_agreement_id = @base_agreement_id + 7; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [279/420] Roberto Aldecoa → parent#33183 SET @child_agent_id = @base_agent_id + 278; SET @parent_agent_id = @base_agent_id + 315; SET @child_agreement_id = @base_agreement_id + 278; SET @parent_agreement_id = @base_agreement_id + 315; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [280/420] Miguel Pasquariello → parent#32562 SET @child_agent_id = @base_agent_id + 279; SET @parent_agent_id = @base_agent_id + 58; SET @child_agreement_id = @base_agreement_id + 279; SET @parent_agreement_id = @base_agreement_id + 58; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [281/420] Pascual Miguel Quagliano → parent#32562 SET @child_agent_id = @base_agent_id + 280; SET @parent_agent_id = @base_agent_id + 58; SET @child_agreement_id = @base_agreement_id + 280; SET @parent_agreement_id = @base_agreement_id + 58; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [286/420] Marianne Delgado → parent#SL1014 SET @child_agent_id = @base_agent_id + 285; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 285; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [287/420] Gustavo Bergstrom → parent#12048 SET @child_agent_id = @base_agent_id + 286; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 286; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [289/420] Giovanni Rossomando de la Rosa → parent#12048 SET @child_agent_id = @base_agent_id + 288; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 288; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [290/420] Enzo Isaias Herrera Fernandez → parent#12048 SET @child_agent_id = @base_agent_id + 289; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 289; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [291/420] ROBERTO BAEZ DUARTE → parent#12048 SET @child_agent_id = @base_agent_id + 290; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 290; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [292/420] Alejandro Osorio → parent#12048 SET @child_agent_id = @base_agent_id + 291; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 291; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [293/420] Marelvis Coraspe → parent#12048 SET @child_agent_id = @base_agent_id + 292; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 292; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [294/420] Jose Manuel Galanton Hernandez → parent#12048 SET @child_agent_id = @base_agent_id + 293; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 293; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [295/420] Ivan Gonima → parent#12048 SET @child_agent_id = @base_agent_id + 294; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 294; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [296/420] Oswaldo Prada → parent#12048 SET @child_agent_id = @base_agent_id + 295; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 295; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [297/420] Alfredo Osiglia → parent#12048 SET @child_agent_id = @base_agent_id + 296; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 296; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [298/420] MARYOLEY CAROLINA VIVAS GIL → parent#12048 SET @child_agent_id = @base_agent_id + 297; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 297; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [299/420] LIZZET RICCARDI → parent#12048 SET @child_agent_id = @base_agent_id + 298; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 298; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [300/420] Nathaly Rojas Aguilera → parent#12048 SET @child_agent_id = @base_agent_id + 299; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 299; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [301/420] Wilson Molina Sanguino → parent#12048 SET @child_agent_id = @base_agent_id + 300; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 300; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [302/420] Jon Olabeaga Urresti → parent#12048 SET @child_agent_id = @base_agent_id + 301; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 301; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [303/420] Oswaldo Figueroa → parent#12048 SET @child_agent_id = @base_agent_id + 302; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 302; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [304/420] German Villarreal → parent#12048 SET @child_agent_id = @base_agent_id + 303; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 303; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [306/420] Dainazet Robespierre → parent#12048 SET @child_agent_id = @base_agent_id + 305; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 305; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [307/420] Tomas Andara → parent#12048 SET @child_agent_id = @base_agent_id + 306; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 306; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [308/420] Lenis Silva → parent#12070 SET @child_agent_id = @base_agent_id + 307; SET @parent_agent_id = @base_agent_id + 11; SET @child_agreement_id = @base_agreement_id + 307; SET @parent_agreement_id = @base_agreement_id + 11; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [309/420] Bernardo Rodriguez → parent#12048 SET @child_agent_id = @base_agent_id + 308; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 308; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [310/420] Carlos Tagliaferro → parent#12048 SET @child_agent_id = @base_agent_id + 309; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 309; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [311/420] Antonio Jose Osorio Sifontes → parent#12048 SET @child_agent_id = @base_agent_id + 310; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 310; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [312/420] Beatriz Gabriela Arias Petit → parent#12048 SET @child_agent_id = @base_agent_id + 311; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 311; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [315/420] Rocco Nardulli → parent#12048 SET @child_agent_id = @base_agent_id + 314; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 314; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [316/420] Excellence Asesores CA → parent#12048 SET @child_agent_id = @base_agent_id + 315; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 315; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [317/420] Luisa Viso → parent#12048 SET @child_agent_id = @base_agent_id + 316; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 316; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [319/420] Audry Gonzalez → parent#12048 SET @child_agent_id = @base_agent_id + 318; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 318; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [320/420] Cristobal Alvelo → parent#12048 SET @child_agent_id = @base_agent_id + 319; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 319; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [321/420] Marlene Fernandez → parent#12048 SET @child_agent_id = @base_agent_id + 320; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 320; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [322/420] Ambar Arredondo → parent#12048 SET @child_agent_id = @base_agent_id + 321; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 321; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [323/420] ELVIA MORENO → parent#12048 SET @child_agent_id = @base_agent_id + 322; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 322; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [324/420] Olga Herrera → parent#12048 SET @child_agent_id = @base_agent_id + 323; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 323; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [325/420] kristen Pena → parent#12048 SET @child_agent_id = @base_agent_id + 324; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 324; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [326/420] Johnny Paz → parent#12048 SET @child_agent_id = @base_agent_id + 325; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 325; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [327/420] Jhoanna Querales → parent#12048 SET @child_agent_id = @base_agent_id + 326; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 326; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [328/420] Ariadna Quroz → parent#12048 SET @child_agent_id = @base_agent_id + 327; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 327; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [329/420] Marycarmen Hurtado → parent#12048 SET @child_agent_id = @base_agent_id + 328; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 328; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [331/420] Elisa Baez → parent#32683 SET @child_agent_id = @base_agent_id + 330; SET @parent_agent_id = @base_agent_id + 129; SET @child_agreement_id = @base_agreement_id + 330; SET @parent_agreement_id = @base_agreement_id + 129; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [332/420] Erick Oropeza → parent#12048 SET @child_agent_id = @base_agent_id + 331; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 331; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [333/420] Andreyna Molla → parent#12048 SET @child_agent_id = @base_agent_id + 332; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 332; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [334/420] Gisel Morillo → parent#12048 SET @child_agent_id = @base_agent_id + 333; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 333; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [335/420] Mariangie Reverol → parent#12048 SET @child_agent_id = @base_agent_id + 334; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 334; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [336/420] Mariangie Reverol → parent#12048 SET @child_agent_id = @base_agent_id + 335; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 335; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [337/420] ANTONIO SIFONTES → parent#12048 SET @child_agent_id = @base_agent_id + 336; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 336; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [338/420] Maria Arenas → parent#12048 SET @child_agent_id = @base_agent_id + 337; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 337; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [339/420] Joselyn Aguilar → parent#12048 SET @child_agent_id = @base_agent_id + 338; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 338; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [340/420] Anabella Vazquez → parent#12048 SET @child_agent_id = @base_agent_id + 339; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 339; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [341/420] Patricia Gil Porto → parent#12048 SET @child_agent_id = @base_agent_id + 340; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 340; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [342/420] Marys Soto → parent#12048 SET @child_agent_id = @base_agent_id + 341; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 341; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [343/420] Johana Sanchez → parent#12048 SET @child_agent_id = @base_agent_id + 342; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 342; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [344/420] Vicente Emilio Alvarez Jimenez → parent#12064 SET @child_agent_id = @base_agent_id + 343; SET @parent_agent_id = @base_agent_id + 7; SET @child_agreement_id = @base_agreement_id + 343; SET @parent_agreement_id = @base_agreement_id + 7; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [345/420] ELIZBETH MARTORELLI → parent#12048 SET @child_agent_id = @base_agent_id + 344; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 344; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [346/420] Liseth Segovia → parent#12048 SET @child_agent_id = @base_agent_id + 345; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 345; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [347/420] Paulo Tabares Ramirez → parent#33233 SET @child_agent_id = @base_agent_id + 346; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 346; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [348/420] Elena Socorro Flores → parent#33233 SET @child_agent_id = @base_agent_id + 347; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 347; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [349/420] Jenny VivasVasquez → parent#12048 SET @child_agent_id = @base_agent_id + 348; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 348; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [350/420] Mabelis Del Valle Suarez Viloria → parent#33269 SET @child_agent_id = @base_agent_id + 349; SET @parent_agent_id = @base_agent_id + 360; SET @child_agreement_id = @base_agreement_id + 349; SET @parent_agreement_id = @base_agreement_id + 360; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [353/420] Claudia Diaz Picon → parent#32692 SET @child_agent_id = @base_agent_id + 352; SET @parent_agent_id = @base_agent_id + 134; SET @child_agreement_id = @base_agreement_id + 352; SET @parent_agreement_id = @base_agreement_id + 134; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [354/420] Larissa Pinto Pina → parent#33271 SET @child_agent_id = @base_agent_id + 353; SET @parent_agent_id = @base_agent_id + 362; SET @child_agreement_id = @base_agreement_id + 353; SET @parent_agreement_id = @base_agreement_id + 362; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [355/420] DANIELLA NAVA RUBIANO → parent#33271 SET @child_agent_id = @base_agent_id + 354; SET @parent_agent_id = @base_agent_id + 362; SET @child_agreement_id = @base_agreement_id + 354; SET @parent_agreement_id = @base_agreement_id + 362; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [356/420] THAIS DELGADO → parent#33271 SET @child_agent_id = @base_agent_id + 355; SET @parent_agent_id = @base_agent_id + 362; SET @child_agreement_id = @base_agreement_id + 355; SET @parent_agreement_id = @base_agreement_id + 362; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [361/420] Bianeys Barreto Centeno → parent#33233 SET @child_agent_id = @base_agent_id + 360; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 360; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [362/420] Fernando Zuleta → parent#33233 SET @child_agent_id = @base_agent_id + 361; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 361; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [363/420] Maria Rubiano → parent#33233 SET @child_agent_id = @base_agent_id + 362; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 362; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [364/420] Rosalyn Fonseca → parent#33233 SET @child_agent_id = @base_agent_id + 363; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 363; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [365/420] Veronica Suarez → parent#33233 SET @child_agent_id = @base_agent_id + 364; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 364; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [366/420] Manuel De Pablos Barboza → parent#33271 SET @child_agent_id = @base_agent_id + 365; SET @parent_agent_id = @base_agent_id + 362; SET @child_agreement_id = @base_agreement_id + 365; SET @parent_agreement_id = @base_agreement_id + 362; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [367/420] Maria Isolina Martinez → parent#33271 SET @child_agent_id = @base_agent_id + 366; SET @parent_agent_id = @base_agent_id + 362; SET @child_agreement_id = @base_agreement_id + 366; SET @parent_agreement_id = @base_agreement_id + 362; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [368/420] Yeraldit Barreto → parent#33269 SET @child_agent_id = @base_agent_id + 367; SET @parent_agent_id = @base_agent_id + 360; SET @child_agreement_id = @base_agreement_id + 367; SET @parent_agreement_id = @base_agreement_id + 360; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [369/420] Rafael Antonio Jimenez Gonzalez → parent#33269 SET @child_agent_id = @base_agent_id + 368; SET @parent_agent_id = @base_agent_id + 360; SET @child_agreement_id = @base_agreement_id + 368; SET @parent_agreement_id = @base_agreement_id + 360; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [371/420] AMERICA CLORINDA BECK RODRIGUEZ → parent#33233 SET @child_agent_id = @base_agent_id + 370; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 370; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [373/420] ana rodriguez → parent#12048 SET @child_agent_id = @base_agent_id + 372; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 372; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [377/420] Raiza Marlene Villegas → parent#12048 SET @child_agent_id = @base_agent_id + 376; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 376; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [378/420] Vanessa Rendón → parent#12048 SET @child_agent_id = @base_agent_id + 377; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 377; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [379/420] Rodolfo Montero → parent#33233 SET @child_agent_id = @base_agent_id + 378; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 378; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [380/420] Tamara Gonzalez → parent#33183 SET @child_agent_id = @base_agent_id + 379; SET @parent_agent_id = @base_agent_id + 315; SET @child_agreement_id = @base_agreement_id + 379; SET @parent_agreement_id = @base_agreement_id + 315; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [381/420] Vanessa Rendón → parent#12048 SET @child_agent_id = @base_agent_id + 380; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 380; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [383/420] Rosa Prado → parent#12048 SET @child_agent_id = @base_agent_id + 382; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 382; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [384/420] Tahiruma Colina → parent#12048 SET @child_agent_id = @base_agent_id + 383; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 383; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [385/420] CARLA VIRGINIA GUTIERREZ SOCORRO → parent#33235 SET @child_agent_id = @base_agent_id + 384; SET @parent_agent_id = @base_agent_id + 347; SET @child_agreement_id = @base_agreement_id + 384; SET @parent_agreement_id = @base_agreement_id + 347; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [386/420] LUZ MALDONADO → parent#33235 SET @child_agent_id = @base_agent_id + 385; SET @parent_agent_id = @base_agent_id + 347; SET @child_agreement_id = @base_agreement_id + 385; SET @parent_agreement_id = @base_agreement_id + 347; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [387/420] MARIA BETHINA SARCOS → parent#33235 SET @child_agent_id = @base_agent_id + 386; SET @parent_agent_id = @base_agent_id + 347; SET @child_agreement_id = @base_agreement_id + 386; SET @parent_agreement_id = @base_agreement_id + 347; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [388/420] Nancy Almanzar → parent#12048 SET @child_agent_id = @base_agent_id + 387; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 387; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [389/420] Lidiana Fernandez → parent#33233 SET @child_agent_id = @base_agent_id + 388; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 388; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [390/420] Liz Perozo → parent#33233 SET @child_agent_id = @base_agent_id + 389; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 389; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [391/420] Amir Asaff → parent#33233 SET @child_agent_id = @base_agent_id + 390; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 390; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [392/420] Javier Garcia → parent#33233 SET @child_agent_id = @base_agent_id + 391; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 391; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [393/420] Douglas Gonzalez → parent#33233 SET @child_agent_id = @base_agent_id + 392; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 392; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [394/420] Marielina Herrera → parent#33233 SET @child_agent_id = @base_agent_id + 393; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 393; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [395/420] Fabiana Pacheco → parent#33233 SET @child_agent_id = @base_agent_id + 394; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 394; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [396/420] Miguel Indavec → parent#33233 SET @child_agent_id = @base_agent_id + 395; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 395; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [397/420] Estepfanny Castillo → parent#33233 SET @child_agent_id = @base_agent_id + 396; SET @parent_agent_id = @base_agent_id + 345; SET @child_agreement_id = @base_agreement_id + 396; SET @parent_agreement_id = @base_agreement_id + 345; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [398/420] Rebeca Oxford de Yrureta → parent#12091 SET @child_agent_id = @base_agent_id + 397; SET @parent_agent_id = @base_agent_id + 19; SET @child_agreement_id = @base_agreement_id + 397; SET @parent_agreement_id = @base_agreement_id + 19; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [399/420] SAMIR GHANNOUM HITTI → parent#12095 SET @child_agent_id = @base_agent_id + 398; SET @parent_agent_id = @base_agent_id + 22; SET @child_agreement_id = @base_agreement_id + 398; SET @parent_agreement_id = @base_agreement_id + 22; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [400/420] Naskary Granadillo → parent#12048 SET @child_agent_id = @base_agent_id + 399; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 399; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [401/420] Alfredo Carrillo → parent#12048 SET @child_agent_id = @base_agent_id + 400; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 400; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [402/420] JOEL GARCIA → parent#12048 SET @child_agent_id = @base_agent_id + 401; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 401; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [403/420] Maria Milagros Vazquez → parent#12048 SET @child_agent_id = @base_agent_id + 402; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 402; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [404/420] Milagros Valladares de Figueira → parent#12048 SET @child_agent_id = @base_agent_id + 403; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 403; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [405/420] Francis Restrepo → parent#SL1014 SET @child_agent_id = @base_agent_id + 404; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 404; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [406/420] Natasha Gabriela Prince Quero → parent#12048 SET @child_agent_id = @base_agent_id + 405; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 405; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [407/420] Hector Jose Ramirez Bravo → parent#12048 SET @child_agent_id = @base_agent_id + 406; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 406; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [408/420] Paolo Hamann → parent#12069 SET @child_agent_id = @base_agent_id + 407; SET @parent_agent_id = @base_agent_id + 10; SET @child_agreement_id = @base_agreement_id + 407; SET @parent_agreement_id = @base_agreement_id + 10; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [409/420] ROMAN ARTURO ROMERO MEZA → parent#12048 SET @child_agent_id = @base_agent_id + 408; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 408; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [410/420] Silvia E. Bukowitz → parent#12048 SET @child_agent_id = @base_agent_id + 409; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 409; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [411/420] Johana Andrade → parent#12048 SET @child_agent_id = @base_agent_id + 410; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 410; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [412/420] Ernesto Martinez → parent#12048 SET @child_agent_id = @base_agent_id + 411; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 411; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [414/420] Pedro Chavez → parent#33092 SET @child_agent_id = @base_agent_id + 413; SET @parent_agent_id = @base_agent_id + 289; SET @child_agreement_id = @base_agreement_id + 413; SET @parent_agreement_id = @base_agreement_id + 289; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [415/420] Liliana Rodriguez → parent#12048 SET @child_agent_id = @base_agent_id + 414; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 414; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [417/420] Ibrahim Gonzalez → parent#12048 SET @child_agent_id = @base_agent_id + 416; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 416; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [418/420] Alfredo Ramirez → parent#12048 SET @child_agent_id = @base_agent_id + 417; SET @parent_agent_id = @base_agent_id + 0; SET @child_agreement_id = @base_agreement_id + 417; SET @parent_agreement_id = @base_agreement_id + 0; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [419/420] Fernando Contreras → parent#SL1014 SET @child_agent_id = @base_agent_id + 418; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 418; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- [420/420] Eduardo Acosta Barreto → parent#SL1014 SET @child_agent_id = @base_agent_id + 419; SET @parent_agent_id = @base_agent_id + 417; SET @child_agreement_id = @base_agreement_id + 419; SET @parent_agreement_id = @base_agreement_id + 417; INSERT INTO commercial_structure (id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@commercial_structure_id, @child_agent_id, @child_agreement_id, NOW(), NOW()); INSERT INTO agency_level (id, commercial_structure_id, general_agent_id, agreement_id, created_at, updated_at) VALUES (@agency_level_id, @commercial_structure_id, @parent_agent_id, @parent_agreement_id, NOW(), NOW()); SET @commercial_structure_id = @commercial_structure_id + 1; SET @agency_level_id = @agency_level_id + 1; -- ======================================== -- ACTUALIZAR REFERENCIAS INVERSAS -- ======================================== -- Actualizar agreement.commercial_structure_id para los 349 agentes con jerarquía interna UPDATE agreement a INNER JOIN commercial_structure cs ON cs.agreement_id = a.id AND cs.general_agent_id = a.agent_id SET a.commercial_structure_id = cs.id WHERE a.agent_id >= @base_agent_id AND a.agent_id <= (@base_agent_id + 419); -- Actualizar commercial_structure.agent_level_id = 6 (Level 2 - hijos de Open Insurances Level 1) UPDATE commercial_structure cs SET cs.agent_level_id = 6 WHERE cs.general_agent_id >= @base_agent_id AND cs.general_agent_id <= (@base_agent_id + 419);