
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'WT' 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, '73260', 1697790726);
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, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @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),
    (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 = 'Terrain' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' 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, '55996', 1697790728);
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, 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 = '2012' 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, '56000', 1697790728);
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, 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 = '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 = '2012' 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, '6896', 1697790728);
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 = '2012' 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, '6897', 1697790728);
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 = '2012' 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, '6898', 1697790728);
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 = '2012' 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, '6899', 1697790728);
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 = '2012' 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, '6900', 1697790728);
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 = '2012' 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, '6901', 1697790728);
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 = '2012' 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, '6902', 1697790728);
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 = '2012' 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, '6903', 1697790728);
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),
    (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 = '2012' 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, '6904', 1697790728);
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),
    (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 = '2012' 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, '6905', 1697790728);
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 = '2012' 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, '6906', 1697790728);
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 = '2012' 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, '6907', 1697790729);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'GX' 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, '6908', 1697790729);
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 = '2012' 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, '6909', 1697790729);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Si HFP' 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, '6910', 1697790729);
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, 7, 215, 215, 'OR', '37845a0ec8fc3023a155b3200563f6ea', @groupId,0),
    (45, 45, 17, 17, 7, 7, 215, 215, 'OP', '9fb35c96c8cda3df6eccbd6812eb381f', @groupId,0),
    (40, 40, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'c04418b403f7ac99203420afd36d9dd4', @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 = '2012' 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, '43397', 1697790729);
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 = '2012' 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, '43399', 1697790729);
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 = '2012' 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, '43401', 1697790729);
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 = '2012' 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, '43403', 1697790729);
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 = '2012' 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, '16729', 1697790729);
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 = '2012' 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, '16730', 1697790729);
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 = '2012' 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, '16731', 1697790729);
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 = 'Fit' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 4, 100, '13878', 1697790729);
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 = '2012' 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, '13879', 1697790729);
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 = '2012' 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, '13880', 1697790729);
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 = '2012' 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, '13881', 1697790729);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'DX-A' 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, '13882', 1697790729);
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 = '2012' 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, '67191', 1697790729);
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 = '2012' 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, '67192', 1697790729);
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 = '2012' 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, '67193', 1697790729);
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 = '2012' 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, '67194', 1697790729);
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 = '2012' 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, '67195', 1697790729);
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 = '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 = '2012' 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, '51542', 1697790736);
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, 215, 215, 'OR', '2988438fa9aee2ac600c1a77377f657f', @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),
    (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 = '2012' 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, '51546', 1697790736);
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),
    (65, 65, 17, 17, 6.5, 6.5, 215, 215, 'OP', '52785f368e97dbe9d9b30cbdeab35f61', @groupId,0),
    (60, 60, 17, 17, 6.5, 6.5, 215, 215, 'OP', 'd698f48c412dd0a8b954040ec47ad256', @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 = '2012' 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, '51548', 1697790736);
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, 215, 215, 'OR', '2988438fa9aee2ac600c1a77377f657f', @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),
    (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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'North Edition' 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, '51552', 1697790736);
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 = '2012' 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, '23656', 1697790736);
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 = '2012' 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, '23660', 1697790736);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Laredo E' 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, '23664', 1697790736);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Laredo X' 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, '23666', 1697790736);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SRT8' 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, '23670', 1697790736);
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 = '2012' 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, '23671', 1697790736);
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 = 'Grand Cherokee' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Overland 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, '23675', 1697790736);
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 = 'Liberty' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' 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, '24008', 1697790736);
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),
    (75, 75, 16, 16, 7, 7, 225, 225, 'OP', '195d831fb996b1d5eac69c5bad8ad90d', @groupId,0),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OP', '15975c11f614af14abd3df68f3570f7f', @groupId,0),
    (60, 60, 17, 17, 7, 7, 215, 215, 'OP', '15b862c0f8fbf3e6b528c010a11c636e', @groupId,0),
    (50, 50, 20, 20, 9, 9, 245, 245, 'OP', 'b26db94559f7e6c5e47a8f2b0e203e7f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Liberty' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' 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, '24010', 1697790736);
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),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OR', 'fa2f745b74993ccf2d7f8a1fef3ca712', @groupId,0),
    (65, 65, 17, 17, 7, 7, 235, 235, 'OP', '508acdf523521daf67d8b7d8954d45e2', @groupId,0),
    (60, 60, 17, 17, 7, 7, 215, 215, 'OP', '15b862c0f8fbf3e6b528c010a11c636e', @groupId,0),
    (60, 60, 18, 18, 7, 7, 235, 235, 'OP', 'bf52bf4a4459f497acbea31ac3815e68', @groupId,0),
    (50, 50, 20, 20, 9, 9, 245, 245, 'OP', 'b26db94559f7e6c5e47a8f2b0e203e7f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Liberty' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Jet' 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, '24012', 1697790736);
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, 9, 9, 245, 245, 'OR', '0bed98665c4bd215f9f9c7f68bc4eb51', @groupId,0),
    (75, 75, 16, 16, 7, 7, 225, 225, 'OP', '195d831fb996b1d5eac69c5bad8ad90d', @groupId,0),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OP', '15975c11f614af14abd3df68f3570f7f', @groupId,0),
    (65, 65, 17, 17, 7, 7, 235, 235, 'OP', '508acdf523521daf67d8b7d8954d45e2', @groupId,0),
    (60, 60, 17, 17, 7, 7, 215, 215, 'OP', '15b862c0f8fbf3e6b528c010a11c636e', @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 = 'Liberty' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'North Edition' 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, '24014', 1697790736);
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, 215, 215, 'OR', 'f9a6d3424dea1c1972c3b69b4b3bf37f', @groupId,0),
    (75, 75, 16, 16, 7, 7, 225, 225, 'OP', '195d831fb996b1d5eac69c5bad8ad90d', @groupId,0),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OP', '15975c11f614af14abd3df68f3570f7f', @groupId,0),
    (65, 65, 17, 17, 7, 7, 235, 235, 'OP', '508acdf523521daf67d8b7d8954d45e2', @groupId,0),
    (60, 60, 18, 18, 7, 7, 235, 235, 'OP', 'bf52bf4a4459f497acbea31ac3815e68', @groupId,0),
    (50, 50, 20, 20, 9, 9, 245, 245, 'OP', 'b26db94559f7e6c5e47a8f2b0e203e7f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Liberty' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Limited Edition' 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, '24016', 1697790736);
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),
    (75, 75, 16, 16, 7, 7, 225, 225, 'OP', '195d831fb996b1d5eac69c5bad8ad90d', @groupId,0),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OP', '15975c11f614af14abd3df68f3570f7f', @groupId,0),
    (65, 65, 17, 17, 7, 7, 235, 235, 'OP', '508acdf523521daf67d8b7d8954d45e2', @groupId,0),
    (60, 60, 17, 17, 7, 7, 215, 215, 'OP', '15b862c0f8fbf3e6b528c010a11c636e', @groupId,0),
    (50, 50, 20, 20, 9, 9, 245, 245, 'OP', 'b26db94559f7e6c5e47a8f2b0e203e7f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'JEEP' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Liberty' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Limited Jet' 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, '274390', 1697790736);
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, 9, 9, 245, 245, 'OR', '0bed98665c4bd215f9f9c7f68bc4eb51', @groupId,0),
    (75, 75, 16, 16, 7, 7, 225, 225, 'OP', '195d831fb996b1d5eac69c5bad8ad90d', @groupId,0),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OP', '15975c11f614af14abd3df68f3570f7f', @groupId,0),
    (65, 65, 17, 17, 7, 7, 235, 235, 'OP', '508acdf523521daf67d8b7d8954d45e2', @groupId,0),
    (60, 60, 17, 17, 7, 7, 215, 215, 'OP', '15b862c0f8fbf3e6b528c010a11c636e', @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 = 'Wrangler' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' 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, '24103', 1697790737);
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 = '2012' 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, '24104', 1697790737);
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 = '2012' 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, '24105', 1697790737);
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 = '2012' 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, '24106', 1697790737);
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 = '2012' 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, '24107', 1697790737);
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 = '2012' 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, '24108', 1697790737);
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 = '2012' 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, '15604', 1697790745);
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 = '2012' 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, '15606', 1697790745);
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.5, 8.5, 245, 245, 'OR', '50acf780018fcf9f782a09840de0037f', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (45, 45, 19, 19, 8, 8, 255, 255, 'OP', 'fd0182df90d12bb903549fa9de685fad', @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 = '2012' 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, '56181', 1697790745);
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 = '2012' 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, '56183', 1697790745);
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 = '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 = '2012' 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, '17837', 1697790837);
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 = '2012' 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, '44869', 1697790837);
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 = '2012' 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, '44871', 1697790837);
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 = '2012' 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, '44873', 1697790837);
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 = '2012' 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, '10369', 1697790837);
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 = '2012' 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, '10370', 1697790837);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XLS' 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, '10371', 1697790837);
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 = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' 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, '10524', 1697790837);
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 = '2012' 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, '10525', 1697790837);
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 = '2012' 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, '10527', 1697790837);
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 = '2012' 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, '10529', 1697790837);
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 = '2012' 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, '10530', 1697790837);
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 = '2012' 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, '10531', 1697790837);
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 = 'Prius' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' 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, '10862', 1697790840);
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 = '2012' 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, '10863', 1697790840);
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 = '2012' 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, '10864', 1697790840);
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 = '2012' 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, '10865', 1697790840);
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 = '2012' 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, '10866', 1697790840);
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 = '2012' 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, '45327', 1697790840);
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, 7, 7, 215, 215, 'OR', 'cab8a416316a971ae5043e4e8ae9c3c8', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 225, 225, 'OR', '89cf04dd229cd21a9e2ada9fceef6d8e', @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 = '2012' 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, '45331', 1697790840);
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.5, 7.5, 225, 225, 'OR', '89cf04dd229cd21a9e2ada9fceef6d8e', @groupId,0),
    (70, 70, 16, 16, 7, 7, 215, 215, 'OP', 'ef6d5b8dd0ad29a008191b5b5d9050ae', @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 = '2012' 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, '45335', 1697790840);
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),
    (70, 70, 16, 16, 7, 7, 215, 215, 'OP', 'ef6d5b8dd0ad29a008191b5b5d9050ae', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 225, 225, 'OP', '32dbba0bc13ef9bd27d1e38619b2c20f', @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 = '2012' 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, '45339', 1697790840);
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.5, 7.5, 225, 225, 'OR', '89cf04dd229cd21a9e2ada9fceef6d8e', @groupId,0),
    (70, 70, 16, 16, 7, 7, 215, 215, 'OP', 'ef6d5b8dd0ad29a008191b5b5d9050ae', @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 = '2013' 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, '12753', 1697790846);
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, 8, 8, 225, 225, 'OP', '3bb6d62f8bc48a53ec413918b5e0fe89', @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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'TDI' 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, '12754', 1697790846);
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, 8, 8, 225, 225, 'OP', '3bb6d62f8bc48a53ec413918b5e0fe89', @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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Sportback' 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, '12755', 1697790846);
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, 8, 8, 225, 225, 'OP', '3bb6d62f8bc48a53ec413918b5e0fe89', @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 = '2013' 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, '9855', 1697790846);
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.5, 7.5, 225, 225, 'OR', '5508f7b1dacbbff1440de71b2875ad53', @groupId,0),
    (45, 45, 17, 17, 8, 8, 245, 245, 'OR', '87815b89e5a3c6e35d5dccbb0bd12cd4', @groupId,0),
    (40, 40, 18, 18, 8, 8, 245, 245, 'OR', '89aa6e7ae92953ce76e283826d9c18c1', @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),
    (45, 45, 17, 17, 8, 8, 235, 235, 'OP', '890ed40dd90b52ab63f494e5da78aa69', @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 = 'Q7' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' 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, '51294', 1697790848);
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),
    (55, 55, 18, 18, 8.5, 8.5, 255, 255, 'OR', '9864a4373d5df4580022a8eec2cc42ac', @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 = '2013' 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, '51295', 1697790848);
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),
    (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),
    (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 = '2013' 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, '51296', 1697790848);
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),
    (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),
    (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 = '2013' 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, '51297', 1697790848);
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),
    (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 = '2013' 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, '51298', 1697790848);
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),
    (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 = '2013' 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, '51299', 1697790848);
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),
    (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 = '2013' 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, 130, '51300', 1697790848);
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 = '2013' 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, '51301', 1697790848);
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 = 'S8' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' 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, '10243', 1697790848);
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, 'OP', '1b9877b886f22eba158a37ac0fd6b032', @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 = '2013' 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, '12594', 1697790852);
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, 40, 19, 19, 8.5, 9.5, 245, 275, 'OR', 'dbeece92a56438be8a56d2bbf1160f56', @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),
    (45, 45, 19, 19, 8.5, 8.5, 245, 245, 'OP', 'a5be3beef6a9ebf2cfe882cb37aaca79', @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 = '2013' 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, '2674', 1697790854);
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.5, 9.5, 245, 265, 'OR', '11de368f782ddd53fc2552ee509dc2e0', @groupId,0),
    (35, 35, 19, 19, 8.5, 9.5, 245, 265, 'OR', 'bc2abd5f3958d0b4780aa111bcb7cd1d', @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 = '2013' 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, '2675', 1697790854);
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.5, 9.5, 245, 265, 'OR', '11de368f782ddd53fc2552ee509dc2e0', @groupId,0),
    (35, 35, 19, 19, 8.5, 9.5, 245, 265, 'OR', 'bc2abd5f3958d0b4780aa111bcb7cd1d', @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 = '2013' 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, 132, '52560', 1697790854);
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 = 'Encore' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' 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, '60482', 1697790854);
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 = '2013' 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, '60484', 1697790855);
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 = '2013' 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, '60486', 1697790855);
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 = '2013' 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, '60488', 1697790855);
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 = '2013' 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, '17207', 1697790855);
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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Turbo' 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, '17208', 1697790855);
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 = '2013' 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, '17209', 1697790855);
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),
    (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 = '2013' 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, '17210', 1697790855);
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),
    (45, 45, 18, 18, 7.5, 7.5, 235, 235, 'OP', '650c1fa00aad9073f2aa1ff76a4b757b', @groupId,0);