UPDATE `organisation` SET `Verfahrensstufe` = '0' WHERE (`Verfahrensstufe` = '1');

ALTER TABLE `gkvabrechnung` 
ADD COLUMN `OrganisationOid` BIGINT NULL DEFAULT NULL AFTER `Verfahrensstufe`;

UPDATE gkvabrechnung gab
LEFT JOIN gkvabrechnung2invoicebase gib 
ON gib.GkvAbrechnungOid = gab.Oid
LEFT JOIN invoicebase ib
ON gib.InvoiceBaseOid = ib.Oid
LEFT JOIN costbearer2supportconcept c2sc
ON ib.CostBearer2SupportConceptOid = c2sc.Oid
LEFT JOIN costbearer cb 
ON c2sc.CostBearerOid = cb.Oid
LEFT JOIN organisation o
ON o.CostBearerOid = cb.Oid
SET gab.OrganisationOid = o.Oid;

UPDATE organisation o
RIGHT JOIN gkvabrechnung g
ON o.Oid = g.OrganisationOid
SET o.Verfahrensstufe = 1;