-- ========================================
-- 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);
