-- Automatisch generierte SQL-Statements für Node Predecessor Chains
-- Generiert aus: pre_nodes.xlsx

-- Predecessor Chain 1: CTT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CTT')
         );

SET @chain_id_1 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Bat3'),
             @chain_id_1,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             @chain_id_1,
             2
         );

-- Predecessor Chain 2: CTT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CTT')
         );

SET @chain_id_2 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Jeantet'),
             @chain_id_2,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             @chain_id_2,
             2
         );

-- Predecessor Chain 3: CTT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CTT')
         );

SET @chain_id_3 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FRLEH'),
             @chain_id_3,
             1
         );

-- Predecessor Chain 4: CTT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CTT')
         );

SET @chain_id_4 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             @chain_id_4,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_4,
             2
         );

-- Predecessor Chain 5: AB
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'AB')
         );

SET @chain_id_5 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             @chain_id_5,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_5,
             2
         );

-- Predecessor Chain 6: AB
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'AB')
         );

SET @chain_id_6 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban Wörth'),
             @chain_id_6,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_6,
             2
         );

-- Predecessor Chain 7: AB
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'AB')
         );

SET @chain_id_7 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             @chain_id_7,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_7,
             2
         );

-- Predecessor Chain 8: AB
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'AB')
         );

SET @chain_id_8 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_8,
             1
         );

-- Predecessor Chain 9: FGG
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FGG')
         );

SET @chain_id_9 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             @chain_id_9,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_9,
             2
         );

-- Predecessor Chain 10: FGG
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'FGG')
         );

SET @chain_id_10 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_10,
             1
         );

-- Predecessor Chain 11: KWS
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'KWS')
         );

SET @chain_id_11 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             @chain_id_11,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_11,
             2
         );

-- Predecessor Chain 12: KWS
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'KWS')
         );

SET @chain_id_12 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_12,
             1
         );

-- Predecessor Chain 13: EGD
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'EGD')
         );

SET @chain_id_13 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Pfaff Rade'),
             @chain_id_13,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_13,
             2
         );

-- Predecessor Chain 14: EGD
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'EGD')
         );

SET @chain_id_14 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_14,
             1
         );

-- Predecessor Chain 15: LZZ
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LZZ')
         );

SET @chain_id_15 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             @chain_id_15,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_15,
             2
         );

-- Predecessor Chain 16: LZZ
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LZZ')
         );

SET @chain_id_16 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban Rolo'),
             @chain_id_16,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban AB'),
             @chain_id_16,
             2
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'BEZEE'),
             @chain_id_16,
             3
         );

-- Predecessor Chain 17: LZZ
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LZZ')
         );

SET @chain_id_17 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Urban Rolo'),
             @chain_id_17,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ITGOA'),
             @chain_id_17,
             2
         );

-- Predecessor Chain 18: LZZ
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LZZ')
         );

SET @chain_id_18 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ITGOA'),
             @chain_id_18,
             1
         );

-- Predecessor Chain 19: STR
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'STR')
         );

SET @chain_id_19 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Zbůch'),
             @chain_id_19,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_19,
             2
         );

-- Predecessor Chain 20: STR
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'STR')
         );

SET @chain_id_20 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_20,
             1
         );

-- Predecessor Chain 21: VOP
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'VOP')
         );

SET @chain_id_21 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Zbůch'),
             @chain_id_21,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_21,
             2
         );

-- Predecessor Chain 22: VOP
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'VOP')
         );

SET @chain_id_22 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_22,
             1
         );

-- Predecessor Chain 23: KOL
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'KOL')
         );

SET @chain_id_23 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_23,
             1
         );

-- Predecessor Chain 24: LiPo
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LiPo')
         );

SET @chain_id_24 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Zbůch'),
             @chain_id_24,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_24,
             2
         );

-- Predecessor Chain 25: LiPo
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LiPo')
         );

SET @chain_id_25 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_25,
             1
         );

-- Predecessor Chain 26: HH
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'HH')
         );

SET @chain_id_26 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_26,
             1
         );

-- Predecessor Chain 27: HH
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'HH')
         );

SET @chain_id_27 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Pfaff Rade'),
             @chain_id_27,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'DEHAM'),
             @chain_id_27,
             2
         );

