select * from contacts where id in ("s0100003","s1100003","s1100004","s1400004","s1500001","s1500002","s2200005","s2700003","s2700004","s2700005","s2700017","s2700021","s4000005","s4000008","s4000009","s4000010","s4000013","s4700003")
select * from users where contact_id in ("s0100003","s1100003","s1100004","s1400004","s1500001","s1500002","s2200005","s2700003","s2700004","s2700005","s2700017","s2700021","s4000005","s4000008","s4000009","s4000010","s4000013","s4700003")

-- スタッフ削除
UPDATE contacts SET deleted = "1" WHERE id = "s0100003";
UPDATE contacts SET deleted = "1" WHERE id = "s1100003";
UPDATE contacts SET deleted = "1" WHERE id = "s1100004";
UPDATE contacts SET deleted = "1" WHERE id = "s1400004";
UPDATE contacts SET deleted = "1" WHERE id = "s1500001";
UPDATE contacts SET deleted = "1" WHERE id = "s1500002";
UPDATE contacts SET deleted = "1" WHERE id = "s2200005";
UPDATE contacts SET deleted = "1" WHERE id = "s2700003";
UPDATE contacts SET deleted = "1" WHERE id = "s2700004";
UPDATE contacts SET deleted = "1" WHERE id = "s2700005";
UPDATE contacts SET deleted = "1" WHERE id = "s2700017";
UPDATE contacts SET deleted = "1" WHERE id = "s2700021";
UPDATE contacts SET deleted = "1" WHERE id = "s4000005";
UPDATE contacts SET deleted = "1" WHERE id = "s4000008";
UPDATE contacts SET deleted = "1" WHERE id = "s4000009";
UPDATE contacts SET deleted = "1" WHERE id = "s4000010";
UPDATE contacts SET deleted = "1" WHERE id = "s4000013";
UPDATE contacts SET deleted = "1" WHERE id = "s4700003";

-- ユーザ削除、非活性
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s0100003";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s1100003";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s1100004";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s1400004";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s1500001";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s1500002";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s2200005";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s2700003";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s2700004";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s2700005";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s2700017";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s2700021";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s4000005";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s4000008";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s4000009";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s4000010";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s4000013";
UPDATE users SET deleted = "1", status="Inactive" WHERE contact_id = "s4700003";