Find player's latest match whether player was the winner or loser
Are you looking for this,

select top(1)  isWinner,  win_end_hcp
from
(
select 1 isWinner, end_time,  win_end_hcp from table1
where winner_id=X
union ALL
select 0 isWinner, end_time,  win_end_hcp from table1
where loser_id=X
)t4
order by t4.end_time desc