Transfer Rights to Another User

INSERT INTO equipment_equipment_role (user_id, equipment_id, role_id, dateCreated, comment, inApprovalFlow, status) SELECT 2239, equipment_id, role_id, NOW(), 'Added as temporary replacement for User X', inApprovalFlow, status FROM equipment_equipment_role WHERE user_id = 2241 AND inApprovalFlow = 1 AND status = 1 AND equipment_id NOT IN (SELECT equipment_id FROM equipment_equipment_role WHERE user_id = 2239); INSERT INTO room_room_role (user_id, room_id, role_id, dateCreated, comment, inApprovalFlow, status) SELECT 2239, room_id, role_id, NOW(), 'Added as temporary replacement for User X', inApprovalFlow, status FROM room_room_role WHERE user_id = 2241 AND inApprovalFlow = 1 AND status = 1 AND room_id NOT IN (SELECT room_id FROM room_room_role WHERE user_id = 2239);