רנקליסט 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 = 3604 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 = 3604 LEFT JOIN CLUB C2 ON C2.CLUB_ID = DP2.CLUB_2_ID WHERE PLAYER_ID IN (2284,1867,1053)