
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 = '2011' 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, '56180', 1697790678);
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 = 'MERCURY' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Grand Marquis' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2011' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'LS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '6330', 1697790684);
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, 16, 16, 7, 7, 225, 225, 'OR', 'fff60363db423b07489d2355d278e425', @groupId,0),
    (60, 60, 16, 16, 7, 7, 225, 225, 'OP', '5a48f338bb6c41821fb668b08805928e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TESLA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Roadster' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2011' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Sport 2.5' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 110, '14797', 1697790698);
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, 45, 16, 17, 6, 7.5, 175, 225, 'OR', '3c0afb24a3a74ad525fd145ce6db5968', @groupId,0),
    (55, 45, 16, 17, 6, 7.5, 175, 225, 'OP', '90a5a670f5e41f760aa454efbf53ee45', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TESLA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Roadster' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2011' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = '2.5' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 110, '14798', 1697790698);
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, 45, 16, 17, 6, 7.5, 175, 225, 'OR', '3c0afb24a3a74ad525fd145ce6db5968', @groupId,0),
    (55, 45, 16, 17, 6, 7.5, 175, 225, 'OP', '90a5a670f5e41f760aa454efbf53ee45', @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 = '2011' 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, '44864', 1697790698);
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 = '2011' 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, '44866', 1697790698);
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 = '2011' 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, '44868', 1697790698);
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 = '2011' 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, '10366', 1697790698);
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),
    (60, 60, 16, 16, 7, 7, 215, 215, 'OP', 'd769b192da345167df4085ec0bb72dd3', @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 = '2011' 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, '10367', 1697790698);
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),
    (60, 60, 16, 16, 7, 7, 215, 215, 'OP', 'd769b192da345167df4085ec0bb72dd3', @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 = '2011' 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, '10368', 1697790698);
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),
    (60, 60, 16, 16, 7, 7, 215, 215, 'OP', 'd769b192da345167df4085ec0bb72dd3', @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 = '2011' 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, '10516', 1697790698);
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, 16, 16, 6.5, 6.5, 215, 215, 'OR', 'c22c13d75e7475b3db942148a47c7287', @groupId,0),
    (65, 65, 15, 15, 6.5, 6.5, 205, 205, 'OP', '7ffcf95e8f1e7b986969a55d4a084add', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @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 = '2011' 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, '10517', 1697790698);
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, 16, 16, 6.5, 6.5, 215, 215, 'OR', 'c22c13d75e7475b3db942148a47c7287', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OR', '0b4657a1241af9e5427d78558d5910f5', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OR', 'ba869085fbcf75c6d7823f4d3d835d02', @groupId,0),
    (65, 65, 15, 15, 6.5, 6.5, 205, 205, 'OP', '7ffcf95e8f1e7b986969a55d4a084add', @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 = '2011' 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, '10519', 1697790698);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2011' 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, '10521', 1697790698);
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, 16, 16, 6.5, 6.5, 215, 215, 'OR', 'c22c13d75e7475b3db942148a47c7287', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OR', 'ba869085fbcf75c6d7823f4d3d835d02', @groupId,0),
    (65, 65, 15, 15, 6.5, 6.5, 205, 205, 'OP', '7ffcf95e8f1e7b986969a55d4a084add', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OP', '6db45cd6720213ac7e906e8720faf609', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0),
    (55, 55, 17, 17, 7.5, 7.5, 215, 215, 'OP', '64ed75586506ac9be2d7babe73594201', @groupId,0),
    (45, 45, 18, 18, 7.5, 7.5, 225, 225, 'OP', 'b6ac74044c901fbd6ce63df9f6c2b5e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'TOYOTA' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camry' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2011' 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, '10523', 1697790698);
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, 16, 16, 6.5, 6.5, 215, 215, 'OR', 'c22c13d75e7475b3db942148a47c7287', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 205, 205, 'OR', '0b4657a1241af9e5427d78558d5910f5', @groupId,0),
    (65, 65, 15, 15, 6.5, 6.5, 205, 205, 'OP', '7ffcf95e8f1e7b986969a55d4a084add', @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 = '2011' 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, '10861', 1697790699);
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 = 'RAV4' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2011' 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, '45315', 1697790699);
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 = '2011' 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, '45319', 1697790699);
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 = '2011' 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, '45323', 1697790699);
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 = '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 = '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, 112, '12733', 1697790704);
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 = '2012' 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, '12734', 1697790704);
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 = '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, 112, '9847', 1697790704);
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),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (45, 45, 17, 17, 8, 8, 235, 235, 'OP', '890ed40dd90b52ab63f494e5da78aa69', @groupId,0),
    (45, 45, 17, 17, 8, 8, 245, 245, 'OP', 'b8bed917f01db4a14c03b7b21722f62c', @groupId,0),
    (40, 40, 18, 18, 8, 8, 245, 245, 'OP', '53c388af54652de7a28689a78dc50d19', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0),
    (35, 35, 19, 19, 8, 8, 255, 255, 'OP', '33a40cc2f8e93ed6c72c4869b6ae4d01', @groupId,0),
    (35, 35, 19, 19, 8.5, 8.5, 255, 255, 'OP', '852a246236c80009ad009398f91db0b5', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'AUDI' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Q7' 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, 130, '51287', 1697790705);
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 = '2012' 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, '51288', 1697790705);
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 = '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, 130, '51289', 1697790705);
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, '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 = '2012' 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, '51290', 1697790705);
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 = '2012' 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, '51291', 1697790705);
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 = '2012' 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, '51292', 1697790705);
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 = '2012' 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, '51293', 1697790705);
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 = '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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ActiveHybrid' AND level3_id = @l3 LIMIT 1);
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, '12592', 1697790707);
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 = '750i' 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, '12593', 1697790707);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 18, 18, 8, 8, 245, 245, 'OR', 'a713e52ecaf4205d74c4abc3ddc4043c', @groupId,0),
    (45, 40, 19, 19, 8.5, 9.5, 245, 275, 'OR', 'dbeece92a56438be8a56d2bbf1160f56', @groupId,0),
    (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 = '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, '2672', 1697790707);
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 = '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, '2673', 1697790707);
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 = '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, 6, 132, '52558', 1697790708);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (60, 60, 19, 19, 7.5, 7.5, 255, 255, 'OR', 'eaaf964e229af76fbde30ab6a35c8f05', @groupId,0),
    (65, 65, 18, 18, 7.5, 7.5, 255, 255, 'OP', '757d55cde164fd46a0201b8d1f6e250d', @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 = 'Verano' 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, 115, '17204', 1697790708);
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 = '2012' 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, '17205', 1697790708);
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 = '2012' 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, '17206', 1697790708);
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 = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Escalade' 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, 6, 139.7, '24311', 1697790708);
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, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 9, 9, 275, 275, 'OR', '467df53db9b387a1db06945277ce7e00', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @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 = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Escalade' 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 = 'Platinum' AND level3_id = @l3 LIMIT 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, '24313', 1697790708);
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, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @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.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (55, 55, 20, 20, 9, 9, 275, 275, 'OP', '68ef29c821155af3f53328eb9a1519a3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Escalade' 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 = 'Luxury' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '24315', 1697790708);
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, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @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);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Escalade' 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, 6, 139.7, '24317', 1697790708);
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, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @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);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Escalade' 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, 6, 139.7, '24319', 1697790709);
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, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CADILLAC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Escalade' 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 Platinum' AND level3_id = @l3 LIMIT 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, '24321', 1697790709);
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, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @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);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camaro' 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 = 'ZL1' AND level3_id = @l3 LIMIT 1);
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, '4538', 1697790709);
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, 20, 20, 10, 11, 285, 305, 'OR', 'cbf0020b6a5d37dfb95b20a633a229e7', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camaro' 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 = 'LS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120, '4539', 1697790709);
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, 245, 245, 'OR', '44f16c7153c873727d4724581e0bc2fe', @groupId,0),
    (55, 50, 18, 19, 7.5, 8, 245, 245, 'OP', '719b19b572411e15a3849a2e1d92f276', @groupId,0),
    (45, 40, 20, 20, 8, 9, 245, 275, 'OP', '4ec12897a9afad2acf75de069f63c5df', @groupId,0),
    (40, 35, 21, 21, 8.5, 9.5, 245, 275, 'OP', '3d5044206192c2d96a1a7dad65199a0b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camaro' 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 = 'LT' AND level3_id = @l3 LIMIT 1);
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, '4540', 1697790709);
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, 50, 18, 19, 7.5, 8, 245, 245, 'OR', '28e688e89da60f9e132b4dc93a73412a', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 245, 245, 'OP', 'af5522b52b68a1f8c2bae416ef4f4aaf', @groupId,0),
    (45, 40, 20, 20, 8, 9, 245, 275, 'OP', '4ec12897a9afad2acf75de069f63c5df', @groupId,0),
    (40, 35, 21, 21, 8.5, 9.5, 245, 275, 'OP', '3d5044206192c2d96a1a7dad65199a0b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camaro' 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 = 'LT' AND level3_id = @l3 LIMIT 1);
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, '4541', 1697790709);
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, 245, 245, 'OR', '1a009258ef2ea5befc3657e4d96e5b70', @groupId,0),
    (50, 50, 19, 19, 8, 8, 245, 245, 'OP', '3b520d2b3d0cf00b389c0f3e04ace717', @groupId,0),
    (45, 40, 20, 20, 8, 8.5, 245, 275, 'OP', '2b9ca665beafb4cce86876b340710bc5', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camaro' 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 = 'SS' AND level3_id = @l3 LIMIT 1);
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, '4542', 1697790709);
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, 20, 20, 8, 9, 245, 275, 'OR', 'f819e175d85b76af2a1fd72582a33b82', @groupId,0),
    (35, 35, 20, 20, 10, 11, 285, 285, 'OP', 'c13c6c136fda3946967831cb37b8fc49', @groupId,0),
    (40, 35, 21, 21, 8.5, 9.5, 245, 275, 'OP', '3d5044206192c2d96a1a7dad65199a0b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Camaro' 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 = 'SS' AND level3_id = @l3 LIMIT 1);
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, '4543', 1697790709);
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, 20, 20, 8, 9, 245, 275, 'OR', 'f819e175d85b76af2a1fd72582a33b82', @groupId,0),
    (35, 35, 20, 20, 10, 11, 285, 285, 'OP', 'c13c6c136fda3946967831cb37b8fc49', @groupId,0),
    (40, 35, 21, 21, 8.5, 9.5, 245, 275, 'OP', '3d5044206192c2d96a1a7dad65199a0b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Equinox' 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 = 'LS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 120, '49059', 1697790710);
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),
    (55, 55, 18, 18, 7, 7, 235, 235, 'OP', 'ea14fff92bcba6405d10ba75443865bc', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Equinox' 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 = 'LT' AND level3_id = @l3 LIMIT 1);
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, '49061', 1697790710);
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),
    (55, 55, 18, 18, 7, 7, 235, 235, 'OR', '57187f8bf7f7d7ec1822890740ba2252', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OR', '69e6877aac0d7e86fee1ab077616011a', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Equinox' 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 = 'LTZ' AND level3_id = @l3 LIMIT 1);
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, '49065', 1697790710);
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),
    (55, 55, 18, 18, 7, 7, 235, 235, 'OR', '57187f8bf7f7d7ec1822890740ba2252', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Malibu' 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 = 'LS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 110, '4952', 1697790710);
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),
    (50, 50, 17, 17, 7, 7, 225, 225, 'OP', '039fe8f6dcdd5d6155db682a01a927ed', @groupId,0),
    (50, 50, 18, 18, 7, 7, 225, 225, 'OP', '9c84ff717f134be188573eb949a8e7b0', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Malibu' 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 = 'LT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 110, '4953', 1697790710);
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),
    (50, 50, 18, 18, 7, 7, 225, 225, 'OR', '424917b3a2bf577ccb1e011fba2c4b1e', @groupId,0),
    (50, 50, 17, 17, 7, 7, 225, 225, 'OP', '039fe8f6dcdd5d6155db682a01a927ed', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Malibu' 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 = 'LTZ' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 110, '4955', 1697790710);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (50, 50, 18, 18, 7, 7, 225, 225, 'OR', '424917b3a2bf577ccb1e011fba2c4b1e', @groupId,0),
    (50, 50, 17, 17, 7, 7, 225, 225, 'OP', '039fe8f6dcdd5d6155db682a01a927ed', @groupId,0),
    (55, 55, 17, 17, 7, 7, 215, 215, 'OP', '136d00ddb01acce9162f91f39d56285d', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Tahoe' 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, 6, 139.7, '29808', 1697790712);
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, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (60, 60, 17, 17, 7.5, 7.5, 265, 265, 'OP', '6a522dd797bc28813fef98d4bbec0cab', @groupId,0),
    (65, 65, 18, 18, 8.5, 8.5, 265, 265, 'OP', '8a549876ef910c87fa452836973ba84e', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 8.5, 8.5, 285, 285, 'OP', '4876df4039eb4f97566fbcdd630d7e39', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Tahoe' 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 = 'LS' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '29810', 1697790712);
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, 17, 17, 7.5, 7.5, 265, 265, 'OP', '6a522dd797bc28813fef98d4bbec0cab', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (65, 65, 18, 18, 8.5, 8.5, 265, 265, 'OP', '8a549876ef910c87fa452836973ba84e', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 8.5, 8.5, 285, 285, 'OP', '4876df4039eb4f97566fbcdd630d7e39', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Tahoe' 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 = 'LT' AND level3_id = @l3 LIMIT 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, '29812', 1697790712);
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, 17, 17, 7.5, 7.5, 265, 265, 'OP', '6a522dd797bc28813fef98d4bbec0cab', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (65, 65, 18, 18, 8.5, 8.5, 265, 265, 'OP', '8a549876ef910c87fa452836973ba84e', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 8.5, 8.5, 285, 285, 'OP', '4876df4039eb4f97566fbcdd630d7e39', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Tahoe' 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 = 'LTZ' AND level3_id = @l3 LIMIT 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, '29814', 1697790712);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OR', '0eec3266a634b04eb62ad0c791d0d09c', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (60, 60, 17, 17, 7.5, 7.5, 265, 265, 'OP', '6a522dd797bc28813fef98d4bbec0cab', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (65, 65, 18, 18, 8.5, 8.5, 265, 265, 'OP', '8a549876ef910c87fa452836973ba84e', @groupId,0),
    (45, 45, 22, 22, 8.5, 8.5, 285, 285, 'OP', '4876df4039eb4f97566fbcdd630d7e39', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Tahoe' 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 = 'PPV' AND level3_id = @l3 LIMIT 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, '29816', 1697790712);
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.5, 7.5, 265, 265, 'OR', '05b89b919f0d9f7bdfe30ea2555a4957', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (65, 65, 18, 18, 8.5, 8.5, 265, 265, 'OP', '8a549876ef910c87fa452836973ba84e', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 8.5, 8.5, 285, 285, 'OP', '4876df4039eb4f97566fbcdd630d7e39', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHEVROLET' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Tahoe' 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 = 'SSV' AND level3_id = @l3 LIMIT 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, '29817', 1697790712);
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.5, 7.5, 265, 265, 'OR', '05b89b919f0d9f7bdfe30ea2555a4957', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (65, 65, 18, 18, 8.5, 8.5, 265, 265, 'OP', '8a549876ef910c87fa452836973ba84e', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 8.5, 8.5, 285, 285, 'OP', '4876df4039eb4f97566fbcdd630d7e39', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Town & Country' 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, '68274', 1697790712);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 225, 225, 'OP', 'dda26f23cbb781a17b2790ef16198b79', @groupId,0),
    (60, 60, 16, 16, 6.5, 6.5, 235, 235, 'OP', 'c9ef64b58aa0ae3209451051c8e6d663', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Town & Country' 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, 127, '68275', 1697790712);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 225, 225, 'OP', 'dda26f23cbb781a17b2790ef16198b79', @groupId,0),
    (60, 60, 16, 16, 6.5, 6.5, 235, 235, 'OP', 'c9ef64b58aa0ae3209451051c8e6d663', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'CHRYSLER' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Town & Country' 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 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, 127, '68276', 1697790712);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OR', 'ea9cfb874f8253935e7fd3a46f615c73', @groupId,0),
    (65, 65, 16, 16, 6.5, 6.5, 225, 225, 'OP', 'dda26f23cbb781a17b2790ef16198b79', @groupId,0),
    (60, 60, 16, 16, 6.5, 6.5, 235, 235, 'OP', 'c9ef64b58aa0ae3209451051c8e6d663', @groupId,0),
    (65, 65, 17, 17, 6.5, 6.5, 225, 225, 'OP', 'b1c8377a4af6d8ee1773c55f2d8bfb60', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Challenger' 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 = 'R/T' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '3311', 1697790713);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OR', '635e0cb0fdeb99d3d1d7486d4ab2827e', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OP', '8e615abef1a93a6715f94c18726e3478', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 245, 'OP', '28d385845a68b1400b514f6a1e96aade', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Challenger' 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, 115, '3312', 1697790713);
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, 245, 245, 'OR', 'e19f110915f01b488218f1f1baa4650e', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 255, 'OP', 'edd3806f387efa548e3c5eacbd6f284a', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Challenger' 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 = 'SXT' AND level3_id = @l3 LIMIT 1);
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, '3313', 1697790713);
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, 20, 20, 8, 8, 245, 245, 'OR', 'c6ced0d6324fd1dc5955ff7e325dfc6a', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 245, 'OP', '28d385845a68b1400b514f6a1e96aade', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Challenger' 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 = 'SXT 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, 115, '3314', 1697790713);
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, 20, 20, 8, 8, 245, 245, 'OR', 'c6ced0d6324fd1dc5955ff7e325dfc6a', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 245, 'OP', '28d385845a68b1400b514f6a1e96aade', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Challenger' 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 = 'R/T Classic' AND level3_id = @l3 LIMIT 1);
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, '3315', 1697790713);
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, 20, 20, 8, 8, 245, 245, 'OR', 'c6ced0d6324fd1dc5955ff7e325dfc6a', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 245, 'OP', '28d385845a68b1400b514f6a1e96aade', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Charger' 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 = 'R/T' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 115, '3473', 1697790713);
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),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OR', '69e6877aac0d7e86fee1ab077616011a', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OR', 'c6ced0d6324fd1dc5955ff7e325dfc6a', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 215, 215, 'OP', '0c2cbf9e3ee7239ed8074e004fbf8cf4', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 225, 225, 'OP', '8e4ef9adbf4e86e7806464635d945b5a', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OP', '8e615abef1a93a6715f94c18726e3478', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Charger' 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, 115, '3475', 1697790713);
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, 215, 215, 'OR', '1797c4f25f34c7291614d192b7de97ae', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 225, 225, 'OP', '8e4ef9adbf4e86e7806464635d945b5a', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OP', '8e615abef1a93a6715f94c18726e3478', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 245, 'OP', '28d385845a68b1400b514f6a1e96aade', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Charger' 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 = 'SXT' AND level3_id = @l3 LIMIT 1);
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, '3477', 1697790713);
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, 215, 215, 'OR', '1797c4f25f34c7291614d192b7de97ae', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OR', '635e0cb0fdeb99d3d1d7486d4ab2827e', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OR', '69e6877aac0d7e86fee1ab077616011a', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OR', 'c6ced0d6324fd1dc5955ff7e325dfc6a', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 215, 215, 'OP', '0c2cbf9e3ee7239ed8074e004fbf8cf4', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 225, 225, 'OP', '8e4ef9adbf4e86e7806464635d945b5a', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OP', '8e615abef1a93a6715f94c18726e3478', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 245, 'OP', '28d385845a68b1400b514f6a1e96aade', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Charger' 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, 115, '3479', 1697790713);
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, 245, 245, 'OR', 'e19f110915f01b488218f1f1baa4650e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Charger' 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 = 'SXT 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, 115, '3480', 1697790713);
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),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OR', '69e6877aac0d7e86fee1ab077616011a', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 215, 215, 'OP', '0c2cbf9e3ee7239ed8074e004fbf8cf4', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 225, 225, 'OP', '8e4ef9adbf4e86e7806464635d945b5a', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OP', '8e615abef1a93a6715f94c18726e3478', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Charger' 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 = 'Pursuit' AND level3_id = @l3 LIMIT 1);
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, '3482', 1697790713);
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.5, 7.5, 225, 225, 'OR', '75d3b8172a60e82d854fb6e22c2d40fe', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OP', 'f4aa7cea82fd814bf26aece98a241eaf', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OP', '8e615abef1a93a6715f94c18726e3478', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'DODGE' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Charger' 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 = 'Enforcer' AND level3_id = @l3 LIMIT 1);
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, '3484', 1697790713);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 18, 18, 7.5, 7.5, 235, 235, 'OR', '635e0cb0fdeb99d3d1d7486d4ab2827e', @groupId,0),
    (65, 65, 17, 17, 7, 7, 215, 215, 'OP', 'c66e12ba7b462e80fedab380ae521569', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 225, 225, 'OP', '8e4ef9adbf4e86e7806464635d945b5a', @groupId,0),
    (55, 55, 19, 19, 7.5, 7.5, 235, 235, 'OP', '5a2d11a91fc9df1d01ded730c564b4c4', @groupId,0),
    (45, 45, 20, 20, 8, 8, 245, 245, 'OP', '8e615abef1a93a6715f94c18726e3478', @groupId,0),
    (45, 45, 20, 20, 9, 9, 245, 245, 'OP', '28d385845a68b1400b514f6a1e96aade', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Explorer' 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, '36218', 1697790715);
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, 235, 235, 'OR', 'fa2f745b74993ccf2d7f8a1fef3ca712', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 245, 245, 'OR', '7acca5f646d0c4a8665dfb4bc9dad3d4', @groupId,0),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OP', '15975c11f614af14abd3df68f3570f7f', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 245, 245, 'OP', '08d73651d6389a428d5d1b5a9c90c648', @groupId,0),
    (50, 50, 20, 20, 8, 8, 255, 255, 'OP', '204280f614597a467dbb8219771b9d69', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Explorer' 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, '36222', 1697790715);
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, 255, 255, 'OR', '3dc884a6b24f823d3296b59349f0b59a', @groupId,0),
    (70, 70, 16, 16, 7, 7, 235, 235, 'OP', '15975c11f614af14abd3df68f3570f7f', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 245, 245, 'OP', 'de453c537cd9d585bce29405db8787e9', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 245, 245, 'OP', '08d73651d6389a428d5d1b5a9c90c648', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Explorer' 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 = 'XLT' AND level3_id = @l3 LIMIT 1);
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, '36226', 1697790715);
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, 235, 235, 'OR', 'fa2f745b74993ccf2d7f8a1fef3ca712', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 245, 245, 'OR', '7acca5f646d0c4a8665dfb4bc9dad3d4', @groupId,0),
    (50, 50, 20, 20, 8, 8, 255, 255, 'OR', '3dc884a6b24f823d3296b59349f0b59a', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 245, 245, 'OP', '08d73651d6389a428d5d1b5a9c90c648', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'F-150' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'FX2' AND level3_id = @l3 LIMIT 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, 135, '37293', 1697790715);
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),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OR', '0eec3266a634b04eb62ad0c791d0d09c', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 235, 235, 'OP', 'd9c0a9e2fa606c281bf19a3d14ec53ed', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OP', 'a961c39855fd07387114d392a2fe9be4', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (75, 75, 17, 17, 8, 8, 245, 245, 'OP', 'af661cb91e09c5e6840e18d2a018f780', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 265, 265, 'OP', 'c70d56788e6db40b080abc1bf05f84ab', @groupId,0),
    (65, 65, 18, 18, 8, 8, 275, 275, 'OP', '96bf0088414c8daafc7e4a7f4d2f14c8', @groupId,0),
    (45, 45, 22, 22, 9, 9, 275, 275, 'OP', 'e30fd22ced01037a4c3cfa9cf9cf8e3b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'F-150' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'FX2' AND level3_id = @l3 LIMIT 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, 135, '37295', 1697790715);
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),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OR', '0eec3266a634b04eb62ad0c791d0d09c', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 235, 235, 'OP', 'd9c0a9e2fa606c281bf19a3d14ec53ed', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OP', 'a961c39855fd07387114d392a2fe9be4', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (75, 75, 17, 17, 8, 8, 245, 245, 'OP', 'af661cb91e09c5e6840e18d2a018f780', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 265, 265, 'OP', 'c70d56788e6db40b080abc1bf05f84ab', @groupId,0),
    (65, 65, 18, 18, 8, 8, 275, 275, 'OP', '96bf0088414c8daafc7e4a7f4d2f14c8', @groupId,0),
    (45, 45, 22, 22, 9, 9, 275, 275, 'OP', 'e30fd22ced01037a4c3cfa9cf9cf8e3b', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'F-150' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'FX4' AND level3_id = @l3 LIMIT 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, 135, '37297', 1697790715);
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, 8, 8, 275, 275, 'OR', '395a283bf5bcc379586345c030946363', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OR', '0eec3266a634b04eb62ad0c791d0d09c', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 255, 255, 'OP', 'f5cd51c10d606c05024b3b6e71634fce', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 235, 235, 'OP', '80cee18ae3ad1106f585e9757599b83c', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 235, 235, 'OP', 'd9c0a9e2fa606c281bf19a3d14ec53ed', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 255, 255, 'OP', '1b2fe33f0950c1b0c14bb8d55a5dd29c', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OP', 'b74e2e192c58e3a018d8e6170358db1b', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @groupId,0),
    (65, 65, 18, 18, 8, 8, 275, 275, 'OP', '96bf0088414c8daafc7e4a7f4d2f14c8', @groupId,0),
    (60, 60, 18, 18, 8, 8, 275, 275, 'OP', '57f7b1a4170551f06d7808540d282056', @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, 275, 275, 'OP', 'e30fd22ced01037a4c3cfa9cf9cf8e3b', @groupId,0);
