INSERT INTO camps_camp (name, points_per_a, points_per_b_plus, points_per_b, points_per_b_minus, points_per_c_plus, points_per_c, points_per_c_minus, points_per_d, points_per_e, max_education_points, exam_mark_ratio, max_points_appearance, max_points_cdt_attitude, max_points_cdt_knowledge, max_points_course_attitude, max_points_subject_knowledge, max_points_general_knowledge, points_per_camp, max_camps_points, max_service_points) values
('Power Pilot Scholarship',          20, 18, 17, 16, 15, 14, 13, 10, 6, 20, 0.25, 7,  5,  5,  5, 10, 10, 0, 0, 8),
('Glider Pilot Scholarship',         20, 18, 17, 16, 15, 14, 13, 10, 6, 20, 0.25, 7,  5,  5,  5, 10, 10, 0, 0, 8),
('International Air Cadet Exchange', 20, 18, 17, 16, 15, 14, 13, 10, 6, 20, 0.0, 15, 10,  0, 10, 10, 15, 1, 5, 10),
('Airport Operations Course',        15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
('Air Traffic Control Course',       15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
('Technical Training Course',        15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
('Survival Instructor Course',       15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
('Athletic Instructor Course',       15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
('Senior Leaders Course',            15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
('Space Course',                     15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10);

INSERT INTO camps_cadet (surname, given_names, rank, sqn_id, sex, weight, height, address, city, province, postcode, home_phone_number, enrollment_date, date_of_birth) values
('Test1','Fred','Sgt',223,'F',0.00,0.00,'Address1','City1','BC','V0E 0H0','250-555-5555','2001-9-16','1989-3-14'),
('Test2','Kate','Sgt',819,'M',0,0,'Address2','City2','BC','V3S 0H0','604-555-5555','2000-5-19','1988-5-16');

INSERT INTO camps_application (cadet_id, year, camp_id, decision, comment, tech_choice_1, tech_choice_2, tech_choice_3) VALUES
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Air Traffic Control Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Competing in Australia','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Spr','','Elec','Service','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Air Traffic Control Course'),'Del','Did not show for Boards','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'PdgI','Fitness Test','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','','Service','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'N/R','Below 60% overall','Photo','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','','Elec','Service','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Air Traffic Control Course'),'Del','No waiver','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','Replacement for Veltmeyer','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','Aircraft Servicing','Service','Photo','Elec'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United States','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Spr','','Service','Elec','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','Not proper level - changed course','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','','Photo','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','Withdrew application','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','Not proper level - withdrew','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'SelI','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','','Elec','Service','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Del','Withdrew application','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','declined course','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Del','Withdrew application','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','','Photo','Service','Elec'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','Has only Cat 4 Med Cert','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Withdrew - low exam mark','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Spare','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Spr','','Photo','Service','Elec'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Del','Turns 19 in August 06','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Photography','Photo','Elec','Service'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Spr','','Elec','Service','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','Left Cadet Program','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','','Service','Elec','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','Changed to Survival Instr.','Photo','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - Turkey','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Del','Entering RMC','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Photography','Photo','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Air Traffic Control Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Del','Withdrew - personal reasons','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Air Traffic Control Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'SprI','Fitness Test','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Basic Electronics - Waiver approved','Service','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Withdrew - low exam mark','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'SelI','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Basic Electronics - Waiver approved','Service','Elec','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Del','Did not appear for Boards','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Pdg','','Service','Photo','Elec'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1''Neill') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Del','2 waivers requested - trg lvl & rank','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Del','No Show for Boards','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','Did not appear for Boards','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - Singapore','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Basic Electronics','Elec','Photo','Service'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Basic Electronics','Elec','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Did not complete conversion','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'N/R','Below 50% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Air Traffic Control Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','changed from ATC','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Basic Electronics','Photo','Elec','Service'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','Fitness Test received','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Did not appear for Boards','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Pdg','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Del','Left cadet squadron','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Survival Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Athletic Instructor Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Del','Withdrew - summer employment','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Del','Not proper level - changed course','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id from camps_camp 
WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Senior Leaders Course'),'Sel','','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
((SELECT id from camps_cadet 
WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2006,(SELECT id FROM camps_camp 
WHERE name='Air Traffic Control Course'),'Sel','','','','');
