Something

CREATE PROCEDURE `ewtr`(IN resLabel VARCHAR(255), OUT r INT, OUT w INT, OUT x INT)
    READS SQL DATA
BEGIN
	DECLARE ra, wa,xa INT;
	DECLARE rd, wd, xd INT;
	DECLARE eof INT;
	ra = NULL;
	wa = NULL;
	xa = NULL;
	DECLARE permChain CURSOR FOR SELECT r, w, x FROM Privtemp ORDER BY id;
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET eof = 1;
	OPEN permChain;
	REPEAT
		FETCH permChain INTO rd, wd, xd;
		IF rd IS NOT NULL;
		THEN ra = rd;
		END IF;
		IF wd IS NOT NULL;
		THEN wa = rd;
		END IF;
		IF xd IS NOT NULL;
		THEN xa = rd;
		END IF;
		UNTIL eof=1;
	END REPEAT;
	CLOSE permChain;
	SET r = ra;
	SET w = wa;
	SET x = xa;
END