-- Lukenya Premier Academy — combined student import from CSV registers
-- Generated: 2026-10-11 19:46:49
-- Total students: 207
-- Run in phpMyAdmin on database xjumypsj_educore_erp (or your live DB)

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- Ensure Playgroup class exists
INSERT INTO classes (name, code, sort_order, created_at, updated_at)
VALUES ('Playgroup', 'PG', 0, NOW(), NOW())
ON DUPLICATE KEY UPDATE name = VALUES(name), sort_order = VALUES(sort_order), updated_at = NOW();

INSERT INTO streams (class_id, name, code, capacity, created_at, updated_at)
SELECT c.id, 'Stream A', 'A', 40, NOW(), NOW()
FROM classes c
WHERE c.code = 'PG'
AND NOT EXISTS (
    SELECT 1 FROM streams s WHERE s.class_id = c.id AND s.code = 'A'
);

-- Students
INSERT INTO students (admission_no, first_name, last_name, gender, admission_date, boarding_status, status, created_at, updated_at)
VALUES
('LLA/001', 'Israel', 'Joshua', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/002', 'Gifton', 'Kibaru', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/003', 'Ariella', 'Kiloko', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/004', 'Favour', 'Muuo', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/005', 'Getrude', 'Njambi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/006', 'Hartley', 'Boniface', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/007', 'Treasure', 'Jael', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/008', 'Liam', 'Jasper', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/009', 'Mirabelle', 'Mwende', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/010', 'Mireya', 'Stephen', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/011', 'Noel', 'Muuo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/012', 'Reign', 'Muena', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/013', 'Scarlet', 'Moige', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/014', 'Taina', 'Safari', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/015', 'Neslyn', 'Nat', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/016', 'Sebastian', 'Evan', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/017', 'Antony', 'Mugo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/018', 'Samuel', 'Munene', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/019', 'Liam', 'Gikonyo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/020', 'Hayden', 'Baraka', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/021', 'Claire', 'Mumo', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/022', 'Dapheny', 'Chepchumba', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/023', 'Millan', 'Amadi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/024', 'Tashleen', 'Mumo', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/025', 'Tessa', 'Wayua', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/026', 'Elianah', 'Adriel', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/027', 'Rowel', 'Georges', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/028', 'Daniel', 'Mwendwa', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/029', 'Humeira', 'Hassan', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/030', 'Damasus', 'Munene', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/031', 'Israel', 'Itumo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/032', 'Hala', 'Ndungwa', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/033', 'Godwill', 'Utaio', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/034', 'Gracious', 'Imani', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/035', 'David', 'Mutuku', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/036', 'Millan', 'Keli', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/037', 'Leon', 'Kahangara', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/038', 'Bassey', 'Shantol', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/039', 'Tiffany', 'Zawadi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/040', 'Marley', 'Mikale', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/041', 'Keisha', 'Wambui', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/042', 'Jonah', 'Kroko', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/043', 'Carson', 'Njuma', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/044', 'Ryan', 'Michael', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/045', 'Levi', 'Sixtus', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/046', 'Ramsey', 'Mutinda', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/047', 'Javier', 'Mwitiki', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/048', 'Elian', 'Wendo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/049', 'Braylon', 'Zane', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/050', 'Tainasha', 'Royalty', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/051', 'Samuel', 'Kimieu', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/052', 'Modechai', 'Barasa', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/053', 'Brandon', 'Amani', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/054', 'Edda', 'Ndlanu', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/055', 'Kayla', 'Ndinda', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/056', 'Phinehas', 'Baraka', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/057', 'Blessing', 'Ndunge', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/058', 'Timothy', 'Kioko', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/059', 'Urseta', 'Ushindi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/060', 'William', 'Hubbian', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/061', 'Alexis', 'Kaiya', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/062', 'Angeliet', 'Atemi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/063', 'Cynthia', 'Lucas', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/064', 'Donatella', 'Maria', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/065', 'Glory', 'Kanyi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/066', 'Hayden', 'Jammie', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/067', 'Kellan', 'Macharia', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/068', 'Mary', 'Nduku', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/069', 'Melvin', 'Briton', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/070', 'Naomi', 'Kitavi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/071', 'Nathan', 'Muthwii', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/072', 'Oriana', 'Ndanu', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/073', 'Owen', 'Waringu', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/074', 'Precious', 'Omunandi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/075', 'Ramsy', 'Mumo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/076', 'Ruth', 'Muthoni', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/077', 'Israel', 'Rugongo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/078', 'Basil', 'Musya', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/079', 'Jerry', 'Biden', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/080', 'Dylan', 'Cole', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/081', 'Courtney', 'Osiemo', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/082', 'Ethan', 'Mumo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/083', 'Frendrick', 'Kitonga', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/084', 'Emmanuel', 'Masambe', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/085', 'Ariam', 'Mwania', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/086', 'Eusebia', 'Aundry', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/087', 'Joy', 'Mumo', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/088', 'Berly', 'Mutanu', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/089', 'Geovanah', 'Adah', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/090', 'David', 'Kithisya', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/091', 'Clinton', 'Mereti', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/092', 'Meshack', 'Bwire', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/093', 'Emmanuel', 'Muathime', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/094', 'Deborah', 'Mwongeli', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/095', 'Ryan', 'Korir', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/096', 'Prince Mumo', 'Prosper', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/097', 'Elizabeth', 'Mueni', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/098', 'Shania', 'Ngina', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/099', 'Sydney', 'Mbugua', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/100', 'Hope', 'Rita', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/101', 'Adriel', 'Mumo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/102', 'Ivannah', 'Mwanki', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/103', 'Brighton', 'Amollo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/104', 'Eliana Njeri', 'Clifton', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/105', 'Dennis', 'Ngumo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/106', 'Emmah', 'Cherop', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/107', 'Anthony', 'Arento', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/108', 'Bravin', 'Mumo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/109', 'Advine', 'Malanga', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/110', 'Harvey', 'Munyao', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/111', 'Samuel', 'Kyalo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/112', 'Lenny', 'Leticia', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/113', 'Gabriella', 'Zawadi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/114', 'Sarah', 'Angelus', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/115', 'McKaylin', 'Anthony', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/116', 'Precious', 'Musenya', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/117', 'Biton', 'Atemi', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/118', 'Hadassah', 'Wakesho', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/119', 'Hadassah', 'Neema', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/120', 'Vienna', 'Mwende', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/121', 'Sebastian', 'Mayaka', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/122', 'Daniel', 'Toki', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/123', 'Maryann', 'Muini', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/124', 'Adrian', 'Myles', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/125', 'Brandon', 'Wambua', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/126', 'Daniel', 'Mutisya', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/127', 'Hadassah', 'Mutheu', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/128', 'Joylene', 'Mbithi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/129', 'Lamel', 'Muuo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/130', 'Leticia', 'Kamotho', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/131', 'Leticia', 'Natasha', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/132', 'Brayden', 'Mwenda', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/133', 'Tajanae', 'Safari', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/134', 'Jayden', 'Jayleen', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/135', 'Katlyn', 'Gladys', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/136', 'Euphresia', 'Adrian', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/137', 'Amelia', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/138', 'Macrina', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/139', 'Tiffany', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/140', 'Blessing', 'Muthoni', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/141', 'Favour', 'Blessing', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/142', 'Nikita', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/143', 'Shanti', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/144', 'Valeria', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/145', 'Mary', 'Wapgoi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/146', 'Andre', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/147', 'Aiden', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/148', 'Leon', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/149', 'Nelson', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/150', 'Jayden Asebe', 'Baraka', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/151', 'Liam', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/152', 'Jordan', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/153', 'Valentine', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/154', 'Joy', 'Mutethya', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/155', 'Karen', 'Amani', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/156', 'Nathan', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/157', 'Happiness', '.', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/158', 'Boniface', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/159', 'Thomas', '.', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/160', 'John', 'Itumo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/161', 'Brighton', 'Muuo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/162', 'Gloriana', 'Masheti', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/163', 'Levie Haddassah', 'Mwakera', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/164', 'Joram', 'Otieno', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/165', 'Benjamin Stanley', 'Masambel', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/166', 'Irene Mitchell', 'Mwende', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/167', 'Patience Precious', 'Ngina', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/168', 'James', 'Russell', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/169', 'Ryan', 'Mwendwa', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/170', 'Lemuel', 'Baraka', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/171', 'Christine', 'Marion', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/172', 'Christine', 'Muthoki', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/173', 'Jayden', 'Mutua', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/174', 'Tessy', 'Mumo', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/175', 'Virana', 'Mwitiki', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/176', 'Alvin', 'Kimutai', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/177', 'Andrew', 'Nyaga', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/178', 'Benjamin', 'Maei', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/179', 'Ephraim', 'Israel', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/180', 'Favour', 'Muuo', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/181', 'Nicole', 'Utanu', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/182', 'Olivia', 'Kioko', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/183', 'Prosper', 'Muuo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/184', 'Mahir Muzamil', 'Muhammad', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/185', 'Morris', 'Mwanandu', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/186', 'Geoffrey', 'Kimeu', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/187', 'Esther', 'Mumbi', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/188', 'Victor', 'Mwendwa', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/189', 'Levy', 'Mwendwa', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/190', 'Mashack', 'Matheka', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/191', 'Benjamin', 'Omwega', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/192', 'Keisha', 'Mukii', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/193', 'Michael', 'Kimatithi', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/194', 'Adams', 'Saidi', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/195', 'Blessing', 'Mwendwa', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/196', 'Josphat Daniel', 'Kiombe', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/197', 'Joshua', 'Mbaluka', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/198', 'Ian', 'Mwanza', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/199', 'Joel', 'Sila', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/200', 'Maxwell', 'Fundi', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/201', 'Nia', 'Njoki', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/202', 'Stanley', 'Matambe', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/203', 'Stephane', 'Mueni', 'female', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/204', 'Jayden', 'Gichuru', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/205', 'Kim', 'Caleb', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/206', 'Samuel', 'Njoroge', 'male', '2026-01-01', 'day', 'active', NOW(), NOW()),
('LLA/207', 'Edmond', 'Mugo', 'male', '2026-01-01', 'day', 'active', NOW(), NOW())
ON DUPLICATE KEY UPDATE
    first_name = VALUES(first_name),
    last_name = VALUES(last_name),
    gender = VALUES(gender),
    admission_date = VALUES(admission_date),
    status = 'active',
    updated_at = NOW();

-- Refresh current-year enrollments for imported learners
DELETE se
FROM student_enrollments se
INNER JOIN students s ON s.id = se.student_id
INNER JOIN academic_years ay ON ay.id = se.academic_year_id AND ay.is_current = 1
WHERE s.admission_no IN ('LLA/001', 'LLA/002', 'LLA/003', 'LLA/004', 'LLA/005', 'LLA/006', 'LLA/007', 'LLA/008', 'LLA/009', 'LLA/010', 'LLA/011', 'LLA/012', 'LLA/013', 'LLA/014', 'LLA/015', 'LLA/016', 'LLA/017', 'LLA/018', 'LLA/019', 'LLA/020', 'LLA/021', 'LLA/022', 'LLA/023', 'LLA/024', 'LLA/025', 'LLA/026', 'LLA/027', 'LLA/028', 'LLA/029', 'LLA/030', 'LLA/031', 'LLA/032', 'LLA/033', 'LLA/034', 'LLA/035', 'LLA/036', 'LLA/037', 'LLA/038', 'LLA/039', 'LLA/040', 'LLA/041', 'LLA/042', 'LLA/043', 'LLA/044', 'LLA/045', 'LLA/046', 'LLA/047', 'LLA/048', 'LLA/049', 'LLA/050', 'LLA/051', 'LLA/052', 'LLA/053', 'LLA/054', 'LLA/055', 'LLA/056', 'LLA/057', 'LLA/058', 'LLA/059', 'LLA/060', 'LLA/061', 'LLA/062', 'LLA/063', 'LLA/064', 'LLA/065', 'LLA/066', 'LLA/067', 'LLA/068', 'LLA/069', 'LLA/070', 'LLA/071', 'LLA/072', 'LLA/073', 'LLA/074', 'LLA/075', 'LLA/076', 'LLA/077', 'LLA/078', 'LLA/079', 'LLA/080', 'LLA/081', 'LLA/082', 'LLA/083', 'LLA/084', 'LLA/085', 'LLA/086', 'LLA/087', 'LLA/088', 'LLA/089', 'LLA/090', 'LLA/091', 'LLA/092', 'LLA/093', 'LLA/094', 'LLA/095', 'LLA/096', 'LLA/097', 'LLA/098', 'LLA/099', 'LLA/100', 'LLA/101', 'LLA/102', 'LLA/103', 'LLA/104', 'LLA/105', 'LLA/106', 'LLA/107', 'LLA/108', 'LLA/109', 'LLA/110', 'LLA/111', 'LLA/112', 'LLA/113', 'LLA/114', 'LLA/115', 'LLA/116', 'LLA/117', 'LLA/118', 'LLA/119', 'LLA/120', 'LLA/121', 'LLA/122', 'LLA/123', 'LLA/124', 'LLA/125', 'LLA/126', 'LLA/127', 'LLA/128', 'LLA/129', 'LLA/130', 'LLA/131', 'LLA/132', 'LLA/133', 'LLA/134', 'LLA/135', 'LLA/136', 'LLA/137', 'LLA/138', 'LLA/139', 'LLA/140', 'LLA/141', 'LLA/142', 'LLA/143', 'LLA/144', 'LLA/145', 'LLA/146', 'LLA/147', 'LLA/148', 'LLA/149', 'LLA/150', 'LLA/151', 'LLA/152', 'LLA/153', 'LLA/154', 'LLA/155', 'LLA/156', 'LLA/157', 'LLA/158', 'LLA/159', 'LLA/160', 'LLA/161', 'LLA/162', 'LLA/163', 'LLA/164', 'LLA/165', 'LLA/166', 'LLA/167', 'LLA/168', 'LLA/169', 'LLA/170', 'LLA/171', 'LLA/172', 'LLA/173', 'LLA/174', 'LLA/175', 'LLA/176', 'LLA/177', 'LLA/178', 'LLA/179', 'LLA/180', 'LLA/181', 'LLA/182', 'LLA/183', 'LLA/184', 'LLA/185', 'LLA/186', 'LLA/187', 'LLA/188', 'LLA/189', 'LLA/190', 'LLA/191', 'LLA/192', 'LLA/193', 'LLA/194', 'LLA/195', 'LLA/196', 'LLA/197', 'LLA/198', 'LLA/199', 'LLA/200', 'LLA/201', 'LLA/202', 'LLA/203', 'LLA/204', 'LLA/205', 'LLA/206', 'LLA/207');

INSERT INTO student_enrollments
    (student_id, class_id, stream_id, academic_year_id, academic_term_id, admission_status, roll_no, joined_on, status, created_at, updated_at)
VALUES
((SELECT id FROM students WHERE admission_no = 'LLA/001' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-001', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/002' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-002', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/003' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-003', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/004' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-004', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/005' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-005', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/006' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-006', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/007' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-007', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/008' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-008', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/009' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-009', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/010' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-010', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/011' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-011', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/012' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-012', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/013' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-013', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/014' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-014', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/015' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-015', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/016' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-016', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/017' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-017', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/018' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-018', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/019' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-019', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/020' LIMIT 1), (SELECT id FROM classes WHERE code = 'PG' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PG' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PG-A-020', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/021' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-021', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/022' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-022', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/023' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-023', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/024' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-024', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/025' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-025', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/026' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-026', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/027' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-027', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/028' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-028', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/029' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-029', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/030' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-030', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/031' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-031', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/032' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-032', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/033' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-033', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/034' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-034', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/035' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-035', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/036' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-036', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/037' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-037', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/038' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-038', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/039' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-039', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/040' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-040', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/041' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-041', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/042' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-042', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/043' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-043', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/044' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-044', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/045' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-045', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/046' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-046', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/047' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-047', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/048' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-048', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/049' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-049', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/050' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-050', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/051' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-051', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/052' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-052', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/053' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-053', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/054' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-054', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/055' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-055', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/056' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP1-A-056', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/057' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-057', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/058' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-058', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/059' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-059', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/060' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-060', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/061' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-061', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/062' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-062', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/063' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-063', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/064' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-064', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/065' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-065', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/066' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-066', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/067' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-067', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/068' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-068', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/069' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-069', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/070' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-070', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/071' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-071', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/072' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-072', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/073' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-073', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/074' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-074', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/075' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-075', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/076' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-076', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/077' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-077', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/078' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-078', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/079' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-079', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/080' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-080', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/081' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-081', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/082' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-082', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/083' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-083', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/084' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-084', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/085' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-085', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/086' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-086', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/087' LIMIT 1), (SELECT id FROM classes WHERE code = 'PP2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'PP2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'PP2-A-087', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/088' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-088', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/089' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-089', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/090' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-090', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/091' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-091', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/092' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-092', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/093' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-093', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/094' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-094', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/095' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-095', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/096' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-096', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/097' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-097', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/098' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-098', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/099' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-099', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/100' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-100', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/101' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-101', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/102' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-102', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/103' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-103', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/104' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-104', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/105' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-105', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/106' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-106', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/107' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-107', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/108' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-108', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/109' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-109', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/110' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-110', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/111' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-111', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/112' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-112', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/113' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-113', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/114' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-114', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/115' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-115', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/116' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-116', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/117' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-117', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/118' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-118', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/119' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-119', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/120' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-120', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/121' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-121', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/122' LIMIT 1), (SELECT id FROM classes WHERE code = 'G1' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G1' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G1-A-122', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/123' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-123', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/124' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-124', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/125' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-125', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/126' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-126', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/127' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-127', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/128' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-128', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/129' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-129', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/130' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-130', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/131' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-131', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/132' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-132', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/133' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-133', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/134' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-134', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/135' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-135', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/136' LIMIT 1), (SELECT id FROM classes WHERE code = 'G2' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G2' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G2-A-136', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/137' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-137', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/138' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-138', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/139' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-139', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/140' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-140', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/141' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-141', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/142' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-142', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/143' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-143', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/144' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-144', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/145' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-145', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/146' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-146', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/147' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-147', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/148' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-148', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/149' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-149', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/150' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-150', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/151' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-151', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/152' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-152', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/153' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-153', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/154' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-154', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/155' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-155', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/156' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-156', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/157' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-157', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/158' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-158', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/159' LIMIT 1), (SELECT id FROM classes WHERE code = 'G3' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G3' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G3-A-159', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/160' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-160', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/161' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-161', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/162' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-162', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/163' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-163', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/164' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-164', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/165' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-165', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/166' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-166', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/167' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-167', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/168' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-168', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/169' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-169', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/170' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-170', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/171' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-171', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/172' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-172', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/173' LIMIT 1), (SELECT id FROM classes WHERE code = 'G4' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G4' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G4-A-173', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/174' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-174', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/175' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-175', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/176' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-176', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/177' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-177', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/178' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-178', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/179' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-179', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/180' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-180', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/181' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-181', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/182' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-182', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/183' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-183', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/184' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-184', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/185' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-185', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/186' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-186', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/187' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-187', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/188' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-188', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/189' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-189', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/190' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-190', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/191' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-191', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/192' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-192', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/193' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-193', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/194' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-194', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/195' LIMIT 1), (SELECT id FROM classes WHERE code = 'G5' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G5' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G5-A-195', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/196' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-196', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/197' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-197', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/198' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-198', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/199' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-199', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/200' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-200', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/201' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-201', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/202' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-202', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/203' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-203', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/204' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-204', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/205' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-205', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/206' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-206', '2026-01-01', 'active', NOW(), NOW()),
((SELECT id FROM students WHERE admission_no = 'LLA/207' LIMIT 1), (SELECT id FROM classes WHERE code = 'G6' LIMIT 1), (SELECT s.id FROM streams s INNER JOIN classes c ON c.id = s.class_id WHERE c.code = 'G6' AND s.code = 'A' LIMIT 1), (SELECT id FROM academic_years WHERE is_current = 1 ORDER BY id DESC LIMIT 1), (SELECT t.id FROM academic_terms t INNER JOIN academic_years y ON y.id = t.academic_year_id AND y.is_current = 1 WHERE t.is_current = 1 ORDER BY t.id DESC LIMIT 1), 'active', 'G6-A-207', '2026-01-01', 'active', NOW(), NOW())
;

SET FOREIGN_KEY_CHECKS = 1;

-- Verify:
-- SELECT COUNT(*) AS total_students FROM students WHERE status = 'active';
-- SELECT c.code, COUNT(*) AS learners FROM student_enrollments se INNER JOIN students s ON s.id = se.student_id INNER JOIN classes c ON c.id = se.class_id WHERE se.status = 'active' GROUP BY c.code ORDER BY c.sort_order;