SELECT * FROM rosters_view LEFT JOIN players ON players.player_id = rosters_view.player_id WHERE rosters_view.visible = '1' AND ( team_id = '144474') AND ( game_id = '1768316') AND ( position = 'g') AND ( gets_decision = '1') GROUP BY roster_id ORDER BY roster_id DESC