1 -- WARNING: Do not modify this script. Make a new one instead.
4 UPDATE profiles
SET ax_id
= 20100029 WHERE pid
= 43956;
5 UPDATE profiles
SET ax_id
= 20100030 WHERE pid
= 43959;
6 UPDATE profiles
SET ax_id
= 20100031 WHERE pid
= 44079;
7 UPDATE profiles
SET ax_id
= 20100032 WHERE pid
= 43961;
8 UPDATE profiles
SET ax_id
= 20100033 WHERE pid
= 43964;
9 UPDATE profiles
SET ax_id
= 20100034 WHERE pid
= 43965;
10 UPDATE profiles
SET ax_id
= 20100035 WHERE pid
= 43966;
11 UPDATE profiles
SET ax_id
= 20100037 WHERE pid
= 43968;
12 UPDATE profiles
SET ax_id
= 20100038 WHERE pid
= 43969;
13 UPDATE profiles
SET ax_id
= 20100039 WHERE pid
= 43970;
14 UPDATE profiles
SET ax_id
= 20100040 WHERE pid
= 43971;
15 UPDATE profiles
SET ax_id
= 20100041 WHERE pid
= 43972;
16 UPDATE profiles
SET ax_id
= 20100042 WHERE pid
= 43973;
17 UPDATE profiles
SET ax_id
= 20100043 WHERE pid
= 43974;
18 UPDATE profiles
SET ax_id
= 20100044 WHERE pid
= 43976;
19 UPDATE profiles
SET ax_id
= 20100045 WHERE pid
= 43977;
20 UPDATE profiles
SET ax_id
= 20100046 WHERE pid
= 43978;
21 UPDATE profiles
SET ax_id
= 20100047 WHERE pid
= 43979;
22 UPDATE profiles
SET ax_id
= 20100048 WHERE pid
= 43980;
23 UPDATE profiles
SET ax_id
= 20100049 WHERE pid
= 43981;
24 UPDATE profiles
SET ax_id
= 20100050 WHERE pid
= 43983;
25 UPDATE profiles
SET ax_id
= 20100051 WHERE pid
= 43984;
26 UPDATE profiles
SET ax_id
= 20100052 WHERE pid
= 43985;
27 UPDATE profiles
SET ax_id
= 20100053 WHERE pid
= 43986;
28 UPDATE profiles
SET ax_id
= 20100054 WHERE pid
= 43987;
29 UPDATE profiles
SET ax_id
= 20100055 WHERE pid
= 43988;
30 UPDATE profiles
SET ax_id
= 20100056 WHERE pid
= 43989;
31 UPDATE profiles
SET ax_id
= 20100057 WHERE pid
= 43990;
32 UPDATE profiles
SET ax_id
= 20100058 WHERE pid
= 43991;
33 UPDATE profiles
SET ax_id
= 20100059 WHERE pid
= 43993;
34 UPDATE profiles
SET ax_id
= 20100060 WHERE pid
= 43994;
35 UPDATE profiles
SET ax_id
= 20100061 WHERE pid
= 43997;
36 UPDATE profiles
SET ax_id
= 20100062 WHERE pid
= 43998;
37 UPDATE profiles
SET ax_id
= 20100063 WHERE pid
= 43999;
38 UPDATE profiles
SET ax_id
= 20100064 WHERE pid
= 44000;
39 UPDATE profiles
SET ax_id
= 20100065 WHERE pid
= 44002;
40 UPDATE profiles
SET ax_id
= 20100066 WHERE pid
= 44003;
41 UPDATE profiles
SET ax_id
= 20100067 WHERE pid
= 44004;
42 UPDATE profiles
SET ax_id
= 20100068 WHERE pid
= 44005;
43 UPDATE profiles
SET ax_id
= 20100069 WHERE pid
= 44006;
44 UPDATE profiles
SET ax_id
= 20100070 WHERE pid
= 44010;
45 UPDATE profiles
SET ax_id
= 20100071 WHERE pid
= 44011;
46 UPDATE profiles
SET ax_id
= 20100072 WHERE pid
= 44012;
47 UPDATE profiles
SET ax_id
= 20100073 WHERE pid
= 44013;
48 UPDATE profiles
SET ax_id
= 20100074 WHERE pid
= 44014;
49 UPDATE profiles
SET ax_id
= 20100075 WHERE pid
= 44015;
50 UPDATE profiles
SET ax_id
= 20100076 WHERE pid
= 44016;
51 UPDATE profiles
SET ax_id
= 20100077 WHERE pid
= 44017;
52 UPDATE profiles
SET ax_id
= 20100078 WHERE pid
= 44018;
53 UPDATE profiles
SET ax_id
= 20100079 WHERE pid
= 44019;
54 UPDATE profiles
SET ax_id
= 20100080 WHERE pid
= 44021;
55 UPDATE profiles
SET ax_id
= 20100081 WHERE pid
= 44022;
56 UPDATE profiles
SET ax_id
= 20100082 WHERE pid
= 44023;
57 UPDATE profiles
SET ax_id
= 20100083 WHERE pid
= 44024;
58 UPDATE profiles
SET ax_id
= 20100084 WHERE pid
= 44025;
59 UPDATE profiles
SET ax_id
= 20100085 WHERE pid
= 44026;
60 UPDATE profiles
SET ax_id
= 20100086 WHERE pid
= 44028;
61 UPDATE profiles
SET ax_id
= 20100087 WHERE pid
= 44029;
62 UPDATE profiles
SET ax_id
= 20100088 WHERE pid
= 44030;
63 UPDATE profiles
SET ax_id
= 20100089 WHERE pid
= 44031;
64 UPDATE profiles
SET ax_id
= 20100090 WHERE pid
= 44032;
65 UPDATE profiles
SET ax_id
= 20100091 WHERE pid
= 44033;
66 UPDATE profiles
SET ax_id
= 20100092 WHERE pid
= 44034;
67 UPDATE profiles
SET ax_id
= 20100093 WHERE pid
= 44035;
68 UPDATE profiles
SET ax_id
= 20100094 WHERE pid
= 44036;
69 UPDATE profiles
SET ax_id
= 20100095 WHERE pid
= 44037;
70 UPDATE profiles
SET ax_id
= 20100096 WHERE pid
= 44038;
71 UPDATE profiles
SET ax_id
= 20100097 WHERE pid
= 44040;
72 UPDATE profiles
SET ax_id
= 20100098 WHERE pid
= 44042;
73 UPDATE profiles
SET ax_id
= 20100099 WHERE pid
= 44043;
74 UPDATE profiles
SET ax_id
= 20100100 WHERE pid
= 44044;
75 UPDATE profiles
SET ax_id
= 20100101 WHERE pid
= 44045;
76 UPDATE profiles
SET ax_id
= 20100102 WHERE pid
= 44046;
77 UPDATE profiles
SET ax_id
= 20100103 WHERE pid
= 44047;
78 UPDATE profiles
SET ax_id
= 20100104 WHERE pid
= 44048;
79 UPDATE profiles
SET ax_id
= 20100105 WHERE pid
= 44049;
80 UPDATE profiles
SET ax_id
= 20100106 WHERE pid
= 44050;
81 UPDATE profiles
SET ax_id
= 20100107 WHERE pid
= 44051;
82 UPDATE profiles
SET ax_id
= 20100108 WHERE pid
= 44053;
83 UPDATE profiles
SET ax_id
= 20100109 WHERE pid
= 44054;
84 UPDATE profiles
SET ax_id
= 20100110 WHERE pid
= 44055;
85 UPDATE profiles
SET ax_id
= 20100111 WHERE pid
= 44056;
86 UPDATE profiles
SET ax_id
= 20100112 WHERE pid
= 44057;
87 UPDATE profiles
SET ax_id
= 20100113 WHERE pid
= 44058;
88 UPDATE profiles
SET ax_id
= 20100114 WHERE pid
= 44060;
89 UPDATE profiles
SET ax_id
= 20100115 WHERE pid
= 44062;
90 UPDATE profiles
SET ax_id
= 20100116 WHERE pid
= 44063;
91 UPDATE profiles
SET ax_id
= 20100117 WHERE pid
= 44064;
92 UPDATE profiles
SET ax_id
= 20100118 WHERE pid
= 44065;
93 UPDATE profiles
SET ax_id
= 20100119 WHERE pid
= 44087;
94 UPDATE profiles
SET ax_id
= 20100120 WHERE pid
= 44066;
95 UPDATE profiles
SET ax_id
= 20100121 WHERE pid
= 44067;
96 UPDATE profiles
SET ax_id
= 20100122 WHERE pid
= 44068;
97 UPDATE profiles
SET ax_id
= 20100123 WHERE pid
= 44069;
98 UPDATE profiles
SET ax_id
= 20100124 WHERE pid
= 44070;
99 UPDATE profiles
SET ax_id
= 20100125 WHERE pid
= 44071;
100 UPDATE profiles
SET ax_id
= 20100126 WHERE pid
= 44072;
101 UPDATE profiles
SET ax_id
= 20100127 WHERE pid
= 44073;
102 UPDATE profiles
SET ax_id
= 20100128 WHERE pid
= 44074;
103 UPDATE profiles
SET ax_id
= 20100129 WHERE pid
= 44075;
104 UPDATE profiles
SET ax_id
= 20100130 WHERE pid
= 44076;
105 UPDATE profiles
SET ax_id
= 20100131 WHERE pid
= 44077;
106 UPDATE profiles
SET ax_id
= 20100132 WHERE pid
= 44078;
107 UPDATE profiles
SET ax_id
= 20100133 WHERE pid
= 44080;
108 UPDATE profiles
SET ax_id
= 20100134 WHERE pid
= 44082;
109 UPDATE profiles
SET ax_id
= 20100135 WHERE pid
= 44083;
110 UPDATE profiles
SET ax_id
= 20100136 WHERE pid
= 44084;
111 UPDATE profiles
SET ax_id
= 20100137 WHERE pid
= 44085;
112 UPDATE profiles
SET ax_id
= 20100138 WHERE pid
= 44086;
113 UPDATE profiles
SET ax_id
= 20100139 WHERE pid
= 44094;
114 UPDATE profiles
SET ax_id
= 20100140 WHERE pid
= 44095;
115 UPDATE profiles
SET ax_id
= 20100141 WHERE pid
= 44096;
116 UPDATE profiles
SET ax_id
= 20100142 WHERE pid
= 44097;
117 UPDATE profiles
SET ax_id
= 20100143 WHERE pid
= 44098;
118 UPDATE profiles
SET ax_id
= 20100144 WHERE pid
= 44099;
119 UPDATE profiles
SET ax_id
= 20100145 WHERE pid
= 44100;
120 UPDATE profiles
SET ax_id
= 20100146 WHERE pid
= 44101;
121 UPDATE profiles
SET ax_id
= 20100147 WHERE pid
= 44102;
122 UPDATE profiles
SET ax_id
= 20100148 WHERE pid
= 44103;
123 UPDATE profiles
SET ax_id
= 20100149 WHERE pid
= 44105;
124 UPDATE profiles
SET ax_id
= 20100150 WHERE pid
= 44106;
125 UPDATE profiles
SET ax_id
= 20100151 WHERE pid
= 44107;
126 UPDATE profiles
SET ax_id
= 20100152 WHERE pid
= 44108;
127 UPDATE profiles
SET ax_id
= 20100153 WHERE pid
= 44109;
128 UPDATE profiles
SET ax_id
= 20100154 WHERE pid
= 44110;
129 UPDATE profiles
SET ax_id
= 20100155 WHERE pid
= 44111;
130 UPDATE profiles
SET ax_id
= 20100156 WHERE pid
= 44112;
131 UPDATE profiles
SET ax_id
= 20100157 WHERE pid
= 44113;
132 UPDATE profiles
SET ax_id
= 20100158 WHERE pid
= 44114;
133 UPDATE profiles
SET ax_id
= 20100159 WHERE pid
= 44115;
134 UPDATE profiles
SET ax_id
= 20100160 WHERE pid
= 44116;
135 UPDATE profiles
SET ax_id
= 20100161 WHERE pid
= 44117;
136 UPDATE profiles
SET ax_id
= 20100162 WHERE pid
= 44118;
137 UPDATE profiles
SET ax_id
= 20100163 WHERE pid
= 44119;
138 UPDATE profiles
SET ax_id
= 20100164 WHERE pid
= 44120;
139 UPDATE profiles
SET ax_id
= 20100165 WHERE pid
= 44122;
140 UPDATE profiles
SET ax_id
= 20100166 WHERE pid
= 44123;
141 UPDATE profiles
SET ax_id
= 20100167 WHERE pid
= 44125;
142 UPDATE profiles
SET ax_id
= 20100168 WHERE pid
= 44127;
143 UPDATE profiles
SET ax_id
= 20100169 WHERE pid
= 44126;
144 UPDATE profiles
SET ax_id
= 20100170 WHERE pid
= 44128;
145 UPDATE profiles
SET ax_id
= 20100171 WHERE pid
= 44129;
146 UPDATE profiles
SET ax_id
= 20100172 WHERE pid
= 44130;
147 UPDATE profiles
SET ax_id
= 20100173 WHERE pid
= 44131;
148 UPDATE profiles
SET ax_id
= 20100174 WHERE pid
= 44132;
149 UPDATE profiles
SET ax_id
= 20100175 WHERE pid
= 44133;
150 UPDATE profiles
SET ax_id
= 20100176 WHERE pid
= 44134;
151 UPDATE profiles
SET ax_id
= 20100177 WHERE pid
= 44135;
152 UPDATE profiles
SET ax_id
= 20100178 WHERE pid
= 44136;
153 UPDATE profiles
SET ax_id
= 20100179 WHERE pid
= 44137;
154 UPDATE profiles
SET ax_id
= 20100180 WHERE pid
= 44138;
155 UPDATE profiles
SET ax_id
= 20100181 WHERE pid
= 44140;
156 UPDATE profiles
SET ax_id
= 20100182 WHERE pid
= 44141;
157 UPDATE profiles
SET ax_id
= 20100183 WHERE pid
= 44142;
158 UPDATE profiles
SET ax_id
= 20100184 WHERE pid
= 44143;
159 UPDATE profiles
SET ax_id
= 20100185 WHERE pid
= 44144;
160 UPDATE profiles
SET ax_id
= 20100186 WHERE pid
= 44145;
161 UPDATE profiles
SET ax_id
= 20100187 WHERE pid
= 44146;
162 UPDATE profiles
SET ax_id
= 20100188 WHERE pid
= 44147;
163 UPDATE profiles
SET ax_id
= 20100189 WHERE pid
= 44148;
164 UPDATE profiles
SET ax_id
= 20100190 WHERE pid
= 44149;
165 UPDATE profiles
SET ax_id
= 20100191 WHERE pid
= 44150;
166 UPDATE profiles
SET ax_id
= 20100192 WHERE pid
= 44151;
167 UPDATE profiles
SET ax_id
= 20100193 WHERE pid
= 44152;
168 UPDATE profiles
SET ax_id
= 20100194 WHERE pid
= 44153;
169 UPDATE profiles
SET ax_id
= 20100195 WHERE pid
= 44154;
170 UPDATE profiles
SET ax_id
= 20100196 WHERE pid
= 44155;
171 UPDATE profiles
SET ax_id
= 20100197 WHERE pid
= 44156;
172 UPDATE profiles
SET ax_id
= 20100198 WHERE pid
= 44157;
173 UPDATE profiles
SET ax_id
= 20100199 WHERE pid
= 44158;
174 UPDATE profiles
SET ax_id
= 20100200 WHERE pid
= 44159;
175 UPDATE profiles
SET ax_id
= 20100201 WHERE pid
= 44160;
176 UPDATE profiles
SET ax_id
= 20100202 WHERE pid
= 44161;
177 UPDATE profiles
SET ax_id
= 20100203 WHERE pid
= 44162;
178 UPDATE profiles
SET ax_id
= 20100204 WHERE pid
= 44164;
179 UPDATE profiles
SET ax_id
= 20100205 WHERE pid
= 44166;
180 UPDATE profiles
SET ax_id
= 20100206 WHERE pid
= 44167;
181 UPDATE profiles
SET ax_id
= 20100207 WHERE pid
= 44168;
182 UPDATE profiles
SET ax_id
= 20100208 WHERE pid
= 44169;
183 UPDATE profiles
SET ax_id
= 20100209 WHERE pid
= 44172;
184 UPDATE profiles
SET ax_id
= 20100210 WHERE pid
= 44173;
185 UPDATE profiles
SET ax_id
= 20100211 WHERE pid
= 44174;
186 UPDATE profiles
SET ax_id
= 20100212 WHERE pid
= 44175;
187 UPDATE profiles
SET ax_id
= 20100213 WHERE pid
= 44176;
188 UPDATE profiles
SET ax_id
= 20100214 WHERE pid
= 44177;
189 UPDATE profiles
SET ax_id
= 20100215 WHERE pid
= 44178;
190 UPDATE profiles
SET ax_id
= 20100216 WHERE pid
= 44179;
191 UPDATE profiles
SET ax_id
= 20100217 WHERE pid
= 44180;
192 UPDATE profiles
SET ax_id
= 20100218 WHERE pid
= 44181;
193 UPDATE profiles
SET ax_id
= 20100219 WHERE pid
= 44182;
194 UPDATE profiles
SET ax_id
= 20100220 WHERE pid
= 44183;
195 UPDATE profiles
SET ax_id
= 20100221 WHERE pid
= 44184;
196 UPDATE profiles
SET ax_id
= 20100222 WHERE pid
= 44185;
197 UPDATE profiles
SET ax_id
= 20100223 WHERE pid
= 44186;
198 UPDATE profiles
SET ax_id
= 20100224 WHERE pid
= 44187;
199 UPDATE profiles
SET ax_id
= 20100225 WHERE pid
= 44188;
200 UPDATE profiles
SET ax_id
= 20100226 WHERE pid
= 44190;
201 UPDATE profiles
SET ax_id
= 20100227 WHERE pid
= 44191;
202 UPDATE profiles
SET ax_id
= 20100228 WHERE pid
= 44192;
203 UPDATE profiles
SET ax_id
= 20100229 WHERE pid
= 44194;
204 UPDATE profiles
SET ax_id
= 20100230 WHERE pid
= 44195;
205 UPDATE profiles
SET ax_id
= 20100231 WHERE pid
= 44196;
206 UPDATE profiles
SET ax_id
= 20100232 WHERE pid
= 44198;
207 UPDATE profiles
SET ax_id
= 20100233 WHERE pid
= 44199;
208 UPDATE profiles
SET ax_id
= 20100234 WHERE pid
= 44200;
209 UPDATE profiles
SET ax_id
= 20100235 WHERE pid
= 44201;
210 UPDATE profiles
SET ax_id
= 20100236 WHERE pid
= 44203;
211 UPDATE profiles
SET ax_id
= 20100237 WHERE pid
= 44204;
212 UPDATE profiles
SET ax_id
= 20100238 WHERE pid
= 44205;
213 UPDATE profiles
SET ax_id
= 20100239 WHERE pid
= 44206;
214 UPDATE profiles
SET ax_id
= 20100240 WHERE pid
= 44207;
215 UPDATE profiles
SET ax_id
= 20100241 WHERE pid
= 44208;
216 UPDATE profiles
SET ax_id
= 20100242 WHERE pid
= 44210;
217 UPDATE profiles
SET ax_id
= 20100243 WHERE pid
= 44213;
218 UPDATE profiles
SET ax_id
= 20100244 WHERE pid
= 44215;
219 UPDATE profiles
SET ax_id
= 20100245 WHERE pid
= 44216;
220 UPDATE profiles
SET ax_id
= 20100246 WHERE pid
= 44217;
221 UPDATE profiles
SET ax_id
= 20100247 WHERE pid
= 44218;
222 UPDATE profiles
SET ax_id
= 20100248 WHERE pid
= 44219;
223 UPDATE profiles
SET ax_id
= 20100249 WHERE pid
= 44220;
224 UPDATE profiles
SET ax_id
= 20100250 WHERE pid
= 44221;
225 UPDATE profiles
SET ax_id
= 20100251 WHERE pid
= 44222;
226 UPDATE profiles
SET ax_id
= 20100252 WHERE pid
= 44088;
227 UPDATE profiles
SET ax_id
= 20100253 WHERE pid
= 44223;
228 UPDATE profiles
SET ax_id
= 20100254 WHERE pid
= 44224;
229 UPDATE profiles
SET ax_id
= 20100255 WHERE pid
= 44225;
230 UPDATE profiles
SET ax_id
= 20100256 WHERE pid
= 44226;
231 UPDATE profiles
SET ax_id
= 20100257 WHERE pid
= 44214;
232 UPDATE profiles
SET ax_id
= 20100258 WHERE pid
= 44227;
233 UPDATE profiles
SET ax_id
= 20100259 WHERE pid
= 44228;
234 UPDATE profiles
SET ax_id
= 20100260 WHERE pid
= 44229;
235 UPDATE profiles
SET ax_id
= 20100261 WHERE pid
= 44230;
236 UPDATE profiles
SET ax_id
= 20100262 WHERE pid
= 44231;
237 UPDATE profiles
SET ax_id
= 20100263 WHERE pid
= 44232;
238 UPDATE profiles
SET ax_id
= 20100264 WHERE pid
= 44233;
239 UPDATE profiles
SET ax_id
= 20100265 WHERE pid
= 44234;
240 UPDATE profiles
SET ax_id
= 20100266 WHERE pid
= 44235;
241 UPDATE profiles
SET ax_id
= 20100267 WHERE pid
= 44237;
242 UPDATE profiles
SET ax_id
= 20100268 WHERE pid
= 44238;
243 UPDATE profiles
SET ax_id
= 20100269 WHERE pid
= 44239;
244 UPDATE profiles
SET ax_id
= 20100270 WHERE pid
= 44240;
245 UPDATE profiles
SET ax_id
= 20100271 WHERE pid
= 44241;
246 UPDATE profiles
SET ax_id
= 20100272 WHERE pid
= 44089;
247 UPDATE profiles
SET ax_id
= 20100273 WHERE pid
= 44242;
248 UPDATE profiles
SET ax_id
= 20100274 WHERE pid
= 44243;
249 UPDATE profiles
SET ax_id
= 20100275 WHERE pid
= 44244;
250 UPDATE profiles
SET ax_id
= 20100276 WHERE pid
= 44245;
251 UPDATE profiles
SET ax_id
= 20100277 WHERE pid
= 44250;
252 UPDATE profiles
SET ax_id
= 20100278 WHERE pid
= 44251;
253 UPDATE profiles
SET ax_id
= 20100279 WHERE pid
= 44252;
254 UPDATE profiles
SET ax_id
= 20100280 WHERE pid
= 44253;
255 UPDATE profiles
SET ax_id
= 20100281 WHERE pid
= 44254;
256 UPDATE profiles
SET ax_id
= 20100282 WHERE pid
= 44255;
257 UPDATE profiles
SET ax_id
= 20100283 WHERE pid
= 44256;
258 UPDATE profiles
SET ax_id
= 20100284 WHERE pid
= 44257;
259 UPDATE profiles
SET ax_id
= 20100285 WHERE pid
= 44258;
260 UPDATE profiles
SET ax_id
= 20100286 WHERE pid
= 44259;
261 UPDATE profiles
SET ax_id
= 20100287 WHERE pid
= 44090;
262 UPDATE profiles
SET ax_id
= 20100288 WHERE pid
= 44261;
263 UPDATE profiles
SET ax_id
= 20100289 WHERE pid
= 44262;
264 UPDATE profiles
SET ax_id
= 20100290 WHERE pid
= 44263;
265 UPDATE profiles
SET ax_id
= 20100291 WHERE pid
= 44264;
266 UPDATE profiles
SET ax_id
= 20100292 WHERE pid
= 44265;
267 UPDATE profiles
SET ax_id
= 20100293 WHERE pid
= 44266;
268 UPDATE profiles
SET ax_id
= 20100294 WHERE pid
= 44267;
269 UPDATE profiles
SET ax_id
= 20100295 WHERE pid
= 44268;
270 UPDATE profiles
SET ax_id
= 20100296 WHERE pid
= 44270;
271 UPDATE profiles
SET ax_id
= 20100297 WHERE pid
= 44271;
272 UPDATE profiles
SET ax_id
= 20100298 WHERE pid
= 44272;
273 UPDATE profiles
SET ax_id
= 20100299 WHERE pid
= 44273;
274 UPDATE profiles
SET ax_id
= 20100300 WHERE pid
= 44274;
275 UPDATE profiles
SET ax_id
= 20100301 WHERE pid
= 44275;
276 UPDATE profiles
SET ax_id
= 20100302 WHERE pid
= 44091;
277 UPDATE profiles
SET ax_id
= 20100303 WHERE pid
= 44276;
278 UPDATE profiles
SET ax_id
= 20100304 WHERE pid
= 44277;
279 UPDATE profiles
SET ax_id
= 20100305 WHERE pid
= 44278;
280 UPDATE profiles
SET ax_id
= 20100306 WHERE pid
= 44279;
281 UPDATE profiles
SET ax_id
= 20100307 WHERE pid
= 44280;
282 UPDATE profiles
SET ax_id
= 20100308 WHERE pid
= 44281;
283 UPDATE profiles
SET ax_id
= 20100309 WHERE pid
= 44282;
284 UPDATE profiles
SET ax_id
= 20100310 WHERE pid
= 44283;
285 UPDATE profiles
SET ax_id
= 20100311 WHERE pid
= 44284;
286 UPDATE profiles
SET ax_id
= 20100312 WHERE pid
= 44285;
287 UPDATE profiles
SET ax_id
= 20100313 WHERE pid
= 44287;
288 UPDATE profiles
SET ax_id
= 20100314 WHERE pid
= 44286;
289 UPDATE profiles
SET ax_id
= 20100315 WHERE pid
= 44288;
290 UPDATE profiles
SET ax_id
= 20100316 WHERE pid
= 44289;
291 UPDATE profiles
SET ax_id
= 20100317 WHERE pid
= 44291;
292 UPDATE profiles
SET ax_id
= 20100318 WHERE pid
= 44292;
293 UPDATE profiles
SET ax_id
= 20100319 WHERE pid
= 44296;
294 UPDATE profiles
SET ax_id
= 20100320 WHERE pid
= 44297;
295 UPDATE profiles
SET ax_id
= 20100321 WHERE pid
= 44298;
296 UPDATE profiles
SET ax_id
= 20100322 WHERE pid
= 44299;
297 UPDATE profiles
SET ax_id
= 20100323 WHERE pid
= 44301;
298 UPDATE profiles
SET ax_id
= 20100324 WHERE pid
= 44302;
299 UPDATE profiles
SET ax_id
= 20100325 WHERE pid
= 44304;
300 UPDATE profiles
SET ax_id
= 20100326 WHERE pid
= 44305;
301 UPDATE profiles
SET ax_id
= 20100327 WHERE pid
= 44306;
302 UPDATE profiles
SET ax_id
= 20100328 WHERE pid
= 44307;
303 UPDATE profiles
SET ax_id
= 20100329 WHERE pid
= 44308;
304 UPDATE profiles
SET ax_id
= 20100330 WHERE pid
= 44309;
305 UPDATE profiles
SET ax_id
= 20100331 WHERE pid
= 44310;
306 UPDATE profiles
SET ax_id
= 20100332 WHERE pid
= 44311;
307 UPDATE profiles
SET ax_id
= 20100333 WHERE pid
= 44312;
308 UPDATE profiles
SET ax_id
= 20100334 WHERE pid
= 44313;
309 UPDATE profiles
SET ax_id
= 20100335 WHERE pid
= 44314;
310 UPDATE profiles
SET ax_id
= 20100336 WHERE pid
= 44315;
311 UPDATE profiles
SET ax_id
= 20100337 WHERE pid
= 44316;
312 UPDATE profiles
SET ax_id
= 20100338 WHERE pid
= 44317;
313 UPDATE profiles
SET ax_id
= 20100339 WHERE pid
= 44318;
314 UPDATE profiles
SET ax_id
= 20100340 WHERE pid
= 44319;
315 UPDATE profiles
SET ax_id
= 20100341 WHERE pid
= 44320;
316 UPDATE profiles
SET ax_id
= 20100342 WHERE pid
= 44321;
317 UPDATE profiles
SET ax_id
= 20100343 WHERE pid
= 44322;
318 UPDATE profiles
SET ax_id
= 20100344 WHERE pid
= 44323;
319 UPDATE profiles
SET ax_id
= 20100345 WHERE pid
= 44324;
320 UPDATE profiles
SET ax_id
= 20100346 WHERE pid
= 44325;
321 UPDATE profiles
SET ax_id
= 20100347 WHERE pid
= 44326;
322 UPDATE profiles
SET ax_id
= 20100348 WHERE pid
= 44327;
323 UPDATE profiles
SET ax_id
= 20100349 WHERE pid
= 44328;
324 UPDATE profiles
SET ax_id
= 20100350 WHERE pid
= 44329;
325 UPDATE profiles
SET ax_id
= 20100351 WHERE pid
= 44330;
326 UPDATE profiles
SET ax_id
= 20100352 WHERE pid
= 44331;
327 UPDATE profiles
SET ax_id
= 20100353 WHERE pid
= 44332;
328 UPDATE profiles
SET ax_id
= 20100354 WHERE pid
= 44333;
329 UPDATE profiles
SET ax_id
= 20100355 WHERE pid
= 44334;
330 UPDATE profiles
SET ax_id
= 20100356 WHERE pid
= 44335;
331 UPDATE profiles
SET ax_id
= 20100357 WHERE pid
= 44336;
332 UPDATE profiles
SET ax_id
= 20100358 WHERE pid
= 44337;
333 UPDATE profiles
SET ax_id
= 20100359 WHERE pid
= 44338;
334 UPDATE profiles
SET ax_id
= 20100360 WHERE pid
= 44339;
335 UPDATE profiles
SET ax_id
= 20100361 WHERE pid
= 44340;
336 UPDATE profiles
SET ax_id
= 20100362 WHERE pid
= 44341;
337 UPDATE profiles
SET ax_id
= 20100363 WHERE pid
= 44342;
338 UPDATE profiles
SET ax_id
= 20100364 WHERE pid
= 44343;
339 UPDATE profiles
SET ax_id
= 20100365 WHERE pid
= 44345;
340 UPDATE profiles
SET ax_id
= 20100366 WHERE pid
= 44346;
341 UPDATE profiles
SET ax_id
= 20100367 WHERE pid
= 44347;
342 UPDATE profiles
SET ax_id
= 20100368 WHERE pid
= 44348;
343 UPDATE profiles
SET ax_id
= 20100369 WHERE pid
= 44349;
344 UPDATE profiles
SET ax_id
= 20100370 WHERE pid
= 44350;
345 UPDATE profiles
SET ax_id
= 20100371 WHERE pid
= 44351;
346 UPDATE profiles
SET ax_id
= 20100372 WHERE pid
= 44352;
347 UPDATE profiles
SET ax_id
= 20100373 WHERE pid
= 44353;
348 UPDATE profiles
SET ax_id
= 20100374 WHERE pid
= 44354;
349 UPDATE profiles
SET ax_id
= 20100375 WHERE pid
= 44355;
350 UPDATE profiles
SET ax_id
= 20100376 WHERE pid
= 44356;
351 UPDATE profiles
SET ax_id
= 20100377 WHERE pid
= 44357;
352 UPDATE profiles
SET ax_id
= 20100378 WHERE pid
= 44358;
353 UPDATE profiles
SET ax_id
= 20100379 WHERE pid
= 44359;
354 UPDATE profiles
SET ax_id
= 20100380 WHERE pid
= 44362;
355 UPDATE profiles
SET ax_id
= 20100381 WHERE pid
= 44363;
356 UPDATE profiles
SET ax_id
= 20100382 WHERE pid
= 44364;
357 UPDATE profiles
SET ax_id
= 20100383 WHERE pid
= 44366;
358 UPDATE profiles
SET ax_id
= 20100384 WHERE pid
= 44367;
359 UPDATE profiles
SET ax_id
= 20100385 WHERE pid
= 44092;
360 UPDATE profiles
SET ax_id
= 20100386 WHERE pid
= 44368;
361 UPDATE profiles
SET ax_id
= 20100387 WHERE pid
= 44369;
362 UPDATE profiles
SET ax_id
= 20100388 WHERE pid
= 44093;
363 UPDATE profiles
SET ax_id
= 20100389 WHERE pid
= 44370;
364 UPDATE profiles
SET ax_id
= 20100390 WHERE pid
= 44371;
365 UPDATE profiles
SET ax_id
= 20100391 WHERE pid
= 44372;
366 UPDATE profiles
SET ax_id
= 20100392 WHERE pid
= 44373;
367 UPDATE profiles
SET ax_id
= 20100393 WHERE pid
= 44374;
368 UPDATE profiles
SET ax_id
= 20100394 WHERE pid
= 44377;
369 UPDATE profiles
SET ax_id
= 20100395 WHERE pid
= 44378;
370 UPDATE profiles
SET ax_id
= 20100396 WHERE pid
= 44379;
371 UPDATE profiles
SET ax_id
= 20100397 WHERE pid
= 44380;
372 UPDATE profiles
SET ax_id
= 20100398 WHERE pid
= 44382;
373 UPDATE profiles
SET ax_id
= 20100399 WHERE pid
= 44361;
374 UPDATE profiles
SET ax_id
= 20100400 WHERE pid
= 44383;
375 UPDATE profiles
SET ax_id
= 20100401 WHERE pid
= 44384;
376 UPDATE profiles
SET ax_id
= 20100402 WHERE pid
= 44385;
377 UPDATE profiles
SET ax_id
= 20100403 WHERE pid
= 44386;
378 UPDATE profiles
SET ax_id
= 20100404 WHERE pid
= 44388;
379 UPDATE profiles
SET ax_id
= 20100405 WHERE pid
= 44389;
380 UPDATE profiles
SET ax_id
= 20100406 WHERE pid
= 44390;
381 UPDATE profiles
SET ax_id
= 20100407 WHERE pid
= 44392;
382 UPDATE profiles
SET ax_id
= 20100408 WHERE pid
= 44393;
383 UPDATE profiles
SET ax_id
= 20100409 WHERE pid
= 44394;
384 UPDATE profiles
SET ax_id
= 20100410 WHERE pid
= 44395;
385 UPDATE profiles
SET ax_id
= 20100411 WHERE pid
= 44398;
386 UPDATE profiles
SET ax_id
= 20100412 WHERE pid
= 44399;
387 UPDATE profiles
SET ax_id
= 20100413 WHERE pid
= 44400;
388 UPDATE profiles
SET ax_id
= 20100414 WHERE pid
= 44401;
389 UPDATE profiles
SET ax_id
= 20100415 WHERE pid
= 44402;
390 UPDATE profiles
SET ax_id
= 20100416 WHERE pid
= 44403;
391 UPDATE profiles
SET ax_id
= 20100417 WHERE pid
= 44404;
392 UPDATE profiles
SET ax_id
= 20100418 WHERE pid
= 44405;
393 UPDATE profiles
SET ax_id
= 20100419 WHERE pid
= 44406;
394 UPDATE profiles
SET ax_id
= 20100420 WHERE pid
= 44411;
395 UPDATE profiles
SET ax_id
= 20100421 WHERE pid
= 44412;
396 UPDATE profiles
SET ax_id
= 20100422 WHERE pid
= 44413;
397 UPDATE profiles
SET ax_id
= 20100423 WHERE pid
= 44414;
398 UPDATE profiles
SET ax_id
= 20100424 WHERE pid
= 44415;
399 UPDATE profiles
SET ax_id
= 20100425 WHERE pid
= 44417;
400 UPDATE profiles
SET ax_id
= 20100426 WHERE pid
= 44420;
401 UPDATE profiles
SET ax_id
= 20100427 WHERE pid
= 44423;
402 UPDATE profiles
SET ax_id
= 20100428 WHERE pid
= 44428;
403 UPDATE profiles
SET ax_id
= 20100429 WHERE pid
= 43957;
404 UPDATE profiles
SET ax_id
= 20100430 WHERE pid
= 43958;
405 UPDATE profiles
SET ax_id
= 20100431 WHERE pid
= 43960;
406 UPDATE profiles
SET ax_id
= 20100432 WHERE pid
= 43962;
407 UPDATE profiles
SET ax_id
= 20100433 WHERE pid
= 43963;
408 UPDATE profiles
SET ax_id
= 20100434 WHERE pid
= 43975;
409 UPDATE profiles
SET ax_id
= 20100435 WHERE pid
= 43982;
410 UPDATE profiles
SET ax_id
= 20100436 WHERE pid
= 43992;
411 UPDATE profiles
SET ax_id
= 20100437 WHERE pid
= 43995;
412 UPDATE profiles
SET ax_id
= 20100438 WHERE pid
= 43996;
413 UPDATE profiles
SET ax_id
= 20100439 WHERE pid
= 44001;
414 UPDATE profiles
SET ax_id
= 20100440 WHERE pid
= 44007;
415 UPDATE profiles
SET ax_id
= 20100441 WHERE pid
= 44008;
416 UPDATE profiles
SET ax_id
= 20100442 WHERE pid
= 44009;
417 UPDATE profiles
SET ax_id
= 20100443 WHERE pid
= 44020;
418 UPDATE profiles
SET ax_id
= 20100444 WHERE pid
= 44027;
419 UPDATE profiles
SET ax_id
= 20100445 WHERE pid
= 44039;
420 UPDATE profiles
SET ax_id
= 20100446 WHERE pid
= 44041;
421 UPDATE profiles
SET ax_id
= 20100447 WHERE pid
= 44052;
422 UPDATE profiles
SET ax_id
= 20100448 WHERE pid
= 44059;
423 UPDATE profiles
SET ax_id
= 20100449 WHERE pid
= 44061;
424 UPDATE profiles
SET ax_id
= 20100450 WHERE pid
= 44081;
425 UPDATE profiles
SET ax_id
= 20100451 WHERE pid
= 44104;
426 UPDATE profiles
SET ax_id
= 20100452 WHERE pid
= 44121;
427 UPDATE profiles
SET ax_id
= 20100453 WHERE pid
= 44124;
428 UPDATE profiles
SET ax_id
= 20100454 WHERE pid
= 44139;
429 UPDATE profiles
SET ax_id
= 20100455 WHERE pid
= 44163;
430 UPDATE profiles
SET ax_id
= 20100456 WHERE pid
= 44165;
431 UPDATE profiles
SET ax_id
= 20100457 WHERE pid
= 44170;
432 UPDATE profiles
SET ax_id
= 20100458 WHERE pid
= 44171;
433 UPDATE profiles
SET ax_id
= 20100459 WHERE pid
= 44189;
434 UPDATE profiles
SET ax_id
= 20100460 WHERE pid
= 44193;
435 UPDATE profiles
SET ax_id
= 20100461 WHERE pid
= 44197;
436 UPDATE profiles
SET ax_id
= 20100462 WHERE pid
= 44202;
437 UPDATE profiles
SET ax_id
= 20100463 WHERE pid
= 44209;
438 UPDATE profiles
SET ax_id
= 20100464 WHERE pid
= 44211;
439 UPDATE profiles
SET ax_id
= 20100465 WHERE pid
= 44212;
440 UPDATE profiles
SET ax_id
= 20100466 WHERE pid
= 44236;
441 UPDATE profiles
SET ax_id
= 20100467 WHERE pid
= 44247;
442 UPDATE profiles
SET ax_id
= 20100468 WHERE pid
= 44246;
443 UPDATE profiles
SET ax_id
= 20100469 WHERE pid
= 44248;
444 UPDATE profiles
SET ax_id
= 20100470 WHERE pid
= 44249;
445 UPDATE profiles
SET ax_id
= 20100471 WHERE pid
= 44260;
446 UPDATE profiles
SET ax_id
= 20100472 WHERE pid
= 44269;
447 UPDATE profiles
SET ax_id
= 20100474 WHERE pid
= 44290;
448 UPDATE profiles
SET ax_id
= 20100475 WHERE pid
= 44293;
449 UPDATE profiles
SET ax_id
= 20100476 WHERE pid
= 44294;
450 UPDATE profiles
SET ax_id
= 20100477 WHERE pid
= 44295;
451 UPDATE profiles
SET ax_id
= 20100478 WHERE pid
= 44300;
452 UPDATE profiles
SET ax_id
= 20100480 WHERE pid
= 44303;
453 UPDATE profiles
SET ax_id
= 20100481 WHERE pid
= 44344;
454 UPDATE profiles
SET ax_id
= 20100482 WHERE pid
= 44360;
455 UPDATE profiles
SET ax_id
= 20100483 WHERE pid
= 44365;
456 UPDATE profiles
SET ax_id
= 20100484 WHERE pid
= 44375;
457 UPDATE profiles
SET ax_id
= 20100485 WHERE pid
= 44376;
458 UPDATE profiles
SET ax_id
= 20100486 WHERE pid
= 44381;
459 UPDATE profiles
SET ax_id
= 20100487 WHERE pid
= 44387;
460 UPDATE profiles
SET ax_id
= 20100488 WHERE pid
= 44391;
461 UPDATE profiles
SET ax_id
= 20100489 WHERE pid
= 44396;
462 UPDATE profiles
SET ax_id
= 20100490 WHERE pid
= 44397;
463 UPDATE profiles
SET ax_id
= 20100491 WHERE pid
= 44407;
464 UPDATE profiles
SET ax_id
= 20100492 WHERE pid
= 44408;
465 UPDATE profiles
SET ax_id
= 20100493 WHERE pid
= 44409;
466 UPDATE profiles
SET ax_id
= 20100494 WHERE pid
= 44410;
467 UPDATE profiles
SET ax_id
= 20100495 WHERE pid
= 44416;
468 UPDATE profiles
SET ax_id
= 20100496 WHERE pid
= 44418;
469 UPDATE profiles
SET ax_id
= 20100497 WHERE pid
= 44419;
470 UPDATE profiles
SET ax_id
= 20100498 WHERE pid
= 44421;
471 UPDATE profiles
SET ax_id
= 20100499 WHERE pid
= 44422;
472 UPDATE profiles
SET ax_id
= 20100500 WHERE pid
= 44424;
473 UPDATE profiles
SET ax_id
= 20100501 WHERE pid
= 44425;
474 UPDATE profiles
SET ax_id
= 20100502 WHERE pid
= 44426;
475 UPDATE profiles
SET ax_id
= 20100503 WHERE pid
= 44427;
477 -- Updates promo for oranjes who only stated their orajisation to AX.
478 -- WARNING: this does not affect the display of their promotion anywhere. It will just allow them to attend events to both promotions.
479 -- Also they wiil not need to require a validation if they want to change promo on the site.
481 UPDATE profile_education
482 SET grad_year
= grad_year
+ 1
483 WHERE FIND_IN_SET('primary', flags
) AND pid
IN (42018, 42216, 43135, 43216, 42981, 43039, 41827, 42322);
485 -- Same as before but double orajisation.
486 UPDATE profile_education
487 SET grad_year
= grad_year
+ 2
488 WHERE FIND_IN_SET('primary', flags
) AND pid
= 41291;
490 -- Fixes erroneous data
491 UPDATE profile_education
492 SET entry_year
= 1951, grad_year
= 1954
493 WHERE FIND_IN_SET('primary', flags
) AND pid
= 29674;
494 UPDATE profile_display
498 -- Inserts missing couple (education, degree) required by AX data.
499 INSERT IGNORE INTO profile_education_degree (eduid
, degreeid
)
502 -- vim:set syntax=mysql:;