SET @num :=  0;
SET @id  := -1;

SELECT e.*, y.ChallengerID, CASE WHEN ep.isChampion IS TRUE THEN TRUE ELSE FALSE END AS isCurrentChampion
FROM
(
.
.
.