query om bepaalde toetsen uit periode 29 om te zetten naar periode 30:

INSERT INTO rex ( prev_rex_id, period_id, ppl_id, timestamp, subj_id, pta_id, info, weight, fixed) SELECT rex_id, 30, ppl_id, timestamp, rex.subj_id, pta_id, info, weight, fixed FROM `rex` JOIN ptas USING (pta_id) WHERE period_id = 29 AND ( gemaakt = 0 OR ( pta_leerjr = 4 AND stvt = 'ST' AND pta_target = 'V') ) 

query:

INSERT INTO rex ( prev_rex_id, period_id, ppl_id, timestamp, subj_id, pta_id, info, weight, fixed) SELECT rex_id, 42, ppl_id, timestamp, rex.subj_id, pta_id, info, weight, fixed FROM `rex` JOIN ptas USING (pta_id) WHERE period_id = 41 AND gemaakt = 0 


INSERT INTO rex ( prev_rex_id, period_id, ppl_id, timestamp, subj_id, pta_id, info, weight, fixed) 
SELECT rex_id, 43, ppl_id, timestamp, rex.subj_id, pta_id, info, 0, 1 FROM `rex` WHERE period_id = 41 AND gemaakt = 0