רנקליסט מס.1

רמה 1

SELECT PLAYER.*, IF(C1.CLUB_NAME = NULL, C2.CLUB_NAME, C1.CLUB_NAME) CLUB_NAME FROM PLAYER LEFT JOIN DRAW_PLAYER DP1 ON PLAYER.PLAYER_ID = DP1.PLAYER_1_ID AND DP1.DRAW_ID = 6070 LEFT JOIN CLUB C1 ON C1.CLUB_ID = DP1.CLUB_1_ID LEFT JOIN DRAW_PLAYER DP2 ON PLAYER.PLAYER_ID = DP2.PLAYER_2_ID AND DP2.DRAW_ID = 6070 LEFT JOIN CLUB C2 ON C2.CLUB_ID = DP2.CLUB_2_ID WHERE PLAYER_ID IN (2620,617,3082)