Ticket #3233: cadet.sql

File cadet.sql, 67.6 KB (added by anonymous, 8 years ago)

SQL file that fails

Line 
1INSERT 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
2('Power Pilot Scholarship',          20, 18, 17, 16, 15, 14, 13, 10, 6, 20, 0.25, 7,  5,  5,  5, 10, 10, 0, 0, 8),
3('Glider Pilot Scholarship',         20, 18, 17, 16, 15, 14, 13, 10, 6, 20, 0.25, 7,  5,  5,  5, 10, 10, 0, 0, 8),
4('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),
5('Airport Operations Course',        15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
6('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),
7('Technical Training Course',        15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
8('Survival Instructor Course',       15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
9('Athletic Instructor Course',       15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10),
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),
11('Space Course',                     15, 14, 13, 12, 11, 10,  9,  5, 3, 15, 0.0, 10, 10, 10, 15, 15, 10, 0, 0, 10);
12
13INSERT 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
14('Test1','Fred','Sgt',223,'F',0.00,0.00,'Address1','City1','BC','V0E 0H0','250-555-5555','2001-9-16','1989-3-14'),
15('Test2','Kate','Sgt',819,'M',0,0,'Address2','City2','BC','V3S 0H0','604-555-5555','2000-5-19','1988-5-16');
16
17INSERT INTO camps_application (cadet_id, year, camp_id, decision, comment, tech_choice_1, tech_choice_2, tech_choice_3) VALUES
18((SELECT id from camps_cadet
19WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
202006,(SELECT id FROM camps_camp
21WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
22((SELECT id from camps_cadet
23WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
242006,(SELECT id from camps_camp
25WHERE name='Athletic Instructor Course'),'Sel','','','',''),
26((SELECT id from camps_cadet
27WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
282006,(SELECT id FROM camps_camp
29WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
30((SELECT id from camps_cadet
31WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
322006,(SELECT id FROM camps_camp
33WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
34((SELECT id from camps_cadet
35WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
362006,(SELECT id FROM camps_camp
37WHERE name='Air Traffic Control Course'),'Sel','','','',''),
38((SELECT id from camps_cadet
39WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
402006,(SELECT id from camps_camp
41WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
42((SELECT id from camps_cadet
43WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
442006,(SELECT id FROM camps_camp
45WHERE name='Glider Pilot Scholarship'),'Del','Competing in Australia','','',''),
46((SELECT id from camps_cadet
47WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
482006,(SELECT id FROM camps_camp
49WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
50((SELECT id from camps_cadet
51WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
522006,(SELECT id FROM camps_camp
53WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
54((SELECT id from camps_cadet
55WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
562006,(SELECT id FROM camps_camp
57WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
58((SELECT id from camps_cadet
59WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
602006,(SELECT id FROM camps_camp
61WHERE name='Survival Instructor Course'),'Sel','','','',''),
62((SELECT id from camps_cadet
63WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
642006,(SELECT id FROM camps_camp
65WHERE name='Technical Training Course'),'Spr','','Elec','Service','Photo'),
66((SELECT id from camps_cadet
67WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
682006,(SELECT id FROM camps_camp
69WHERE name='Survival Instructor Course'),'Pdg','','','',''),
70((SELECT id from camps_cadet
71WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
722006,(SELECT id FROM camps_camp
73WHERE name='Survival Instructor Course'),'Sel','','','',''),
74((SELECT id from camps_cadet
75WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
762006,(SELECT id FROM camps_camp
77WHERE name='Survival Instructor Course'),'Sel','','','',''),
78((SELECT id from camps_cadet
79WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
802006,(SELECT id FROM camps_camp
81WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
82((SELECT id from camps_cadet
83WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
842006,(SELECT id from camps_camp
85WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
86((SELECT id from camps_cadet
87WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
882006,(SELECT id FROM camps_camp
89WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
90((SELECT id from camps_cadet
91WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
922006,(SELECT id FROM camps_camp
93WHERE name='Senior Leaders Course'),'Sel','','','',''),
94((SELECT id from camps_cadet
95WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
962006,(SELECT id FROM camps_camp
97WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
98((SELECT id from camps_cadet
99WHERE (surname='Test1') AND (rank='Sgt')),
1002006,(SELECT id from camps_camp
101WHERE name='Athletic Instructor Course'),'Sel','','','',''),
102((SELECT id from camps_cadet
103WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1042006,(SELECT id from camps_camp
105WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
106((SELECT id from camps_cadet
107WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1082006,(SELECT id FROM camps_camp
109WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
110((SELECT id from camps_cadet
111WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1122006,(SELECT id from camps_camp
113WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
114((SELECT id from camps_cadet
115WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1162006,(SELECT id from camps_camp
117WHERE name='Athletic Instructor Course'),'Spr','','','',''),
118((SELECT id from camps_cadet
119WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1202006,(SELECT id from camps_camp
121WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
122((SELECT id from camps_cadet
123WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1242006,(SELECT id FROM camps_camp
125WHERE name='Senior Leaders Course'),'Sel','','','',''),
126((SELECT id from camps_cadet
127WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1282006,(SELECT id from camps_camp
129WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
130((SELECT id from camps_cadet
131WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1322006,(SELECT id FROM camps_camp
133WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
134((SELECT id from camps_cadet
135WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1362006,(SELECT id FROM camps_camp
137WHERE name='Air Traffic Control Course'),'Del','Did not show for Boards','','',''),
138((SELECT id from camps_cadet
139WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1402006,(SELECT id FROM camps_camp
141WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
142((SELECT id from camps_cadet
143WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1442006,(SELECT id FROM camps_camp
145WHERE name='Survival Instructor Course'),'Pdg','','','',''),
146((SELECT id from camps_cadet
147WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1482006,(SELECT id FROM camps_camp
149WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
150((SELECT id from camps_cadet
151WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1522006,(SELECT id FROM camps_camp
153WHERE name='Senior Leaders Course'),'Sel','','','',''),
154((SELECT id from camps_cadet
155WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1562006,(SELECT id from camps_camp
157WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
158((SELECT id from camps_cadet
159WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1602006,(SELECT id from camps_camp
161WHERE name='Athletic Instructor Course'),'PdgI','Fitness Test','','',''),
162((SELECT id from camps_cadet
163WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1642006,(SELECT id FROM camps_camp
165WHERE name='Technical Training Course'),'Pdg','','Service','',''),
166((SELECT id from camps_cadet
167WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1682006,(SELECT id from camps_camp
169WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
170((SELECT id from camps_cadet
171WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1722006,(SELECT id from camps_camp
173WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
174((SELECT id from camps_cadet
175WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1762006,(SELECT id FROM camps_camp
177WHERE name='Technical Training Course'),'N/R','Below 60% overall','Photo','',''),
178((SELECT id from camps_cadet
179WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1802006,(SELECT id from camps_camp
181WHERE name='Athletic Instructor Course'),'Spr','','','',''),
182((SELECT id from camps_cadet
183WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1842006,(SELECT id FROM camps_camp
185WHERE name='Survival Instructor Course'),'Pdg','','','',''),
186((SELECT id from camps_cadet
187WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1882006,(SELECT id from camps_camp
189WHERE name='Athletic Instructor Course'),'Sel','','','',''),
190((SELECT id from camps_cadet
191WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1922006,(SELECT id FROM camps_camp
193WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
194((SELECT id from camps_cadet
195WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
1962006,(SELECT id FROM camps_camp
197WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
198((SELECT id from camps_cadet
199WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2002006,(SELECT id FROM camps_camp
201WHERE name='Technical Training Course'),'Pdg','','Elec','Service','Photo'),
202((SELECT id from camps_cadet
203WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2042006,(SELECT id FROM camps_camp
205WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
206((SELECT id from camps_cadet
207WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2082006,(SELECT id FROM camps_camp
209WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
210((SELECT id from camps_cadet
211WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2122006,(SELECT id FROM camps_camp
213WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
214((SELECT id from camps_cadet
215WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2162006,(SELECT id FROM camps_camp
217WHERE name='Survival Instructor Course'),'Sel','','','',''),
218((SELECT id from camps_cadet
219WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2202006,(SELECT id FROM camps_camp
221WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
222((SELECT id from camps_cadet
223WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2242006,(SELECT id FROM camps_camp
225WHERE name='Air Traffic Control Course'),'Del','No waiver','','',''),
226((SELECT id from camps_cadet
227WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2282006,(SELECT id from camps_camp
229WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
230((SELECT id from camps_cadet
231WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2322006,(SELECT id from camps_camp
233WHERE name='Athletic Instructor Course'),'Sel','Replacement for Veltmeyer','','',''),
234((SELECT id from camps_cadet
235WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2362006,(SELECT id FROM camps_camp
237WHERE name='Senior Leaders Course'),'Sel','','','',''),
238((SELECT id from camps_cadet
239WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2402006,(SELECT id FROM camps_camp
241WHERE name='Senior Leaders Course'),'Sel','','','',''),
242((SELECT id from camps_cadet
243WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2442006,(SELECT id FROM camps_camp
245WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
246((SELECT id from camps_cadet
247WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2482006,(SELECT id FROM camps_camp
249WHERE name='Senior Leaders Course'),'Sel','','','',''),
250((SELECT id from camps_cadet
251WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2522006,(SELECT id FROM camps_camp
253WHERE name='Senior Leaders Course'),'Sel','','','',''),
254((SELECT id from camps_cadet
255WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2562006,(SELECT id from camps_camp
257WHERE name='Athletic Instructor Course'),'Spr','','','',''),
258((SELECT id from camps_cadet
259WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2602006,(SELECT id from camps_camp
261WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
262((SELECT id from camps_cadet
263WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2642006,(SELECT id FROM camps_camp
265WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
266((SELECT id from camps_cadet
267WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2682006,(SELECT id FROM camps_camp
269WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
270((SELECT id from camps_cadet
271WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2722006,(SELECT id from camps_camp
273WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
274((SELECT id from camps_cadet
275WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2762006,(SELECT id FROM camps_camp
277WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
278((SELECT id from camps_cadet
279WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2802006,(SELECT id FROM camps_camp
281WHERE name='Survival Instructor Course'),'Sel','','','',''),
282((SELECT id from camps_cadet
283WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2842006,(SELECT id FROM camps_camp
285WHERE name='Technical Training Course'),'Pdg','Aircraft Servicing','Service','Photo','Elec'),
286((SELECT id from camps_cadet
287WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2882006,(SELECT id FROM camps_camp
289WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
290((SELECT id from camps_cadet
291WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2922006,(SELECT id FROM camps_camp
293WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
294((SELECT id from camps_cadet
295WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
2962006,(SELECT id FROM camps_camp
297WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
298((SELECT id from camps_cadet
299WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3002006,(SELECT id from camps_camp
301WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
302((SELECT id from camps_cadet
303WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3042006,(SELECT id from camps_camp
305WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
306((SELECT id from camps_cadet
307WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3082006,(SELECT id FROM camps_camp
309WHERE name='Glider Pilot Scholarship'),'Del','Below 60% overall','','',''),
310((SELECT id from camps_cadet
311WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3122006,(SELECT id FROM camps_camp
313WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United States','','',''),
314((SELECT id from camps_cadet
315WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3162006,(SELECT id from camps_camp
317WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
318((SELECT id from camps_cadet
319WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3202006,(SELECT id FROM camps_camp
321WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
322((SELECT id from camps_cadet
323WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3242006,(SELECT id FROM camps_camp
325WHERE name='Glider Pilot Scholarship'),'Pdg','','','',''),
326((SELECT id from camps_cadet
327WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3282006,(SELECT id from camps_camp
329WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
330((SELECT id from camps_cadet
331WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3322006,(SELECT id FROM camps_camp
333WHERE name='Technical Training Course'),'Spr','','Service','Elec','Photo'),
334((SELECT id from camps_cadet
335WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3362006,(SELECT id FROM camps_camp
337WHERE name='Senior Leaders Course'),'Del','Not proper level - changed course','','',''),
338((SELECT id from camps_cadet
339WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3402006,(SELECT id FROM camps_camp
341WHERE name='Senior Leaders Course'),'Sel','','','',''),
342((SELECT id from camps_cadet
343WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3442006,(SELECT id FROM camps_camp
345WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
346((SELECT id from camps_cadet
347WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3482006,(SELECT id FROM camps_camp
349WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
350((SELECT id from camps_cadet
351WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3522006,(SELECT id FROM camps_camp
353WHERE name='Survival Instructor Course'),'Sel','','','',''),
354((SELECT id from camps_cadet
355WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3562006,(SELECT id FROM camps_camp
357WHERE name='Technical Training Course'),'Pdg','','Photo','',''),
358((SELECT id from camps_cadet
359WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3602006,(SELECT id FROM camps_camp
361WHERE name='Senior Leaders Course'),'Del','Withdrew application','','',''),
362((SELECT id from camps_cadet
363WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3642006,(SELECT id FROM camps_camp
365WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
366((SELECT id from camps_cadet
367WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3682006,(SELECT id FROM camps_camp
369WHERE name='Senior Leaders Course'),'Del','Not proper level - withdrew','','',''),
370((SELECT id from camps_cadet
371WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3722006,(SELECT id FROM camps_camp
373WHERE name='Glider Pilot Scholarship'),'SelI','Require Medical Certificate','','',''),
374((SELECT id from camps_cadet
375WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3762006,(SELECT id FROM camps_camp
377WHERE name='Senior Leaders Course'),'Sel','','','',''),
378((SELECT id from camps_cadet
379WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3802006,(SELECT id FROM camps_camp
381WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
382((SELECT id from camps_cadet
383WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3842006,(SELECT id FROM camps_camp
385WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
386((SELECT id from camps_cadet
387WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3882006,(SELECT id FROM camps_camp
389WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
390((SELECT id from camps_cadet
391WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3922006,(SELECT id from camps_camp
393WHERE name='Athletic Instructor Course'),'Spr','','','',''),
394((SELECT id from camps_cadet
395WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
3962006,(SELECT id FROM camps_camp
397WHERE name='Senior Leaders Course'),'Sel','','','',''),
398((SELECT id from camps_cadet
399WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4002006,(SELECT id FROM camps_camp
401WHERE name='Senior Leaders Course'),'Sel','','','',''),
402((SELECT id from camps_cadet
403WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4042006,(SELECT id from camps_camp
405WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
406((SELECT id from camps_cadet
407WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4082006,(SELECT id FROM camps_camp
409WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
410((SELECT id from camps_cadet
411WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4122006,(SELECT id FROM camps_camp
413WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
414((SELECT id from camps_cadet
415WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4162006,(SELECT id FROM camps_camp
417WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
418((SELECT id from camps_cadet
419WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4202006,(SELECT id FROM camps_camp
421WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
422((SELECT id from camps_cadet
423WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4242006,(SELECT id FROM camps_camp
425WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
426((SELECT id from camps_cadet
427WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4282006,(SELECT id FROM camps_camp
429WHERE name='Survival Instructor Course'),'Sel','','','',''),
430((SELECT id from camps_cadet
431WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4322006,(SELECT id FROM camps_camp
433WHERE name='Senior Leaders Course'),'Sel','','','',''),
434((SELECT id from camps_cadet
435WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4362006,(SELECT id FROM camps_camp
437WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
438((SELECT id from camps_cadet
439WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4402006,(SELECT id from camps_camp
441WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
442((SELECT id from camps_cadet
443WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4442006,(SELECT id from camps_camp
445WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
446((SELECT id from camps_cadet
447WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4482006,(SELECT id FROM camps_camp
449WHERE name='Technical Training Course'),'Pdg','','Elec','Service','Photo'),
450((SELECT id from camps_cadet
451WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4522006,(SELECT id from camps_camp
453WHERE name='Athletic Instructor Course'),'Del','Withdrew application','','',''),
454((SELECT id from camps_cadet
455WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4562006,(SELECT id from camps_camp
457WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
458((SELECT id from camps_cadet
459WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4602006,(SELECT id FROM camps_camp
461WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
462((SELECT id from camps_cadet
463WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4642006,(SELECT id FROM camps_camp
465WHERE name='Survival Instructor Course'),'Sel','','','',''),
466((SELECT id from camps_cadet
467WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4682006,(SELECT id FROM camps_camp
469WHERE name='Senior Leaders Course'),'Del','declined course','','',''),
470((SELECT id from camps_cadet
471WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4722006,(SELECT id from camps_camp
473WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
474((SELECT id from camps_cadet
475WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4762006,(SELECT id FROM camps_camp
477WHERE name='Senior Leaders Course'),'Pdg','','','',''),
478((SELECT id from camps_cadet
479WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4802006,(SELECT id FROM camps_camp
481WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
482((SELECT id from camps_cadet
483WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4842006,(SELECT id FROM camps_camp
485WHERE name='Survival Instructor Course'),'Sel','','','',''),
486((SELECT id from camps_cadet
487WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4882006,(SELECT id FROM camps_camp
489WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
490((SELECT id from camps_cadet
491WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4922006,(SELECT id FROM camps_camp
493WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
494((SELECT id from camps_cadet
495WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
4962006,(SELECT id from camps_camp
497WHERE name='Athletic Instructor Course'),'Sel','','','',''),
498((SELECT id from camps_cadet
499WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5002006,(SELECT id FROM camps_camp
501WHERE name='Senior Leaders Course'),'Pdg','','','',''),
502((SELECT id from camps_cadet
503WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5042006,(SELECT id FROM camps_camp
505WHERE name='Survival Instructor Course'),'Sel','','','',''),
506((SELECT id from camps_cadet
507WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5082006,(SELECT id FROM camps_camp
509WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
510((SELECT id from camps_cadet
511WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5122006,(SELECT id FROM camps_camp
513WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
514((SELECT id from camps_cadet
515WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5162006,(SELECT id from camps_camp
517WHERE name='Athletic Instructor Course'),'Del','Withdrew application','','',''),
518((SELECT id from camps_cadet
519WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5202006,(SELECT id FROM camps_camp
521WHERE name='Technical Training Course'),'Pdg','','Photo','Service','Elec'),
522((SELECT id from camps_cadet
523WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5242006,(SELECT id from camps_camp
525WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
526((SELECT id from camps_cadet
527WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5282006,(SELECT id from camps_camp
529WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
530((SELECT id from camps_cadet
531WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5322006,(SELECT id FROM camps_camp
533WHERE name='Survival Instructor Course'),'Sel','','','',''),
534((SELECT id from camps_cadet
535WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5362006,(SELECT id from camps_camp
537WHERE name='Athletic Instructor Course'),'Sel','','','',''),
538((SELECT id from camps_cadet
539WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5402006,(SELECT id from camps_camp
541WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
542((SELECT id from camps_cadet
543WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5442006,(SELECT id FROM camps_camp
545WHERE name='Senior Leaders Course'),'Sel','','','',''),
546((SELECT id from camps_cadet
547WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5482006,(SELECT id FROM camps_camp
549WHERE name='Survival Instructor Course'),'Sel','','','',''),
550((SELECT id from camps_cadet
551WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5522006,(SELECT id FROM camps_camp
553WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
554((SELECT id from camps_cadet
555WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5562006,(SELECT id from camps_camp
557WHERE name='Power Pilot Scholarship'),'Sel','Has only Cat 4 Med Cert','','',''),
558((SELECT id from camps_cadet
559WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5602006,(SELECT id from camps_camp
561WHERE name='Power Pilot Scholarship'),'Del','Withdrew - low exam mark','','',''),
562((SELECT id from camps_cadet
563WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5642006,(SELECT id FROM camps_camp
565WHERE name='Survival Instructor Course'),'Spare','','','',''),
566((SELECT id from camps_cadet
567WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5682006,(SELECT id from camps_camp
569WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
570((SELECT id from camps_cadet
571WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5722006,(SELECT id FROM camps_camp
573WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
574((SELECT id from camps_cadet
575WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5762006,(SELECT id from camps_camp
577WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
578((SELECT id from camps_cadet
579WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5802006,(SELECT id FROM camps_camp
581WHERE name='Survival Instructor Course'),'Pdg','','','',''),
582((SELECT id from camps_cadet
583WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5842006,(SELECT id from camps_camp
585WHERE name='Athletic Instructor Course'),'Sel','','','',''),
586((SELECT id from camps_cadet
587WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5882006,(SELECT id FROM camps_camp
589WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
590((SELECT id from camps_cadet
591WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5922006,(SELECT id FROM camps_camp
593WHERE name='Technical Training Course'),'Spr','','Photo','Service','Elec'),
594((SELECT id from camps_cadet
595WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
5962006,(SELECT id FROM camps_camp
597WHERE name='Survival Instructor Course'),'Sel','','','',''),
598((SELECT id from camps_cadet
599WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6002006,(SELECT id FROM camps_camp
601WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
602((SELECT id from camps_cadet
603WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6042006,(SELECT id FROM camps_camp
605WHERE name='International Air Cadet Exchange'),'Del','Turns 19 in August 06','','',''),
606((SELECT id from camps_cadet
607WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6082006,(SELECT id FROM camps_camp
609WHERE name='Survival Instructor Course'),'Sel','','','',''),
610((SELECT id from camps_cadet
611WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6122006,(SELECT id from camps_camp
613WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
614((SELECT id from camps_cadet
615WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6162006,(SELECT id FROM camps_camp
617WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
618((SELECT id from camps_cadet
619WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6202006,(SELECT id from camps_camp
621WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
622((SELECT id from camps_cadet
623WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6242006,(SELECT id FROM camps_camp
625WHERE name='Glider Pilot Scholarship'),'Del','Require Medical Certificate','','',''),
626((SELECT id from camps_cadet
627WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6282006,(SELECT id FROM camps_camp
629WHERE name='Technical Training Course'),'Sel','Photography','Photo','Elec','Service'),
630((SELECT id from camps_cadet
631WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6322006,(SELECT id FROM camps_camp
633WHERE name='Technical Training Course'),'Spr','','Elec','Service','Photo'),
634((SELECT id from camps_cadet
635WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6362006,(SELECT id FROM camps_camp
637WHERE name='Senior Leaders Course'),'Sel','','','',''),
638((SELECT id from camps_cadet
639WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6402006,(SELECT id FROM camps_camp
641WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
642((SELECT id from camps_cadet
643WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6442006,(SELECT id FROM camps_camp
645WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
646((SELECT id from camps_cadet
647WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6482006,(SELECT id FROM camps_camp
649WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
650((SELECT id from camps_cadet
651WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6522006,(SELECT id FROM camps_camp
653WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
654((SELECT id from camps_cadet
655WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6562006,(SELECT id from camps_camp
657WHERE name='Power Pilot Scholarship'),'Pdg','','','',''),
658((SELECT id from camps_cadet
659WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6602006,(SELECT id from camps_camp
661WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
662((SELECT id from camps_cadet
663WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6642006,(SELECT id FROM camps_camp
665WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
666((SELECT id from camps_cadet
667WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6682006,(SELECT id FROM camps_camp
669WHERE name='Senior Leaders Course'),'Del','Left Cadet Program','','',''),
670((SELECT id from camps_cadet
671WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6722006,(SELECT id FROM camps_camp
673WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
674((SELECT id from camps_cadet
675WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6762006,(SELECT id FROM camps_camp
677WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
678((SELECT id from camps_cadet
679WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6802006,(SELECT id FROM camps_camp
681WHERE name='Survival Instructor Course'),'Pdg','','','',''),
682((SELECT id from camps_cadet
683WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6842006,(SELECT id from camps_camp
685WHERE name='Athletic Instructor Course'),'Sel','','','',''),
686((SELECT id from camps_cadet
687WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6882006,(SELECT id FROM camps_camp
689WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
690((SELECT id from camps_cadet
691WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6922006,(SELECT id FROM camps_camp
693WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
694((SELECT id from camps_cadet
695WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
6962006,(SELECT id FROM camps_camp
697WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
698((SELECT id from camps_cadet
699WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7002006,(SELECT id FROM camps_camp
701WHERE name='Technical Training Course'),'Pdg','','Service','Elec','Photo'),
702((SELECT id from camps_cadet
703WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7042006,(SELECT id from camps_camp
705WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
706((SELECT id from camps_cadet
707WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7082006,(SELECT id FROM camps_camp
709WHERE name='Senior Leaders Course'),'Del','Changed to Survival Instr.','Photo','',''),
710((SELECT id from camps_cadet
711WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7122006,(SELECT id FROM camps_camp
713WHERE name='Senior Leaders Course'),'Sel','','','',''),
714((SELECT id from camps_cadet
715WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7162006,(SELECT id FROM camps_camp
717WHERE name='Senior Leaders Course'),'Sel','','','',''),
718((SELECT id from camps_cadet
719WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7202006,(SELECT id FROM camps_camp
721WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
722((SELECT id from camps_cadet
723WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7242006,(SELECT id FROM camps_camp
725WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - Turkey','','',''),
726((SELECT id from camps_cadet
727WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7282006,(SELECT id FROM camps_camp
729WHERE name='Survival Instructor Course'),'Pdg','','','',''),
730((SELECT id from camps_cadet
731WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7322006,(SELECT id FROM camps_camp
733WHERE name='Senior Leaders Course'),'Sel','','','',''),
734((SELECT id from camps_cadet
735WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7362006,(SELECT id FROM camps_camp
737WHERE name='Survival Instructor Course'),'Sel','','','',''),
738((SELECT id from camps_cadet
739WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7402006,(SELECT id FROM camps_camp
741WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
742((SELECT id from camps_cadet
743WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7442006,(SELECT id FROM camps_camp
745WHERE name='International Air Cadet Exchange'),'Del','Entering RMC','','',''),
746((SELECT id from camps_cadet
747WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7482006,(SELECT id FROM camps_camp
749WHERE name='Technical Training Course'),'Sel','Photography','Photo','',''),
750((SELECT id from camps_cadet
751WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7522006,(SELECT id FROM camps_camp
753WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
754((SELECT id from camps_cadet
755WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7562006,(SELECT id FROM camps_camp
757WHERE name='Senior Leaders Course'),'Pdg','','','',''),
758((SELECT id from camps_cadet
759WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7602006,(SELECT id FROM camps_camp
761WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
762((SELECT id from camps_cadet
763WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7642006,(SELECT id FROM camps_camp
765WHERE name='Air Traffic Control Course'),'Spr','','','',''),
766((SELECT id from camps_cadet
767WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7682006,(SELECT id from camps_camp
769WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
770((SELECT id from camps_cadet
771WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7722006,(SELECT id FROM camps_camp
773WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
774((SELECT id from camps_cadet
775WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7762006,(SELECT id FROM camps_camp
777WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
778((SELECT id from camps_cadet
779WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7802006,(SELECT id from camps_camp
781WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
782((SELECT id from camps_cadet
783WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7842006,(SELECT id FROM camps_camp
785WHERE name='Senior Leaders Course'),'Sel','','','',''),
786((SELECT id from camps_cadet
787WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7882006,(SELECT id FROM camps_camp
789WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
790((SELECT id from camps_cadet
791WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7922006,(SELECT id FROM camps_camp
793WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
794((SELECT id from camps_cadet
795WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
7962006,(SELECT id FROM camps_camp
797WHERE name='Senior Leaders Course'),'Sel','','','',''),
798((SELECT id from camps_cadet
799WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8002006,(SELECT id FROM camps_camp
801WHERE name='Senior Leaders Course'),'Sel','','','',''),
802((SELECT id from camps_cadet
803WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8042006,(SELECT id FROM camps_camp
805WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
806((SELECT id from camps_cadet
807WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8082006,(SELECT id FROM camps_camp
809WHERE name='Senior Leaders Course'),'Pdg','','','',''),
810((SELECT id from camps_cadet
811WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8122006,(SELECT id FROM camps_camp
813WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
814((SELECT id from camps_cadet
815WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8162006,(SELECT id FROM camps_camp
817WHERE name='Survival Instructor Course'),'Pdg','','','',''),
818((SELECT id from camps_cadet
819WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8202006,(SELECT id FROM camps_camp
821WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
822((SELECT id from camps_cadet
823WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8242006,(SELECT id from camps_camp
825WHERE name='Athletic Instructor Course'),'Sel','','','',''),
826((SELECT id from camps_cadet
827WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8282006,(SELECT id FROM camps_camp
829WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
830((SELECT id from camps_cadet
831WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8322006,(SELECT id FROM camps_camp
833WHERE name='Senior Leaders Course'),'Sel','','','',''),
834((SELECT id from camps_cadet
835WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8362006,(SELECT id FROM camps_camp
837WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
838((SELECT id from camps_cadet
839WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8402006,(SELECT id FROM camps_camp
841WHERE name='Survival Instructor Course'),'Sel','','','',''),
842((SELECT id from camps_cadet
843WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8442006,(SELECT id from camps_camp
845WHERE name='Athletic Instructor Course'),'Sel','','','',''),
846((SELECT id from camps_cadet
847WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8482006,(SELECT id FROM camps_camp
849WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
850((SELECT id from camps_cadet
851WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8522006,(SELECT id FROM camps_camp
853WHERE name='Survival Instructor Course'),'Sel','','','',''),
854((SELECT id from camps_cadet
855WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8562006,(SELECT id from camps_camp
857WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
858((SELECT id from camps_cadet
859WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8602006,(SELECT id FROM camps_camp
861WHERE name='International Air Cadet Exchange'),'Del','Withdrew - personal reasons','','',''),
862((SELECT id from camps_cadet
863WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8642006,(SELECT id FROM camps_camp
865WHERE name='Air Traffic Control Course'),'Spr','','','',''),
866((SELECT id from camps_cadet
867WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8682006,(SELECT id FROM camps_camp
869WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
870((SELECT id from camps_cadet
871WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8722006,(SELECT id FROM camps_camp
873WHERE name='Senior Leaders Course'),'Sel','','','',''),
874((SELECT id from camps_cadet
875WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8762006,(SELECT id FROM camps_camp
877WHERE name='Senior Leaders Course'),'Pdg','','','',''),
878((SELECT id from camps_cadet
879WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8802006,(SELECT id FROM camps_camp
881WHERE name='Survival Instructor Course'),'Sel','','','',''),
882((SELECT id from camps_cadet
883WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8842006,(SELECT id from camps_camp
885WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
886((SELECT id from camps_cadet
887WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8882006,(SELECT id FROM camps_camp
889WHERE name='Senior Leaders Course'),'Sel','','','',''),
890((SELECT id from camps_cadet
891WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8922006,(SELECT id FROM camps_camp
893WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
894((SELECT id from camps_cadet
895WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
8962006,(SELECT id FROM camps_camp
897WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
898((SELECT id from camps_cadet
899WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9002006,(SELECT id FROM camps_camp
901WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
902((SELECT id from camps_cadet
903WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9042006,(SELECT id FROM camps_camp
905WHERE name='Survival Instructor Course'),'Sel','','','',''),
906((SELECT id from camps_cadet
907WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9082006,(SELECT id from camps_camp
909WHERE name='Athletic Instructor Course'),'Sel','','','',''),
910((SELECT id from camps_cadet
911WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9122006,(SELECT id from camps_camp
913WHERE name='Athletic Instructor Course'),'SprI','Fitness Test','','',''),
914((SELECT id from camps_cadet
915WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9162006,(SELECT id FROM camps_camp
917WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
918((SELECT id from camps_cadet
919WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9202006,(SELECT id FROM camps_camp
921WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
922((SELECT id from camps_cadet
923WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9242006,(SELECT id from camps_camp
925WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
926((SELECT id from camps_cadet
927WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9282006,(SELECT id from camps_camp
929WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
930((SELECT id from camps_cadet
931WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9322006,(SELECT id FROM camps_camp
933WHERE name='Technical Training Course'),'Sel','Basic Electronics - Waiver approved','Service','',''),
934((SELECT id from camps_cadet
935WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9362006,(SELECT id FROM camps_camp
937WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
938((SELECT id from camps_cadet
939WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9402006,(SELECT id from camps_camp
941WHERE name='Power Pilot Scholarship'),'Del','Withdrew - low exam mark','','',''),
942((SELECT id from camps_cadet
943WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9442006,(SELECT id FROM camps_camp
945WHERE name='Glider Pilot Scholarship'),'SelI','Require Medical Certificate','','',''),
946((SELECT id from camps_cadet
947WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9482006,(SELECT id from camps_camp
949WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
950((SELECT id from camps_cadet
951WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9522006,(SELECT id from camps_camp
953WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
954((SELECT id from camps_cadet
955WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9562006,(SELECT id FROM camps_camp
957WHERE name='Technical Training Course'),'Sel','Basic Electronics - Waiver approved','Service','Elec','Photo'),
958((SELECT id from camps_cadet
959WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9602006,(SELECT id from camps_camp
961WHERE name='Athletic Instructor Course'),'Del','Did not appear for Boards','','',''),
962((SELECT id from camps_cadet
963WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9642006,(SELECT id from camps_camp
965WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
966((SELECT id from camps_cadet
967WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9682006,(SELECT id FROM camps_camp
969WHERE name='Senior Leaders Course'),'Sel','','','',''),
970((SELECT id from camps_cadet
971WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9722006,(SELECT id FROM camps_camp
973WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
974((SELECT id from camps_cadet
975WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9762006,(SELECT id from camps_camp
977WHERE name='Athletic Instructor Course'),'Sel','','','',''),
978((SELECT id from camps_cadet
979WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9802006,(SELECT id FROM camps_camp
981WHERE name='Technical Training Course'),'Pdg','','Service','Photo','Elec'),
982((SELECT id from camps_cadet
983WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9842006,(SELECT id FROM camps_camp
985WHERE name='Survival Instructor Course'),'Sel','','','',''),
986((SELECT id from camps_cadet
987WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9882006,(SELECT id FROM camps_camp
989WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
990((SELECT id from camps_cadet
991WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9922006,(SELECT id FROM camps_camp
993WHERE name='Survival Instructor Course'),'Sel','','','',''),
994((SELECT id from camps_cadet
995WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
9962006,(SELECT id FROM camps_camp
997WHERE name='Senior Leaders Course'),'Sel','','','',''),
998((SELECT id from camps_cadet
999WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10002006,(SELECT id FROM camps_camp
1001WHERE name='Survival Instructor Course'),'Sel','','','',''),
1002((SELECT id from camps_cadet
1003WHERE (surname='Test1''Neill') AND (given_names='Fred') AND (rank='Sgt')),
10042006,(SELECT id FROM camps_camp
1005WHERE name='Survival Instructor Course'),'Sel','','','',''),
1006((SELECT id from camps_cadet
1007WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10082006,(SELECT id FROM camps_camp
1009WHERE name='International Air Cadet Exchange'),'Del','2 waivers requested - trg lvl & rank','','',''),
1010((SELECT id from camps_cadet
1011WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10122006,(SELECT id from camps_camp
1013WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1014((SELECT id from camps_cadet
1015WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10162006,(SELECT id FROM camps_camp
1017WHERE name='Survival Instructor Course'),'Pdg','','','',''),
1018((SELECT id from camps_cadet
1019WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10202006,(SELECT id from camps_camp
1021WHERE name='Athletic Instructor Course'),'Del','No Show for Boards','','',''),
1022((SELECT id from camps_cadet
1023WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10242006,(SELECT id FROM camps_camp
1025WHERE name='Survival Instructor Course'),'Sel','','','',''),
1026((SELECT id from camps_cadet
1027WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10282006,(SELECT id FROM camps_camp
1029WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1030((SELECT id from camps_cadet
1031WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10322006,(SELECT id from camps_camp
1033WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1034((SELECT id from camps_cadet
1035WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10362006,(SELECT id from camps_camp
1037WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1038((SELECT id from camps_cadet
1039WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10402006,(SELECT id FROM camps_camp
1041WHERE name='Survival Instructor Course'),'Sel','','','',''),
1042((SELECT id from camps_cadet
1043WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10442006,(SELECT id FROM camps_camp
1045WHERE name='Survival Instructor Course'),'Sel','','','',''),
1046((SELECT id from camps_cadet
1047WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10482006,(SELECT id FROM camps_camp
1049WHERE name='Senior Leaders Course'),'Sel','','','',''),
1050((SELECT id from camps_cadet
1051WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10522006,(SELECT id FROM camps_camp
1053WHERE name='Senior Leaders Course'),'Sel','','','',''),
1054((SELECT id from camps_cadet
1055WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10562006,(SELECT id from camps_camp
1057WHERE name='Athletic Instructor Course'),'Sel','','','',''),
1058((SELECT id from camps_cadet
1059WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10602006,(SELECT id FROM camps_camp
1061WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
1062((SELECT id from camps_cadet
1063WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10642006,(SELECT id FROM camps_camp
1065WHERE name='Senior Leaders Course'),'Sel','','','',''),
1066((SELECT id from camps_cadet
1067WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10682006,(SELECT id FROM camps_camp
1069WHERE name='Survival Instructor Course'),'Pdg','','','',''),
1070((SELECT id from camps_cadet
1071WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10722006,(SELECT id from camps_camp
1073WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
1074((SELECT id from camps_cadet
1075WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10762006,(SELECT id from camps_camp
1077WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1078((SELECT id from camps_cadet
1079WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10802006,(SELECT id FROM camps_camp
1081WHERE name='Senior Leaders Course'),'Del','Did not appear for Boards','','',''),
1082((SELECT id from camps_cadet
1083WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10842006,(SELECT id FROM camps_camp
1085WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
1086((SELECT id from camps_cadet
1087WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10882006,(SELECT id FROM camps_camp
1089WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
1090((SELECT id from camps_cadet
1091WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10922006,(SELECT id FROM camps_camp
1093WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1094((SELECT id from camps_cadet
1095WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
10962006,(SELECT id FROM camps_camp
1097WHERE name='Survival Instructor Course'),'Sel','','','',''),
1098((SELECT id from camps_cadet
1099WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11002006,(SELECT id FROM camps_camp
1101WHERE name='Senior Leaders Course'),'Sel','','','',''),
1102((SELECT id from camps_cadet
1103WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11042006,(SELECT id FROM camps_camp
1105WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - Singapore','','',''),
1106((SELECT id from camps_cadet
1107WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11082006,(SELECT id from camps_camp
1109WHERE name='Power Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
1110((SELECT id from camps_cadet
1111WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11122006,(SELECT id FROM camps_camp
1113WHERE name='Survival Instructor Course'),'Sel','','','',''),
1114((SELECT id from camps_cadet
1115WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11162006,(SELECT id FROM camps_camp
1117WHERE name='Technical Training Course'),'Sel','Basic Electronics','Elec','Photo','Service'),
1118((SELECT id from camps_cadet
1119WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11202006,(SELECT id FROM camps_camp
1121WHERE name='Survival Instructor Course'),'Sel','','','',''),
1122((SELECT id from camps_cadet
1123WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11242006,(SELECT id FROM camps_camp
1125WHERE name='Survival Instructor Course'),'Sel','','','',''),
1126((SELECT id from camps_cadet
1127WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11282006,(SELECT id FROM camps_camp
1129WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1130((SELECT id from camps_cadet
1131WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11322006,(SELECT id FROM camps_camp
1133WHERE name='Senior Leaders Course'),'Sel','','','',''),
1134((SELECT id from camps_cadet
1135WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11362006,(SELECT id from camps_camp
1137WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1138((SELECT id from camps_cadet
1139WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11402006,(SELECT id FROM camps_camp
1141WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
1142((SELECT id from camps_cadet
1143WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11442006,(SELECT id from camps_camp
1145WHERE name='Athletic Instructor Course'),'Sel','','','',''),
1146((SELECT id from camps_cadet
1147WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11482006,(SELECT id FROM camps_camp
1149WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
1150((SELECT id from camps_cadet
1151WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11522006,(SELECT id FROM camps_camp
1153WHERE name='Senior Leaders Course'),'Pdg','','','',''),
1154((SELECT id from camps_cadet
1155WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11562006,(SELECT id FROM camps_camp
1157WHERE name='Technical Training Course'),'Sel','Basic Electronics','Elec','',''),
1158((SELECT id from camps_cadet
1159WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11602006,(SELECT id from camps_camp
1161WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1162((SELECT id from camps_cadet
1163WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11642006,(SELECT id FROM camps_camp
1165WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
1166((SELECT id from camps_cadet
1167WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11682006,(SELECT id FROM camps_camp
1169WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1170((SELECT id from camps_cadet
1171WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11722006,(SELECT id FROM camps_camp
1173WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1174((SELECT id from camps_cadet
1175WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11762006,(SELECT id FROM camps_camp
1177WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
1178((SELECT id from camps_cadet
1179WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11802006,(SELECT id FROM camps_camp
1181WHERE name='Survival Instructor Course'),'Pdg','','','',''),
1182((SELECT id from camps_cadet
1183WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11842006,(SELECT id FROM camps_camp
1185WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1186((SELECT id from camps_cadet
1187WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11882006,(SELECT id from camps_camp
1189WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1190((SELECT id from camps_cadet
1191WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11922006,(SELECT id FROM camps_camp
1193WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
1194((SELECT id from camps_cadet
1195WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
11962006,(SELECT id FROM camps_camp
1197WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
1198((SELECT id from camps_cadet
1199WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12002006,(SELECT id FROM camps_camp
1201WHERE name='Survival Instructor Course'),'Pdg','','','',''),
1202((SELECT id from camps_cadet
1203WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12042006,(SELECT id from camps_camp
1205WHERE name='Power Pilot Scholarship'),'Del','Did not complete conversion','','',''),
1206((SELECT id from camps_cadet
1207WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12082006,(SELECT id FROM camps_camp
1209WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1210((SELECT id from camps_cadet
1211WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12122006,(SELECT id from camps_camp
1213WHERE name='Athletic Instructor Course'),'Sel','','','',''),
1214((SELECT id from camps_cadet
1215WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12162006,(SELECT id from camps_camp
1217WHERE name='Athletic Instructor Course'),'Sel','','','',''),
1218((SELECT id from camps_cadet
1219WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12202006,(SELECT id FROM camps_camp
1221WHERE name='Survival Instructor Course'),'Pdg','','','',''),
1222((SELECT id from camps_cadet
1223WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12242006,(SELECT id FROM camps_camp
1225WHERE name='Survival Instructor Course'),'Sel','','','',''),
1226((SELECT id from camps_cadet
1227WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12282006,(SELECT id from camps_camp
1229WHERE name='Athletic Instructor Course'),'Sel','','','',''),
1230((SELECT id from camps_cadet
1231WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12322006,(SELECT id FROM camps_camp
1233WHERE name='Survival Instructor Course'),'N/R','Below 50% overall','','',''),
1234((SELECT id from camps_cadet
1235WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12362006,(SELECT id FROM camps_camp
1237WHERE name='Survival Instructor Course'),'Sel','','','',''),
1238((SELECT id from camps_cadet
1239WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12402006,(SELECT id FROM camps_camp
1241WHERE name='Air Traffic Control Course'),'Pdg','','','',''),
1242((SELECT id from camps_cadet
1243WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12442006,(SELECT id from camps_camp
1245WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
1246((SELECT id from camps_cadet
1247WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12482006,(SELECT id FROM camps_camp
1249WHERE name='Senior Leaders Course'),'Sel','changed from ATC','','',''),
1250((SELECT id from camps_cadet
1251WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12522006,(SELECT id FROM camps_camp
1253WHERE name='Senior Leaders Course'),'Sel','','','',''),
1254((SELECT id from camps_cadet
1255WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12562006,(SELECT id FROM camps_camp
1257WHERE name='Technical Training Course'),'Sel','Basic Electronics','Photo','Elec','Service'),
1258((SELECT id from camps_cadet
1259WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12602006,(SELECT id from camps_camp
1261WHERE name='Athletic Instructor Course'),'Spr','','','',''),
1262((SELECT id from camps_cadet
1263WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12642006,(SELECT id from camps_camp
1265WHERE name='Athletic Instructor Course'),'Sel','Fitness Test received','','',''),
1266((SELECT id from camps_cadet
1267WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12682006,(SELECT id FROM camps_camp
1269WHERE name='Senior Leaders Course'),'Sel','','','',''),
1270((SELECT id from camps_cadet
1271WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12722006,(SELECT id from camps_camp
1273WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1274((SELECT id from camps_cadet
1275WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12762006,(SELECT id from camps_camp
1277WHERE name='Athletic Instructor Course'),'Spr','','','',''),
1278((SELECT id from camps_cadet
1279WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12802006,(SELECT id FROM camps_camp
1281WHERE name='Glider Pilot Scholarship'),'Del','Did not appear for Boards','','',''),
1282((SELECT id from camps_cadet
1283WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12842006,(SELECT id FROM camps_camp
1285WHERE name='Survival Instructor Course'),'Pdg','','','',''),
1286((SELECT id from camps_cadet
1287WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12882006,(SELECT id from camps_camp
1289WHERE name='Athletic Instructor Course'),'Del','Left cadet squadron','','',''),
1290((SELECT id from camps_cadet
1291WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12922006,(SELECT id FROM camps_camp
1293WHERE name='Survival Instructor Course'),'Sel','','','',''),
1294((SELECT id from camps_cadet
1295WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
12962006,(SELECT id FROM camps_camp
1297WHERE name='Senior Leaders Course'),'Sel','','','',''),
1298((SELECT id from camps_cadet
1299WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13002006,(SELECT id from camps_camp
1301WHERE name='Athletic Instructor Course'),'Sel','','','',''),
1302((SELECT id from camps_cadet
1303WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13042006,(SELECT id FROM camps_camp
1305WHERE name='Senior Leaders Course'),'Sel','','','',''),
1306((SELECT id from camps_cadet
1307WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13082006,(SELECT id FROM camps_camp
1309WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1310((SELECT id from camps_cadet
1311WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13122006,(SELECT id from camps_camp
1313WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
1314((SELECT id from camps_cadet
1315WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13162006,(SELECT id FROM camps_camp
1317WHERE name='Technical Training Course'),'Del','Withdrew - summer employment','','',''),
1318((SELECT id from camps_cadet
1319WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13202006,(SELECT id FROM camps_camp
1321WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
1322((SELECT id from camps_cadet
1323WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13242006,(SELECT id FROM camps_camp
1325WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
1326((SELECT id from camps_cadet
1327WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13282006,(SELECT id FROM camps_camp
1329WHERE name='Senior Leaders Course'),'Del','Not proper level - changed course','','',''),
1330((SELECT id from camps_cadet
1331WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13322006,(SELECT id from camps_camp
1333WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
1334((SELECT id from camps_cadet
1335WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13362006,(SELECT id FROM camps_camp
1337WHERE name='Senior Leaders Course'),'Sel','','','',''),
1338((SELECT id from camps_cadet
1339WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13402006,(SELECT id FROM camps_camp
1341WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
1342((SELECT id from camps_cadet
1343WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13442006,(SELECT id FROM camps_camp
1345WHERE name='Senior Leaders Course'),'Sel','','','',''),
1346((SELECT id from camps_cadet
1347WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13482006,(SELECT id FROM camps_camp
1349WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
1350((SELECT id from camps_cadet
1351WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13522006,(SELECT id FROM camps_camp
1353WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
1354((SELECT id from camps_cadet
1355WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
13562006,(SELECT id FROM camps_camp
1357WHERE name='Air Traffic Control Course'),'Sel','','','','');
Back to Top