-- SEPALS Parent Portal Access Slips - 301 Students
-- Import ONCE. Existing Excel credentials are reused; missing 54 students are completed.
START TRANSACTION;
CREATE TABLE IF NOT EXISTS `parent_access_credentials` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`student_id` int(10) UNSIGNED NOT NULL,
`parent_id` int(10) UNSIGNED NOT NULL,
`temp_password` varchar(120) DEFAULT NULL,
`prepared_at` datetime NOT NULL DEFAULT current_timestamp(),
`updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `uq_parent_access_student` (`student_id`),
KEY `idx_parent_access_parent` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0002';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0004';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0006';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0007';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0019';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0023';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0027';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0030';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0073';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0075';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0095';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0096';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0102';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0105';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0107';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0158';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0197';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0226';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0293';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0308';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0344';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0347';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0399';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0402';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0407';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0450';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0476';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0482';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0492';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0493';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0496';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0497';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0504';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0508';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0513';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0515';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0517';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0518';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0522';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0524';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0526';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0527';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0531';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0533';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0535';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0545';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0547';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0556';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0559';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0562';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0564';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0566';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0569';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0571';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0582';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0604';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0615';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0616';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0618';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0620';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0628';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0633';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0638';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0642';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0656';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0658';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0660';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0661';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0662';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0668';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0669';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0671';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0677';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0678';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0683';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0690';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0691';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0700';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0706';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0712';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0718';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0719';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0721';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0736';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0737';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0739';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0744';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0745';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0747';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0748';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0752';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0756';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0767';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0768';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0770';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0778';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0782';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0784';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0791';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0798';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0800';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0806';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0807';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0813';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0817';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0820';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0830';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0834';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0835';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0840';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0841';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0843';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0844';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0847';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0848';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0850';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0851';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0853';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0855';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0857';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0860';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0861';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0865';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0867';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0869';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0875';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0880';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0881';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0883';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0897';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0898';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0901';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0903';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0904';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0917';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0918';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0919';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0920';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0921';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0922';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0923';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0925';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0927';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0930';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0933';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0934';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0935';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0936';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0937';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0941';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0942';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0944';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0946';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0948';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0949';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0951';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0953';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0954';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0955';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0956';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0957';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0958';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0961';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0962';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0963';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0972';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0973';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0975';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0976';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0977';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0981';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0982';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0983';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0988';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0990';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0991';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0993';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0998';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1011';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1012';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1014';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1015';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1019';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1027';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1029';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1033';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1038';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1044';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1048';
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1059';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Faisal Ahmad','P0433','03151954724',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P0433');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0433';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Arshad Hussain','P0512','03139666322',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P0512');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0512';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Telawat Khan','P0673','03139109869',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P0673');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0673';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Muhammad Arif','P0703','03139552973',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P0703');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0703';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Shoab Khan','P0999','03118216163',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P0999');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P0999';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Muhammad Aftab','P1000','03428480090',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1000');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1000';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Rizwanullah','P1002',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1002');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1002';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Zeshanullah','P1003',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1003');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1003';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Irfanullah','P1004',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1004');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1004';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Hamid Khan','P1006',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1006');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1006';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Muhammad Bilal','P1007','03158818105',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1007');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1007';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Kamran Khan','P1009',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1009');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1009';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Asif Khan','P1010','03152999536',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1010');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1010';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Muhammad Fayaz','P1016','03183677171',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1016');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1016';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Ikramulhaq','P1020',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1020');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1020';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Zeeshan Ahmad','P1022','03135142414',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1022');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1022';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Mahmood Shah','P1023','03159834593',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1023');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1023';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Majeed Khan','P1024','03171454854',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1024');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1024';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Bahram Khan','P1028','03131990677',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1028');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1028';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Nizamulhaq','P1030','03150864848',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1030');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1030';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Amjid Khan','P1036',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1036');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1036';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Muhammad Waseem','P1037','03118299582',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1037');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1037';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Muhammad Wali Khan','P1039','03239035252',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1039');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1039';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Asim Khan','P1040','03120397839',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1040');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1040';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Arifullah','P1041',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1041');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1041';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Muhammad Kamran','P1045',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1045');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1045';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Qasam Jan','P1047','03109680747',NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1047');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1047';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Aftab','P1049',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1049');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1049';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Farhan','P1050',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1050');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1050';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Dildar','P1051',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1051');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1051';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Shoaib','P1052',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1052');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1052';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Ateeq','P1053',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1053');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1053';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Majid','P1055',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1055');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1055';
INSERT INTO `parent_accounts` (`parent_name`,`username`,`phone`,`email`,`password`,`status`) SELECT 'Tahir','P1056',NULL,NULL,'$2y$08$0X5ulGiVAx8YWu3GI8FfmOu6DkRj12/Y1i4.S5M6W8d.4F.DfzJp6','active' WHERE NOT EXISTS(SELECT 1 FROM `parent_accounts` WHERE `username`='P1056');
UPDATE `parent_accounts` SET `status`='active' WHERE `username`='P1056';
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='2' WHERE pa.`username`='P0002' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000201',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0002' WHERE s.`admission_no`='2' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='4' WHERE pa.`username`='P0004' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000480',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0004' WHERE s.`admission_no`='4' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='6' WHERE pa.`username`='P0006' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000614',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0006' WHERE s.`admission_no`='6' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='7' WHERE pa.`username`='P0007' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000776',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0007' WHERE s.`admission_no`='7' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='19' WHERE pa.`username`='P0019' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@001981',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0019' WHERE s.`admission_no`='19' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='23' WHERE pa.`username`='P0023' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@002323',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0023' WHERE s.`admission_no`='23' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='27' WHERE pa.`username`='P0027' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@002767',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0027' WHERE s.`admission_no`='27' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='30' WHERE pa.`username`='P0030' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@003035',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0030' WHERE s.`admission_no`='30' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='73' WHERE pa.`username`='P0073' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@007319',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0073' WHERE s.`admission_no`='73' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='75' WHERE pa.`username`='P0075' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@007566',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0075' WHERE s.`admission_no`='75' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='95' WHERE pa.`username`='P0095' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@009501',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0095' WHERE s.`admission_no`='95' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='96' WHERE pa.`username`='P0096' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@009622',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0096' WHERE s.`admission_no`='96' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='102' WHERE pa.`username`='P0102' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010224',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0102' WHERE s.`admission_no`='102' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='105' WHERE pa.`username`='P0105' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010540',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0105' WHERE s.`admission_no`='105' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='107' WHERE pa.`username`='P0107' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010734',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0107' WHERE s.`admission_no`='107' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='158' WHERE pa.`username`='P0158' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@015810',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0158' WHERE s.`admission_no`='158' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='193' WHERE pa.`username`='P0006' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000614',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0006' WHERE s.`admission_no`='193' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='197' WHERE pa.`username`='P0197' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@019742',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0197' WHERE s.`admission_no`='197' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='226' WHERE pa.`username`='P0226' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@022662',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0226' WHERE s.`admission_no`='226' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='293' WHERE pa.`username`='P0293' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@029389',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0293' WHERE s.`admission_no`='293' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='300' WHERE pa.`username`='P0515' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051507',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0515' WHERE s.`admission_no`='300' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='301' WHERE pa.`username`='P0107' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010734',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0107' WHERE s.`admission_no`='301' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='308' WHERE pa.`username`='P0308' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@030844',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0308' WHERE s.`admission_no`='308' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='344' WHERE pa.`username`='P0344' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@034487',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0344' WHERE s.`admission_no`='344' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='347' WHERE pa.`username`='P0347' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@034719',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0347' WHERE s.`admission_no`='347' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='399' WHERE pa.`username`='P0399' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@039901',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0399' WHERE s.`admission_no`='399' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='402' WHERE pa.`username`='P0402' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@040287',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0402' WHERE s.`admission_no`='402' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='407' WHERE pa.`username`='P0407' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@040787',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0407' WHERE s.`admission_no`='407' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='422' WHERE pa.`username`='P0105' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010540',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0105' WHERE s.`admission_no`='422' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='428' WHERE pa.`username`='P0102' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010224',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0102' WHERE s.`admission_no`='428' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='433' WHERE pa.`username`='P0433' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@043324',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0433' WHERE s.`admission_no`='433' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='444' WHERE pa.`username`='P0616' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@061632',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0616' WHERE s.`admission_no`='444' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='450' WHERE pa.`username`='P0450' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@045016',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0450' WHERE s.`admission_no`='450' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='455' WHERE pa.`username`='P0737' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@073744',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0737' WHERE s.`admission_no`='455' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='469' WHERE pa.`username`='P0344' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@034487',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0344' WHERE s.`admission_no`='469' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='476' WHERE pa.`username`='P0476' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@047671',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0476' WHERE s.`admission_no`='476' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='482' WHERE pa.`username`='P0482' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@048264',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0482' WHERE s.`admission_no`='482' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='491' WHERE pa.`username`='P0402' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@040287',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0402' WHERE s.`admission_no`='491' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='492' WHERE pa.`username`='P0492' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@049220',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0492' WHERE s.`admission_no`='492' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='493' WHERE pa.`username`='P0493' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@049390',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0493' WHERE s.`admission_no`='493' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='495' WHERE pa.`username`='P0006' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000614',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0006' WHERE s.`admission_no`='495' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='496' WHERE pa.`username`='P0496' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@049610',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0496' WHERE s.`admission_no`='496' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='497' WHERE pa.`username`='P0497' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@049785',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0497' WHERE s.`admission_no`='497' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='499' WHERE pa.`username`='P0004' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000480',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0004' WHERE s.`admission_no`='499' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='504' WHERE pa.`username`='P0504' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@050496',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0504' WHERE s.`admission_no`='504' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='508' WHERE pa.`username`='P0508' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@050819',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0508' WHERE s.`admission_no`='508' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='512' WHERE pa.`username`='P0512' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051222',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0512' WHERE s.`admission_no`='512' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='513' WHERE pa.`username`='P0513' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051395',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0513' WHERE s.`admission_no`='513' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='515' WHERE pa.`username`='P0515' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051507',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0515' WHERE s.`admission_no`='515' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='517' WHERE pa.`username`='P0517' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051714',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0517' WHERE s.`admission_no`='517' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='518' WHERE pa.`username`='P0518' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051871',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0518' WHERE s.`admission_no`='518' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='522' WHERE pa.`username`='P0522' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@052265',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0522' WHERE s.`admission_no`='522' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='524' WHERE pa.`username`='P0524' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@052426',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0524' WHERE s.`admission_no`='524' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='526' WHERE pa.`username`='P0526' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@052685',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0526' WHERE s.`admission_no`='526' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='527' WHERE pa.`username`='P0527' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@052795',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0527' WHERE s.`admission_no`='527' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='531' WHERE pa.`username`='P0531' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@053199',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0531' WHERE s.`admission_no`='531' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='533' WHERE pa.`username`='P0533' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@053374',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0533' WHERE s.`admission_no`='533' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='535' WHERE pa.`username`='P0535' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@053503',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0535' WHERE s.`admission_no`='535' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='545' WHERE pa.`username`='P0545' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@054527',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0545' WHERE s.`admission_no`='545' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='547' WHERE pa.`username`='P0547' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@054757',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0547' WHERE s.`admission_no`='547' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='551' WHERE pa.`username`='P0102' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010224',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0102' WHERE s.`admission_no`='551' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='554' WHERE pa.`username`='P0095' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@009501',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0095' WHERE s.`admission_no`='554' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='556' WHERE pa.`username`='P0556' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@055699',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0556' WHERE s.`admission_no`='556' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='559' WHERE pa.`username`='P0559' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@055959',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0559' WHERE s.`admission_no`='559' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='561' WHERE pa.`username`='P0545' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@054527',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0545' WHERE s.`admission_no`='561' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='562' WHERE pa.`username`='P0562' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@056281',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0562' WHERE s.`admission_no`='562' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='564' WHERE pa.`username`='P0564' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@056456',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0564' WHERE s.`admission_no`='564' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='565' WHERE pa.`username`='P0564' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@056456',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0564' WHERE s.`admission_no`='565' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='566' WHERE pa.`username`='P0566' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@056623',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0566' WHERE s.`admission_no`='566' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='569' WHERE pa.`username`='P0569' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@056973',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0569' WHERE s.`admission_no`='569' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='571' WHERE pa.`username`='P0571' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@057126',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0571' WHERE s.`admission_no`='571' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='577' WHERE pa.`username`='P0524' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@052426',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0524' WHERE s.`admission_no`='577' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='582' WHERE pa.`username`='P0582' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@058215',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0582' WHERE s.`admission_no`='582' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='585' WHERE pa.`username`='P0482' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@048264',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0482' WHERE s.`admission_no`='585' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='601' WHERE pa.`username`='P0102' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010224',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0102' WHERE s.`admission_no`='601' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='602' WHERE pa.`username`='P0504' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@050496',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0504' WHERE s.`admission_no`='602' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='604' WHERE pa.`username`='P0604' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@060401',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0604' WHERE s.`admission_no`='604' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='610' WHERE pa.`username`='P0492' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@049220',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0492' WHERE s.`admission_no`='610' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='615' WHERE pa.`username`='P0615' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@061512',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0615' WHERE s.`admission_no`='615' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='616' WHERE pa.`username`='P0616' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@061632',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0616' WHERE s.`admission_no`='616' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='618' WHERE pa.`username`='P0618' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@061863',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0618' WHERE s.`admission_no`='618' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='620' WHERE pa.`username`='P0620' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@062057',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0620' WHERE s.`admission_no`='620' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='628' WHERE pa.`username`='P0628' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@062801',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0628' WHERE s.`admission_no`='628' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='633' WHERE pa.`username`='P0633' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@063363',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0633' WHERE s.`admission_no`='633' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='634' WHERE pa.`username`='P0615' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@061512',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0615' WHERE s.`admission_no`='634' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='638' WHERE pa.`username`='P0638' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@063877',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0638' WHERE s.`admission_no`='638' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='642' WHERE pa.`username`='P0642' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@064283',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0642' WHERE s.`admission_no`='642' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='648' WHERE pa.`username`='P0107' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010734',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0107' WHERE s.`admission_no`='648' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='656' WHERE pa.`username`='P0656' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@065615',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0656' WHERE s.`admission_no`='656' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='658' WHERE pa.`username`='P0658' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@065815',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0658' WHERE s.`admission_no`='658' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='659' WHERE pa.`username`='P0658' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@065815',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0658' WHERE s.`admission_no`='659' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='660' WHERE pa.`username`='P0660' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066051',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0660' WHERE s.`admission_no`='660' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='661' WHERE pa.`username`='P0661' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066108',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0661' WHERE s.`admission_no`='661' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='662' WHERE pa.`username`='P0662' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066285',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0662' WHERE s.`admission_no`='662' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='667' WHERE pa.`username`='P0515' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051507',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0515' WHERE s.`admission_no`='667' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='668' WHERE pa.`username`='P0668' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066828',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0668' WHERE s.`admission_no`='668' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='669' WHERE pa.`username`='P0669' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066985',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0669' WHERE s.`admission_no`='669' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='671' WHERE pa.`username`='P0671' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067131',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0671' WHERE s.`admission_no`='671' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='673' WHERE pa.`username`='P0673' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067369',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0673' WHERE s.`admission_no`='673' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='677' WHERE pa.`username`='P0677' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067734',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0677' WHERE s.`admission_no`='677' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='678' WHERE pa.`username`='P0678' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067854',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0678' WHERE s.`admission_no`='678' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='681' WHERE pa.`username`='P0671' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067131',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0671' WHERE s.`admission_no`='681' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='683' WHERE pa.`username`='P0683' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@068372',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0683' WHERE s.`admission_no`='683' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='689' WHERE pa.`username`='P0004' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000480',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0004' WHERE s.`admission_no`='689' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='690' WHERE pa.`username`='P0690' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@069071',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0690' WHERE s.`admission_no`='690' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='691' WHERE pa.`username`='P0691' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@069181',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0691' WHERE s.`admission_no`='691' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='700' WHERE pa.`username`='P0700' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@070001',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0700' WHERE s.`admission_no`='700' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='701' WHERE pa.`username`='P0618' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@061863',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0618' WHERE s.`admission_no`='701' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='703' WHERE pa.`username`='P0703' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@070373',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0703' WHERE s.`admission_no`='703' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='706' WHERE pa.`username`='P0706' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@070619',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0706' WHERE s.`admission_no`='706' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='712' WHERE pa.`username`='P0712' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@071262',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0712' WHERE s.`admission_no`='712' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='718' WHERE pa.`username`='P0718' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@071846',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0718' WHERE s.`admission_no`='718' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='719' WHERE pa.`username`='P0719' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@071948',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0719' WHERE s.`admission_no`='719' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='721' WHERE pa.`username`='P0721' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@072121',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0721' WHERE s.`admission_no`='721' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='730' WHERE pa.`username`='P0004' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000480',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0004' WHERE s.`admission_no`='730' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='732' WHERE pa.`username`='P0006' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000614',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0006' WHERE s.`admission_no`='732' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='736' WHERE pa.`username`='P0736' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@073699',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0736' WHERE s.`admission_no`='736' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='737' WHERE pa.`username`='P0737' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@073744',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0737' WHERE s.`admission_no`='737' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='739' WHERE pa.`username`='P0739' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@073934',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0739' WHERE s.`admission_no`='739' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='744' WHERE pa.`username`='P0744' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@074449',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0744' WHERE s.`admission_no`='744' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='745' WHERE pa.`username`='P0745' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@074539',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0745' WHERE s.`admission_no`='745' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='747' WHERE pa.`username`='P0747' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@074750',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0747' WHERE s.`admission_no`='747' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='748' WHERE pa.`username`='P0748' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@074887',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0748' WHERE s.`admission_no`='748' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='750' WHERE pa.`username`='P0476' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@047671',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0476' WHERE s.`admission_no`='750' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='752' WHERE pa.`username`='P0752' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@075244',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0752' WHERE s.`admission_no`='752' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='754' WHERE pa.`username`='P0721' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@072121',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0721' WHERE s.`admission_no`='754' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='756' WHERE pa.`username`='P0756' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@075612',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0756' WHERE s.`admission_no`='756' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='767' WHERE pa.`username`='P0767' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@076797',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0767' WHERE s.`admission_no`='767' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='768' WHERE pa.`username`='P0768' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@076897',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0768' WHERE s.`admission_no`='768' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='770' WHERE pa.`username`='P0770' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@077095',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0770' WHERE s.`admission_no`='770' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='778' WHERE pa.`username`='P0778' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@077886',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0778' WHERE s.`admission_no`='778' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='780' WHERE pa.`username`='P0700' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@070001',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0700' WHERE s.`admission_no`='780' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='782' WHERE pa.`username`='P0782' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@078281',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0782' WHERE s.`admission_no`='782' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='784' WHERE pa.`username`='P0784' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@078415',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0784' WHERE s.`admission_no`='784' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='785' WHERE pa.`username`='P0752' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@075244',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0752' WHERE s.`admission_no`='785' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='786' WHERE pa.`username`='P0531' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@053199',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0531' WHERE s.`admission_no`='786' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='791' WHERE pa.`username`='P0791' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@079193',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0791' WHERE s.`admission_no`='791' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='796' WHERE pa.`username`='P0582' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@058215',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0582' WHERE s.`admission_no`='796' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='797' WHERE pa.`username`='P0668' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066828',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0668' WHERE s.`admission_no`='797' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='798' WHERE pa.`username`='P0798' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@079807',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0798' WHERE s.`admission_no`='798' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='800' WHERE pa.`username`='P0800' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@080003',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0800' WHERE s.`admission_no`='800' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='806' WHERE pa.`username`='P0806' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@080631',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0806' WHERE s.`admission_no`='806' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='807' WHERE pa.`username`='P0807' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@080741',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0807' WHERE s.`admission_no`='807' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='809' WHERE pa.`username`='P0669' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066985',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0669' WHERE s.`admission_no`='809' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='813' WHERE pa.`username`='P0813' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@081352',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0813' WHERE s.`admission_no`='813' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='817' WHERE pa.`username`='P0817' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@081708',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0817' WHERE s.`admission_no`='817' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='818' WHERE pa.`username`='P0691' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@069181',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0691' WHERE s.`admission_no`='818' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='820' WHERE pa.`username`='P0820' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@082019',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0820' WHERE s.`admission_no`='820' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='830' WHERE pa.`username`='P0830' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@083020',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0830' WHERE s.`admission_no`='830' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='834' WHERE pa.`username`='P0834' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@083416',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0834' WHERE s.`admission_no`='834' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='835' WHERE pa.`username`='P0835' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@083532',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0835' WHERE s.`admission_no`='835' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='836' WHERE pa.`username`='P0102' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010224',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0102' WHERE s.`admission_no`='836' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='839' WHERE pa.`username`='P0105' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@010540',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0105' WHERE s.`admission_no`='839' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='840' WHERE pa.`username`='P0840' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@084069',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0840' WHERE s.`admission_no`='840' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='841' WHERE pa.`username`='P0841' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@084139',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0841' WHERE s.`admission_no`='841' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='843' WHERE pa.`username`='P0843' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@084332',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0843' WHERE s.`admission_no`='843' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='844' WHERE pa.`username`='P0844' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@084433',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0844' WHERE s.`admission_no`='844' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='847' WHERE pa.`username`='P0847' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@084701',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0847' WHERE s.`admission_no`='847' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='848' WHERE pa.`username`='P0848' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@084834',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0848' WHERE s.`admission_no`='848' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='849' WHERE pa.`username`='P0515' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051507',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0515' WHERE s.`admission_no`='849' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='850' WHERE pa.`username`='P0850' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@085036',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0850' WHERE s.`admission_no`='850' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='851' WHERE pa.`username`='P0851' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@085110',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0851' WHERE s.`admission_no`='851' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='853' WHERE pa.`username`='P0853' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@085338',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0853' WHERE s.`admission_no`='853' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='855' WHERE pa.`username`='P0855' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@085567',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0855' WHERE s.`admission_no`='855' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='857' WHERE pa.`username`='P0857' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@085780',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0857' WHERE s.`admission_no`='857' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='860' WHERE pa.`username`='P0860' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@086009',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0860' WHERE s.`admission_no`='860' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='861' WHERE pa.`username`='P0861' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@086133',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0861' WHERE s.`admission_no`='861' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='862' WHERE pa.`username`='P0855' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@085567',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0855' WHERE s.`admission_no`='862' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='865' WHERE pa.`username`='P0865' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@086564',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0865' WHERE s.`admission_no`='865' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='867' WHERE pa.`username`='P0867' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@086757',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0867' WHERE s.`admission_no`='867' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='869' WHERE pa.`username`='P0869' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@086942',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0869' WHERE s.`admission_no`='869' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='875' WHERE pa.`username`='P0875' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@087567',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0875' WHERE s.`admission_no`='875' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='876' WHERE pa.`username`='P0875' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@087567',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0875' WHERE s.`admission_no`='876' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='878' WHERE pa.`username`='P0857' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@085780',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0857' WHERE s.`admission_no`='878' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='880' WHERE pa.`username`='P0880' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@088004',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0880' WHERE s.`admission_no`='880' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='881' WHERE pa.`username`='P0881' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@088175',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0881' WHERE s.`admission_no`='881' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='882' WHERE pa.`username`='P0880' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@088004',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0880' WHERE s.`admission_no`='882' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='883' WHERE pa.`username`='P0883' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@088380',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0883' WHERE s.`admission_no`='883' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='885' WHERE pa.`username`='P0566' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@056623',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0566' WHERE s.`admission_no`='885' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='890' WHERE pa.`username`='P0875' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@087567',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0875' WHERE s.`admission_no`='890' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='897' WHERE pa.`username`='P0897' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@089764',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0897' WHERE s.`admission_no`='897' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='898' WHERE pa.`username`='P0898' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@089849',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0898' WHERE s.`admission_no`='898' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='901' WHERE pa.`username`='P0901' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@090173',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0901' WHERE s.`admission_no`='901' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='903' WHERE pa.`username`='P0903' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@090348',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0903' WHERE s.`admission_no`='903' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='904' WHERE pa.`username`='P0904' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@090423',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0904' WHERE s.`admission_no`='904' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='917' WHERE pa.`username`='P0917' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@091778',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0917' WHERE s.`admission_no`='917' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='918' WHERE pa.`username`='P0918' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@091886',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0918' WHERE s.`admission_no`='918' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='919' WHERE pa.`username`='P0919' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@091957',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0919' WHERE s.`admission_no`='919' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='920' WHERE pa.`username`='P0920' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092010',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0920' WHERE s.`admission_no`='920' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='921' WHERE pa.`username`='P0921' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092176',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0921' WHERE s.`admission_no`='921' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='922' WHERE pa.`username`='P0922' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092271',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0922' WHERE s.`admission_no`='922' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='923' WHERE pa.`username`='P0923' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092366',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0923' WHERE s.`admission_no`='923' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='924' WHERE pa.`username`='P0798' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@079807',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0798' WHERE s.`admission_no`='924' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='925' WHERE pa.`username`='P0925' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092522',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0925' WHERE s.`admission_no`='925' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='926' WHERE pa.`username`='P0678' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067854',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0678' WHERE s.`admission_no`='926' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='927' WHERE pa.`username`='P0927' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092741',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0927' WHERE s.`admission_no`='927' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='930' WHERE pa.`username`='P0930' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@093070',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0930' WHERE s.`admission_no`='930' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='933' WHERE pa.`username`='P0933' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@093390',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0933' WHERE s.`admission_no`='933' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='934' WHERE pa.`username`='P0934' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@093457',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0934' WHERE s.`admission_no`='934' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='935' WHERE pa.`username`='P0935' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@093574',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0935' WHERE s.`admission_no`='935' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='936' WHERE pa.`username`='P0936' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@093603',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0936' WHERE s.`admission_no`='936' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='937' WHERE pa.`username`='P0937' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@093769',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0937' WHERE s.`admission_no`='937' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='938' WHERE pa.`username`='P0927' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092741',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0927' WHERE s.`admission_no`='938' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='940' WHERE pa.`username`='P0556' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@055699',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0556' WHERE s.`admission_no`='940' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='941' WHERE pa.`username`='P0941' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@094120',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0941' WHERE s.`admission_no`='941' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='942' WHERE pa.`username`='P0942' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@094221',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0942' WHERE s.`admission_no`='942' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='943' WHERE pa.`username`='P0927' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@092741',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0927' WHERE s.`admission_no`='943' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='944' WHERE pa.`username`='P0944' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@094401',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0944' WHERE s.`admission_no`='944' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='945' WHERE pa.`username`='P0004' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@000480',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0004' WHERE s.`admission_no`='945' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='946' WHERE pa.`username`='P0946' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@094668',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0946' WHERE s.`admission_no`='946' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='947' WHERE pa.`username`='P0946' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@094668',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0946' WHERE s.`admission_no`='947' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='948' WHERE pa.`username`='P0948' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@094842',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0948' WHERE s.`admission_no`='948' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='949' WHERE pa.`username`='P0949' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@094972',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0949' WHERE s.`admission_no`='949' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='951' WHERE pa.`username`='P0951' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@095186',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0951' WHERE s.`admission_no`='951' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='953' WHERE pa.`username`='P0953' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@095383',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0953' WHERE s.`admission_no`='953' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='954' WHERE pa.`username`='P0954' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@095483',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0954' WHERE s.`admission_no`='954' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='955' WHERE pa.`username`='P0955' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@095595',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0955' WHERE s.`admission_no`='955' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='956' WHERE pa.`username`='P0956' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@095668',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0956' WHERE s.`admission_no`='956' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='957' WHERE pa.`username`='P0957' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@095703',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0957' WHERE s.`admission_no`='957' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='958' WHERE pa.`username`='P0958' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@095882',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0958' WHERE s.`admission_no`='958' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='959' WHERE pa.`username`='P0638' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@063877',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0638' WHERE s.`admission_no`='959' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='960' WHERE pa.`username`='P0504' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@050496',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0504' WHERE s.`admission_no`='960' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='961' WHERE pa.`username`='P0961' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@096183',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0961' WHERE s.`admission_no`='961' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='962' WHERE pa.`username`='P0962' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@096225',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0962' WHERE s.`admission_no`='962' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='963' WHERE pa.`username`='P0963' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@096374',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0963' WHERE s.`admission_no`='963' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='972' WHERE pa.`username`='P0972' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@097292',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0972' WHERE s.`admission_no`='972' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='973' WHERE pa.`username`='P0973' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@097387',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0973' WHERE s.`admission_no`='973' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='975' WHERE pa.`username`='P0975' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@097588',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0975' WHERE s.`admission_no`='975' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='976' WHERE pa.`username`='P0976' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@097689',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0976' WHERE s.`admission_no`='976' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='977' WHERE pa.`username`='P0977' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@097790',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0977' WHERE s.`admission_no`='977' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='980' WHERE pa.`username`='P0677' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067734',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0677' WHERE s.`admission_no`='980' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='981' WHERE pa.`username`='P0981' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@098144',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0981' WHERE s.`admission_no`='981' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='982' WHERE pa.`username`='P0982' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@098292',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0982' WHERE s.`admission_no`='982' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='983' WHERE pa.`username`='P0983' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@098352',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0983' WHERE s.`admission_no`='983' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='988' WHERE pa.`username`='P0988' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@098800',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0988' WHERE s.`admission_no`='988' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='990' WHERE pa.`username`='P0990' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@099017',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0990' WHERE s.`admission_no`='990' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='991' WHERE pa.`username`='P0991' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@099196',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0991' WHERE s.`admission_no`='991' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='993' WHERE pa.`username`='P0993' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@099396',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0993' WHERE s.`admission_no`='993' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='994' WHERE pa.`username`='P0990' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@099017',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0990' WHERE s.`admission_no`='994' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='998' WHERE pa.`username`='P0998' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@099811',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0998' WHERE s.`admission_no`='998' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='999' WHERE pa.`username`='P0999' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@099963',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0999' WHERE s.`admission_no`='999' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1000' WHERE pa.`username`='P1000' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100090',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1000' WHERE s.`admission_no`='1000' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1001' WHERE pa.`username`='P0661' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@066108',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0661' WHERE s.`admission_no`='1001' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1002' WHERE pa.`username`='P1002' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100245',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1002' WHERE s.`admission_no`='1002' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1003' WHERE pa.`username`='P1003' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100396',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1003' WHERE s.`admission_no`='1003' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1004' WHERE pa.`username`='P1004' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100425',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1004' WHERE s.`admission_no`='1004' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1005' WHERE pa.`username`='P1004' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100425',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1004' WHERE s.`admission_no`='1005' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1006' WHERE pa.`username`='P1006' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100647',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1006' WHERE s.`admission_no`='1006' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1007' WHERE pa.`username`='P1007' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100705',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1007' WHERE s.`admission_no`='1007' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1008' WHERE pa.`username`='P0719' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@071948',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0719' WHERE s.`admission_no`='1008' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1009' WHERE pa.`username`='P1009' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@100938',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1009' WHERE s.`admission_no`='1009' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1010' WHERE pa.`username`='P1010' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@101036',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1010' WHERE s.`admission_no`='1010' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1011' WHERE pa.`username`='P1011' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@101199',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1011' WHERE s.`admission_no`='1011' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1012' WHERE pa.`username`='P1012' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@101203',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1012' WHERE s.`admission_no`='1012' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1013' WHERE pa.`username`='P0683' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@068372',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0683' WHERE s.`admission_no`='1013' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1014' WHERE pa.`username`='P1014' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@101411',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1014' WHERE s.`admission_no`='1014' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1015' WHERE pa.`username`='P1015' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@101571',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1015' WHERE s.`admission_no`='1015' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1016' WHERE pa.`username`='P1016' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@101671',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1016' WHERE s.`admission_no`='1016' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1017' WHERE pa.`username`='P0700' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@070001',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0700' WHERE s.`admission_no`='1017' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1018' WHERE pa.`username`='P0744' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@074449',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0744' WHERE s.`admission_no`='1018' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1019' WHERE pa.`username`='P1019' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@101935',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1019' WHERE s.`admission_no`='1019' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1020' WHERE pa.`username`='P1020' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@102075',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1020' WHERE s.`admission_no`='1020' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1021' WHERE pa.`username`='P0633' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@063363',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0633' WHERE s.`admission_no`='1021' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1022' WHERE pa.`username`='P1022' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@102214',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1022' WHERE s.`admission_no`='1022' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1023' WHERE pa.`username`='P1023' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@102393',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1023' WHERE s.`admission_no`='1023' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1024' WHERE pa.`username`='P1024' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@102454',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1024' WHERE s.`admission_no`='1024' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1025' WHERE pa.`username`='P0752' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@075244',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0752' WHERE s.`admission_no`='1025' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1026' WHERE pa.`username`='P0616' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@061632',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0616' WHERE s.`admission_no`='1026' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1027' WHERE pa.`username`='P1027' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@102769',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1027' WHERE s.`admission_no`='1027' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1028' WHERE pa.`username`='P1028' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@102877',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1028' WHERE s.`admission_no`='1028' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1029' WHERE pa.`username`='P1029' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@102982',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1029' WHERE s.`admission_no`='1029' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1030' WHERE pa.`username`='P1030' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103048',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1030' WHERE s.`admission_no`='1030' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1031' WHERE pa.`username`='P0158' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@015810',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0158' WHERE s.`admission_no`='1031' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1032' WHERE pa.`username`='P0745' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@074539',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0745' WHERE s.`admission_no`='1032' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1033' WHERE pa.`username`='P1033' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103338',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1033' WHERE s.`admission_no`='1033' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1034' WHERE pa.`username`='P1033' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103338',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1033' WHERE s.`admission_no`='1034' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1035' WHERE pa.`username`='P1033' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103338',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1033' WHERE s.`admission_no`='1035' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1036' WHERE pa.`username`='P1036' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103671',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1036' WHERE s.`admission_no`='1036' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1037' WHERE pa.`username`='P1037' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103782',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1037' WHERE s.`admission_no`='1037' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1038' WHERE pa.`username`='P1038' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103830',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1038' WHERE s.`admission_no`='1038' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1039' WHERE pa.`username`='P1039' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@103952',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1039' WHERE s.`admission_no`='1039' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1040' WHERE pa.`username`='P1040' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104039',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1040' WHERE s.`admission_no`='1040' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1041' WHERE pa.`username`='P1041' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104192',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1041' WHERE s.`admission_no`='1041' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1042' WHERE pa.`username`='P0678' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@067854',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0678' WHERE s.`admission_no`='1042' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1043' WHERE pa.`username`='P0512' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@051222',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0512' WHERE s.`admission_no`='1043' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1044' WHERE pa.`username`='P1044' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104426',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1044' WHERE s.`admission_no`='1044' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1045' WHERE pa.`username`='P1045' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104565',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1045' WHERE s.`admission_no`='1045' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1046' WHERE pa.`username`='P1045' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104565',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1045' WHERE s.`admission_no`='1046' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1047' WHERE pa.`username`='P1047' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104747',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1047' WHERE s.`admission_no`='1047' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1048' WHERE pa.`username`='P1048' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104819',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1048' WHERE s.`admission_no`='1048' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1049' WHERE pa.`username`='P1049' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@104949',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1049' WHERE s.`admission_no`='1049' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1050' WHERE pa.`username`='P1050' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105063',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1050' WHERE s.`admission_no`='1050' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1051' WHERE pa.`username`='P1051' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105184',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1051' WHERE s.`admission_no`='1051' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1052' WHERE pa.`username`='P1052' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105288',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1052' WHERE s.`admission_no`='1052' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1053' WHERE pa.`username`='P1053' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105332',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1053' WHERE s.`admission_no`='1053' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1054' WHERE pa.`username`='P1053' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105332',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1053' WHERE s.`admission_no`='1054' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1055' WHERE pa.`username`='P1055' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105596',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1055' WHERE s.`admission_no`='1055' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1056' WHERE pa.`username`='P1056' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105696',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1056' WHERE s.`admission_no`='1056' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1057' WHERE pa.`username`='P0620' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@062057',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0620' WHERE s.`admission_no`='1057' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1058' WHERE pa.`username`='P0158' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@015810',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P0158' WHERE s.`admission_no`='1058' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
INSERT IGNORE INTO `parent_student_links` (`parent_id`,`student_id`,`relation`) SELECT pa.id,s.id,'Parent' FROM `parent_accounts` pa JOIN `students` s ON s.`admission_no`='1059' WHERE pa.`username`='P1059' LIMIT 1;
INSERT INTO `parent_access_credentials` (`student_id`,`parent_id`,`temp_password`,`prepared_at`) SELECT s.id,pa.id,'Sep@105920',NOW() FROM `students` s JOIN `parent_accounts` pa ON pa.`username`='P1059' WHERE s.`admission_no`='1059' LIMIT 1 ON DUPLICATE KEY UPDATE `parent_id`=VALUES(`parent_id`);
COMMIT;
-- Expected: 301 credential rows, 224 parent logins, 34 new accounts.