1 -- Updates promo for oranjes who only stated their orajisation to AX.
2 -- WARNING: this does not affect the display of their promotion anywhere. It will just allow them to attend events to both promotions.
3 -- Also they will not need to require a validation if they want to change promo on the site.
5 UPDATE profile_education
6 SET grad_year
= grad_year
+ 1
7 WHERE FIND_IN_SET('primary', flags
) AND pid
IN (41342, 41581, 41670, 42220, 43438, 43529, 43699);
9 -- Same as before but double orajisation.
10 UPDATE profile_education
11 SET grad_year
= grad_year
+ 2
12 WHERE FIND_IN_SET('primary', flags
) AND pid
IN (41441, 42307);
14 -- vim:set syntax=mysql:;