
SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'F-150' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2023' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XLT Lariat' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 139.7, '311462', 0);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2020' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Premium' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 112, '12862', 1693986725);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2020' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Premium Plus' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 112, '12863', 1693986725);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2022' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Prestige' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 112, '273843', 1693986739);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2022' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Premium Plus' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 112, '273844', 1693986739);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2022' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Premium' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 112, '273845', 1693986739);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2023' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Premium Plus' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 112, '296925', 1693986746);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2023' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Premium' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 112, '296927', 1693986746);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Eldorado' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ESC' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4485', 1697790128);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Eldorado' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ETC' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4486', 1697790128);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '300M' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3012', 1697790133);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Concorde' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LX' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3031', 1697790133);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Concorde' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LXi' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3032', 1697790133);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ES' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3932', 1697790135);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'High Line' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3933', 1697790136);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Cougar' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6331', 1697790156);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Cougar' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'V6' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6332', 1697790156);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mystique' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'GS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6354', 1697790157);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mystique' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6355', 1697790157);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Villager' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Estate' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '67133', 1697790157);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Villager' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Sport' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '67134', 1697790157);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Villager' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '67135', 1697790157);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Bonneville' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '5116', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Bonneville' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '5117', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Bonneville' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SSEi' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '5118', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5134', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5135', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Formula' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5136', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Trans Am' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5137', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Trans Am' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5138', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2000' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Formula' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5139', 1697790159);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Eldorado' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ESC' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4487', 1697790167);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Eldorado' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ETC' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4488', 1697790167);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '300M' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3013', 1697790172);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Concorde' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LX' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3033', 1697790172);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Concorde' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LXi' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3034', 1697790172);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ACR' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3918', 1697790173);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3919', 1697790173);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ES' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3920', 1697790173);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'R/T' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3921', 1697790173);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3922', 1697790173);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Cougar' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6333', 1697790185);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Cougar' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'V6' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6335', 1697790185);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Cougar' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'S' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6336', 1697790185);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Villager' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Estate' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '67136', 1697790185);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Villager' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Sport' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '67137', 1697790185);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Villager' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '67138', 1697790185);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Aztek' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '35174', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Aztek' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'GT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '35176', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Bonneville' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '5119', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Bonneville' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '5120', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Bonneville' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SSEi' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '5121', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5140', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5141', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Formula' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5142', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Trans Am' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5143', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'PONTIAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Firebird' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2001' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Trans Am' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120.65, '5144', 1697790188);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'DeVille' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4463', 1697790199);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'DeVille' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4464', 1697790199);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'DeVille' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4465', 1697790199);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'DeVille' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'DHS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4466', 1697790199);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'DeVille' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'DTS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4467', 1697790199);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Eldorado' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ESC' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4489', 1697790200);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Eldorado' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ETC' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '4490', 1697790200);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '300M' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3014', 1697790209);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '300M' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Special' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3015', 1697790209);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Concorde' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LX' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3036', 1697790209);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Concorde' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LXi' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3037', 1697790209);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Concorde' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Limited' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '3038', 1697790209);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ACR' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3925', 1697790211);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'R/T' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3926', 1697790211);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3927', 1697790211);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ES' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3928', 1697790211);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '3931', 1697790211);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Neon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'S' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 100, '273932', 1697790211);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HUMMER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'H1' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 8, 165.1, '50917', 1697790223);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Cougar' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6337', 1697790227);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Cougar' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'V6' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 108, '6339', 1697790227);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sable' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'GS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 108, '6367', 1697790227);
SET @groupId = LAST_INSERT_ID();



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sable' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2002' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'GS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 108, '6368', 1697790227);
SET @groupId = LAST_INSERT_ID();