SELECT sgd.side_game_detail_id,sg.side_game_name,h.hole_name,sgd.side_game_id FROM `side_game_details` sgd JOIN side_game sg on sgd.side_game_id=sg.side_game_id JOIN ctp_details ctp on sg.side_game_id=ctp.side_game_id JOIN holes h on ctp.hole_id=h.hole_id WHERE sgd.player_id=913 AND sg.round_id=830

---