
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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Lariat' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 135, '162257', 1697790947);
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),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OR', '4def77b3164781de6bde51239bd97ef4', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @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),
    (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, 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),
    (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),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OP', 'b74e2e192c58e3a018d8e6170358db1b', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @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),
    (60, 60, 18, 18, 8, 8, 275, 275, 'OP', '57f7b1a4170551f06d7808540d282056', @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);



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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Lariat' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 135, '162258', 1697790947);
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),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OR', '4def77b3164781de6bde51239bd97ef4', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @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),
    (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, 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),
    (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),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OP', 'b74e2e192c58e3a018d8e6170358db1b', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @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),
    (60, 60, 18, 18, 8, 8, 275, 275, 'OP', '57f7b1a4170551f06d7808540d282056', @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);



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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'King Ranch' AND level3_id = @l3 LIMIT 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, '162259', 1697790947);
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),
    (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),
    (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, 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),
    (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),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OP', 'b74e2e192c58e3a018d8e6170358db1b', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @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),
    (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);



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 = '2013' 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, 135, '162260', 1697790947);
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, 235, 235, 'OP', 'd9c0a9e2fa606c281bf19a3d14ec53ed', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @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, 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),
    (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),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OP', 'b74e2e192c58e3a018d8e6170358db1b', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 265, 265, 'OP', 'c70d56788e6db40b080abc1bf05f84ab', @groupId,0),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OP', '76bfeb7c9e624ab58dd5931b3ec74a4a', @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);



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 = '2013' 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, 135, '162261', 1697790947);
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, 255, 255, 'OR', '7b62bc61cbce68d1952edd53aceadedc', @groupId,0),
    (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),
    (45, 45, 22, 22, 9, 9, 275, 275, 'OR', '07308cab9d254dcbc3d5fbce12f66a73', @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),
    (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, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @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),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OP', 'b74e2e192c58e3a018d8e6170358db1b', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 265, 265, 'OP', 'c70d56788e6db40b080abc1bf05f84ab', @groupId,0),
    (60, 60, 18, 18, 8, 8, 265, 265, 'OP', '76bfeb7c9e624ab58dd5931b3ec74a4a', @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);



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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SVT Raptor' AND level3_id = @l3 LIMIT 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, '162262', 1697790947);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 8.5, 8.5, 315, 315, 'OR', '119a8fa99109b6bcdf761531cfc5d41c', @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 = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SVT Raptor' AND level3_id = @l3 LIMIT 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, '162263', 1697790975);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 8.5, 8.5, 315, 315, 'OR', '119a8fa99109b6bcdf761531cfc5d41c', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Focus' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Electric' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 108, '5593', 1697790978);
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),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (50, 50, 17, 17, 7, 7, 215, 215, 'OP', 'f9dea9d51e9ac8c54e19c572e7216c7c', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Focus' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'ST' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 108, '5594', 1697790978);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (40, 40, 18, 18, 8, 8, 235, 235, 'OR', '0872dbea0031b30b4704560186e0f49f', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Focus' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'S' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 108, '5595', 1697790978);
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.5, 6.5, 195, 195, 'OR', '05d872c13425de1167492cbd9f48df84', @groupId,0),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (50, 50, 17, 17, 7, 7, 215, 215, 'OP', 'f9dea9d51e9ac8c54e19c572e7216c7c', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Focus' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = '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, 108, '5596', 1697790978);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 7, 7, 215, 215, 'OR', '236b23820ac5e4e3320ae994b2ea9927', @groupId,0),
    (50, 50, 17, 17, 7, 7, 215, 215, 'OR', 'd6cee30b6228b25f6cc39cb5daf4c21d', @groupId,0),
    (50, 50, 17, 17, 7, 7, 225, 225, 'OP', '039fe8f6dcdd5d6155db682a01a927ed', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Focus' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = '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, 108, '5597', 1697790978);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (55, 55, 16, 16, 7, 7, 215, 215, 'OR', '236b23820ac5e4e3320ae994b2ea9927', @groupId,0),
    (50, 50, 17, 17, 7, 7, 215, 215, 'OR', 'd6cee30b6228b25f6cc39cb5daf4c21d', @groupId,0),
    (65, 65, 15, 15, 6.5, 6.5, 195, 195, 'OP', 'e8eecaff7dc9f5f871c0c43d090ca4b6', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OP', '45f6b674b1fbde55d564884af509b6e3', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Focus' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Titanium' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 108, '5598', 1697790979);
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, 215, 215, 'OR', 'd6cee30b6228b25f6cc39cb5daf4c21d', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OR', '0872dbea0031b30b4704560186e0f49f', @groupId,0),
    (65, 65, 15, 15, 6.5, 6.5, 195, 195, 'OP', 'e8eecaff7dc9f5f871c0c43d090ca4b6', @groupId,0),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Focus' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Titanium' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 108, '5599', 1697790979);
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, 215, 215, 'OR', 'd6cee30b6228b25f6cc39cb5daf4c21d', @groupId,0),
    (40, 40, 18, 18, 8, 8, 235, 235, 'OR', '0872dbea0031b30b4704560186e0f49f', @groupId,0),
    (55, 55, 16, 16, 7, 7, 215, 215, 'OP', 'ca9756fc7a697568195c0a13ab005bdf', @groupId,0),
    (50, 50, 17, 17, 7, 7, 225, 225, 'OP', '039fe8f6dcdd5d6155db682a01a927ed', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mustang' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'GT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '5788', 1697790979);
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, 235, 235, 'OR', 'ca7493ffed5d04e5ed1abe67215d7a80', @groupId,0),
    (45, 45, 19, 19, 8.5, 8.5, 245, 245, 'OR', '8023d2cab6a04b36ae8141b3348d44dd', @groupId,0),
    (55, 55, 17, 17, 8, 8, 235, 235, 'OP', 'a95c74d244d947f851250963d1ab733e', @groupId,0),
    (50, 50, 18, 18, 8.5, 8.5, 235, 235, 'OP', '9fd18128d8feaeb0055f2fe44732aeab', @groupId,0),
    (40, 40, 19, 19, 9, 9, 255, 255, 'OP', 'e6d8f69cf377299873c5e607d8e7e54c', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mustang' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'GT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '5789', 1697790979);
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, 235, 235, 'OR', 'ca7493ffed5d04e5ed1abe67215d7a80', @groupId,0),
    (45, 45, 19, 19, 8.5, 8.5, 245, 245, 'OR', '8023d2cab6a04b36ae8141b3348d44dd', @groupId,0),
    (40, 40, 19, 19, 9, 9, 255, 255, 'OR', '39ecc082411d2f0b9ef3496b8e9a3921', @groupId,0),
    (55, 55, 17, 17, 8, 8, 235, 235, 'OP', 'a95c74d244d947f851250963d1ab733e', @groupId,0),
    (50, 50, 18, 18, 8.5, 8.5, 235, 235, 'OP', '9fd18128d8feaeb0055f2fe44732aeab', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mustang' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '5790', 1697790979);
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),
    (40, 40, 19, 19, 8.5, 8.5, 255, 255, 'OR', '7324f348c8a09214a0e871268dc20b81', @groupId,0),
    (65, 65, 16, 16, 7, 7, 215, 215, 'OP', '19be3557ff9a357afe0e3f1fec95833b', @groupId,0),
    (60, 60, 17, 17, 7, 7, 215, 215, 'OP', '15b862c0f8fbf3e6b528c010a11c636e', @groupId,0),
    (60, 60, 17, 17, 7, 7, 225, 225, 'OP', '539fd9203a65c19b6e7345120bf3c8b3', @groupId,0),
    (55, 55, 17, 17, 8, 8, 235, 235, 'OP', 'a95c74d244d947f851250963d1ab733e', @groupId,0),
    (50, 50, 18, 18, 8, 8, 235, 235, 'OP', '301c35de5c71270b98eff18f1e407fa7', @groupId,0),
    (50, 50, 18, 18, 8.5, 8.5, 235, 235, 'OP', '9fd18128d8feaeb0055f2fe44732aeab', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mustang' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Base' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 5, 114.3, '5791', 1697790979);
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),
    (50, 50, 18, 18, 8.5, 8.5, 235, 235, 'OR', '81231762f4ba4822222a35662573a3ae', @groupId,0),
    (65, 65, 16, 16, 7, 7, 215, 215, 'OP', '19be3557ff9a357afe0e3f1fec95833b', @groupId,0),
    (60, 60, 17, 17, 7, 7, 215, 215, 'OP', '15b862c0f8fbf3e6b528c010a11c636e', @groupId,0),
    (60, 60, 17, 17, 7, 7, 225, 225, 'OP', '539fd9203a65c19b6e7345120bf3c8b3', @groupId,0),
    (55, 55, 17, 17, 8, 8, 235, 235, 'OP', 'a95c74d244d947f851250963d1ab733e', @groupId,0),
    (50, 50, 18, 18, 8, 8, 235, 235, 'OP', '301c35de5c71270b98eff18f1e407fa7', @groupId,0),
    (40, 40, 19, 19, 8.5, 8.5, 255, 255, 'OP', '5de874c20c99d5b599a7b9f228818f30', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mustang' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Boss 302' AND level3_id = @l3 LIMIT 1);
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, '5792', 1697790979);
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, 35, 19, 19, 9.5, 9.5, 255, 285, 'OR', '329b08a0ce0fa97198b25d4a41d5a377', @groupId,0),
    (45, 40, 18, 18, 9.5, 9.5, 255, 285, 'OP', '7a4696eb2f67073a479a68d0ba9911c8', @groupId,0),
    (35, 35, 20, 20, 9.5, 9.5, 255, 285, 'OP', '34c229d229cb552f20912a99bfe109ef', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mustang' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Shelby GT500' AND level3_id = @l3 LIMIT 1);
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, '5793', 1697790979);
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, 9.5, 9.5, 255, 285, 'OR', 'd78a463719504db0323154cafb2371a5', @groupId,0),
    (45, 40, 18, 18, 9.5, 9.5, 255, 285, 'OP', '7a4696eb2f67073a479a68d0ba9911c8', @groupId,0),
    (40, 35, 19, 19, 9.5, 9.5, 255, 285, 'OP', '44194930363dfaa4b67b7e43fd0907a2', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'FORD' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Mustang' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Shelby GT500' AND level3_id = @l3 LIMIT 1);
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, '5794', 1697790979);
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, 9.5, 9.5, 255, 285, 'OR', 'd78a463719504db0323154cafb2371a5', @groupId,0),
    (45, 40, 18, 18, 9.5, 9.5, 255, 285, 'OP', '7a4696eb2f67073a479a68d0ba9911c8', @groupId,0),
    (40, 35, 19, 19, 9.5, 9.5, 255, 285, 'OP', '44194930363dfaa4b67b7e43fd0907a2', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Acadia' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'Denali' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 132, '52399', 1697790979);
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, 8, 255, 255, 'OR', 'c48df419de20b033ce563ab90d25bcf9', @groupId,0),
    (65, 65, 18, 18, 7.5, 7.5, 255, 255, 'OP', '757d55cde164fd46a0201b8d1f6e250d', @groupId,0),
    (60, 60, 19, 19, 8, 8, 255, 255, 'OP', '2ab6eb009551cebefc9c140e56d65e11', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Acadia' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SL' AND level3_id = @l3 LIMIT 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, '52401', 1697790979);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (65, 65, 18, 18, 7.5, 7.5, 255, 255, 'OR', '19da3d9c628ca3b4486155ab1503a3e1', @groupId,0),
    (60, 60, 19, 19, 8, 8, 255, 255, 'OP', '2ab6eb009551cebefc9c140e56d65e11', @groupId,0),
    (55, 55, 20, 20, 8, 8, 255, 255, 'OP', '541097005133b0b41a6381a859ae9c77', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Acadia' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 132, '52403', 1697790993);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Acadia' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 132, '52405', 1697790993);
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, 8, 8, 255, 255, 'OR', 'f9dfb3d06a8fa4b440071804a505de9d', @groupId,0),
    (65, 65, 18, 18, 7.5, 7.5, 255, 255, 'OP', '757d55cde164fd46a0201b8d1f6e250d', @groupId,0),
    (55, 55, 20, 20, 8, 8, 255, 255, 'OP', '541097005133b0b41a6381a859ae9c77', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' 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, '31690', 1697790993);
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),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SL' AND level3_id = @l3 LIMIT 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, '31692', 1697790993);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SL' AND level3_id = @l3 LIMIT 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, '31694', 1697790993);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SL' AND level3_id = @l3 LIMIT 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, '31696', 1697790993);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31704', 1697790993);
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),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31707', 1697790993);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (75, 75, 16, 16, 7, 7, 235, 235, 'OP', '5d104904a1f68cb534d23a8486bee719', @groupId,0),
    (70, 70, 16, 16, 7, 7, 255, 255, 'OP', '377c68794de85041a0a5484040494184', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31710', 1697790993);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @groupId,0),
    (75, 75, 16, 16, 7, 7, 235, 235, 'OP', '5d104904a1f68cb534d23a8486bee719', @groupId,0),
    (70, 70, 16, 16, 7, 7, 255, 255, 'OP', '377c68794de85041a0a5484040494184', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31713', 1697790993);
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),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLE' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31716', 1697790993);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (75, 75, 16, 16, 7, 7, 235, 235, 'OP', '5d104904a1f68cb534d23a8486bee719', @groupId,0),
    (70, 70, 16, 16, 7, 7, 255, 255, 'OP', '377c68794de85041a0a5484040494184', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31734', 1697790993);
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),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OR', 'be1026d8ee9ebee3f18eb1c68f9225e6', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @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),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OP', '7e3e62f4ddaf8affe31713dad4547372', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31736', 1697790993);
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),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OR', 'be1026d8ee9ebee3f18eb1c68f9225e6', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OR', '0eec3266a634b04eb62ad0c791d0d09c', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @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),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'SLT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31738', 1697790993);
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),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OR', 'be1026d8ee9ebee3f18eb1c68f9225e6', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OR', '4d038474e59833b103fa58ba953787bb', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OR', '99639ff7eeda75e5a889e9325f559768', @groupId,0),
    (55, 55, 20, 20, 8.5, 8.5, 275, 275, 'OR', '0eec3266a634b04eb62ad0c791d0d09c', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OR', '36e13b6b7601e660230d2caddcf91c2a', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @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),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'WT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31746', 1697790993);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'WT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31749', 1697790993);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'WT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31752', 1697790994);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'WT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31755', 1697790994);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'WT' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 139.7, '31758', 1697790994);
SET @groupId = LAST_INSERT_ID();

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



SET @l1 = (SELECT id FROM `%%XC%%_level1` WHERE value = 'GMC' LIMIT 1);
SET @l2 = (SELECT id FROM `%%XC%%_level2` WHERE value = 'Sierra 1500' AND level1_id = @l1 LIMIT 1);
SET @l3 = (SELECT id FROM `%%XC%%_level3` WHERE value = '2013' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XFE' AND level3_id = @l3 LIMIT 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, '31776', 1697790994);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OR', 'f493355b63f18d26cb2b19094d362bab', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OP', '04fd5a66776abe46265724c4db833166', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 245, 245, 'OP', '4a186bedb7a10cd2bf0f4566f354d359', @groupId,0),
    (65, 65, 18, 18, 8, 8, 265, 265, 'OP', 'db3db69b3d8c3ef81b71871a3e4fc05b', @groupId,0),
    (55, 55, 20, 20, 8, 8, 275, 275, 'OP', '49cc73749ea8b3ecbe3f6f975c397ddb', @groupId,0),
    (45, 45, 22, 22, 9, 9, 285, 285, 'OP', '76f2510e60ba61ca9fd092fbdaea496e', @groupId,0);