
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, '37299', 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);



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 = 'Harley-Davidson Edition' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 135, '37301', 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
    (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, 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 = '2012' 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, '37303', 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),
    (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 = '2012' 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, '37307', 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),
    (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 = '2012' 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, '37310', 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),
    (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 = '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, 135, '37319', 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
    (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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'STX' AND level3_id = @l3 LIMIT 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, '37325', 1697790716);
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, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @groupId,0),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OR', '807866a037614df1ae9fc9bea134f712', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OR', 'be1026d8ee9ebee3f18eb1c68f9225e6', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 265, 265, 'OR', '2fb2d9c2d6f802502bb1d232b4bdc96a', @groupId,0),
    (65, 65, 18, 18, 8, 8, 275, 275, 'OR', '395a283bf5bcc379586345c030946363', @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),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (75, 75, 17, 17, 8, 8, 245, 245, 'OP', 'af661cb91e09c5e6840e18d2a018f780', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'STX' AND level3_id = @l3 LIMIT 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, '37327', 1697790716);
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, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @groupId,0),
    (70, 70, 17, 17, 8, 8, 255, 255, 'OR', '807866a037614df1ae9fc9bea134f712', @groupId,0),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OR', 'be1026d8ee9ebee3f18eb1c68f9225e6', @groupId,0),
    (60, 60, 18, 18, 7.5, 7.5, 265, 265, 'OR', '2fb2d9c2d6f802502bb1d232b4bdc96a', @groupId,0),
    (65, 65, 18, 18, 8, 8, 275, 275, 'OR', '395a283bf5bcc379586345c030946363', @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),
    (70, 70, 17, 17, 8, 8, 265, 265, 'OP', '10235406f2c3aaa25cc189d2010d90be', @groupId,0),
    (75, 75, 17, 17, 8, 8, 245, 245, 'OP', 'af661cb91e09c5e6840e18d2a018f780', @groupId,0),
    (75, 75, 17, 17, 8, 8, 235, 235, 'OP', '217dc6360ecf44739513e8c835eeb6e3', @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 = '2012' 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, '37333', 1697790716);
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 = '2012' 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, '37334', 1697790716);
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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XL' AND level3_id = @l3 LIMIT 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, '37335', 1697790716);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (75, 75, 17, 17, 7.5, 7.5, 235, 235, 'OR', '2f455dcbc852a1ab567519de651ef278', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 235, 235, 'OR', '1848bee63f26fdb8a91b11da2fc64f80', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @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, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 255, 255, 'OP', '1b2fe33f0950c1b0c14bb8d55a5dd29c', @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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XL' AND level3_id = @l3 LIMIT 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, '37338', 1697790716);
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),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @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),
    (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, 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 = '2012' AND level2_id = @l2 LIMIT 1);
SET @l4 = (SELECT id FROM `%%XC%%_level4` WHERE value = 'XL' AND level3_id = @l3 LIMIT 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, '37341', 1697790716);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (75, 75, 17, 17, 7.5, 7.5, 235, 235, 'OR', '2f455dcbc852a1ab567519de651ef278', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 235, 235, 'OR', '1848bee63f26fdb8a91b11da2fc64f80', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @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, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 255, 255, 'OP', '1b2fe33f0950c1b0c14bb8d55a5dd29c', @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 = '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, 6, 135, '37353', 1697790716);
SET @groupId = LAST_INSERT_ID();

INSERT INTO `%%XC%%_vehicle_attribute_values`
    (aspectRatio, aspectRatioRear, rimDiameter, rimDiameterRear, rimWidth, rimWidthRear, sectionWidth, sectionWidthRear, type, hash, vehicleAttributeGroup, autoSyncUpdateTime)
VALUES
    (75, 75, 17, 17, 7.5, 7.5, 235, 235, 'OR', '2f455dcbc852a1ab567519de651ef278', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 235, 235, 'OR', '1848bee63f26fdb8a91b11da2fc64f80', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @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, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 255, 255, 'OP', '1b2fe33f0950c1b0c14bb8d55a5dd29c', @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 = '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, 6, 135, '37356', 1697790716);
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, 235, 235, 'OR', '1848bee63f26fdb8a91b11da2fc64f80', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 235, 235, 'OR', '2f455dcbc852a1ab567519de651ef278', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @groupId,0),
    (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, 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, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 255, 255, 'OP', '1b2fe33f0950c1b0c14bb8d55a5dd29c', @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 = '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, 6, 135, '37359', 1697790716);
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, 235, 235, 'OR', '1848bee63f26fdb8a91b11da2fc64f80', @groupId,0),
    (75, 75, 17, 17, 7.5, 7.5, 235, 235, 'OR', '2f455dcbc852a1ab567519de651ef278', @groupId,0),
    (70, 70, 17, 17, 7.5, 7.5, 265, 265, 'OR', 'ba6a36e93d85bebd95167fc6f26ba4f5', @groupId,0),
    (65, 65, 17, 17, 8, 8, 255, 255, 'OR', 'e4b360feaf431a580a75dd30ebf304f5', @groupId,0),
    (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, 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, 245, 245, 'OP', '01437c4586a27eda771d707338f67e08', @groupId,0),
    (65, 65, 17, 17, 7.5, 7.5, 255, 255, 'OP', '1b2fe33f0950c1b0c14bb8d55a5dd29c', @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 = '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, '162203', 1697790716);
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, '162204', 1697790716);
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, '162205', 1697790716);
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);



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, '162206', 1697790716);
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);



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 = 'Harley-Davidson Edition' AND level3_id = @l3 LIMIT 1);
INSERT INTO `%%XC%%_vehicle_attribute_groups`
    (level1_id, level2_id, level3_id, level4_id, lugCount, boltCircle, autoSyncId, autoSyncUpdateTime)
VALUES
    (@l1, @l2, @l3, @l4, 6, 135, '162207', 1697790716);
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, 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, 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);