-- ======================================== -- 03-insert-agreements.sql -- Segunda Carga Masiva Open Insurance -- ======================================== -- IMPORTANT: Incluye comisiones desde Excel columna Q -- Usa agreement_commission_type id=1 (New Business) -- Crea agreements para TODOS los registros: 371 agents + 49 agencies = 420 -- CRITICAL: agreement.agent_id → general_agent.id (NO person.id) -- Step 1: Crear compañía Open Insurance si no existe -- Verificar si ya existe SET @existing_company_id = (SELECT p.id FROM person p WHERE p.full_name = 'Open Insurance' LIMIT 1); -- Si no existe, crear nueva ID SET @open_insurance_person_id = IF(@existing_company_id IS NULL, (SELECT COALESCE(MAX(id), 0) + 1 FROM person), @existing_company_id); -- Person (tabla padre) - DTYPE DEBE SER 'legalperson' INSERT INTO person (id, full_name, dtype, is_active, created_at, updated_at, deleted_at) SELECT @open_insurance_person_id, 'Open Insurance', 'legalperson', 1, NOW(), NOW(), NULL FROM DUAL WHERE @existing_company_id IS NULL; -- LegalPerson INSERT INTO legal_person (id) SELECT @open_insurance_person_id FROM DUAL WHERE @existing_company_id IS NULL; -- Company (solo campos propios: id, code) INSERT INTO company (id, code) SELECT @open_insurance_person_id, 'OPEN' FROM DUAL WHERE @existing_company_id IS NULL; -- Obtener ID de la compañía (garantizado que existe) SET @company_id = @open_insurance_person_id; -- Step 2: Crear agreements y comisiones para TODOS los registros -- CRITICAL: Usar general_agent.id (NO person.id) SET @agent_id = (SELECT MAX(id) - 419 FROM general_agent); SET @agreement_id = (SELECT COALESCE(MAX(id), 0) + 1 FROM agreement); SET @commission_id = (SELECT COALESCE(MAX(id), 0) + 1 FROM agreement_commission); -- [1/420] Agreement: Open Insurance LLC (45.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 45.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [2/420] Agreement: Jason Wagner (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [3/420] Agreement: Daniel Feigenbaum (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [4/420] Agreement: Juan Carlos Fernandez Aleman (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [5/420] Agreement: Isabel Fernandez Aleman (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [6/420] Agreement: La Coordinadora La Coordinadora (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [7/420] Agreement: Jose Felipe Herrera Calcano (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [8/420] Agreement: Gonzalo Veloz (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [9/420] Agreement: Ricardo Salas Martinez (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [10/420] Agreement: Anna Fusella (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [11/420] Agreement: Maria del Pilar Avendano Cisneros (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [12/420] Agreement: Alfredo Jose Martinez Bermudez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [13/420] Agreement: Wendy Moya (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [14/420] Agreement: Maria Ciniglio (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [15/420] Agreement: Ana Teresa Fernandez Aleman (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [16/420] Agreement: Ysmerai Loundior (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [17/420] Agreement: Raquel Munoz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [18/420] Agreement: Dale Neuenschwander (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [19/420] Agreement: Lenny Trivino (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [20/420] Agreement: Luis Avila Merino (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [21/420] Agreement: Guillermo Ochoa (15.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 15.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [22/420] Agreement: Paolo Nicolicchia (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [23/420] Agreement: Gustavo Rojas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [24/420] Agreement: Gustavo Rojas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [25/420] Agreement: Ainola Iturralde (15.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 15.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [26/420] Agreement: Kevin Ryan (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [27/420] Agreement: Ranjeeta Singh (10.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 10.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [28/420] Agreement: David Waich (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [29/420] Agreement: Antonio Sanchez (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [30/420] Agreement: Miguel Ratini (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [31/420] Agreement: Mark Wiersma (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [32/420] Agreement: Alejandro Pages (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [33/420] Agreement: Cesar Michelangeli Cesar Michelangeli (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [34/420] Agreement: Luis Cercos Ruiz (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [35/420] Agreement: Anabelle Fernandez Soto (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [36/420] Agreement: Mayda Acosta (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [37/420] Agreement: Mikelander Aldecoa (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [38/420] Agreement: Laura Tinoco de Gonzalez (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [39/420] Agreement: ADONIS TOMEY (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [40/420] Agreement: Grecia Alejandra Chacon Duran (15.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 15.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [41/420] Agreement: Alfredo Benedettti Punceles (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [42/420] Agreement: JORGE LUIS MIRELES CRESPO (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [43/420] Agreement: JOHAN LEAL SALGUERO (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [44/420] Agreement: Julio Canas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [45/420] Agreement: RAFAEL CORDERO (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [46/420] Agreement: Oriana Marino (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [47/420] Agreement: Johnny Blatt (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [48/420] Agreement: Tony Sosa (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [49/420] Agreement: Ricardo Villarroel (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [50/420] Agreement: GUSTAVO MASSIANI (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [51/420] Agreement: Eduardo Montero Gonzalez (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [52/420] Agreement: REINALDO LAINVILLE TIRADO (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [53/420] Agreement: Carlos Cordero Vazquez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [54/420] Agreement: Jackleny Castro (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [55/420] Agreement: Marisela Franzius (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [56/420] Agreement: John Fredy Sanchez Sepulveda (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [57/420] Agreement: Julio Salas Reyes (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [58/420] Agreement: Isidro Nava (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [59/420] Agreement: Walter Patricelli (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [60/420] Agreement: Carlos Velarde (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [61/420] Agreement: Sarai Tovar Martinez (15.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 15.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [62/420] Agreement: Jose Oliveira (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [63/420] Agreement: John Johnson Fischel (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [64/420] Agreement: Andrea Sofia Reyes Arvelo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [65/420] Agreement: Servio Tulio Rangel (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [66/420] Agreement: Ana Clemencia Vivas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [67/420] Agreement: Adriana Rivas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [68/420] Agreement: Salomon Abadi (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [69/420] Agreement: Marysol Roca Marysol Roca (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [70/420] Agreement: Alvaro Sucre Guruceaga (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [71/420] Agreement: Sofia Alejandra Fernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [72/420] Agreement: Angela Viviana Sanchez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [73/420] Agreement: Monserrat Feliu (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [74/420] Agreement: Jenny Alvarado (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [75/420] Agreement: Andrea Figueroa Ravell (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [76/420] Agreement: Luis Alberto Ricaurte Chumo (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [77/420] Agreement: Ana Maria Chiriboga (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [78/420] Agreement: Thais Moreno (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [79/420] Agreement: Jacob Mizrahi (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [80/420] Agreement: Maria Elisa Monaco (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [81/420] Agreement: Andreina Avellaneda (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [82/420] Agreement: Ascensio Cercio (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [83/420] Agreement: Oriana Gabriela Marino Morales (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [84/420] Agreement: Jennifer Tomassetti (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [85/420] Agreement: David Eline (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [86/420] Agreement: Vanessa Jimenez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [87/420] Agreement: Jaime Rafael Inciarte Molero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [88/420] Agreement: Jose Vargas Hungria (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [89/420] Agreement: Rafael Jose Urribarri (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [90/420] Agreement: Sandra Rodriguez (15.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 15.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [91/420] Agreement: Adriana Yumar (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [92/420] Agreement: Alfredo Troconis (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [93/420] Agreement: Ana Borga (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [94/420] Agreement: Ana Elizabeth Coll de Casado (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [95/420] Agreement: Ana Teresa Celis (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [96/420] Agreement: Ana Victoria Borga (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [97/420] Agreement: Anastasia Romero Tovar (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [98/420] Agreement: Andreina Sucre (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [99/420] Agreement: Anita Tantino (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [100/420] Agreement: Arturo Chirinos (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [101/420] Agreement: Belisa Vegas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [102/420] Agreement: Blanca Marlene Mayorca (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [103/420] Agreement: Carlos Eduardo Guerra (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [104/420] Agreement: Claudia Guanipa (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [105/420] Agreement: Dharla Maldonado (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [106/420] Agreement: Diana Sosa (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [107/420] Agreement: Dixon Gonzalez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [108/420] Agreement: Fernando Santos (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [109/420] Agreement: Gianni Russo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [110/420] Agreement: Gladys Moros (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [111/420] Agreement: Guillermo Ponte (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [112/420] Agreement: Hector Gonzalez Pineda (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [113/420] Agreement: Irma Fernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [114/420] Agreement: Jeannie Pacheco (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [115/420] Agreement: Jenisse Arellano (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [116/420] Agreement: Jose Antonio Madriz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [117/420] Agreement: Jose Ignacio Sucre (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [118/420] Agreement: Juan Ignacio Sucre (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [119/420] Agreement: Rebeca Payares (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [120/420] Agreement: Beatriz Grau (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [121/420] Agreement: Ligia Jaimes (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [122/420] Agreement: Rodolfo Casado (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [123/420] Agreement: Rafael Diaz Lovera (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [124/420] Agreement: Lisbeth Perez (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [125/420] Agreement: Lorena Bracho (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [126/420] Agreement: Magin Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [127/420] Agreement: Manuel Andres Diaz Sucre (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [128/420] Agreement: Maria Gabriela Vega (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [129/420] Agreement: Maria Valentina Diaz Sucre (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [130/420] Agreement: Mary Fiorellys Barrios (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [131/420] Agreement: Natascha Benavides (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [132/420] Agreement: Rene Selem (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [133/420] Agreement: Sandra Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [134/420] Agreement: Magaly Suarez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [135/420] Agreement: Antonio Sanz (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [136/420] Agreement: Charlie Correa (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [137/420] Agreement: Jose Rafael Ribas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [138/420] Agreement: Claudia Diaz (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [139/420] Agreement: Jose Enrique Diaz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [140/420] Agreement: Leonardo Lossada (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [141/420] Agreement: Alberto Colina (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [142/420] Agreement: Victor Babino (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [143/420] Agreement: Jesus Rondon Benaim (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [144/420] Agreement: Maria Gabriela Neri Luciani (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [145/420] Agreement: Guillermo Marcano (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [146/420] Agreement: Doris de Matattia (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [147/420] Agreement: Andreina Avila (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [148/420] Agreement: Nabis de Jesus Mendoza Garcia (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [149/420] Agreement: Ricardo Rafael Raven Matheus (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [150/420] Agreement: Faine Coromoto Hernandez Sierra (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [151/420] Agreement: Nadeska Carolina Pina Garrido (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [152/420] Agreement: Erik Dupret (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [153/420] Agreement: Carlos Eduardo Boccaccini (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [154/420] Agreement: Monica Cristina Lecuna (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [155/420] Agreement: Hector Fernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [156/420] Agreement: Hilda Ballester (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [157/420] Agreement: Jose Humberto Barazarte (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [158/420] Agreement: Adrian Duque (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [159/420] Agreement: Andres Marquez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [160/420] Agreement: Maria Daniela Alcala Lis (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [161/420] Agreement: Manuela García de Carrasquero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [162/420] Agreement: Barbara Velasquez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [163/420] Agreement: Luis C. Dominguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [164/420] Agreement: Juan Alvaro Lopez Hernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [165/420] Agreement: Luis Fernando Avila Boffil (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [166/420] Agreement: Antonio Sotillo Rosales (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [167/420] Agreement: Maria Auxiliadora Ramirez Maria Auxiliadora Ramirez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [168/420] Agreement: Alvaro Cesar Almaral (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [169/420] Agreement: Marisela Rincon (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [170/420] Agreement: Adriana Carolina Lorenzo Triana (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [171/420] Agreement: Maria Soledad Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [172/420] Agreement: Rosa Perez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [173/420] Agreement: Pilar Bello (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [174/420] Agreement: Juan Carlos Sucre Chapellin (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [175/420] Agreement: Iliana Zeppenfeldt (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [176/420] Agreement: Arnoldo Jimenez Canino (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [177/420] Agreement: Maria Eugenia Coronado Garcia (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [178/420] Agreement: Jorge Enrique Zafra Ramirez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [179/420] Agreement: Beatriz Lopez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [180/420] Agreement: Maria Fernanda Obediente (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [181/420] Agreement: Francisco Viloria (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [182/420] Agreement: Karla Gamarra (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [183/420] Agreement: Libe Pereira de Arriola (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [184/420] Agreement: Carlos Alfredo Noguera Gil (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [185/420] Agreement: Morella Garcia (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [186/420] Agreement: Federica Iturriza (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [187/420] Agreement: Maria Alejandra Arriaga (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [188/420] Agreement: Belkys Zuleta (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [189/420] Agreement: Pablo Luis Ramos Fuentes (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [190/420] Agreement: Luis Armando Cerezo Soto (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [191/420] Agreement: Claudia Blanco (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [192/420] Agreement: Maria Fernanda Zuluaga (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [193/420] Agreement: Mayerling Sayago (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [194/420] Agreement: Monica Finol Monica Finol (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [195/420] Agreement: Gabriela Pernetz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [196/420] Agreement: Ricardo Angles Perez (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [197/420] Agreement: Belisa Vegas Castro (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [198/420] Agreement: Diana Cordero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [199/420] Agreement: Valenttina Fernandes (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [200/420] Agreement: Jacqueline Marvez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [201/420] Agreement: Luis Manuel Vargas Marcano (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [202/420] Agreement: Alains Figueroa Alains Figueroa (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [203/420] Agreement: Eliana Yanez Angel (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [204/420] Agreement: Alejandro Sandoval (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [205/420] Agreement: Domingo Morales (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [206/420] Agreement: Pedro Luis Tineo Marcano (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [207/420] Agreement: Rodolfo Vera Vera (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [208/420] Agreement: Damelys Dadiotis (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [209/420] Agreement: Carlos Scott (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [210/420] Agreement: Guillermo Schutte (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [211/420] Agreement: Mercedes Palacios (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [212/420] Agreement: Maria Carolina Vega Colina (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [213/420] Agreement: Noraima Colmenares (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [214/420] Agreement: Isabela Sequera (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [215/420] Agreement: Gustavo Bandes (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [216/420] Agreement: Cristian Milagro Guedez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [217/420] Agreement: Regina Friedman (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [218/420] Agreement: Kira Kariakin (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [219/420] Agreement: Yasmin Mesa (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [220/420] Agreement: Yanubis Luc Yanubis Luc (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [221/420] Agreement: Maria Schutte (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [222/420] Agreement: Corini Pantoja (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [223/420] Agreement: Gustavo Gomez (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [224/420] Agreement: Mario Leon Chirinos (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [225/420] Agreement: Agustin Da Silva-Diaz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [226/420] Agreement: Larry Padron (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [227/420] Agreement: Adrian Lopez De Aguiar (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [228/420] Agreement: Jose Uzcategui Amare (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [229/420] Agreement: Sandra Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [230/420] Agreement: Doris Perez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [231/420] Agreement: Johann Gomez Sanchez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [232/420] Agreement: Valerie Obregon Aguilera (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [233/420] Agreement: Ivan Vezga (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [234/420] Agreement: Fernando Vera Useche (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [235/420] Agreement: Elimar Hung Nieves (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [236/420] Agreement: Fabiola Tejada (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [237/420] Agreement: Patricia Arriete V. (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [238/420] Agreement: Luz Tarborda B. (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [239/420] Agreement: Maria Mineses Contreras (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [240/420] Agreement: Jorge Chacon L (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [241/420] Agreement: Andrea Leon (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [242/420] Agreement: Claudia De Urdaneta (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [243/420] Agreement: Juan Mila de la Roca (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [244/420] Agreement: Jorge Ojeda (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [245/420] Agreement: Ricardo Gomez Otto (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [246/420] Agreement: Maribel Briceno (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [247/420] Agreement: Ginett Luces (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [248/420] Agreement: Juan Targa (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [249/420] Agreement: Jose Narvaez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [250/420] Agreement: Nerio Socorro (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [251/420] Agreement: Cecilio Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [252/420] Agreement: Tannya Lisseth Sierra Quiroga (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [253/420] Agreement: Lisbeth Josefina Seijas Pineda (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [254/420] Agreement: Jacqueline Bali Jacqueline Bali (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [255/420] Agreement: MARIELYS SEMPRUN (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [256/420] Agreement: Maria Jose Couri Araujo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [257/420] Agreement: Oscar Freites (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [258/420] Agreement: Guido Pena (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [259/420] Agreement: Maria Gracia Cruz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [260/420] Agreement: Cesareo Belsol (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [261/420] Agreement: Ana Isabel Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [262/420] Agreement: Jorge Villamizar (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [263/420] Agreement: MARIA TERESA RIVAS (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [264/420] Agreement: Cesar Hulett (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [265/420] Agreement: Maria Elvia Becerra Maria Elvia Becerra (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [266/420] Agreement: Kassandra Fagundez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [267/420] Agreement: Julian Gonzalez Balbo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [268/420] Agreement: Omar Alfredo Gutierrez Guerrero Gutierrez Guerrero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [269/420] Agreement: Ignacio Jaramillo Abondano (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [270/420] Agreement: Adolfo Cumana (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [271/420] Agreement: Kenic Narvarro (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [272/420] Agreement: Carlos Montero (15.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 15.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [273/420] Agreement: Jesus Ugas (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [274/420] Agreement: Karelia Gomez Martinez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [275/420] Agreement: David Waich (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [276/420] Agreement: Maria Alejandra Tovar Ojeda (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [277/420] Agreement: Maria Idalina Rodriguez Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [278/420] Agreement: Gabriella Lopez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [279/420] Agreement: Roberto Aldecoa (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [280/420] Agreement: Miguel Pasquariello (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [281/420] Agreement: Pascual Miguel Quagliano (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [282/420] Agreement: Heremar Mercedes Morales Daal (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [283/420] Agreement: Maria Carolina Crespo Gonzalez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [284/420] Agreement: Hector Alfredo Reyes Franco (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [285/420] Agreement: Evelyn Josefina Rondon Benaim (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [286/420] Agreement: Marianne Delgado (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [287/420] Agreement: Gustavo Bergstrom (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [288/420] Agreement: Gladys Moros Nieto (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [289/420] Agreement: Giovanni Rossomando de la Rosa (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [290/420] Agreement: Enzo Isaias Herrera Fernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [291/420] Agreement: ROBERTO BAEZ DUARTE (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [292/420] Agreement: Alejandro Osorio (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [293/420] Agreement: Marelvis Coraspe (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [294/420] Agreement: Jose Manuel Galanton Hernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [295/420] Agreement: Ivan Gonima (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [296/420] Agreement: Oswaldo Prada (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [297/420] Agreement: Alfredo Osiglia (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [298/420] Agreement: MARYOLEY CAROLINA VIVAS GIL (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [299/420] Agreement: LIZZET RICCARDI (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [300/420] Agreement: Nathaly Rojas Aguilera (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [301/420] Agreement: Wilson Molina Sanguino (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [302/420] Agreement: Jon Olabeaga Urresti (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [303/420] Agreement: Oswaldo Figueroa (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [304/420] Agreement: German Villarreal (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [305/420] Agreement: John Nathan Marin Gonzalez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [306/420] Agreement: Dainazet Robespierre (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [307/420] Agreement: Tomas Andara (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [308/420] Agreement: Lenis Silva (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [309/420] Agreement: Bernardo Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [310/420] Agreement: Carlos Tagliaferro (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [311/420] Agreement: Antonio Jose Osorio Sifontes (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [312/420] Agreement: Beatriz Gabriela Arias Petit (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [313/420] Agreement: Castor Fernandez Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [314/420] Agreement: Jesus Rodrigues (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [315/420] Agreement: Rocco Nardulli (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [316/420] Agreement: Excellence Asesores CA (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [317/420] Agreement: Luisa Viso (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [318/420] Agreement: Elizabeth Johnson (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [319/420] Agreement: Audry Gonzalez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [320/420] Agreement: Cristobal Alvelo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [321/420] Agreement: Marlene Fernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [322/420] Agreement: Ambar Arredondo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [323/420] Agreement: ELVIA MORENO (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [324/420] Agreement: Olga Herrera (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [325/420] Agreement: kristen Pena (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [326/420] Agreement: Johnny Paz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [327/420] Agreement: Jhoanna Querales (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [328/420] Agreement: Ariadna Quroz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [329/420] Agreement: Marycarmen Hurtado (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [330/420] Agreement: Rosangela Diaz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [331/420] Agreement: Elisa Baez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [332/420] Agreement: Erick Oropeza (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [333/420] Agreement: Andreyna Molla (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [334/420] Agreement: Gisel Morillo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [335/420] Agreement: Mariangie Reverol (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [336/420] Agreement: Mariangie Reverol (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [337/420] Agreement: ANTONIO SIFONTES (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [338/420] Agreement: Maria Arenas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [339/420] Agreement: Joselyn Aguilar (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [340/420] Agreement: Anabella Vazquez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [341/420] Agreement: Patricia Gil Porto (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [342/420] Agreement: Marys Soto (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [343/420] Agreement: Johana Sanchez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [344/420] Agreement: Vicente Emilio Alvarez Jimenez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [345/420] Agreement: ELIZBETH MARTORELLI (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [346/420] Agreement: Liseth Segovia (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [347/420] Agreement: Paulo Tabares Ramirez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [348/420] Agreement: Elena Socorro Flores (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [349/420] Agreement: Jenny VivasVasquez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [350/420] Agreement: Mabelis Del Valle Suarez Viloria (15.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 15.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [351/420] Agreement: Anibal Valero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [352/420] Agreement: Antonio Guruceaga (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [353/420] Agreement: Claudia Diaz Picon (20.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 20.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [354/420] Agreement: Larissa Pinto Pina (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [355/420] Agreement: DANIELLA NAVA RUBIANO (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [356/420] Agreement: THAIS DELGADO (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [357/420] Agreement: Pablo Martinez-Acero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [358/420] Agreement: Claudia Tosta Vargas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [359/420] Agreement: Aitza Medina (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [360/420] Agreement: Veronica Camacho (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [361/420] Agreement: Bianeys Barreto Centeno (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [362/420] Agreement: Fernando Zuleta (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [363/420] Agreement: Maria Rubiano (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [364/420] Agreement: Rosalyn Fonseca (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [365/420] Agreement: Veronica Suarez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [366/420] Agreement: Manuel De Pablos Barboza (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [367/420] Agreement: Maria Isolina Martinez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [368/420] Agreement: Yeraldit Barreto (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [369/420] Agreement: Rafael Antonio Jimenez Gonzalez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [370/420] Agreement: ALLYSON HERNANDO ALCON (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [371/420] Agreement: AMERICA CLORINDA BECK RODRIGUEZ (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [372/420] Agreement: Ramon Cabrera (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [373/420] Agreement: ana rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [374/420] Agreement: Dacio Sosa (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [375/420] Agreement: Jeanette Garcia (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [376/420] Agreement: Carlos Garcia Romero (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [377/420] Agreement: Raiza Marlene Villegas (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [378/420] Agreement: Vanessa Rendón (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [379/420] Agreement: Rodolfo Montero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [380/420] Agreement: Tamara Gonzalez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [381/420] Agreement: Vanessa Rendón (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [382/420] Agreement: Maria Vasquez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [383/420] Agreement: Rosa Prado (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [384/420] Agreement: Tahiruma Colina (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [385/420] Agreement: CARLA VIRGINIA GUTIERREZ SOCORRO (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [386/420] Agreement: LUZ MALDONADO (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [387/420] Agreement: MARIA BETHINA SARCOS (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [388/420] Agreement: Nancy Almanzar (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [389/420] Agreement: Lidiana Fernandez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [390/420] Agreement: Liz Perozo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [391/420] Agreement: Amir Asaff (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [392/420] Agreement: Javier Garcia (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [393/420] Agreement: Douglas Gonzalez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [394/420] Agreement: Marielina Herrera (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [395/420] Agreement: Fabiana Pacheco (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [396/420] Agreement: Miguel Indavec (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [397/420] Agreement: Estepfanny Castillo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [398/420] Agreement: Rebeca Oxford de Yrureta (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [399/420] Agreement: SAMIR GHANNOUM HITTI (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [400/420] Agreement: Naskary Granadillo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [401/420] Agreement: Alfredo Carrillo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [402/420] Agreement: JOEL GARCIA (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [403/420] Agreement: Maria Milagros Vazquez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [404/420] Agreement: Milagros Valladares de Figueira (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [405/420] Agreement: Francis Restrepo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [406/420] Agreement: Natasha Gabriela Prince Quero (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [407/420] Agreement: Hector Jose Ramirez Bravo (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [408/420] Agreement: Paolo Hamann (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [409/420] Agreement: ROMAN ARTURO ROMERO MEZA (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [410/420] Agreement: Silvia E. Bukowitz (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [411/420] Agreement: Johana Andrade (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [412/420] Agreement: Ernesto Martinez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [413/420] Agreement: Beatriz Leon (30.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 30.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [414/420] Agreement: Pedro Chavez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [415/420] Agreement: Liliana Rodriguez (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [416/420] Agreement: GISELA PEREZ GOMES (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [417/420] Agreement: Ibrahim Gonzalez (35.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 35.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [418/420] Agreement: Alfredo Ramirez (40.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 40.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [419/420] Agreement: Fernando Contreras (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1; -- [420/420] Agreement: Eduardo Acosta Barreto (25.0%) INSERT INTO agreement_commission (id, type_id, value, is_active, created_at, updated_at, deleted_at) VALUES (@commission_id, 1, 25.0, 1, NOW(), NOW(), NULL); INSERT INTO agreement (id, agent_id, status_id, company_id, number, valid_from, valid_to, created_at, updated_at, deleted_at) VALUES (@agreement_id, @agent_id, 1, @company_id, CONCAT('AGR-', LPAD(@agreement_id, 6, '0')), NOW(), NULL, NOW(), NOW(), NULL); INSERT INTO agreements_commissions (agreement_id, agreement_commission_id) VALUES (@agreement_id, @commission_id); SET @agent_id = @agent_id + 1; SET @agreement_id = @agreement_id + 1; SET @commission_id = @commission_id + 1;