DELIMITER //
CREATE TRIGGER `change_status_to_failed` AFTER UPDATE ON `tasks_dicts` 
FOR EACH ROW 
BEGIN
   	DECLARE dicts_count INT;
	DECLARE stat INT;

	SELECT COUNT(*) INTO dicts_count FROM (SELECT * FROM tasks_dicts WHERE status NOT IN ('1') AND net_id=NEW.net_id) as alias;
	IF (dicts_count=0) THEN
		UPDATE tasks SET status='3' WHERE id=NEW.net_id;
		UPDATE tasks SET forDelete='1' WHERE id=NEW.net_id;
	END IF;
	SELECT status INTO stat FROM tasks WHERE id=NEW.net_id;
	IF (dicts_count!=0 AND stat='3') THEN
		UPDATE tasks SET status='0' WHERE id=NEW.net_id;
	END IF;
END
//
DELIMITER ;

DELIMITER //
CREATE TRIGGER `change_status_to_failed` AFTER UPDATE ON `tasks_dicts` 
FOR EACH ROW 
BEGIN
   	DECLARE dicts_count INT;

	SELECT COUNT(*) INTO dicts_count FROM (SELECT * FROM tasks_dicts WHERE status NOT IN ('1') AND net_id=NEW.net_id) as alias;
	IF (dicts_count=0) THEN
		UPDATE tasks SET status='3' WHERE id=NEW.net_id;
	END IF;	
END
//
DELIMITER ;

DELIMITER //
CREATE TRIGGER `delete_success_failed` AFTER UPDATE ON `tasks` 
FOR EACH ROW 
BEGIN
   	DELETE FROM tasks_dicts WHERE net_id IN(SELECT id FROM tasks WHERE status IN('2', '3'));
END
//
DELIMITER ;

#1442 - Can't update table 'tasks_dicts' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.