CREATE DEFINER = 'my_base'@'%' TRIGGER `plan_schedule_order_mechanism_after_upd_tr1` AFTER UPDATE ON `plan_schedule_order_mechanism`
  FOR EACH ROW
BEGIN
  DECLARE w_id INTEGER(11, UNSIGNED);

  IF EXISTS(SELECT id INTO w_id
            FROM work w
            INNER JOIN mechanism_work mw ON mw.id = w.mechanism_work_id
            WHERE mw.plan_schedule_order_mechanism_id = OLD.id 
            AND w.machine_operator = 'Y')            
            
  THEN  
    UPDATE work
    SET plan_schedule_order_worker_id = NEW.plan_schedule_order_worker_id)
    WHERE id = w_id;

  END IF;
END

BEGIN
  DECLARE w_id INTEGER(11) UNSIGNED;

  SELECT work.id INTO w_id 
         FROM work 
         INNER JOIN mechanism_work ON mechanism_work.id = work.mechanism_work_id
         WHERE mechanism_work.plan_schedule_order_mechanism_id = OLD.id 
         AND work.machine_operator = 'Y';

  IF w_id IS NOT NULL
  THEN  
    UPDATE work
    SET plan_schedule_order_worker_id = NEW.plan_schedule_order_worker_id
    WHERE id = w_id;

  END IF;
END