--liquibase formatted sql
--changeset {patrick}:{e0df48db-f9df-4aa5-bc39-4a444ab826c0}

DELETE FROM `user` WHERE organization_id IN (SELECT id from organization WHERE external_id in ('AW00021160','AW00021150','AW00021158','AW00021171','AW00021093','AW00021101','AW00021173'));
DELETE FROM organization WHERE external_id in ('AW00021160','AW00021150','AW00021158','AW00021171','AW00021093','AW00021101','AW00021173');
