It was a Vancouver Canadians home game at the Nat Bailey Stadium in Vancouver BC Canada. I don't remember the score or even the opposing team. All I remembered was the whole stadium stood up and sang along to the song. It was quite something to see a stadium full of people singing to the same song, even if it's only a Minor League stadium.

This is the wikipedia link about that song. The following is an example of what it's like, but for a Major League game.

You don't know take me out to the ballgame? They do play it at every single baseball game during the 7th inning stretch. You need to come across the pond and catch a baseball game my friend.