
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 = '2010' 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, '37172', 1697790576);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37175', 1697790576);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37177', 1697790576);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37178', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37181', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37183', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37185', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37193', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37195', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37197', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37205', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37207', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37209', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '37211', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '162061', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '162062', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '162063', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '162064', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '162065', 1697790577);
SET @groupId = LAST_INSERT_ID();



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 = '2010' 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, '162066', 1697790577);
SET @groupId = LAST_INSERT_ID();