| 1 | 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
|
|---|
| 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 |
|
|---|
| 13 | 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
|
|---|
| 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 |
|
|---|
| 17 | INSERT 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
|
|---|
| 19 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 20 | 2006,(SELECT id FROM camps_camp
|
|---|
| 21 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 22 | ((SELECT id from camps_cadet
|
|---|
| 23 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 24 | 2006,(SELECT id from camps_camp
|
|---|
| 25 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 26 | ((SELECT id from camps_cadet
|
|---|
| 27 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 28 | 2006,(SELECT id FROM camps_camp
|
|---|
| 29 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 30 | ((SELECT id from camps_cadet
|
|---|
| 31 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 32 | 2006,(SELECT id FROM camps_camp
|
|---|
| 33 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 34 | ((SELECT id from camps_cadet
|
|---|
| 35 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 36 | 2006,(SELECT id FROM camps_camp
|
|---|
| 37 | WHERE name='Air Traffic Control Course'),'Sel','','','',''),
|
|---|
| 38 | ((SELECT id from camps_cadet
|
|---|
| 39 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 40 | 2006,(SELECT id from camps_camp
|
|---|
| 41 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 42 | ((SELECT id from camps_cadet
|
|---|
| 43 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 44 | 2006,(SELECT id FROM camps_camp
|
|---|
| 45 | WHERE name='Glider Pilot Scholarship'),'Del','Competing in Australia','','',''),
|
|---|
| 46 | ((SELECT id from camps_cadet
|
|---|
| 47 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 48 | 2006,(SELECT id FROM camps_camp
|
|---|
| 49 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 50 | ((SELECT id from camps_cadet
|
|---|
| 51 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 52 | 2006,(SELECT id FROM camps_camp
|
|---|
| 53 | WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
|
|---|
| 54 | ((SELECT id from camps_cadet
|
|---|
| 55 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 56 | 2006,(SELECT id FROM camps_camp
|
|---|
| 57 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 58 | ((SELECT id from camps_cadet
|
|---|
| 59 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 60 | 2006,(SELECT id FROM camps_camp
|
|---|
| 61 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 62 | ((SELECT id from camps_cadet
|
|---|
| 63 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 64 | 2006,(SELECT id FROM camps_camp
|
|---|
| 65 | WHERE name='Technical Training Course'),'Spr','','Elec','Service','Photo'),
|
|---|
| 66 | ((SELECT id from camps_cadet
|
|---|
| 67 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 68 | 2006,(SELECT id FROM camps_camp
|
|---|
| 69 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 70 | ((SELECT id from camps_cadet
|
|---|
| 71 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 72 | 2006,(SELECT id FROM camps_camp
|
|---|
| 73 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 74 | ((SELECT id from camps_cadet
|
|---|
| 75 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 76 | 2006,(SELECT id FROM camps_camp
|
|---|
| 77 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 78 | ((SELECT id from camps_cadet
|
|---|
| 79 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 80 | 2006,(SELECT id FROM camps_camp
|
|---|
| 81 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 82 | ((SELECT id from camps_cadet
|
|---|
| 83 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 84 | 2006,(SELECT id from camps_camp
|
|---|
| 85 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 86 | ((SELECT id from camps_cadet
|
|---|
| 87 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 88 | 2006,(SELECT id FROM camps_camp
|
|---|
| 89 | WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 90 | ((SELECT id from camps_cadet
|
|---|
| 91 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 92 | 2006,(SELECT id FROM camps_camp
|
|---|
| 93 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 94 | ((SELECT id from camps_cadet
|
|---|
| 95 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 96 | 2006,(SELECT id FROM camps_camp
|
|---|
| 97 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 98 | ((SELECT id from camps_cadet
|
|---|
| 99 | WHERE (surname='Test1') AND (rank='Sgt')),
|
|---|
| 100 | 2006,(SELECT id from camps_camp
|
|---|
| 101 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 102 | ((SELECT id from camps_cadet
|
|---|
| 103 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 104 | 2006,(SELECT id from camps_camp
|
|---|
| 105 | WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 106 | ((SELECT id from camps_cadet
|
|---|
| 107 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 108 | 2006,(SELECT id FROM camps_camp
|
|---|
| 109 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 110 | ((SELECT id from camps_cadet
|
|---|
| 111 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 112 | 2006,(SELECT id from camps_camp
|
|---|
| 113 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 114 | ((SELECT id from camps_cadet
|
|---|
| 115 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 116 | 2006,(SELECT id from camps_camp
|
|---|
| 117 | WHERE name='Athletic Instructor Course'),'Spr','','','',''),
|
|---|
| 118 | ((SELECT id from camps_cadet
|
|---|
| 119 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 120 | 2006,(SELECT id from camps_camp
|
|---|
| 121 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 122 | ((SELECT id from camps_cadet
|
|---|
| 123 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 124 | 2006,(SELECT id FROM camps_camp
|
|---|
| 125 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 126 | ((SELECT id from camps_cadet
|
|---|
| 127 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 128 | 2006,(SELECT id from camps_camp
|
|---|
| 129 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 130 | ((SELECT id from camps_cadet
|
|---|
| 131 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 132 | 2006,(SELECT id FROM camps_camp
|
|---|
| 133 | WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 134 | ((SELECT id from camps_cadet
|
|---|
| 135 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 136 | 2006,(SELECT id FROM camps_camp
|
|---|
| 137 | WHERE name='Air Traffic Control Course'),'Del','Did not show for Boards','','',''),
|
|---|
| 138 | ((SELECT id from camps_cadet
|
|---|
| 139 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 140 | 2006,(SELECT id FROM camps_camp
|
|---|
| 141 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 142 | ((SELECT id from camps_cadet
|
|---|
| 143 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 144 | 2006,(SELECT id FROM camps_camp
|
|---|
| 145 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 146 | ((SELECT id from camps_cadet
|
|---|
| 147 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 148 | 2006,(SELECT id FROM camps_camp
|
|---|
| 149 | WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 150 | ((SELECT id from camps_cadet
|
|---|
| 151 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 152 | 2006,(SELECT id FROM camps_camp
|
|---|
| 153 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 154 | ((SELECT id from camps_cadet
|
|---|
| 155 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 156 | 2006,(SELECT id from camps_camp
|
|---|
| 157 | WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 158 | ((SELECT id from camps_cadet
|
|---|
| 159 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 160 | 2006,(SELECT id from camps_camp
|
|---|
| 161 | WHERE name='Athletic Instructor Course'),'PdgI','Fitness Test','','',''),
|
|---|
| 162 | ((SELECT id from camps_cadet
|
|---|
| 163 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 164 | 2006,(SELECT id FROM camps_camp
|
|---|
| 165 | WHERE name='Technical Training Course'),'Pdg','','Service','',''),
|
|---|
| 166 | ((SELECT id from camps_cadet
|
|---|
| 167 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 168 | 2006,(SELECT id from camps_camp
|
|---|
| 169 | WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 170 | ((SELECT id from camps_cadet
|
|---|
| 171 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 172 | 2006,(SELECT id from camps_camp
|
|---|
| 173 | WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 174 | ((SELECT id from camps_cadet
|
|---|
| 175 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 176 | 2006,(SELECT id FROM camps_camp
|
|---|
| 177 | WHERE name='Technical Training Course'),'N/R','Below 60% overall','Photo','',''),
|
|---|
| 178 | ((SELECT id from camps_cadet
|
|---|
| 179 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 180 | 2006,(SELECT id from camps_camp
|
|---|
| 181 | WHERE name='Athletic Instructor Course'),'Spr','','','',''),
|
|---|
| 182 | ((SELECT id from camps_cadet
|
|---|
| 183 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 184 | 2006,(SELECT id FROM camps_camp
|
|---|
| 185 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 186 | ((SELECT id from camps_cadet
|
|---|
| 187 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 188 | 2006,(SELECT id from camps_camp
|
|---|
| 189 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 190 | ((SELECT id from camps_cadet
|
|---|
| 191 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 192 | 2006,(SELECT id FROM camps_camp
|
|---|
| 193 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 194 | ((SELECT id from camps_cadet
|
|---|
| 195 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 196 | 2006,(SELECT id FROM camps_camp
|
|---|
| 197 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 198 | ((SELECT id from camps_cadet
|
|---|
| 199 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 200 | 2006,(SELECT id FROM camps_camp
|
|---|
| 201 | WHERE name='Technical Training Course'),'Pdg','','Elec','Service','Photo'),
|
|---|
| 202 | ((SELECT id from camps_cadet
|
|---|
| 203 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 204 | 2006,(SELECT id FROM camps_camp
|
|---|
| 205 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 206 | ((SELECT id from camps_cadet
|
|---|
| 207 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 208 | 2006,(SELECT id FROM camps_camp
|
|---|
| 209 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 210 | ((SELECT id from camps_cadet
|
|---|
| 211 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 212 | 2006,(SELECT id FROM camps_camp
|
|---|
| 213 | WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
|
|---|
| 214 | ((SELECT id from camps_cadet
|
|---|
| 215 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 216 | 2006,(SELECT id FROM camps_camp
|
|---|
| 217 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 218 | ((SELECT id from camps_cadet
|
|---|
| 219 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 220 | 2006,(SELECT id FROM camps_camp
|
|---|
| 221 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 222 | ((SELECT id from camps_cadet
|
|---|
| 223 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 224 | 2006,(SELECT id FROM camps_camp
|
|---|
| 225 | WHERE name='Air Traffic Control Course'),'Del','No waiver','','',''),
|
|---|
| 226 | ((SELECT id from camps_cadet
|
|---|
| 227 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 228 | 2006,(SELECT id from camps_camp
|
|---|
| 229 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 230 | ((SELECT id from camps_cadet
|
|---|
| 231 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 232 | 2006,(SELECT id from camps_camp
|
|---|
| 233 | WHERE name='Athletic Instructor Course'),'Sel','Replacement for Veltmeyer','','',''),
|
|---|
| 234 | ((SELECT id from camps_cadet
|
|---|
| 235 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 236 | 2006,(SELECT id FROM camps_camp
|
|---|
| 237 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 238 | ((SELECT id from camps_cadet
|
|---|
| 239 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 240 | 2006,(SELECT id FROM camps_camp
|
|---|
| 241 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 242 | ((SELECT id from camps_cadet
|
|---|
| 243 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 244 | 2006,(SELECT id FROM camps_camp
|
|---|
| 245 | WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 246 | ((SELECT id from camps_cadet
|
|---|
| 247 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 248 | 2006,(SELECT id FROM camps_camp
|
|---|
| 249 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 250 | ((SELECT id from camps_cadet
|
|---|
| 251 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 252 | 2006,(SELECT id FROM camps_camp
|
|---|
| 253 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 254 | ((SELECT id from camps_cadet
|
|---|
| 255 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 256 | 2006,(SELECT id from camps_camp
|
|---|
| 257 | WHERE name='Athletic Instructor Course'),'Spr','','','',''),
|
|---|
| 258 | ((SELECT id from camps_cadet
|
|---|
| 259 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 260 | 2006,(SELECT id from camps_camp
|
|---|
| 261 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 262 | ((SELECT id from camps_cadet
|
|---|
| 263 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 264 | 2006,(SELECT id FROM camps_camp
|
|---|
| 265 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 266 | ((SELECT id from camps_cadet
|
|---|
| 267 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 268 | 2006,(SELECT id FROM camps_camp
|
|---|
| 269 | WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 270 | ((SELECT id from camps_cadet
|
|---|
| 271 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 272 | 2006,(SELECT id from camps_camp
|
|---|
| 273 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 274 | ((SELECT id from camps_cadet
|
|---|
| 275 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 276 | 2006,(SELECT id FROM camps_camp
|
|---|
| 277 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 278 | ((SELECT id from camps_cadet
|
|---|
| 279 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 280 | 2006,(SELECT id FROM camps_camp
|
|---|
| 281 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 282 | ((SELECT id from camps_cadet
|
|---|
| 283 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 284 | 2006,(SELECT id FROM camps_camp
|
|---|
| 285 | WHERE name='Technical Training Course'),'Pdg','Aircraft Servicing','Service','Photo','Elec'),
|
|---|
| 286 | ((SELECT id from camps_cadet
|
|---|
| 287 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 288 | 2006,(SELECT id FROM camps_camp
|
|---|
| 289 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 290 | ((SELECT id from camps_cadet
|
|---|
| 291 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 292 | 2006,(SELECT id FROM camps_camp
|
|---|
| 293 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 294 | ((SELECT id from camps_cadet
|
|---|
| 295 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 296 | 2006,(SELECT id FROM camps_camp
|
|---|
| 297 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 298 | ((SELECT id from camps_cadet
|
|---|
| 299 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 300 | 2006,(SELECT id from camps_camp
|
|---|
| 301 | WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 302 | ((SELECT id from camps_cadet
|
|---|
| 303 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 304 | 2006,(SELECT id from camps_camp
|
|---|
| 305 | WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
|
|---|
| 306 | ((SELECT id from camps_cadet
|
|---|
| 307 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 308 | 2006,(SELECT id FROM camps_camp
|
|---|
| 309 | WHERE name='Glider Pilot Scholarship'),'Del','Below 60% overall','','',''),
|
|---|
| 310 | ((SELECT id from camps_cadet
|
|---|
| 311 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 312 | 2006,(SELECT id FROM camps_camp
|
|---|
| 313 | WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United States','','',''),
|
|---|
| 314 | ((SELECT id from camps_cadet
|
|---|
| 315 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 316 | 2006,(SELECT id from camps_camp
|
|---|
| 317 | WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
|
|---|
| 318 | ((SELECT id from camps_cadet
|
|---|
| 319 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 320 | 2006,(SELECT id FROM camps_camp
|
|---|
| 321 | WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 322 | ((SELECT id from camps_cadet
|
|---|
| 323 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 324 | 2006,(SELECT id FROM camps_camp
|
|---|
| 325 | WHERE name='Glider Pilot Scholarship'),'Pdg','','','',''),
|
|---|
| 326 | ((SELECT id from camps_cadet
|
|---|
| 327 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 328 | 2006,(SELECT id from camps_camp
|
|---|
| 329 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 330 | ((SELECT id from camps_cadet
|
|---|
| 331 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 332 | 2006,(SELECT id FROM camps_camp
|
|---|
| 333 | WHERE name='Technical Training Course'),'Spr','','Service','Elec','Photo'),
|
|---|
| 334 | ((SELECT id from camps_cadet
|
|---|
| 335 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 336 | 2006,(SELECT id FROM camps_camp
|
|---|
| 337 | WHERE name='Senior Leaders Course'),'Del','Not proper level - changed course','','',''),
|
|---|
| 338 | ((SELECT id from camps_cadet
|
|---|
| 339 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 340 | 2006,(SELECT id FROM camps_camp
|
|---|
| 341 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 342 | ((SELECT id from camps_cadet
|
|---|
| 343 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 344 | 2006,(SELECT id FROM camps_camp
|
|---|
| 345 | WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
|
|---|
| 346 | ((SELECT id from camps_cadet
|
|---|
| 347 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 348 | 2006,(SELECT id FROM camps_camp
|
|---|
| 349 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 350 | ((SELECT id from camps_cadet
|
|---|
| 351 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 352 | 2006,(SELECT id FROM camps_camp
|
|---|
| 353 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 354 | ((SELECT id from camps_cadet
|
|---|
| 355 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 356 | 2006,(SELECT id FROM camps_camp
|
|---|
| 357 | WHERE name='Technical Training Course'),'Pdg','','Photo','',''),
|
|---|
| 358 | ((SELECT id from camps_cadet
|
|---|
| 359 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 360 | 2006,(SELECT id FROM camps_camp
|
|---|
| 361 | WHERE name='Senior Leaders Course'),'Del','Withdrew application','','',''),
|
|---|
| 362 | ((SELECT id from camps_cadet
|
|---|
| 363 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 364 | 2006,(SELECT id FROM camps_camp
|
|---|
| 365 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 366 | ((SELECT id from camps_cadet
|
|---|
| 367 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 368 | 2006,(SELECT id FROM camps_camp
|
|---|
| 369 | WHERE name='Senior Leaders Course'),'Del','Not proper level - withdrew','','',''),
|
|---|
| 370 | ((SELECT id from camps_cadet
|
|---|
| 371 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 372 | 2006,(SELECT id FROM camps_camp
|
|---|
| 373 | WHERE name='Glider Pilot Scholarship'),'SelI','Require Medical Certificate','','',''),
|
|---|
| 374 | ((SELECT id from camps_cadet
|
|---|
| 375 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 376 | 2006,(SELECT id FROM camps_camp
|
|---|
| 377 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 378 | ((SELECT id from camps_cadet
|
|---|
| 379 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 380 | 2006,(SELECT id FROM camps_camp
|
|---|
| 381 | WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
|
|---|
| 382 | ((SELECT id from camps_cadet
|
|---|
| 383 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 384 | 2006,(SELECT id FROM camps_camp
|
|---|
| 385 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 386 | ((SELECT id from camps_cadet
|
|---|
| 387 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 388 | 2006,(SELECT id FROM camps_camp
|
|---|
| 389 | WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 390 | ((SELECT id from camps_cadet
|
|---|
| 391 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 392 | 2006,(SELECT id from camps_camp
|
|---|
| 393 | WHERE name='Athletic Instructor Course'),'Spr','','','',''),
|
|---|
| 394 | ((SELECT id from camps_cadet
|
|---|
| 395 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 396 | 2006,(SELECT id FROM camps_camp
|
|---|
| 397 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 398 | ((SELECT id from camps_cadet
|
|---|
| 399 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 400 | 2006,(SELECT id FROM camps_camp
|
|---|
| 401 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 402 | ((SELECT id from camps_cadet
|
|---|
| 403 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 404 | 2006,(SELECT id from camps_camp
|
|---|
| 405 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 406 | ((SELECT id from camps_cadet
|
|---|
| 407 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 408 | 2006,(SELECT id FROM camps_camp
|
|---|
| 409 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 410 | ((SELECT id from camps_cadet
|
|---|
| 411 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 412 | 2006,(SELECT id FROM camps_camp
|
|---|
| 413 | WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 414 | ((SELECT id from camps_cadet
|
|---|
| 415 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 416 | 2006,(SELECT id FROM camps_camp
|
|---|
| 417 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 418 | ((SELECT id from camps_cadet
|
|---|
| 419 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 420 | 2006,(SELECT id FROM camps_camp
|
|---|
| 421 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 422 | ((SELECT id from camps_cadet
|
|---|
| 423 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 424 | 2006,(SELECT id FROM camps_camp
|
|---|
| 425 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 426 | ((SELECT id from camps_cadet
|
|---|
| 427 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 428 | 2006,(SELECT id FROM camps_camp
|
|---|
| 429 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 430 | ((SELECT id from camps_cadet
|
|---|
| 431 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 432 | 2006,(SELECT id FROM camps_camp
|
|---|
| 433 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 434 | ((SELECT id from camps_cadet
|
|---|
| 435 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 436 | 2006,(SELECT id FROM camps_camp
|
|---|
| 437 | WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
|
|---|
| 438 | ((SELECT id from camps_cadet
|
|---|
| 439 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 440 | 2006,(SELECT id from camps_camp
|
|---|
| 441 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 442 | ((SELECT id from camps_cadet
|
|---|
| 443 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 444 | 2006,(SELECT id from camps_camp
|
|---|
| 445 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 446 | ((SELECT id from camps_cadet
|
|---|
| 447 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 448 | 2006,(SELECT id FROM camps_camp
|
|---|
| 449 | WHERE name='Technical Training Course'),'Pdg','','Elec','Service','Photo'),
|
|---|
| 450 | ((SELECT id from camps_cadet
|
|---|
| 451 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 452 | 2006,(SELECT id from camps_camp
|
|---|
| 453 | WHERE name='Athletic Instructor Course'),'Del','Withdrew application','','',''),
|
|---|
| 454 | ((SELECT id from camps_cadet
|
|---|
| 455 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 456 | 2006,(SELECT id from camps_camp
|
|---|
| 457 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 458 | ((SELECT id from camps_cadet
|
|---|
| 459 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 460 | 2006,(SELECT id FROM camps_camp
|
|---|
| 461 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 462 | ((SELECT id from camps_cadet
|
|---|
| 463 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 464 | 2006,(SELECT id FROM camps_camp
|
|---|
| 465 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 466 | ((SELECT id from camps_cadet
|
|---|
| 467 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 468 | 2006,(SELECT id FROM camps_camp
|
|---|
| 469 | WHERE name='Senior Leaders Course'),'Del','declined course','','',''),
|
|---|
| 470 | ((SELECT id from camps_cadet
|
|---|
| 471 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 472 | 2006,(SELECT id from camps_camp
|
|---|
| 473 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 474 | ((SELECT id from camps_cadet
|
|---|
| 475 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 476 | 2006,(SELECT id FROM camps_camp
|
|---|
| 477 | WHERE name='Senior Leaders Course'),'Pdg','','','',''),
|
|---|
| 478 | ((SELECT id from camps_cadet
|
|---|
| 479 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 480 | 2006,(SELECT id FROM camps_camp
|
|---|
| 481 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 482 | ((SELECT id from camps_cadet
|
|---|
| 483 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 484 | 2006,(SELECT id FROM camps_camp
|
|---|
| 485 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 486 | ((SELECT id from camps_cadet
|
|---|
| 487 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 488 | 2006,(SELECT id FROM camps_camp
|
|---|
| 489 | WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
|
|---|
| 490 | ((SELECT id from camps_cadet
|
|---|
| 491 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 492 | 2006,(SELECT id FROM camps_camp
|
|---|
| 493 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 494 | ((SELECT id from camps_cadet
|
|---|
| 495 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 496 | 2006,(SELECT id from camps_camp
|
|---|
| 497 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 498 | ((SELECT id from camps_cadet
|
|---|
| 499 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 500 | 2006,(SELECT id FROM camps_camp
|
|---|
| 501 | WHERE name='Senior Leaders Course'),'Pdg','','','',''),
|
|---|
| 502 | ((SELECT id from camps_cadet
|
|---|
| 503 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 504 | 2006,(SELECT id FROM camps_camp
|
|---|
| 505 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 506 | ((SELECT id from camps_cadet
|
|---|
| 507 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 508 | 2006,(SELECT id FROM camps_camp
|
|---|
| 509 | WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','',''),
|
|---|
| 510 | ((SELECT id from camps_cadet
|
|---|
| 511 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 512 | 2006,(SELECT id FROM camps_camp
|
|---|
| 513 | WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 514 | ((SELECT id from camps_cadet
|
|---|
| 515 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 516 | 2006,(SELECT id from camps_camp
|
|---|
| 517 | WHERE name='Athletic Instructor Course'),'Del','Withdrew application','','',''),
|
|---|
| 518 | ((SELECT id from camps_cadet
|
|---|
| 519 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 520 | 2006,(SELECT id FROM camps_camp
|
|---|
| 521 | WHERE name='Technical Training Course'),'Pdg','','Photo','Service','Elec'),
|
|---|
| 522 | ((SELECT id from camps_cadet
|
|---|
| 523 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 524 | 2006,(SELECT id from camps_camp
|
|---|
| 525 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 526 | ((SELECT id from camps_cadet
|
|---|
| 527 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 528 | 2006,(SELECT id from camps_camp
|
|---|
| 529 | WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 530 | ((SELECT id from camps_cadet
|
|---|
| 531 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 532 | 2006,(SELECT id FROM camps_camp
|
|---|
| 533 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 534 | ((SELECT id from camps_cadet
|
|---|
| 535 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 536 | 2006,(SELECT id from camps_camp
|
|---|
| 537 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 538 | ((SELECT id from camps_cadet
|
|---|
| 539 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 540 | 2006,(SELECT id from camps_camp
|
|---|
| 541 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 542 | ((SELECT id from camps_cadet
|
|---|
| 543 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 544 | 2006,(SELECT id FROM camps_camp
|
|---|
| 545 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 546 | ((SELECT id from camps_cadet
|
|---|
| 547 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 548 | 2006,(SELECT id FROM camps_camp
|
|---|
| 549 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 550 | ((SELECT id from camps_cadet
|
|---|
| 551 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 552 | 2006,(SELECT id FROM camps_camp
|
|---|
| 553 | WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 554 | ((SELECT id from camps_cadet
|
|---|
| 555 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 556 | 2006,(SELECT id from camps_camp
|
|---|
| 557 | WHERE name='Power Pilot Scholarship'),'Sel','Has only Cat 4 Med Cert','','',''),
|
|---|
| 558 | ((SELECT id from camps_cadet
|
|---|
| 559 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 560 | 2006,(SELECT id from camps_camp
|
|---|
| 561 | WHERE name='Power Pilot Scholarship'),'Del','Withdrew - low exam mark','','',''),
|
|---|
| 562 | ((SELECT id from camps_cadet
|
|---|
| 563 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 564 | 2006,(SELECT id FROM camps_camp
|
|---|
| 565 | WHERE name='Survival Instructor Course'),'Spare','','','',''),
|
|---|
| 566 | ((SELECT id from camps_cadet
|
|---|
| 567 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 568 | 2006,(SELECT id from camps_camp
|
|---|
| 569 | WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
|
|---|
| 570 | ((SELECT id from camps_cadet
|
|---|
| 571 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 572 | 2006,(SELECT id FROM camps_camp
|
|---|
| 573 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 574 | ((SELECT id from camps_cadet
|
|---|
| 575 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 576 | 2006,(SELECT id from camps_camp
|
|---|
| 577 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 578 | ((SELECT id from camps_cadet
|
|---|
| 579 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 580 | 2006,(SELECT id FROM camps_camp
|
|---|
| 581 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 582 | ((SELECT id from camps_cadet
|
|---|
| 583 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 584 | 2006,(SELECT id from camps_camp
|
|---|
| 585 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 586 | ((SELECT id from camps_cadet
|
|---|
| 587 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 588 | 2006,(SELECT id FROM camps_camp
|
|---|
| 589 | WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
|
|---|
| 590 | ((SELECT id from camps_cadet
|
|---|
| 591 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 592 | 2006,(SELECT id FROM camps_camp
|
|---|
| 593 | WHERE name='Technical Training Course'),'Spr','','Photo','Service','Elec'),
|
|---|
| 594 | ((SELECT id from camps_cadet
|
|---|
| 595 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 596 | 2006,(SELECT id FROM camps_camp
|
|---|
| 597 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 598 | ((SELECT id from camps_cadet
|
|---|
| 599 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 600 | 2006,(SELECT id FROM camps_camp
|
|---|
| 601 | WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 602 | ((SELECT id from camps_cadet
|
|---|
| 603 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 604 | 2006,(SELECT id FROM camps_camp
|
|---|
| 605 | WHERE name='International Air Cadet Exchange'),'Del','Turns 19 in August 06','','',''),
|
|---|
| 606 | ((SELECT id from camps_cadet
|
|---|
| 607 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 608 | 2006,(SELECT id FROM camps_camp
|
|---|
| 609 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 610 | ((SELECT id from camps_cadet
|
|---|
| 611 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 612 | 2006,(SELECT id from camps_camp
|
|---|
| 613 | WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 614 | ((SELECT id from camps_cadet
|
|---|
| 615 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 616 | 2006,(SELECT id FROM camps_camp
|
|---|
| 617 | WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
|
|---|
| 618 | ((SELECT id from camps_cadet
|
|---|
| 619 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 620 | 2006,(SELECT id from camps_camp
|
|---|
| 621 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 622 | ((SELECT id from camps_cadet
|
|---|
| 623 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 624 | 2006,(SELECT id FROM camps_camp
|
|---|
| 625 | WHERE name='Glider Pilot Scholarship'),'Del','Require Medical Certificate','','',''),
|
|---|
| 626 | ((SELECT id from camps_cadet
|
|---|
| 627 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 628 | 2006,(SELECT id FROM camps_camp
|
|---|
| 629 | WHERE name='Technical Training Course'),'Sel','Photography','Photo','Elec','Service'),
|
|---|
| 630 | ((SELECT id from camps_cadet
|
|---|
| 631 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 632 | 2006,(SELECT id FROM camps_camp
|
|---|
| 633 | WHERE name='Technical Training Course'),'Spr','','Elec','Service','Photo'),
|
|---|
| 634 | ((SELECT id from camps_cadet
|
|---|
| 635 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 636 | 2006,(SELECT id FROM camps_camp
|
|---|
| 637 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 638 | ((SELECT id from camps_cadet
|
|---|
| 639 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 640 | 2006,(SELECT id FROM camps_camp
|
|---|
| 641 | WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
|
|---|
| 642 | ((SELECT id from camps_cadet
|
|---|
| 643 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 644 | 2006,(SELECT id FROM camps_camp
|
|---|
| 645 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 646 | ((SELECT id from camps_cadet
|
|---|
| 647 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 648 | 2006,(SELECT id FROM camps_camp
|
|---|
| 649 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 650 | ((SELECT id from camps_cadet
|
|---|
| 651 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 652 | 2006,(SELECT id FROM camps_camp
|
|---|
| 653 | WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
|
|---|
| 654 | ((SELECT id from camps_cadet
|
|---|
| 655 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 656 | 2006,(SELECT id from camps_camp
|
|---|
| 657 | WHERE name='Power Pilot Scholarship'),'Pdg','','','',''),
|
|---|
| 658 | ((SELECT id from camps_cadet
|
|---|
| 659 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 660 | 2006,(SELECT id from camps_camp
|
|---|
| 661 | WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 662 | ((SELECT id from camps_cadet
|
|---|
| 663 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 664 | 2006,(SELECT id FROM camps_camp
|
|---|
| 665 | WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 666 | ((SELECT id from camps_cadet
|
|---|
| 667 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 668 | 2006,(SELECT id FROM camps_camp
|
|---|
| 669 | WHERE name='Senior Leaders Course'),'Del','Left Cadet Program','','',''),
|
|---|
| 670 | ((SELECT id from camps_cadet
|
|---|
| 671 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 672 | 2006,(SELECT id FROM camps_camp
|
|---|
| 673 | WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
|
|---|
| 674 | ((SELECT id from camps_cadet
|
|---|
| 675 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 676 | 2006,(SELECT id FROM camps_camp
|
|---|
| 677 | WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 678 | ((SELECT id from camps_cadet
|
|---|
| 679 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 680 | 2006,(SELECT id FROM camps_camp
|
|---|
| 681 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 682 | ((SELECT id from camps_cadet
|
|---|
| 683 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 684 | 2006,(SELECT id from camps_camp
|
|---|
| 685 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 686 | ((SELECT id from camps_cadet
|
|---|
| 687 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 688 | 2006,(SELECT id FROM camps_camp
|
|---|
| 689 | WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - United Kingdom','','',''),
|
|---|
| 690 | ((SELECT id from camps_cadet
|
|---|
| 691 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 692 | 2006,(SELECT id FROM camps_camp
|
|---|
| 693 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 694 | ((SELECT id from camps_cadet
|
|---|
| 695 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 696 | 2006,(SELECT id FROM camps_camp
|
|---|
| 697 | WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 698 | ((SELECT id from camps_cadet
|
|---|
| 699 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 700 | 2006,(SELECT id FROM camps_camp
|
|---|
| 701 | WHERE name='Technical Training Course'),'Pdg','','Service','Elec','Photo'),
|
|---|
| 702 | ((SELECT id from camps_cadet
|
|---|
| 703 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 704 | 2006,(SELECT id from camps_camp
|
|---|
| 705 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 706 | ((SELECT id from camps_cadet
|
|---|
| 707 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 708 | 2006,(SELECT id FROM camps_camp
|
|---|
| 709 | WHERE name='Senior Leaders Course'),'Del','Changed to Survival Instr.','Photo','',''),
|
|---|
| 710 | ((SELECT id from camps_cadet
|
|---|
| 711 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 712 | 2006,(SELECT id FROM camps_camp
|
|---|
| 713 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 714 | ((SELECT id from camps_cadet
|
|---|
| 715 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 716 | 2006,(SELECT id FROM camps_camp
|
|---|
| 717 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 718 | ((SELECT id from camps_cadet
|
|---|
| 719 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 720 | 2006,(SELECT id FROM camps_camp
|
|---|
| 721 | WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 722 | ((SELECT id from camps_cadet
|
|---|
| 723 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 724 | 2006,(SELECT id FROM camps_camp
|
|---|
| 725 | WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - Turkey','','',''),
|
|---|
| 726 | ((SELECT id from camps_cadet
|
|---|
| 727 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 728 | 2006,(SELECT id FROM camps_camp
|
|---|
| 729 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 730 | ((SELECT id from camps_cadet
|
|---|
| 731 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 732 | 2006,(SELECT id FROM camps_camp
|
|---|
| 733 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 734 | ((SELECT id from camps_cadet
|
|---|
| 735 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 736 | 2006,(SELECT id FROM camps_camp
|
|---|
| 737 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 738 | ((SELECT id from camps_cadet
|
|---|
| 739 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 740 | 2006,(SELECT id FROM camps_camp
|
|---|
| 741 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 742 | ((SELECT id from camps_cadet
|
|---|
| 743 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 744 | 2006,(SELECT id FROM camps_camp
|
|---|
| 745 | WHERE name='International Air Cadet Exchange'),'Del','Entering RMC','','',''),
|
|---|
| 746 | ((SELECT id from camps_cadet
|
|---|
| 747 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 748 | 2006,(SELECT id FROM camps_camp
|
|---|
| 749 | WHERE name='Technical Training Course'),'Sel','Photography','Photo','',''),
|
|---|
| 750 | ((SELECT id from camps_cadet
|
|---|
| 751 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 752 | 2006,(SELECT id FROM camps_camp
|
|---|
| 753 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 754 | ((SELECT id from camps_cadet
|
|---|
| 755 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 756 | 2006,(SELECT id FROM camps_camp
|
|---|
| 757 | WHERE name='Senior Leaders Course'),'Pdg','','','',''),
|
|---|
| 758 | ((SELECT id from camps_cadet
|
|---|
| 759 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 760 | 2006,(SELECT id FROM camps_camp
|
|---|
| 761 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 762 | ((SELECT id from camps_cadet
|
|---|
| 763 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 764 | 2006,(SELECT id FROM camps_camp
|
|---|
| 765 | WHERE name='Air Traffic Control Course'),'Spr','','','',''),
|
|---|
| 766 | ((SELECT id from camps_cadet
|
|---|
| 767 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 768 | 2006,(SELECT id from camps_camp
|
|---|
| 769 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 770 | ((SELECT id from camps_cadet
|
|---|
| 771 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 772 | 2006,(SELECT id FROM camps_camp
|
|---|
| 773 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 774 | ((SELECT id from camps_cadet
|
|---|
| 775 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 776 | 2006,(SELECT id FROM camps_camp
|
|---|
| 777 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 778 | ((SELECT id from camps_cadet
|
|---|
| 779 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 780 | 2006,(SELECT id from camps_camp
|
|---|
| 781 | WHERE name='Athletic Instructor Course'),'Pdg','','','',''),
|
|---|
| 782 | ((SELECT id from camps_cadet
|
|---|
| 783 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 784 | 2006,(SELECT id FROM camps_camp
|
|---|
| 785 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 786 | ((SELECT id from camps_cadet
|
|---|
| 787 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 788 | 2006,(SELECT id FROM camps_camp
|
|---|
| 789 | WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
|
|---|
| 790 | ((SELECT id from camps_cadet
|
|---|
| 791 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 792 | 2006,(SELECT id FROM camps_camp
|
|---|
| 793 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 794 | ((SELECT id from camps_cadet
|
|---|
| 795 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 796 | 2006,(SELECT id FROM camps_camp
|
|---|
| 797 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 798 | ((SELECT id from camps_cadet
|
|---|
| 799 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 800 | 2006,(SELECT id FROM camps_camp
|
|---|
| 801 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 802 | ((SELECT id from camps_cadet
|
|---|
| 803 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 804 | 2006,(SELECT id FROM camps_camp
|
|---|
| 805 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 806 | ((SELECT id from camps_cadet
|
|---|
| 807 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 808 | 2006,(SELECT id FROM camps_camp
|
|---|
| 809 | WHERE name='Senior Leaders Course'),'Pdg','','','',''),
|
|---|
| 810 | ((SELECT id from camps_cadet
|
|---|
| 811 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 812 | 2006,(SELECT id FROM camps_camp
|
|---|
| 813 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 814 | ((SELECT id from camps_cadet
|
|---|
| 815 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 816 | 2006,(SELECT id FROM camps_camp
|
|---|
| 817 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 818 | ((SELECT id from camps_cadet
|
|---|
| 819 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 820 | 2006,(SELECT id FROM camps_camp
|
|---|
| 821 | WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
|
|---|
| 822 | ((SELECT id from camps_cadet
|
|---|
| 823 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 824 | 2006,(SELECT id from camps_camp
|
|---|
| 825 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 826 | ((SELECT id from camps_cadet
|
|---|
| 827 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 828 | 2006,(SELECT id FROM camps_camp
|
|---|
| 829 | WHERE name='Glider Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 830 | ((SELECT id from camps_cadet
|
|---|
| 831 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 832 | 2006,(SELECT id FROM camps_camp
|
|---|
| 833 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 834 | ((SELECT id from camps_cadet
|
|---|
| 835 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 836 | 2006,(SELECT id FROM camps_camp
|
|---|
| 837 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 838 | ((SELECT id from camps_cadet
|
|---|
| 839 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 840 | 2006,(SELECT id FROM camps_camp
|
|---|
| 841 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 842 | ((SELECT id from camps_cadet
|
|---|
| 843 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 844 | 2006,(SELECT id from camps_camp
|
|---|
| 845 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 846 | ((SELECT id from camps_cadet
|
|---|
| 847 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 848 | 2006,(SELECT id FROM camps_camp
|
|---|
| 849 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 850 | ((SELECT id from camps_cadet
|
|---|
| 851 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 852 | 2006,(SELECT id FROM camps_camp
|
|---|
| 853 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 854 | ((SELECT id from camps_cadet
|
|---|
| 855 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 856 | 2006,(SELECT id from camps_camp
|
|---|
| 857 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 858 | ((SELECT id from camps_cadet
|
|---|
| 859 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 860 | 2006,(SELECT id FROM camps_camp
|
|---|
| 861 | WHERE name='International Air Cadet Exchange'),'Del','Withdrew - personal reasons','','',''),
|
|---|
| 862 | ((SELECT id from camps_cadet
|
|---|
| 863 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 864 | 2006,(SELECT id FROM camps_camp
|
|---|
| 865 | WHERE name='Air Traffic Control Course'),'Spr','','','',''),
|
|---|
| 866 | ((SELECT id from camps_cadet
|
|---|
| 867 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 868 | 2006,(SELECT id FROM camps_camp
|
|---|
| 869 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 870 | ((SELECT id from camps_cadet
|
|---|
| 871 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 872 | 2006,(SELECT id FROM camps_camp
|
|---|
| 873 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 874 | ((SELECT id from camps_cadet
|
|---|
| 875 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 876 | 2006,(SELECT id FROM camps_camp
|
|---|
| 877 | WHERE name='Senior Leaders Course'),'Pdg','','','',''),
|
|---|
| 878 | ((SELECT id from camps_cadet
|
|---|
| 879 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 880 | 2006,(SELECT id FROM camps_camp
|
|---|
| 881 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 882 | ((SELECT id from camps_cadet
|
|---|
| 883 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 884 | 2006,(SELECT id from camps_camp
|
|---|
| 885 | WHERE name='Power Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 886 | ((SELECT id from camps_cadet
|
|---|
| 887 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 888 | 2006,(SELECT id FROM camps_camp
|
|---|
| 889 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 890 | ((SELECT id from camps_cadet
|
|---|
| 891 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 892 | 2006,(SELECT id FROM camps_camp
|
|---|
| 893 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 894 | ((SELECT id from camps_cadet
|
|---|
| 895 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 896 | 2006,(SELECT id FROM camps_camp
|
|---|
| 897 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 898 | ((SELECT id from camps_cadet
|
|---|
| 899 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 900 | 2006,(SELECT id FROM camps_camp
|
|---|
| 901 | WHERE name='International Air Cadet Exchange'),'Spr','','','',''),
|
|---|
| 902 | ((SELECT id from camps_cadet
|
|---|
| 903 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 904 | 2006,(SELECT id FROM camps_camp
|
|---|
| 905 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 906 | ((SELECT id from camps_cadet
|
|---|
| 907 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 908 | 2006,(SELECT id from camps_camp
|
|---|
| 909 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 910 | ((SELECT id from camps_cadet
|
|---|
| 911 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 912 | 2006,(SELECT id from camps_camp
|
|---|
| 913 | WHERE name='Athletic Instructor Course'),'SprI','Fitness Test','','',''),
|
|---|
| 914 | ((SELECT id from camps_cadet
|
|---|
| 915 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 916 | 2006,(SELECT id FROM camps_camp
|
|---|
| 917 | WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
|
|---|
| 918 | ((SELECT id from camps_cadet
|
|---|
| 919 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 920 | 2006,(SELECT id FROM camps_camp
|
|---|
| 921 | WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
|
|---|
| 922 | ((SELECT id from camps_cadet
|
|---|
| 923 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 924 | 2006,(SELECT id from camps_camp
|
|---|
| 925 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 926 | ((SELECT id from camps_cadet
|
|---|
| 927 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 928 | 2006,(SELECT id from camps_camp
|
|---|
| 929 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 930 | ((SELECT id from camps_cadet
|
|---|
| 931 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 932 | 2006,(SELECT id FROM camps_camp
|
|---|
| 933 | WHERE name='Technical Training Course'),'Sel','Basic Electronics - Waiver approved','Service','',''),
|
|---|
| 934 | ((SELECT id from camps_cadet
|
|---|
| 935 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 936 | 2006,(SELECT id FROM camps_camp
|
|---|
| 937 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 938 | ((SELECT id from camps_cadet
|
|---|
| 939 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 940 | 2006,(SELECT id from camps_camp
|
|---|
| 941 | WHERE name='Power Pilot Scholarship'),'Del','Withdrew - low exam mark','','',''),
|
|---|
| 942 | ((SELECT id from camps_cadet
|
|---|
| 943 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 944 | 2006,(SELECT id FROM camps_camp
|
|---|
| 945 | WHERE name='Glider Pilot Scholarship'),'SelI','Require Medical Certificate','','',''),
|
|---|
| 946 | ((SELECT id from camps_cadet
|
|---|
| 947 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 948 | 2006,(SELECT id from camps_camp
|
|---|
| 949 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 950 | ((SELECT id from camps_cadet
|
|---|
| 951 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 952 | 2006,(SELECT id from camps_camp
|
|---|
| 953 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 954 | ((SELECT id from camps_cadet
|
|---|
| 955 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 956 | 2006,(SELECT id FROM camps_camp
|
|---|
| 957 | WHERE name='Technical Training Course'),'Sel','Basic Electronics - Waiver approved','Service','Elec','Photo'),
|
|---|
| 958 | ((SELECT id from camps_cadet
|
|---|
| 959 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 960 | 2006,(SELECT id from camps_camp
|
|---|
| 961 | WHERE name='Athletic Instructor Course'),'Del','Did not appear for Boards','','',''),
|
|---|
| 962 | ((SELECT id from camps_cadet
|
|---|
| 963 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 964 | 2006,(SELECT id from camps_camp
|
|---|
| 965 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 966 | ((SELECT id from camps_cadet
|
|---|
| 967 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 968 | 2006,(SELECT id FROM camps_camp
|
|---|
| 969 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 970 | ((SELECT id from camps_cadet
|
|---|
| 971 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 972 | 2006,(SELECT id FROM camps_camp
|
|---|
| 973 | WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 974 | ((SELECT id from camps_cadet
|
|---|
| 975 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 976 | 2006,(SELECT id from camps_camp
|
|---|
| 977 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 978 | ((SELECT id from camps_cadet
|
|---|
| 979 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 980 | 2006,(SELECT id FROM camps_camp
|
|---|
| 981 | WHERE name='Technical Training Course'),'Pdg','','Service','Photo','Elec'),
|
|---|
| 982 | ((SELECT id from camps_cadet
|
|---|
| 983 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 984 | 2006,(SELECT id FROM camps_camp
|
|---|
| 985 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 986 | ((SELECT id from camps_cadet
|
|---|
| 987 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 988 | 2006,(SELECT id FROM camps_camp
|
|---|
| 989 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 990 | ((SELECT id from camps_cadet
|
|---|
| 991 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 992 | 2006,(SELECT id FROM camps_camp
|
|---|
| 993 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 994 | ((SELECT id from camps_cadet
|
|---|
| 995 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 996 | 2006,(SELECT id FROM camps_camp
|
|---|
| 997 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 998 | ((SELECT id from camps_cadet
|
|---|
| 999 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1000 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1001 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1002 | ((SELECT id from camps_cadet
|
|---|
| 1003 | WHERE (surname='Test1''Neill') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1004 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1005 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1006 | ((SELECT id from camps_cadet
|
|---|
| 1007 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1008 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1009 | WHERE name='International Air Cadet Exchange'),'Del','2 waivers requested - trg lvl & rank','','',''),
|
|---|
| 1010 | ((SELECT id from camps_cadet
|
|---|
| 1011 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1012 | 2006,(SELECT id from camps_camp
|
|---|
| 1013 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1014 | ((SELECT id from camps_cadet
|
|---|
| 1015 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1016 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1017 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 1018 | ((SELECT id from camps_cadet
|
|---|
| 1019 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1020 | 2006,(SELECT id from camps_camp
|
|---|
| 1021 | WHERE name='Athletic Instructor Course'),'Del','No Show for Boards','','',''),
|
|---|
| 1022 | ((SELECT id from camps_cadet
|
|---|
| 1023 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1024 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1025 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1026 | ((SELECT id from camps_cadet
|
|---|
| 1027 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1028 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1029 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1030 | ((SELECT id from camps_cadet
|
|---|
| 1031 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1032 | 2006,(SELECT id from camps_camp
|
|---|
| 1033 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1034 | ((SELECT id from camps_cadet
|
|---|
| 1035 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1036 | 2006,(SELECT id from camps_camp
|
|---|
| 1037 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1038 | ((SELECT id from camps_cadet
|
|---|
| 1039 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1040 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1041 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1042 | ((SELECT id from camps_cadet
|
|---|
| 1043 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1044 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1045 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1046 | ((SELECT id from camps_cadet
|
|---|
| 1047 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1048 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1049 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1050 | ((SELECT id from camps_cadet
|
|---|
| 1051 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1052 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1053 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1054 | ((SELECT id from camps_cadet
|
|---|
| 1055 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1056 | 2006,(SELECT id from camps_camp
|
|---|
| 1057 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 1058 | ((SELECT id from camps_cadet
|
|---|
| 1059 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1060 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1061 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1062 | ((SELECT id from camps_cadet
|
|---|
| 1063 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1064 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1065 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1066 | ((SELECT id from camps_cadet
|
|---|
| 1067 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1068 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1069 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 1070 | ((SELECT id from camps_cadet
|
|---|
| 1071 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1072 | 2006,(SELECT id from camps_camp
|
|---|
| 1073 | WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 1074 | ((SELECT id from camps_cadet
|
|---|
| 1075 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1076 | 2006,(SELECT id from camps_camp
|
|---|
| 1077 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1078 | ((SELECT id from camps_cadet
|
|---|
| 1079 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1080 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1081 | WHERE name='Senior Leaders Course'),'Del','Did not appear for Boards','','',''),
|
|---|
| 1082 | ((SELECT id from camps_cadet
|
|---|
| 1083 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1084 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1085 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 1086 | ((SELECT id from camps_cadet
|
|---|
| 1087 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1088 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1089 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 1090 | ((SELECT id from camps_cadet
|
|---|
| 1091 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1092 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1093 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1094 | ((SELECT id from camps_cadet
|
|---|
| 1095 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1096 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1097 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1098 | ((SELECT id from camps_cadet
|
|---|
| 1099 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1100 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1101 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1102 | ((SELECT id from camps_cadet
|
|---|
| 1103 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1104 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1105 | WHERE name='International Air Cadet Exchange'),'Sel','Destination Country - Singapore','','',''),
|
|---|
| 1106 | ((SELECT id from camps_cadet
|
|---|
| 1107 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1108 | 2006,(SELECT id from camps_camp
|
|---|
| 1109 | WHERE name='Power Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 1110 | ((SELECT id from camps_cadet
|
|---|
| 1111 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1112 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1113 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1114 | ((SELECT id from camps_cadet
|
|---|
| 1115 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1116 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1117 | WHERE name='Technical Training Course'),'Sel','Basic Electronics','Elec','Photo','Service'),
|
|---|
| 1118 | ((SELECT id from camps_cadet
|
|---|
| 1119 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1120 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1121 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1122 | ((SELECT id from camps_cadet
|
|---|
| 1123 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1124 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1125 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1126 | ((SELECT id from camps_cadet
|
|---|
| 1127 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1128 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1129 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1130 | ((SELECT id from camps_cadet
|
|---|
| 1131 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1132 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1133 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1134 | ((SELECT id from camps_cadet
|
|---|
| 1135 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1136 | 2006,(SELECT id from camps_camp
|
|---|
| 1137 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1138 | ((SELECT id from camps_cadet
|
|---|
| 1139 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1140 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1141 | WHERE name='Glider Pilot Scholarship'),'Spr','Require Medical Certificate','','',''),
|
|---|
| 1142 | ((SELECT id from camps_cadet
|
|---|
| 1143 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1144 | 2006,(SELECT id from camps_camp
|
|---|
| 1145 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 1146 | ((SELECT id from camps_cadet
|
|---|
| 1147 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1148 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1149 | WHERE name='Glider Pilot Scholarship'),'Pdg','Require Medical Certificate','','',''),
|
|---|
| 1150 | ((SELECT id from camps_cadet
|
|---|
| 1151 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1152 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1153 | WHERE name='Senior Leaders Course'),'Pdg','','','',''),
|
|---|
| 1154 | ((SELECT id from camps_cadet
|
|---|
| 1155 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1156 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1157 | WHERE name='Technical Training Course'),'Sel','Basic Electronics','Elec','',''),
|
|---|
| 1158 | ((SELECT id from camps_cadet
|
|---|
| 1159 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1160 | 2006,(SELECT id from camps_camp
|
|---|
| 1161 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1162 | ((SELECT id from camps_cadet
|
|---|
| 1163 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1164 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1165 | WHERE name='Survival Instructor Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 1166 | ((SELECT id from camps_cadet
|
|---|
| 1167 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1168 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1169 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1170 | ((SELECT id from camps_cadet
|
|---|
| 1171 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1172 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1173 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1174 | ((SELECT id from camps_cadet
|
|---|
| 1175 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1176 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1177 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 1178 | ((SELECT id from camps_cadet
|
|---|
| 1179 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1180 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1181 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 1182 | ((SELECT id from camps_cadet
|
|---|
| 1183 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1184 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1185 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1186 | ((SELECT id from camps_cadet
|
|---|
| 1187 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1188 | 2006,(SELECT id from camps_camp
|
|---|
| 1189 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1190 | ((SELECT id from camps_cadet
|
|---|
| 1191 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1192 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1193 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 1194 | ((SELECT id from camps_cadet
|
|---|
| 1195 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1196 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1197 | WHERE name='Glider Pilot Scholarship'),'Sel','Require Medical Certificate','','',''),
|
|---|
| 1198 | ((SELECT id from camps_cadet
|
|---|
| 1199 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1200 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1201 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 1202 | ((SELECT id from camps_cadet
|
|---|
| 1203 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1204 | 2006,(SELECT id from camps_camp
|
|---|
| 1205 | WHERE name='Power Pilot Scholarship'),'Del','Did not complete conversion','','',''),
|
|---|
| 1206 | ((SELECT id from camps_cadet
|
|---|
| 1207 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1208 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1209 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1210 | ((SELECT id from camps_cadet
|
|---|
| 1211 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1212 | 2006,(SELECT id from camps_camp
|
|---|
| 1213 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 1214 | ((SELECT id from camps_cadet
|
|---|
| 1215 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1216 | 2006,(SELECT id from camps_camp
|
|---|
| 1217 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 1218 | ((SELECT id from camps_cadet
|
|---|
| 1219 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1220 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1221 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 1222 | ((SELECT id from camps_cadet
|
|---|
| 1223 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1224 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1225 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1226 | ((SELECT id from camps_cadet
|
|---|
| 1227 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1228 | 2006,(SELECT id from camps_camp
|
|---|
| 1229 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 1230 | ((SELECT id from camps_cadet
|
|---|
| 1231 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1232 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1233 | WHERE name='Survival Instructor Course'),'N/R','Below 50% overall','','',''),
|
|---|
| 1234 | ((SELECT id from camps_cadet
|
|---|
| 1235 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1236 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1237 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1238 | ((SELECT id from camps_cadet
|
|---|
| 1239 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1240 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1241 | WHERE name='Air Traffic Control Course'),'Pdg','','','',''),
|
|---|
| 1242 | ((SELECT id from camps_cadet
|
|---|
| 1243 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1244 | 2006,(SELECT id from camps_camp
|
|---|
| 1245 | WHERE name='Power Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1246 | ((SELECT id from camps_cadet
|
|---|
| 1247 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1248 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1249 | WHERE name='Senior Leaders Course'),'Sel','changed from ATC','','',''),
|
|---|
| 1250 | ((SELECT id from camps_cadet
|
|---|
| 1251 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1252 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1253 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1254 | ((SELECT id from camps_cadet
|
|---|
| 1255 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1256 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1257 | WHERE name='Technical Training Course'),'Sel','Basic Electronics','Photo','Elec','Service'),
|
|---|
| 1258 | ((SELECT id from camps_cadet
|
|---|
| 1259 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1260 | 2006,(SELECT id from camps_camp
|
|---|
| 1261 | WHERE name='Athletic Instructor Course'),'Spr','','','',''),
|
|---|
| 1262 | ((SELECT id from camps_cadet
|
|---|
| 1263 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1264 | 2006,(SELECT id from camps_camp
|
|---|
| 1265 | WHERE name='Athletic Instructor Course'),'Sel','Fitness Test received','','',''),
|
|---|
| 1266 | ((SELECT id from camps_cadet
|
|---|
| 1267 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1268 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1269 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1270 | ((SELECT id from camps_cadet
|
|---|
| 1271 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1272 | 2006,(SELECT id from camps_camp
|
|---|
| 1273 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1274 | ((SELECT id from camps_cadet
|
|---|
| 1275 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1276 | 2006,(SELECT id from camps_camp
|
|---|
| 1277 | WHERE name='Athletic Instructor Course'),'Spr','','','',''),
|
|---|
| 1278 | ((SELECT id from camps_cadet
|
|---|
| 1279 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1280 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1281 | WHERE name='Glider Pilot Scholarship'),'Del','Did not appear for Boards','','',''),
|
|---|
| 1282 | ((SELECT id from camps_cadet
|
|---|
| 1283 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1284 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1285 | WHERE name='Survival Instructor Course'),'Pdg','','','',''),
|
|---|
| 1286 | ((SELECT id from camps_cadet
|
|---|
| 1287 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1288 | 2006,(SELECT id from camps_camp
|
|---|
| 1289 | WHERE name='Athletic Instructor Course'),'Del','Left cadet squadron','','',''),
|
|---|
| 1290 | ((SELECT id from camps_cadet
|
|---|
| 1291 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1292 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1293 | WHERE name='Survival Instructor Course'),'Sel','','','',''),
|
|---|
| 1294 | ((SELECT id from camps_cadet
|
|---|
| 1295 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1296 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1297 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1298 | ((SELECT id from camps_cadet
|
|---|
| 1299 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1300 | 2006,(SELECT id from camps_camp
|
|---|
| 1301 | WHERE name='Athletic Instructor Course'),'Sel','','','',''),
|
|---|
| 1302 | ((SELECT id from camps_cadet
|
|---|
| 1303 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1304 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1305 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1306 | ((SELECT id from camps_cadet
|
|---|
| 1307 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1308 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1309 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1310 | ((SELECT id from camps_cadet
|
|---|
| 1311 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1312 | 2006,(SELECT id from camps_camp
|
|---|
| 1313 | WHERE name='Power Pilot Scholarship'),'Spr','','','',''),
|
|---|
| 1314 | ((SELECT id from camps_cadet
|
|---|
| 1315 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1316 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1317 | WHERE name='Technical Training Course'),'Del','Withdrew - summer employment','','',''),
|
|---|
| 1318 | ((SELECT id from camps_cadet
|
|---|
| 1319 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1320 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1321 | WHERE name='Glider Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1322 | ((SELECT id from camps_cadet
|
|---|
| 1323 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1324 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1325 | WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 1326 | ((SELECT id from camps_cadet
|
|---|
| 1327 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1328 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1329 | WHERE name='Senior Leaders Course'),'Del','Not proper level - changed course','','',''),
|
|---|
| 1330 | ((SELECT id from camps_cadet
|
|---|
| 1331 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1332 | 2006,(SELECT id from camps_camp
|
|---|
| 1333 | WHERE name='Power Pilot Scholarship'),'Sel','','','',''),
|
|---|
| 1334 | ((SELECT id from camps_cadet
|
|---|
| 1335 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1336 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1337 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1338 | ((SELECT id from camps_cadet
|
|---|
| 1339 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1340 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1341 | WHERE name='Senior Leaders Course'),'N/R','Below 60% overall','','',''),
|
|---|
| 1342 | ((SELECT id from camps_cadet
|
|---|
| 1343 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1344 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1345 | WHERE name='Senior Leaders Course'),'Sel','','','',''),
|
|---|
| 1346 | ((SELECT id from camps_cadet
|
|---|
| 1347 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1348 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1349 | WHERE name='Technical Training Course'),'Sel','Aircraft Servicing','Service','Elec','Photo'),
|
|---|
| 1350 | ((SELECT id from camps_cadet
|
|---|
| 1351 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1352 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1353 | WHERE name='Glider Pilot Scholarship'),'Del','Mark too low','','',''),
|
|---|
| 1354 | ((SELECT id from camps_cadet
|
|---|
| 1355 | WHERE (surname='Test1') AND (given_names='Fred') AND (rank='Sgt')),
|
|---|
| 1356 | 2006,(SELECT id FROM camps_camp
|
|---|
| 1357 | WHERE name='Air Traffic Control Course'),'Sel','','','','');
|
|---|