-- Predecessor Chain 28: CNXMN
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN')
         );

SET @chain_id_28 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Xiamen'),
             @chain_id_28,
             1
         );

-- Predecessor Chain 29: CNSHA
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA')
         );

SET @chain_id_29 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Shanghai'),
             @chain_id_29,
             1
         );

-- Predecessor Chain 30: CNSHA
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA')
         );

SET @chain_id_30 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Hangzhou'),
             @chain_id_30,
             1
         );

-- Predecessor Chain 31: CNSHA
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA')
         );

SET @chain_id_31 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Yangzhong'),
             @chain_id_31,
             1
         );

-- Predecessor Chain 32: CNSHA
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNSHA')
         );

SET @chain_id_32 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Taicang'),
             @chain_id_32,
             1
         );

-- Predecessor Chain 33: CNXMN
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN')
         );

SET @chain_id_33 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Jinjiang'),
             @chain_id_33,
             1
         );

-- Predecessor Chain 34: CNTAO
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNTAO')
         );

SET @chain_id_34 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Qingdao'),
             @chain_id_34,
             1
         );

-- Predecessor Chain 35: CNXMN
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN')
         );

SET @chain_id_35 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Fuqin'),
             @chain_id_35,
             1
         );

-- Predecessor Chain 36: CNTAO
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNTAO')
         );

SET @chain_id_36 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Linfen'),
             @chain_id_36,
             1
         );

-- Predecessor Chain 37: CNTGS
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNTGS')
         );

SET @chain_id_37 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Linfen'),
             @chain_id_37,
             1
         );

-- Predecessor Chain 38: CNYTN
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNYTN')
         );

SET @chain_id_38 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Yantian'),
             @chain_id_38,
             1
         );

-- Predecessor Chain 39: INMAA
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA')
         );

SET @chain_id_39 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Bangalore'),
             @chain_id_39,
             1
         );

-- Predecessor Chain 40: INJNPT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT')
         );

SET @chain_id_40 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             @chain_id_40,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Bangalore'),
             @chain_id_40,
             2
         );

-- Predecessor Chain 41: INJNPT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT')
         );

SET @chain_id_41 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             @chain_id_41,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Pune'),
             @chain_id_41,
             2
         );

-- Predecessor Chain 42: INJNPT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT')
         );

SET @chain_id_42 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Pune'),
             @chain_id_42,
             1
         );

-- Predecessor Chain 43: INMAA
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INMAA')
         );

SET @chain_id_43 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Chennai'),
             @chain_id_43,
             1
         );

-- Predecessor Chain 44: INJNPT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT')
         );

SET @chain_id_44 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             @chain_id_44,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Chennai'),
             @chain_id_44,
             2
         );

-- Predecessor Chain 45: INJNPT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT')
         );

SET @chain_id_45 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             @chain_id_45,
             1
         );

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Aurangabad'),
             @chain_id_45,
             2
         );

-- Predecessor Chain 46: INJNPT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT')
         );

SET @chain_id_46 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Aurangabad'),
             @chain_id_46,
             1
         );

-- Predecessor Chain 47: CNXMN
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN')
         );

SET @chain_id_47 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'LX'),
             @chain_id_47,
             1
         );

-- Predecessor Chain 48: INJNPT
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'INJNPT')
         );

SET @chain_id_48 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'ExM'),
             @chain_id_48,
             1
         );

-- Predecessor Chain 49: CNXMN
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNXMN')
         );

SET @chain_id_49 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'JJ'),
             @chain_id_49,
             1
         );

-- Predecessor Chain 50: HKMBP
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'HKMBP')
         );

SET @chain_id_50 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Shenzhen'),
             @chain_id_50,
             1
         );

-- Predecessor Chain 51: CNSZX
INSERT INTO node_predecessor_chain (
    node_id
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'CNSZX')
         );

SET @chain_id_51 = LAST_INSERT_ID();

INSERT INTO node_predecessor_entry (
    node_id,
    node_predecessor_chain_id,
    sequence_number
) VALUES (
             (SELECT id FROM node WHERE external_mapping_id = 'Shenzhen'),
             @chain_id_51,
             1
         );
