Cacher is the code snippet organizer for pro developers

SELECT game.*
    FROM game
    LEFT JOIN user_game 
    ON 
        user_game.game_id = game.id
    WHERE user_game.user_id = 1