INSERT INTO `tbl_thesis_researchers` (`id`, `TID`, `student_id`, `personnel_id`, `Role`) VALUES
(1, 18, 1, NULL, 'Researcher'),
(2, 18, 38, NULL, 'Adviser'),
(3, 19, 2, NULL, 'Researcher'),
(4, 19, 39, NULL, 'Adviser'),
(5, 20, 3, NULL, 'Researcher'),
(6, 20, 40, NULL, 'Adviser'),
(7, 21, 4, NULL, 'Researcher'),
(8, 21, 35, NULL, 'Adviser'),
(9, 22, 5, NULL, 'Researcher'),
(10, 22, 16, NULL, 'Adviser'),
(11, 23, 6, NULL, 'Researcher'),
(12, 23, 40, NULL, 'Adviser'),
(13, 24, 7, NULL, 'Researcher'),
(14, 24, 39, NULL, 'Adviser'),
(15, 25, 8, NULL, 'Researcher'),
(16, 25, 35, NULL, 'Adviser'),
(17, 26, 9, NULL, 'Researcher'),
(18, 26, 40, NULL, 'Adviser'),
(19, 27, 10, NULL, 'Researcher'),
(20, 27, 35, NULL, 'Adviser'),
(21, 28, 11, NULL, 'Researcher'),
(22, 28, 39, NULL, 'Adviser'),
(23, 29, 12, NULL, 'Researcher'),
(24, 29, 40, NULL, 'Adviser'),
(25, 30, 13, NULL, 'Researcher'),
(26, 30, 39, NULL, 'Adviser'),
(27, 31, 14, NULL, 'Researcher'),
(28, 31, 16, NULL, 'Adviser'),
(29, 32, 15, NULL, 'Researcher'),
(30, 32, 38, NULL, 'Adviser'),
(31, 33, 16, NULL, 'Researcher'),
(32, 33, 36, NULL, 'Adviser'),
(33, 34, 17, NULL, 'Researcher'),
(34, 34, 35, NULL, 'Adviser'),
(35, 35, 18, NULL, 'Researcher'),
(36, 35, 38, NULL, 'Adviser'),
(37, 36, 16, NULL, 'Adviser'),
(38, 36, 19, NULL, 'Researcher'),
(39, 37, 20, NULL, 'Researcher'),
(40, 37, 38, NULL, 'Adviser'),
(41, 38, 21, NULL, 'Researcher'),
(42, 38, 35, NULL, 'Adviser'),
(43, 39, 22, NULL, 'Researcher'),
(44, 39, 38, NULL, 'Adviser'),
(45, 40, 16, NULL, 'Adviser'),
(46, 40, 23, NULL, 'Researcher'),
(47, 41, 24, NULL, 'Researcher'),
(48, 41, 38, NULL, 'Adviser'),
(49, 42, 25, NULL, 'Researcher'),
(50, 42, 40, NULL, 'Adviser'),
(51, 43, 26, NULL, 'Researcher'),
(52, 43, 38, NULL, 'Adviser'),
(53, 44, 27, NULL, 'Researcher'),
(54, 44, 40, NULL, 'Adviser'),
(55, 45, 16, NULL, 'Adviser'),
(56, 45, 28, NULL, 'Researcher'),
(57, 46, 29, NULL, 'Researcher'),
(58, 46, 40, NULL, 'Adviser'),
(59, 47, 30, NULL, 'Researcher'),
(60, 47, 40, NULL, 'Adviser'),
(61, 48, 16, NULL, 'Adviser'),
(62, 48, 31, NULL, 'Researcher'),
(63, 49, 32, NULL, 'Researcher'),
(64, 49, 40, NULL, 'Adviser'),
(65, 50, 33, NULL, 'Researcher'),
(66, 50, 38, NULL, 'Adviser'),
(67, 51, 16, NULL, 'Adviser'),
(68, 51, 34, NULL, 'Researcher'),
(69, 54, 40, NULL, 'Researcher'),
(70, 54, 42, NULL, 'Adviser'),
(71, 61, 47, NULL, 'Adviser'),
(72, 61, 48, NULL, 'Researcher'),
(73, 62, 49, NULL, 'Researcher'),
(74, 62, 4, NULL, 'Adviser'),
(75, 63, 50, NULL, 'Researcher'),
(76, 63, 38, NULL, 'Adviser'),
(77, 64, 51, NULL, 'Researcher'),
(78, 64, 40, NULL, 'Adviser'),
(79, 65, 52, NULL, 'Researcher'),
(80, 65, 38, NULL, 'Adviser'),
(81, 66, 53, NULL, 'Researcher'),
(82, 66, 40, NULL, 'Adviser'),
(83, 67, 54, NULL, 'Researcher'),
(84, 67, 38, NULL, 'Adviser'),
(85, 68, 55, NULL, 'Researcher'),
(86, 68, 47, NULL, 'Adviser'),
(87, 69, 56, NULL, 'Researcher'),
(88, 69, 40, NULL, 'Adviser'),
(89, 70, 57, NULL, 'Researcher'),
(90, 70, 40, NULL, 'Adviser'),
(91, 71, 58, NULL, 'Researcher'),
(92, 71, 4, NULL, 'Adviser'),
(93, 72, 59, NULL, 'Researcher'),
(94, 72, 38, NULL, 'Adviser'),
(95, 73, 60, NULL, 'Researcher'),
(96, 73, 40, NULL, 'Adviser'),
(97, 74, 61, NULL, 'Researcher'),
(98, 74, 40, NULL, 'Adviser'),
(99, 75, 62, NULL, 'Researcher'),
(100, 75, 47, NULL, 'Adviser'),
(101, 76, 63, NULL, 'Researcher'),
(102, 76, 47, NULL, 'Adviser'),
(103, 77, 64, NULL, 'Researcher'),
(104, 77, 38, NULL, 'Adviser'),
(105, 78, 65, NULL, 'Researcher'),
(106, 78, 66, NULL, 'Adviser'),
(107, 79, 67, NULL, 'Researcher'),
(108, 79, 68, NULL, 'Adviser'),
(109, 80, 69, NULL, 'Researcher'),
(110, 80, 4, NULL, 'Adviser'),
(111, 81, 70, NULL, 'Researcher'),
(112, 81, 68, NULL, 'Adviser'),
(113, 82, 71, NULL, 'Researcher'),
(114, 82, 47, NULL, 'Adviser'),
(115, 83, 72, NULL, 'Researcher'),
(116, 83, 68, NULL, 'Adviser'),
(117, 87, 73, NULL, 'Researcher'),
(118, 87, 16, NULL, 'Adviser'),
(119, 84, 74, NULL, 'Researcher'),
(120, 84, 75, NULL, 'Adviser'),
(121, 85, 75, NULL, 'Adviser'),
(122, 85, 76, NULL, 'Researcher'),
(123, 88, 78, NULL, 'Researcher'),
(124, 88, 16, NULL, 'Adviser'),
(125, 90, 79, NULL, 'Researcher'),
(126, 90, 4, NULL, 'Adviser'),
(127, 91, 80, NULL, 'Researcher'),
(128, 91, 4, NULL, 'Adviser'),
(129, 92, 81, NULL, 'Researcher'),
(130, 92, 38, NULL, 'Adviser'),
(131, 93, 82, NULL, 'Researcher'),
(132, 93, 40, NULL, 'Adviser'),
(133, 94, 83, NULL, 'Researcher'),
(134, 94, 40, NULL, 'Adviser'),
(135, 95, 84, NULL, 'Researcher'),
(136, 95, 38, NULL, 'Adviser'),
(137, 96, 85, NULL, 'Researcher'),
(138, 96, 40, NULL, 'Adviser'),
(139, 89, 86, NULL, 'Researcher'),
(140, 89, 40, NULL, 'Adviser'),
(141, 97, 87, NULL, 'Researcher'),
(142, 97, 40, NULL, 'Adviser'),
(143, 98, 88, NULL, 'Researcher'),
(144, 98, 4, NULL, 'Adviser'),
(145, 99, 89, NULL, 'Researcher'),
(146, 99, 4, NULL, 'Adviser'),
(147, 100, 90, NULL, 'Researcher'),
(148, 100, 40, NULL, 'Adviser'),
(149, 101, 91, NULL, 'Researcher'),
(150, 101, 74, NULL, 'Adviser'),
(151, 102, 92, NULL, 'Researcher'),
(152, 102, 4, NULL, 'Adviser'),
(153, 103, 93, NULL, 'Researcher'),
(154, 103, 4, NULL, 'Adviser'),
(155, 104, 94, NULL, 'Researcher'),
(156, 104, 38, NULL, 'Adviser'),
(157, 105, 95, NULL, 'Researcher'),
(158, 105, 4, NULL, 'Adviser'),
(159, 106, 96, NULL, 'Researcher'),
(160, 106, 40, NULL, 'Adviser'),
(161, 107, 97, NULL, 'Researcher'),
(162, 107, 38, NULL, 'Adviser'),
(163, 108, 98, NULL, 'Researcher'),
(164, 108, 38, NULL, 'Adviser'),
(165, 109, 99, NULL, 'Researcher'),
(166, 109, 38, NULL, 'Adviser'),
(167, 110, 100, NULL, 'Researcher'),
(168, 110, 4, NULL, 'Adviser'),
(169, 111, 101, NULL, 'Researcher'),
(170, 111, 40, NULL, 'Adviser'),
(171, 112, 102, NULL, 'Researcher'),
(172, 112, 103, NULL, 'Adviser'),
(173, 113, 104, NULL, 'Researcher'),
(174, 113, 38, NULL, 'Adviser'),
(175, 114, 105, NULL, 'Researcher'),
(176, 114, 40, NULL, 'Adviser'),
(177, 115, 106, NULL, 'Researcher'),
(178, 115, 74, NULL, 'Adviser'),
(179, 116, 107, NULL, 'Researcher'),
(180, 116, 4, NULL, 'Adviser'),
(181, 117, 108, NULL, 'Researcher'),
(182, 117, 103, NULL, 'Adviser'),
(183, 118, 109, NULL, 'Researcher'),
(184, 118, 103, NULL, 'Adviser'),
(185, 119, 110, NULL, 'Researcher'),
(186, 119, 38, NULL, 'Adviser'),
(187, 120, 111, NULL, 'Researcher'),
(188, 120, 68, NULL, 'Adviser'),
(189, 121, 112, NULL, 'Researcher'),
(190, 121, 103, NULL, 'Adviser'),
(191, 122, 113, NULL, 'Researcher'),
(192, 122, 74, NULL, 'Adviser'),
(193, 123, 114, NULL, 'Researcher'),
(194, 123, 40, NULL, 'Adviser'),
(195, 124, 115, NULL, 'Researcher'),
(196, 124, 4, NULL, 'Adviser'),
(197, 125, 116, NULL, 'Researcher'),
(198, 125, 4, NULL, 'Adviser'),
(199, 126, 117, NULL, 'Researcher'),
(200, 126, 68, NULL, 'Adviser'),
(201, 127, 118, NULL, 'Researcher'),
(202, 127, 40, NULL, 'Adviser'),
(203, 128, 119, NULL, 'Researcher'),
(204, 128, 74, NULL, 'Adviser'),
(205, 129, 120, NULL, 'Researcher'),
(206, 129, 68, NULL, 'Adviser'),
(207, 130, 121, NULL, 'Researcher'),
(208, 130, 38, NULL, 'Adviser'),
(209, 131, 122, NULL, 'Researcher'),
(210, 131, 74, NULL, 'Adviser'),
(211, 132, 123, NULL, 'Researcher'),
(212, 132, 40, NULL, 'Adviser'),
(213, 133, 124, NULL, 'Researcher'),
(214, 133, 74, NULL, 'Adviser'),
(215, 134, 125, NULL, 'Researcher'),
(216, 134, 40, NULL, 'Adviser'),
(217, 135, 126, NULL, 'Researcher'),
(218, 135, 65, NULL, 'Adviser'),
(219, 136, 127, NULL, 'Researcher'),
(220, 136, 68, NULL, 'Adviser'),
(221, 137, 128, NULL, 'Researcher'),
(222, 137, 68, NULL, 'Adviser'),
(223, 138, 129, NULL, 'Researcher'),
(224, 138, 68, NULL, 'Adviser'),
(225, 139, 130, NULL, 'Researcher'),
(226, 139, 4, NULL, 'Adviser'),
(227, 140, 131, NULL, 'Researcher'),
(228, 140, 40, NULL, 'Adviser'),
(229, 141, 132, NULL, 'Researcher'),
(230, 141, 4, NULL, 'Adviser'),
(231, 142, 133, NULL, 'Researcher'),
(232, 142, 40, NULL, 'Adviser'),
(233, 143, 134, NULL, 'Researcher'),
(234, 143, 4, NULL, 'Adviser'),
(235, 144, 135, NULL, 'Researcher'),
(236, 144, 65, NULL, 'Adviser'),
(237, 145, 136, NULL, 'Researcher'),
(238, 145, 65, NULL, 'Adviser'),
(239, 146, 137, NULL, 'Researcher'),
(240, 146, 103, NULL, 'Adviser'),
(241, 148, 138, NULL, 'Researcher'),
(242, 148, 38, NULL, 'Adviser'),
(243, 149, 139, NULL, 'Researcher'),
(244, 149, 68, NULL, 'Adviser'),
(245, 150, 140, NULL, 'Researcher'),
(246, 150, 38, NULL, 'Adviser');