
SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 6, 139.7, '31803', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 7.5, 7.5, 255, 255, 'OR', '3deba7dfcc75543e333cabce1b5202a8', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OR', '807866a037614df1ae9fc9bea134f712', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (55, 55, 20, 20, 9, 9, 275, 275, 'OP', '68ef29c821155af3f53328eb9a1519a3', @groupId,0),
    (45, 45, 22, 22, 8, 8, 285, 285, 'OP', 'd379cf7f14645b83164a17d26ad8b2d8', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Denali' 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, 6, 139.7, '31811', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 20, 20, 9, 9, 275, 275, 'OR', '467df53db9b387a1db06945277ce7e00', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OP', 'b74e2e192c58e3a018d8e6170358db1b', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Terrain' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Denali' 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, '56016', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7, 7, 235, 235, 'OR', '57187f8bf7f7d7ec1822890740ba2252', @groupId,0),
    (55, 55, 19, 19, 7, 7, 235, 235, 'OR', 'b99b8bb7c041eb66065d81a580db164d', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0),
    (60, 60, 17, 17, 7, 7, 235, 235, 'OP', '8b21cae39e0fcfb8bad352f2155465a2', @groupId,0),
    (60, 60, 18, 18, 7, 7, 225, 225, 'OP', '617ab5d5a8ff558f74a5768c5439cb1d', @groupId,0),
    (55, 55, 18, 18, 7, 7, 235, 235, 'OP', 'ea14fff92bcba6405d10ba75443865bc', @groupId,0),
    (55, 55, 18, 18, 7, 7, 225, 225, 'OP', '14aa3291652b1a3782f6900a0234d708', @groupId,0),
    (50, 50, 19, 19, 7, 7, 235, 235, 'OP', 'b99304db96082598f5dc3815861ca3dc', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Terrain' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLT' 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, '56020', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 17, 17, 7, 7, 235, 235, 'OR', '9de2ef8340b12c38c583a67806215c55', @groupId,0),
    (55, 55, 18, 18, 7, 7, 235, 235, 'OR', '57187f8bf7f7d7ec1822890740ba2252', @groupId,0),
    (55, 55, 19, 19, 7, 7, 235, 235, 'OR', 'b99b8bb7c041eb66065d81a580db164d', @groupId,0),
    (50, 50, 19, 19, 7, 7, 235, 235, 'OR', '8136a35a1f4cfdd2a5a48e58d2b370c9', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0),
    (60, 60, 18, 18, 7, 7, 225, 225, 'OP', '617ab5d5a8ff558f74a5768c5439cb1d', @groupId,0),
    (55, 55, 18, 18, 7, 7, 235, 235, 'OP', 'ea14fff92bcba6405d10ba75443865bc', @groupId,0),
    (55, 55, 18, 18, 7, 7, 225, 225, 'OP', '14aa3291652b1a3782f6900a0234d708', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Terrain' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 120, '56024', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 17, 17, 7, 7, 235, 235, 'OR', '9de2ef8340b12c38c583a67806215c55', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0),
    (60, 60, 18, 18, 7, 7, 225, 225, 'OP', '617ab5d5a8ff558f74a5768c5439cb1d', @groupId,0),
    (55, 55, 18, 18, 7, 7, 235, 235, 'OP', 'ea14fff92bcba6405d10ba75443865bc', @groupId,0),
    (55, 55, 18, 18, 7, 7, 225, 225, 'OP', '14aa3291652b1a3782f6900a0234d708', @groupId,0),
    (55, 55, 19, 19, 7, 7, 235, 235, 'OP', 'd790fb0a79d943d3a3ff6c8dc72ac0f5', @groupId,0),
    (50, 50, 19, 19, 7, 7, 235, 235, 'OP', 'b99304db96082598f5dc3815861ca3dc', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX' 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, '6925', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OR', 'df18745ba3cd0ad4fb38993070e62fda', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX' 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, '6926', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OR', 'df18745ba3cd0ad4fb38993070e62fda', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX-L' 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, '6927', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OR', 'df18745ba3cd0ad4fb38993070e62fda', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX-L' 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, '6928', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OR', 'df18745ba3cd0ad4fb38993070e62fda', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'HF' 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, '6929', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Hybrid' 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, '6930', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Hybrid-L' 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, '6931', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '6932', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '6933', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Natural Gas' 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, '6934', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Si' 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, '6935', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0),
    (40, 40, 18, 18, 7, 7, 215, 215, 'OP', '33647744c8caa80928a08821478d0e1d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Si' 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, '6936', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'DX' 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, '6937', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Civic' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Touring' 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, '6938', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7, 7, 215, 215, 'OR', 'b1709aa5211f6833f00c99bd15661822', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6.5, 6.5, 205, 205, 'OP', '080edd649d08bef84ea3c1c8fdba3c3c', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'CR-V' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX' 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, '43412', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (70, 70, 16, 16, 6.5, 6.5, 215, 215, 'OP', '1ad2b1dc3d291e144c6ad8652def427c', @groupId,0),
    (60, 60, 18, 18, 7, 7, 225, 225, 'OP', '617ab5d5a8ff558f74a5768c5439cb1d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'CR-V' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX-L' 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, '43414', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (70, 70, 16, 16, 6.5, 6.5, 215, 215, 'OP', '1ad2b1dc3d291e144c6ad8652def427c', @groupId,0),
    (60, 60, 18, 18, 7, 7, 225, 225, 'OP', '617ab5d5a8ff558f74a5768c5439cb1d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'CR-V' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '43416', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 16, 16, 6.5, 6.5, 215, 215, 'OR', '07d4941557c7ab8c0442fd1cdbfa9091', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0),
    (60, 60, 18, 18, 7, 7, 225, 225, 'OP', '617ab5d5a8ff558f74a5768c5439cb1d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'CR-V' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Touring' 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, '43418', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (70, 70, 16, 16, 6.5, 6.5, 215, 215, 'OP', '1ad2b1dc3d291e144c6ad8652def427c', @groupId,0),
    (60, 60, 18, 18, 7, 7, 225, 225, 'OP', '617ab5d5a8ff558f74a5768c5439cb1d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'CR-Z' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '16735', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 6, 6, 195, 195, 'OR', 'c20d364789effecf27c2b82f13912283', @groupId,0),
    (45, 45, 17, 17, 6.5, 6.5, 205, 205, 'OP', 'b007509c8fb21ae5adf33f3ad4b52444', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'CR-Z' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX' 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, '16736', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 6, 6, 195, 195, 'OR', 'c20d364789effecf27c2b82f13912283', @groupId,0),
    (45, 45, 17, 17, 6.5, 6.5, 205, 205, 'OP', 'b007509c8fb21ae5adf33f3ad4b52444', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'CR-Z' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 114.3, '16737', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 6.5, 6.5, 205, 205, 'OR', '1ef19a57c247aa5457511df3d1eed508', @groupId,0),
    (55, 55, 16, 16, 6, 6, 195, 195, 'OP', '1d2e546888edfabe847896f97c076fcd', @groupId,0),
    (45, 45, 17, 17, 6.5, 6.5, 205, 205, 'OP', 'b007509c8fb21ae5adf33f3ad4b52444', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Fit' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EV' 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, '13888', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 185, 185, 'OR', '0a0e34779530cd543f1a8639cab95dfd', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Fit' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 4, 100, '13889', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 6, 6, 185, 185, 'OR', 'a335282d40185c754f6244ad5ae496bf', @groupId,0),
    (65, 65, 15, 15, 5.5, 5.5, 175, 175, 'OP', '629ec6206502be1f52a396d244920359', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Fit' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'DX' 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, 100, '13890', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 5.5, 5.5, 175, 175, 'OR', '5a1f6267fba716b7939a76b7d7104bfa', @groupId,0),
    (55, 55, 16, 16, 6, 6, 185, 185, 'OP', '0b4e0e61ae8576e4018828ed91938bcb', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Fit' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 4, 100, '83317', 1697791066);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 5.5, 5.5, 175, 175, 'OR', '5a1f6267fba716b7939a76b7d7104bfa', @groupId,0),
    (55, 55, 16, 16, 6, 6, 185, 185, 'OP', '0b4e0e61ae8576e4018828ed91938bcb', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Odyssey' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX' 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, '67201', 1697791067);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 7, 7, 235, 235, 'OR', '2e12aa8dff0c3d0f3849c8685aa305e3', @groupId,0),
    (60, 60, 18, 18, 7, 7, 235, 235, 'OP', 'bf52bf4a4459f497acbea31ac3815e68', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Odyssey' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EX-L' 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, '67202', 1697791067);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 7, 7, 235, 235, 'OR', '2e12aa8dff0c3d0f3849c8685aa305e3', @groupId,0),
    (60, 60, 18, 18, 7, 7, 235, 235, 'OP', 'bf52bf4a4459f497acbea31ac3815e68', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Odyssey' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 120, '67203', 1697791067);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 7, 7, 235, 235, 'OR', '2e12aa8dff0c3d0f3849c8685aa305e3', @groupId,0),
    (60, 60, 18, 18, 7, 7, 235, 235, 'OP', 'bf52bf4a4459f497acbea31ac3815e68', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Odyssey' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Touring' 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, '67204', 1697791067);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 7, 7, 235, 235, 'OR', '2e12aa8dff0c3d0f3849c8685aa305e3', @groupId,0),
    (60, 60, 18, 18, 7, 7, 235, 235, 'OR', '20330f1ddbd561af9152fd170e975e4f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Odyssey' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Touring Elite' 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, '67205', 1697791067);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 18, 18, 7, 7, 235, 235, 'OR', '20330f1ddbd561af9152fd170e975e4f', @groupId,0),
    (65, 65, 17, 17, 7, 7, 235, 235, 'OP', '508acdf523521daf67d8b7d8954d45e2', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'HONDA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Odyssey' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 120, '67206', 1697791067);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 7, 7, 235, 235, 'OR', '2e12aa8dff0c3d0f3849c8685aa305e3', @groupId,0),
    (60, 60, 18, 18, 7, 7, 235, 235, 'OP', 'bf52bf4a4459f497acbea31ac3815e68', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Compass' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '51570', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 16, 16, 6.5, 6.5, 205, 205, 'OR', '193b1654894a456f87e182eb6cdd4c1a', @groupId,0),
    (60, 60, 17, 17, 6.5, 6.5, 215, 215, 'OR', '9cd210563d576520430352eded25e1cd', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 215, 215, 'OR', '2988438fa9aee2ac600c1a77377f657f', @groupId,0),
    (55, 55, 18, 18, 7, 7, 215, 215, 'OP', '548b0a81be8e3b44c716e0ba2cd8a066', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Compass' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '51574', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7, 7, 215, 215, 'OR', '0cd89741b543728c4c0b6ff6220d1aad', @groupId,0),
    (70, 70, 16, 16, 6.5, 6.5, 205, 205, 'OP', 'c7dc571e203c1d6f15fa80e9e32a7954', @groupId,0),
    (60, 60, 17, 17, 6.5, 6.5, 215, 215, 'OP', 'd698f48c412dd0a8b954040ec47ad256', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 215, 215, 'OP', '52785f368e97dbe9d9b30cbdeab35f61', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Compass' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Latitude' 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, '51576', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 17, 17, 6.5, 6.5, 215, 215, 'OR', '9cd210563d576520430352eded25e1cd', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 215, 215, 'OR', '2988438fa9aee2ac600c1a77377f657f', @groupId,0),
    (70, 70, 16, 16, 6.5, 6.5, 205, 205, 'OP', 'c7dc571e203c1d6f15fa80e9e32a7954', @groupId,0),
    (55, 55, 18, 18, 7, 7, 215, 215, 'OP', '548b0a81be8e3b44c716e0ba2cd8a066', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Compass' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'North' 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, '51580', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 17, 17, 6.5, 6.5, 215, 215, 'OR', '9cd210563d576520430352eded25e1cd', @groupId,0),
    (70, 70, 16, 16, 6.5, 6.5, 205, 205, 'OP', 'c7dc571e203c1d6f15fa80e9e32a7954', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 215, 215, 'OP', '52785f368e97dbe9d9b30cbdeab35f61', @groupId,0),
    (55, 55, 18, 18, 7, 7, 215, 215, 'OP', '548b0a81be8e3b44c716e0ba2cd8a066', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Grand Cherokee' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SRT' 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, 127, '23703', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 20, 20, 10, 10, 295, 295, 'OR', '27996204305927c7b602369a810e001b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Grand Cherokee' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Laredo' 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, 127, '23704', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 8, 8, 245, 245, 'OR', 'b2e6ecc896c7eedcc50c938e564f5c3b', @groupId,0),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OP', '76bfeb7c9e624ab58dd5931b3ec74a4a', @groupId,0),
    (50, 50, 20, 20, 8, 8, 265, 265, 'OP', '951577851b459bb3b416224c517d6a5b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Grand Cherokee' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 127, '23706', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 18, 18, 8, 8, 265, 265, 'OR', '4def77b3164781de6bde51239bd97ef4', @groupId,0),
    (70, 70, 17, 17, 8, 8, 245, 245, 'OP', 'a5a7a756c8bd1ab1061458c088ea89fe', @groupId,0),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OP', '76bfeb7c9e624ab58dd5931b3ec74a4a', @groupId,0),
    (50, 50, 20, 20, 8, 8, 265, 265, 'OP', '951577851b459bb3b416224c517d6a5b', @groupId,0);

SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Grand Cherokee' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Overland' 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, 127, '23712', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 18, 18, 8, 8, 265, 265, 'OR', '4def77b3164781de6bde51239bd97ef4', @groupId,0),
    (50, 50, 20, 20, 8, 8, 265, 265, 'OR', '968ce2eedbb155bb90d29a4cc34b6c0e', @groupId,0),
    (70, 70, 17, 17, 8, 8, 245, 245, 'OP', 'a5a7a756c8bd1ab1061458c088ea89fe', @groupId,0),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OP', '76bfeb7c9e624ab58dd5931b3ec74a4a', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Grand Cherokee' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Summit' 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, 127, '23718', 1697791070);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 20, 20, 8, 8, 265, 265, 'OR', '968ce2eedbb155bb90d29a4cc34b6c0e', @groupId,0),
    (70, 70, 17, 17, 8, 8, 245, 245, 'OP', 'a5a7a756c8bd1ab1061458c088ea89fe', @groupId,0),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OP', '76bfeb7c9e624ab58dd5931b3ec74a4a', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Wrangler' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Rubicon' 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, 127, '24115', 1697791071);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'ee1706d60ac6c477df3597b1793c2dfc', @groupId,0),
    (75, 75, 16, 16, 7, 7, 225, 225, 'OP', '195d831fb996b1d5eac69c5bad8ad90d', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 255, 255, 'OP', 'cf0268eb9c61e313f8a6ac498b31b894', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (70, 70, 18, 18, 7.5, 7.5, 255, 255, 'OP', '76efbf15b062cc985ad99353f7e9c1b4', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Wrangler' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Sahara' 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, 127, '24116', 1697791071);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 18, 18, 7.5, 7.5, 255, 255, 'OR', '837f47356f852a9b16e35d0522f45cc3', @groupId,0),
    (75, 75, 16, 16, 7, 7, 225, 225, 'OP', '195d831fb996b1d5eac69c5bad8ad90d', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 255, 255, 'OP', 'cf0268eb9c61e313f8a6ac498b31b894', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Wrangler' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 127, '24117', 1697791071);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (75, 75, 16, 16, 7, 7, 225, 225, 'OR', '37864a691b86f3992d52852ea8465b54', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 255, 255, 'OP', 'cf0268eb9c61e313f8a6ac498b31b894', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (70, 70, 18, 18, 7.5, 7.5, 255, 255, 'OP', '76efbf15b062cc985ad99353f7e9c1b4', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Wrangler' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Unlimited Rubicon' 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, 127, '24118', 1697791071);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (75, 75, 17, 17, 7.5, 7.5, 255, 255, 'OR', 'c866b21a5614866c1fe642576c8d6c87', @groupId,0),
    (75, 75, 16, 16, 7, 7, 245, 245, 'OP', 'f147e7dd5b2a0f1bfdd79b0a2771e8c8', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (70, 70, 18, 18, 7.5, 7.5, 255, 255, 'OP', '76efbf15b062cc985ad99353f7e9c1b4', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Wrangler' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Unlimited Sahara' 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, 127, '24119', 1697791071);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 18, 18, 7.5, 7.5, 255, 255, 'OR', '837f47356f852a9b16e35d0522f45cc3', @groupId,0),
    (75, 75, 16, 16, 7, 7, 245, 245, 'OP', 'f147e7dd5b2a0f1bfdd79b0a2771e8c8', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 255, 255, 'OP', 'cf0268eb9c61e313f8a6ac498b31b894', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Wrangler' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Unlimited 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, 127, '24120', 1697791071);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (75, 75, 16, 16, 7, 7, 225, 225, 'OR', '37864a691b86f3992d52852ea8465b54', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 255, 255, 'OP', 'cf0268eb9c61e313f8a6ac498b31b894', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (70, 70, 18, 18, 7.5, 7.5, 255, 255, 'OP', '76efbf15b062cc985ad99353f7e9c1b4', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'LINCOLN' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'MKS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '15610', 1697791073);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OR', '635e0cb0fdeb99d3d1d7486d4ab2827e', @groupId,0),
    (45, 45, 19, 19, 8, 8, 255, 255, 'OR', 'a7ba6ec73ab3b960bb59a9454f7afcc0', @groupId,0),
    (45, 45, 20, 20, 8.5, 8.5, 245, 245, 'OR', '50acf780018fcf9f782a09840de0037f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'LINCOLN' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'MKS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EcoBoost' 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, '15612', 1697791073);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 19, 19, 8, 8, 255, 255, 'OR', 'a7ba6ec73ab3b960bb59a9454f7afcc0', @groupId,0),
    (45, 45, 20, 20, 8.5, 8.5, 245, 245, 'OR', '50acf780018fcf9f782a09840de0037f', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'LINCOLN' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'MKT' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EcoBoost' 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, '56189', 1697791073);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OR', '69e6877aac0d7e86fee1ab077616011a', @groupId,0),
    (45, 45, 20, 20, 8, 8, 255, 255, 'OR', 'e6d7fc174c28d6ad5ac79a3876c7729a', @groupId,0),
    (50, 50, 18, 18, 7.5, 7.5, 235, 235, 'OP', '205d4d7a51e8555da03233be293bf12a', @groupId,0),
    (35, 35, 22, 22, 8.5, 8.5, 265, 265, 'OP', 'f6b4fb28d21887dcb1573cde2c494d1f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'LINCOLN' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'MKT' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '56190', 1697791073);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 20, 20, 8, 8, 255, 255, 'OR', 'e6d7fc174c28d6ad5ac79a3876c7729a', @groupId,0),
    (50, 50, 18, 18, 7.5, 7.5, 235, 235, 'OP', '205d4d7a51e8555da03233be293bf12a', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (35, 35, 22, 22, 8.5, 8.5, 265, 265, 'OP', 'f6b4fb28d21887dcb1573cde2c494d1f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TESLA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'S' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '17838', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 19, 19, 8, 8, 245, 245, 'OR', 'c53bc1070de9cb6098d639ce6f91e27e', @groupId,0),
    (35, 35, 21, 21, 8.5, 8.5, 245, 245, 'OR', 'a4f74d13fcf13bf4b37b944adfbfc00b', @groupId,0),
    (45, 40, 19, 19, 9.5, 10.5, 255, 285, 'OP', 'c0ce381217158736596f5ddad0ed45fe', @groupId,0),
    (35, 35, 21, 21, 8.5, 9, 245, 265, 'OP', 'c81e46d7e84dacf01cf51c2e3721d6d5', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TESLA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'S' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Signature' 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, '17840', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 19, 19, 8, 8, 245, 245, 'OR', 'c53bc1070de9cb6098d639ce6f91e27e', @groupId,0),
    (35, 35, 21, 21, 8.5, 8.5, 245, 245, 'OR', 'a4f74d13fcf13bf4b37b944adfbfc00b', @groupId,0),
    (45, 40, 19, 19, 9.5, 10.5, 255, 285, 'OP', 'c0ce381217158736596f5ddad0ed45fe', @groupId,0),
    (35, 35, 21, 21, 8.5, 9, 245, 265, 'OP', 'c81e46d7e84dacf01cf51c2e3721d6d5', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '4Runner' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 6, 139.7, '44879', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 20, 20, 8, 8, 245, 245, 'OR', '06d70018311bbaae12ba6a49c304fe9a', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '4Runner' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SR5' 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, 6, 139.7, '44881', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (60, 60, 20, 20, 8, 8, 245, 245, 'OP', 'b8cf5427ba4f10682022856a66dc2463', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '4Runner' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Trail' 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, 6, 139.7, '44883', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (60, 60, 20, 20, 8, 8, 245, 245, 'OP', 'b8cf5427ba4f10682022856a66dc2463', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Avalon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XLE' 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, '10378', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OR', 'd9df47658635544354d7a5805ce40ec8', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Avalon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '10379', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OR', 'd9df47658635544354d7a5805ce40ec8', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Avalon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Hybrid XLE' 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, '10380', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OR', 'd9df47658635544354d7a5805ce40ec8', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Avalon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Hybrid 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, '10381', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OR', 'd9df47658635544354d7a5805ce40ec8', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Avalon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XLE 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, 114.3, '10382', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OR', 'd9df47658635544354d7a5805ce40ec8', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Avalon' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XLE Touring' 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, '10383', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OR', '7e8194e340aeac097433decab22eaeeb', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Hybrid LE' 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, '10540', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OR', '0b4657a1241af9e5427d78558d5910f5', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Hybrid XLE' 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, '10541', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7, 7, 215, 215, 'OR', 'ba869085fbcf75c6d7823f4d3d835d02', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OR', 'd9df47658635544354d7a5805ce40ec8', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OP', '6db45cd6720213ac7e906e8720faf609', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'L' 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, '10542', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OR', '0b4657a1241af9e5427d78558d5910f5', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LE' 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, '10543', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OR', '0b4657a1241af9e5427d78558d5910f5', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, 114.3, '10544', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7, 7, 215, 215, 'OR', 'ba869085fbcf75c6d7823f4d3d835d02', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OR', '7e8194e340aeac097433decab22eaeeb', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OP', '6db45cd6720213ac7e906e8720faf609', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XLE' 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, '10546', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7, 7, 215, 215, 'OR', 'ba869085fbcf75c6d7823f4d3d835d02', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OR', '7e8194e340aeac097433decab22eaeeb', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OP', '6db45cd6720213ac7e906e8720faf609', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SE 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, '10548', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 17, 17, 7, 7, 215, 215, 'OR', 'ba869085fbcf75c6d7823f4d3d835d02', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OP', '6db45cd6720213ac7e906e8720faf609', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Hybrid 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, 114.3, '10549', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OR', '0b4657a1241af9e5427d78558d5910f5', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OR', 'ba869085fbcf75c6d7823f4d3d835d02', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Prius' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '10872', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (55, 55, 16, 16, 6, 6, 195, 195, 'OP', '1d2e546888edfabe847896f97c076fcd', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Prius' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Two' 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, '10873', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (55, 55, 16, 16, 6, 6, 195, 195, 'OP', '1d2e546888edfabe847896f97c076fcd', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Prius' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Three' 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, '10874', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (55, 55, 16, 16, 6, 6, 195, 195, 'OP', '1d2e546888edfabe847896f97c076fcd', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Prius' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Four' 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, '10875', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 15, 15, 6, 6, 195, 195, 'OR', '7d9bf2197ebdb385189974401ddb630f', @groupId,0),
    (55, 55, 16, 16, 6, 6, 195, 195, 'OP', '1d2e546888edfabe847896f97c076fcd', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Prius' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Five' 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, '10876', 1697783357);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7, 7, 215, 215, 'OR', 'b1709aa5211f6833f00c99bd15661822', @groupId,0),
    (65, 65, 15, 15, 6, 6, 195, 195, 'OP', '42da3dea55f3ed97000903d3db22d080', @groupId,0),
    (55, 55, 16, 16, 6, 6, 195, 195, 'OP', '1d2e546888edfabe847896f97c076fcd', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'RAV4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LE' 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, '45347', 1697783358);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (65, 65, 17, 17, 7, 7, 225, 225, 'OP', 'd5becd33ad619265b84e1b3a1de6f043', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'RAV4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' 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, '45349', 1697783358);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OR', '635e0cb0fdeb99d3d1d7486d4ab2827e', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0),
    (65, 65, 17, 17, 7, 7, 225, 225, 'OP', 'd5becd33ad619265b84e1b3a1de6f043', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'RAV4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XLE' 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, '45351', 1697783358);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (65, 65, 17, 17, 7, 7, 225, 225, 'OP', 'd5becd33ad619265b84e1b3a1de6f043', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'RAV4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2014' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'EV' 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, '45353', 1697783358);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 7, 7, 225, 225, 'OR', '09107de6d534d33efe36d6f9a640095c', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0);



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 = '2015' 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, '12767', 1697783363);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OR', '5aad6ef3aa3782728d550081e0d524a0', @groupId,0),
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 235, 235, 'OP', 'd8aff04de48c16d0783200e29395cb90', @groupId,0);



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 = '2015' 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, '12768', 1697783363);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OR', '5aad6ef3aa3782728d550081e0d524a0', @groupId,0),
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'c04418b403f7ac99203420afd36d9dd4', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' 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, '12769', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' 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, '12770', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 235, 235, 'OR', 'a4dfb4c182a57aca937c517e1aa65657', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0);



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 = '2015' 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, '12771', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' 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, '12772', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 235, 235, 'OR', 'a4dfb4c182a57aca937c517e1aa65657', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Komfort' 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, '12773', 1697783363);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OR', '5aad6ef3aa3782728d550081e0d524a0', @groupId,0),
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'c04418b403f7ac99203420afd36d9dd4', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Progressiv' 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, '12774', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Technik' 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, '12775', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI 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, '12776', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OR', '5aad6ef3aa3782728d550081e0d524a0', @groupId,0),
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'c04418b403f7ac99203420afd36d9dd4', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI 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, '12777', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI 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, '12778', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Komfort' 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, '12779', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OR', '5aad6ef3aa3782728d550081e0d524a0', @groupId,0),
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'c04418b403f7ac99203420afd36d9dd4', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 235, 235, 'OP', 'd8aff04de48c16d0783200e29395cb90', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Komfort' 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, '12780', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OR', '5aad6ef3aa3782728d550081e0d524a0', @groupId,0),
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'c04418b403f7ac99203420afd36d9dd4', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Progressiv' 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, '12781', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Progressiv' 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, '12782', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 235, 235, 'OP', 'd8aff04de48c16d0783200e29395cb90', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Technik' 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, '12783', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 235, 235, 'OP', 'd8aff04de48c16d0783200e29395cb90', @groupId,0);



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 = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Technik' 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, '12784', 1697783364);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OR', '946e7605f35296983ad91de13b0a7d78', @groupId,0),
    (45, 45, 17, 17, 7.5, 7.5, 225, 225, 'OP', '977921d9b6a6348ab3c08b9b15b53820', @groupId,0),
    (35, 35, 19, 19, 8, 8, 235, 235, 'OP', '879de67f0516c86ce512cdc82c617b43', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '9868', 1697783365);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 245, 245, 'OR', '87815b89e5a3c6e35d5dccbb0bd12cd4', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OR', '0872dbea0031b30b4704560186e0f49f', @groupId,0),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (50, 50, 17, 17, 7.5, 7.5, 225, 225, 'OP', 'baab4816a5ebd1e93378a337e1895b70', @groupId,0),
    (45, 45, 17, 17, 8, 8, 235, 235, 'OP', '890ed40dd90b52ab63f494e5da78aa69', @groupId,0),
    (40, 40, 18, 18, 8, 8, 245, 245, 'OP', '53c388af54652de7a28689a78dc50d19', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0),
    (35, 35, 19, 19, 8, 8, 255, 255, 'OP', '33a40cc2f8e93ed6c72c4869b6ae4d01', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 255, 255, 'OP', '852a246236c80009ad009398f91db0b5', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '9869', 1697783365);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 8, 8, 235, 235, 'OR', '0872dbea0031b30b4704560186e0f49f', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 255, 255, 'OR', '7cfe23814bb6f8ea3d3389b7c3fb44d1', @groupId,0),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (50, 50, 17, 17, 7.5, 7.5, 225, 225, 'OP', 'baab4816a5ebd1e93378a337e1895b70', @groupId,0),
    (45, 45, 17, 17, 8, 8, 235, 235, 'OP', '890ed40dd90b52ab63f494e5da78aa69', @groupId,0),
    (45, 45, 17, 17, 8, 8, 245, 245, 'OP', 'b8bed917f01db4a14c03b7b21722f62c', @groupId,0),
    (40, 40, 18, 18, 8, 8, 245, 245, 'OP', '53c388af54652de7a28689a78dc50d19', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0),
    (35, 35, 19, 19, 8, 8, 255, 255, 'OP', '33a40cc2f8e93ed6c72c4869b6ae4d01', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '9870', 1697783365);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 8, 8, 235, 235, 'OR', '0872dbea0031b30b4704560186e0f49f', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 255, 255, 'OR', '7cfe23814bb6f8ea3d3389b7c3fb44d1', @groupId,0),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (50, 50, 17, 17, 7.5, 7.5, 225, 225, 'OP', 'baab4816a5ebd1e93378a337e1895b70', @groupId,0),
    (45, 45, 17, 17, 8, 8, 235, 235, 'OP', '890ed40dd90b52ab63f494e5da78aa69', @groupId,0),
    (45, 45, 17, 17, 8, 8, 245, 245, 'OP', 'b8bed917f01db4a14c03b7b21722f62c', @groupId,0),
    (40, 40, 18, 18, 8, 8, 245, 245, 'OP', '53c388af54652de7a28689a78dc50d19', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0),
    (35, 35, 19, 19, 8, 8, 255, 255, 'OP', '33a40cc2f8e93ed6c72c4869b6ae4d01', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'A4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Komfort' 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, '9871', 1697783365);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 245, 245, 'OR', '87815b89e5a3c6e35d5dccbb0bd12cd4', @groupId,0),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (50, 50, 17, 17, 7.5, 7.5, 225, 225, 'OP', 'baab4816a5ebd1e93378a337e1895b70', @groupId,0),
    (45, 45, 17, 17, 8, 8, 235, 235, 'OP', '890ed40dd90b52ab63f494e5da78aa69', @groupId,0),
    (40, 40, 18, 18, 8, 8, 245, 245, 'OP', '53c388af54652de7a28689a78dc50d19', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0),
    (35, 35, 19, 19, 8, 8, 255, 255, 'OP', '33a40cc2f8e93ed6c72c4869b6ae4d01', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 255, 255, 'OP', '852a246236c80009ad009398f91db0b5', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '60048', 1697783366);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 19, 19, 9, 9, 255, 255, 'OR', '39ecc082411d2f0b9ef3496b8e9a3921', @groupId,0),
    (50, 50, 18, 18, 7, 7, 235, 235, 'OP', '203445d1e8369d355f969cb59ea23ebc', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '60049', 1697783366);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 18, 18, 7, 7, 235, 235, 'OR', '77984eb66ca094b3b3766ca2bbeb37c4', @groupId,0),
    (40, 40, 19, 19, 9, 9, 255, 255, 'OR', '39ecc082411d2f0b9ef3496b8e9a3921', @groupId,0),
    (50, 50, 18, 18, 7, 7, 235, 235, 'OP', '203445d1e8369d355f969cb59ea23ebc', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Technik' 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, '60050', 1697783366);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 19, 19, 9, 9, 255, 255, 'OR', '39ecc082411d2f0b9ef3496b8e9a3921', @groupId,0),
    (50, 50, 18, 18, 7, 7, 235, 235, 'OP', '203445d1e8369d355f969cb59ea23ebc', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Progressiv' 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, '60051', 1697783366);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 19, 19, 9, 9, 255, 255, 'OR', '39ecc082411d2f0b9ef3496b8e9a3921', @groupId,0),
    (50, 50, 18, 18, 7, 7, 235, 235, 'OP', '203445d1e8369d355f969cb59ea23ebc', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 130, '51311', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 8, 8, 255, 255, 'OR', '366515762ffaade452376c508ecc4199', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OR', '2d377d550eebb9ae5dd1a8741f57f8f6', @groupId,0),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OP', '98362e49f676569de4360eb446b115d4', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OP', 'c3a20e5f6547319e5ba50f21fcc85a87', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 130, '51312', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 8, 8, 255, 255, 'OR', '366515762ffaade452376c508ecc4199', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OR', '2d377d550eebb9ae5dd1a8741f57f8f6', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OR', '2c3c5c2320ad5b78cf6743dc1d9ecd29', @groupId,0),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OP', '98362e49f676569de4360eb446b115d4', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 130, '51313', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 20, 20, 9, 9, 275, 275, 'OR', '2c3c5c2320ad5b78cf6743dc1d9ecd29', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OR', 'd62445c0a05d5fc10ca3dfcc2905d095', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OP', '98362e49f676569de4360eb446b115d4', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OP', '1eecc43bb188b49ec4f5e076f5ba545a', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI 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, 130, '51314', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 19, 19, 9, 9, 265, 265, 'OR', '2d377d550eebb9ae5dd1a8741f57f8f6', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OR', '2c3c5c2320ad5b78cf6743dc1d9ecd29', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OP', '98362e49f676569de4360eb446b115d4', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI 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, 130, '51315', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 19, 19, 9, 9, 265, 265, 'OR', '2d377d550eebb9ae5dd1a8741f57f8f6', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OR', '2c3c5c2320ad5b78cf6743dc1d9ecd29', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OP', '98362e49f676569de4360eb446b115d4', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI 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, 130, '51316', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 20, 20, 9, 9, 275, 275, 'OR', '2c3c5c2320ad5b78cf6743dc1d9ecd29', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OR', 'd62445c0a05d5fc10ca3dfcc2905d095', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OP', '98362e49f676569de4360eb446b115d4', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OP', '1eecc43bb188b49ec4f5e076f5ba545a', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 130, '51317', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (35, 35, 21, 21, 10, 10, 295, 295, 'OR', 'd62445c0a05d5fc10ca3dfcc2905d095', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OP', '98362e49f676569de4360eb446b115d4', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OP', '1eecc43bb188b49ec4f5e076f5ba545a', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OP', 'c3a20e5f6547319e5ba50f21fcc85a87', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Progressiv' 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, 130, '51318', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OR', '9864a4373d5df4580022a8eec2cc42ac', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OR', '2d377d550eebb9ae5dd1a8741f57f8f6', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OR', '2c3c5c2320ad5b78cf6743dc1d9ecd29', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OR', 'c689f5848b23cd441f6742b67dac719a', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OR', 'd62445c0a05d5fc10ca3dfcc2905d095', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OP', '1eecc43bb188b49ec4f5e076f5ba545a', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OP', 'c3a20e5f6547319e5ba50f21fcc85a87', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Progressiv' 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, 130, '51319', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OR', '9864a4373d5df4580022a8eec2cc42ac', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OR', '2d377d550eebb9ae5dd1a8741f57f8f6', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OR', '2c3c5c2320ad5b78cf6743dc1d9ecd29', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OR', 'c689f5848b23cd441f6742b67dac719a', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OR', 'd62445c0a05d5fc10ca3dfcc2905d095', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OP', '1eecc43bb188b49ec4f5e076f5ba545a', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OP', 'c3a20e5f6547319e5ba50f21fcc85a87', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Vorsprung' 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, 130, '51320', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OR', '9864a4373d5df4580022a8eec2cc42ac', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OP', '1eecc43bb188b49ec4f5e076f5ba545a', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OP', 'c3a20e5f6547319e5ba50f21fcc85a87', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI Vorsprung' 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, 130, '51321', 1697783367);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OR', '9864a4373d5df4580022a8eec2cc42ac', @groupId,0),
    (55, 55, 18, 18, 8, 8, 255, 255, 'OP', '47ff3eefbe1d58a6daf36b124f5de58c', @groupId,0),
    (50, 50, 19, 19, 8.5, 8.5, 265, 265, 'OP', '9c92f3091bce16b21f317e5b1e124d64', @groupId,0),
    (50, 50, 19, 19, 9, 9, 265, 265, 'OP', '1eecc43bb188b49ec4f5e076f5ba545a', @groupId,0),
    (45, 45, 20, 20, 9, 9, 275, 275, 'OP', 'c3a20e5f6547319e5ba50f21fcc85a87', @groupId,0),
    (35, 35, 21, 21, 10, 10, 295, 295, 'OP', '761b7ab756a61aa03174baeb45f5ef46', @groupId,0),
    (40, 40, 21, 21, 10, 10, 275, 275, 'OP', 'a9b2761c03577a24e7e9045423849adf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'S8' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 112, '10245', 1697783368);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 20, 20, 9, 9, 265, 265, 'OR', '307535f0aa998539f243dd1cf8a835a3', @groupId,0),
    (35, 35, 21, 21, 9, 9, 265, 265, 'OR', '3c71fde23c5380250c3a66258c29eef2', @groupId,0),
    (35, 35, 21, 21, 9, 9, 275, 275, 'OR', '278bf0e26f50e8d4d7aa9416f4bbe46d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BMW' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = '750i' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '12596', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 18, 18, 8, 8, 245, 245, 'OR', 'a713e52ecaf4205d74c4abc3ddc4043c', @groupId,0),
    (45, 40, 19, 19, 8.5, 9.5, 245, 275, 'OR', 'dbeece92a56438be8a56d2bbf1160f56', @groupId,0),
    (45, 45, 19, 19, 8.5, 8.5, 245, 245, 'OR', '8023d2cab6a04b36ae8141b3348d44dd', @groupId,0),
    (40, 35, 20, 20, 8.5, 10, 245, 275, 'OR', 'daf344a4d997ed36890285a42925376c', @groupId,0),
    (50, 50, 18, 18, 8, 8, 245, 245, 'OP', 'e414085e22c83564e4d2de4d8df26b11', @groupId,0),
    (45, 40, 19, 19, 8.5, 9.5, 245, 275, 'OP', 'd145f2d5411b2e4daf6ab311179bcd9c', @groupId,0),
    (40, 35, 20, 20, 8.5, 10, 245, 275, 'OP', '3ede637f4d35ba38008479c82f3d9248', @groupId,0),
    (35, 30, 21, 21, 8.5, 10, 245, 285, 'OP', '21c391e560cd5b0a1252b4f384988aaa', @groupId,0),
    (35, 30, 21, 21, 8.5, 10, 245, 275, 'OP', '123de7a0bc57976a252c2d23d3a63d14', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BMW' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'M3' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '2676', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 9, 10, 255, 275, 'OR', '00b79585fd05a2374e38608c5c2cafee', @groupId,0),
    (35, 35, 19, 19, 9, 10, 255, 275, 'OR', '9fe63c46846a4eca840379a667765d79', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BMW' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'M4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '18950', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 9, 10, 255, 275, 'OR', '00b79585fd05a2374e38608c5c2cafee', @groupId,0),
    (35, 35, 19, 19, 9, 10, 255, 275, 'OR', '9fe63c46846a4eca840379a667765d79', @groupId,0),
    (35, 30, 19, 20, 9, 10, 265, 285, 'OP', '3e26f1d69ae047f3ca1909bc28d3bcd0', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BMW' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'M4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '18951', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 9, 10, 255, 275, 'OR', '00b79585fd05a2374e38608c5c2cafee', @groupId,0),
    (35, 35, 19, 19, 9, 10, 255, 275, 'OR', '9fe63c46846a4eca840379a667765d79', @groupId,0),
    (35, 30, 19, 20, 9, 10, 265, 285, 'OP', '3e26f1d69ae047f3ca1909bc28d3bcd0', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Enclave' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Convenience' 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, 6, 132, '52568', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 18, 18, 7.5, 7.5, 255, 255, 'OR', '19da3d9c628ca3b4486155ab1503a3e1', @groupId,0),
    (60, 60, 19, 19, 7.5, 7.5, 255, 255, 'OR', 'eaaf964e229af76fbde30ab6a35c8f05', @groupId,0),
    (60, 60, 19, 19, 7.5, 7.5, 255, 255, 'OP', '878da6bfd4b628a0c52cf57317d41b35', @groupId,0),
    (55, 55, 20, 20, 7.5, 7.5, 255, 255, 'OP', '1c5b1a23db1b9fbbcba96d7da30ec614', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Enclave' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Leather' 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, 6, 132, '52569', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 19, 19, 7.5, 7.5, 255, 255, 'OR', 'eaaf964e229af76fbde30ab6a35c8f05', @groupId,0),
    (55, 55, 20, 20, 7.5, 7.5, 255, 255, 'OR', '567b6609e24654bbfa9536c4c10f542f', @groupId,0),
    (65, 65, 18, 18, 7.5, 7.5, 255, 255, 'OP', '757d55cde164fd46a0201b8d1f6e250d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Enclave' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 6, 132, '52571', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 19, 19, 7.5, 7.5, 255, 255, 'OR', 'eaaf964e229af76fbde30ab6a35c8f05', @groupId,0),
    (55, 55, 20, 20, 7.5, 7.5, 255, 255, 'OR', '567b6609e24654bbfa9536c4c10f542f', @groupId,0),
    (65, 65, 18, 18, 7.5, 7.5, 255, 255, 'OP', '757d55cde164fd46a0201b8d1f6e250d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Encore' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 105, '60498', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 215, 215, 'OR', '01085e845ef90bf43aae85d3e0c99e34', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Encore' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Convenience' 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, 105, '60500', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 215, 215, 'OR', '01085e845ef90bf43aae85d3e0c99e34', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Encore' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Leather' 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, 105, '60502', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 215, 215, 'OR', '01085e845ef90bf43aae85d3e0c99e34', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Encore' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 105, '60504', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 215, 215, 'OR', '01085e845ef90bf43aae85d3e0c99e34', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Verano' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '17216', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 17, 17, 7, 7, 225, 225, 'OR', '533b569a74c226df3de386100f431546', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 235, 235, 'OR', '7be452bd3bb946e9bb764da9d7cd279d', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 235, 235, 'OP', '650c1fa00aad9073f2aa1ff76a4b757b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Verano' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Convenience' 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, '17217', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 17, 17, 7, 7, 225, 225, 'OR', '533b569a74c226df3de386100f431546', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 235, 235, 'OR', '7be452bd3bb946e9bb764da9d7cd279d', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 235, 235, 'OP', '650c1fa00aad9073f2aa1ff76a4b757b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Verano' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Leather' 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, '17218', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 18, 18, 7.5, 7.5, 235, 235, 'OR', '7be452bd3bb946e9bb764da9d7cd279d', @groupId,0),
    (50, 50, 17, 17, 7, 7, 225, 225, 'OP', '039fe8f6dcdd5d6155db682a01a927ed', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'BUICK' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Verano' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 115, '17219', 1697783370);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 18, 18, 7.5, 7.5, 235, 235, 'OR', '7be452bd3bb946e9bb764da9d7cd279d', @groupId,0),
    (50, 50, 17, 17, 7, 7, 225, 225, 'OP', '039fe8f6dcdd5d6155db682a01a927ed', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'ATS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '17605', 1697783371);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 225, 225, 'OR', 'a6730bfe194532a76759d6c09615ade8', @groupId,0),
    (45, 45, 17, 17, 8, 8, 225, 225, 'OP', '7b6939a85023132b34c399faf28e79c7', @groupId,0),
    (40, 40, 18, 18, 8, 8, 225, 225, 'OP', '3bb6d62f8bc48a53ec413918b5e0fe89', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OP', 'b27753d211d2503a535ed69ef180a40b', @groupId,0),
    (35, 30, 19, 19, 8, 9, 225, 255, 'OP', 'e2134e37d5eae4bb49327c5f28f6fbc7', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'ATS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, '17607', 1697783371);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 225, 225, 'OR', 'a6730bfe194532a76759d6c09615ade8', @groupId,0),
    (40, 40, 18, 18, 8, 8, 225, 225, 'OR', '33446a745085ba468778e646cf8091f8', @groupId,0),
    (45, 45, 17, 17, 8, 8, 225, 225, 'OP', '7b6939a85023132b34c399faf28e79c7', @groupId,0),
    (40, 40, 18, 18, 8, 8, 225, 225, 'OP', '3bb6d62f8bc48a53ec413918b5e0fe89', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OP', 'b27753d211d2503a535ed69ef180a40b', @groupId,0),
    (35, 30, 19, 19, 8, 9, 225, 255, 'OP', 'e2134e37d5eae4bb49327c5f28f6fbc7', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'ATS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Luxury' 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, '17613', 1697783371);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 225, 225, 'OR', 'a6730bfe194532a76759d6c09615ade8', @groupId,0),
    (40, 40, 18, 18, 8, 8, 225, 225, 'OR', '33446a745085ba468778e646cf8091f8', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OP', 'b27753d211d2503a535ed69ef180a40b', @groupId,0),
    (35, 30, 19, 19, 8, 9, 225, 255, 'OP', 'e2134e37d5eae4bb49327c5f28f6fbc7', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'ATS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Luxury' 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, '17616', 1697783371);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 225, 225, 'OR', 'a6730bfe194532a76759d6c09615ade8', @groupId,0),
    (40, 40, 18, 18, 8, 8, 225, 225, 'OR', '33446a745085ba468778e646cf8091f8', @groupId,0),
    (45, 45, 17, 17, 8, 8, 225, 225, 'OP', '7b6939a85023132b34c399faf28e79c7', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OP', 'b27753d211d2503a535ed69ef180a40b', @groupId,0),
    (35, 30, 19, 19, 8, 9, 225, 255, 'OP', 'e2134e37d5eae4bb49327c5f28f6fbc7', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'ATS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Performance' 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, '17625', 1697783371);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 225, 225, 'OR', 'a6730bfe194532a76759d6c09615ade8', @groupId,0),
    (40, 40, 18, 18, 8, 8, 225, 225, 'OR', '33446a745085ba468778e646cf8091f8', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OP', 'b27753d211d2503a535ed69ef180a40b', @groupId,0),
    (35, 30, 19, 19, 8, 9, 225, 255, 'OP', 'e2134e37d5eae4bb49327c5f28f6fbc7', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'ATS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Performance' 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, '17627', 1697783371);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (45, 45, 17, 17, 8, 8, 225, 225, 'OR', 'a6730bfe194532a76759d6c09615ade8', @groupId,0),
    (40, 40, 18, 18, 8, 8, 225, 225, 'OR', '33446a745085ba468778e646cf8091f8', @groupId,0),
    (45, 45, 17, 17, 8, 8, 225, 225, 'OP', '7b6939a85023132b34c399faf28e79c7', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OP', 'b27753d211d2503a535ed69ef180a40b', @groupId,0),
    (35, 30, 19, 19, 8, 9, 225, 255, 'OP', 'e2134e37d5eae4bb49327c5f28f6fbc7', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'ATS' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2015' 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, 115, '17633', 1697783372);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 8, 8, 225, 225, 'OR', '33446a745085ba468778e646cf8091f8', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OR', '844936410fa21911ec842bc8438607a7', @groupId,0),
    (45, 45, 17, 17, 8, 8, 225, 225, 'OP', '7b6939a85023132b34c399faf28e79c7', @groupId,0),
    (40, 35, 18, 18, 8, 9, 225, 255, 'OP', 'b27753d211d2503a535ed69ef180a40b', @groupId,0),
    (35, 30, 19, 19, 8, 9, 225, 255, 'OP', 'e2134e37d5eae4bb49327c5f28f6fbc7', @groupId,0);