action: skate-times

Skate Times - Minnesota

If you'd like to organize a game in this area using HockeyFinder, click here.

SELECT c.country, COUNT(c.country) as gamecount FROM skate_times st inner join centers c on st.centerid = c.centerid LEFT OUTER JOIN invited_players i ON st.skatetimeid = i.skatetimeid AND i.player_username = 'GuestUser' WHERE st.scheduleddate > CURDATE() AND st.scheduleddate <= DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND (1 = 0 OR st.private = 0 OR st.username = 'GuestUser' OR i.player_username IS NOT NULL)
SELECT st.skatetype, count(st.skatetype) as gamecount FROM skate_times st inner join centers c on st.centerid = c.centerid LEFT OUTER JOIN invited_players i ON st.skatetimeid = i.skatetimeid AND i.player_username = 'GuestUser' WHERE st.scheduleddate > CURDATE() AND st.scheduleddate <= DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND (1 = 0 OR st.private = 0 OR st.username = 'GuestUser' OR i.player_username IS NOT NULL) AND c.state = 'MN'
SELECT st.skilllevel, count(st.skilllevel) as gamecount FROM skate_times st inner join centers c on st.centerid = c.centerid LEFT OUTER JOIN invited_players i ON st.skatetimeid = i.skatetimeid AND i.player_username = 'GuestUser' WHERE st.scheduleddate > CURDATE() AND st.scheduleddate <= DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND (1 = 0 OR st.private = 0 OR st.username = 'GuestUser' OR i.player_username IS NOT NULL) AND c.state = 'MN'
SELECT st.username as organizer, COUNT(st.username) as gamecount FROM skate_times st inner join centers c on st.centerid = c.centerid LEFT OUTER JOIN invited_players i ON st.skatetimeid = i.skatetimeid AND i.player_username = 'GuestUser' WHERE (1 = 0 OR st.private = 0 OR st.username = 'GuestUser' OR i.player_username IS NOT NULL) AND st.scheduleddate > CURDATE() AND c.state = 'MN'
SELECT c.centername, c.centerid, COUNT(c.centername) as gamecount FROM skate_times st inner join centers c on st.centerid = c.centerid LEFT OUTER JOIN invited_players i ON st.skatetimeid = i.skatetimeid AND i.player_username = 'GuestUser' WHERE st.scheduleddate > CURDATE() AND st.scheduleddate <= DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND (1 = 0 OR st.private = 0 OR st.username = 'GuestUser' OR i.player_username IS NOT NULL) AND c.state = 'MN'
By Region
  • United States
    • SELECT c.statename, c.state, COUNT(c.state) as gamecount FROM skate_times st inner join centers c on st.centerid = c.centerid LEFT OUTER JOIN invited_players i ON st.skatetimeid = i.skatetimeid AND i.player_username = 'GuestUser' WHERE st.scheduleddate > CURDATE() AND st.scheduleddate <= DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND (1 = 0 OR st.private = 0 OR st.username = 'GuestUser' OR i.player_username IS NOT NULL) AND c.country = 'United States'
    • Indiana  (1)
    • Minnesota  (22)
    • Pennsylvania  (1)
    • Wisconsin  (1)
By Game Type
By Skill Level
By Organizer
By Arena
  • Friday, December 9, 2016 9:25 PM

    Maple Grove Community Center

    Pickup Hockey
    Organized By: MAPLE GROVE HC TORPEDO
    100 Minutes — Level 4 - Intermediate to Advanced

    11 player spot(s) and 1 goalie spot(s) remaining

    12951 Weaver Lake Rd
    Maple Grove, MN 55369
    763-494-6500
  • Friday, December 9, 2016 9:30 PM

    Vadnais Sports Center

    Pickup Hockey
    Organized By: Ben Gulsvig
    60 Minutes — Level 3 - Intermediate

    13 player spot(s) and 2 goalie spot(s) remaining

    1490 County Road East
    Vadnais Heights, MN 55110
    651-481-1000
  • Friday, December 9, 2016 9:40 PM

    Minnesota Made Ice Center

    Pickup Hockey
    Organized By: Go Hockey
    90 Minutes — Level 3 - Intermediate

    1 player spot(s) and 1 goalie spot(s) remaining

    7300 Bush Lake Road
    Edina, MN 55439
    952-746-5728
  • Friday, December 9, 2016 9:45 PM

    Bloomington Ice Garden

    Pickup Hockey
    Organized By: Peter Tschida
    60 Minutes — All are Welcome

    4 player spot(s) and 0 goalie spot(s) remaining

    3600 West 98th Street
    Bloomington, MN 55431
    +19525638842
  • Friday, December 9, 2016 9:50 PM

    Minnesota Made Ice Center

    Pickup Hockey
    Organized By: Minnesota Beginner Hockey
    90 Minutes — Level 2 - Beginner to Intermediate

    9 player spot(s) and 2 goalie spot(s) remaining

    7300 Bush Lake Road
    Edina, MN 55439
    952-746-5728
  • Friday, December 9, 2016 10:00 PM

    Fogerty Arena

    Pickup Hockey
    Organized By: Friday Night Hockey Club
    90 Minutes — Level 4 - Intermediate to Advanced

    0 player spot(s) and 0 goalie spot(s) remaining

    9250 Lincoln St NE
    Blaine, MN 55434
    763-780-3328
  • Friday, December 9, 2016 10:00 PM

    Schwan Super Rink

    Pickup Hockey
    Organized By: HockeyFinder Minnesota
    90 Minutes — All are Welcome

    3 player spot(s) and 1 goalie spot(s) remaining

    1700 105th Ave NE
    Blaine, MN 55449
    7637173881
  • Saturday, December 10, 2016 10:00 PM

    Minnesota Made Ice Center

    Pickup Hockey
    Organized By: HockeyFinder Minnesota
    90 Minutes — Level 1.5

    17 player spot(s) and 2 goalie spot(s) remaining

    7300 Bush Lake Road
    Edina, MN 55439
    952-746-5728
  • Saturday, December 10, 2016 10:00 PM

    FLAAA Sports Center - Lichtscheidl Arena

    Pickup Hockey
    Organized By: Wife Escape
    120 Minutes — Level 3 - Intermediate

    1 player spot(s) and 0 goalie spot(s) remaining

    5530 206th St. N
    Forest Lake, MN 55025
    651-464-0176
  • Saturday, December 10, 2016 10:10 PM

    Minnesota Made Ice Center

    Pickup Hockey
    Organized By: HockeyFinder Minnesota
    90 Minutes — Level 3 - Intermediate

    19 player spot(s) and 2 goalie spot(s) remaining

    7300 Bush Lake Road
    Edina, MN 55439
    952-746-5728
  • Sunday, December 11, 2016 8:30 AM

    Polar Arena

    Pickup Hockey
    Organized By: Sunday Hockey
    75 Minutes — Level 3.5

    0 player spot(s) and 0 goalie spot(s) remaining

    2520 E. 12th Ave.
    North St. Paul, MN 55109
    651-748-6292
  • Sunday, December 11, 2016 9:45 PM

    Veterans Memorial Community Center

    Pickup Hockey
    Organized By: Matt Wolf
    60 Minutes — Level 5 - Advanced

    8 player spot(s) and 0 goalie spot(s) remaining

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Monday, December 12, 2016 9:45 PM

    Veterans Memorial Community Center

    Pickup Hockey
    Organized By: Flyers Hockey
    75 Minutes — Level 2 - Beginner to Intermediate

    7 player spot(s) and 1 goalie spot(s) remaining

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Tuesday, December 13, 2016 8:15 PM

    Parade Ice Garden

    Pickup Hockey
    Organized By: 3on3 Hockey
    90 Minutes — Level 2 - Beginner to Intermediate

    0 player spot(s) and 0 goalie spot(s) remaining

    600 Kenwood Pkwy
    Minneapolis, MN 55403
    6123704846
  • Tuesday, December 13, 2016 10:00 PM

    Oscar Johnson Arena

    Pickup Hockey
    Organized By: Street Factory
    60 Minutes — Level 3 - Intermediate

    0 player spot(s) and 0 goalie spot(s) remaining

    1039 DeCourcy Circle
    St Paul, MN 55105
    651-643-3000
  • Wednesday, December 14, 2016 9:00 PM

    1st Athlete

    Pickup Lacrosse
    Organized By: Seth Scott
    60 Minutes — All are Welcome

    20 player spot(s) and 0 goalie spot(s) remaining

    7101 Amundson Ave
    Edina, MN 55439
  • Wednesday, December 14, 2016 9:20 PM

    Bloomington Ice Garden

    Pickup Hockey
    Organized By: Tyler Schrupp
    90 Minutes — Level 3 - Intermediate

    4 player spot(s) and 2 goalie spot(s) remaining

    3600 West 98th Street
    Bloomington, MN 55431
    +19525638842
  • Wednesday, December 14, 2016 10:00 PM

    Augsburg College Ice Arena

    Pickup Hockey
    Organized By: Vance Trendov
    90 Minutes — Level 5 - Advanced

    20 player spot(s) and 2 goalie spot(s) remaining

    2323 Riverside Avenue
    Minneapolis, MN 55454
    612-330-1504
  • Wednesday, December 14, 2016 10:00 PM

    Buffalo Civic Center

    Pickup Hockey
    Organized By: Josh S
    75 Minutes — Level 4 - Intermediate to Advanced

    4 player spot(s) and 0 goalie spot(s) remaining

    1306 Calder Ave
    Buffalo, MN 55313
    763-682-4132
  • Thursday, December 15, 2016 7:40 PM

    Oscar Johnson Arena

    Pickup Hockey
    Organized By: Scott Hamilton
    60 Minutes — Level 2 - Beginner to Intermediate

    18 player spot(s) and 2 goalie spot(s) remaining

    1039 DeCourcy Circle
    St Paul, MN 55105
    651-643-3000
  • Thursday, December 15, 2016 10:00 PM

    Veterans Memorial Community Center

    Pickup Hockey
    Organized By: JOHN RITTER
    60 Minutes — All are Welcome

    5 player spot(s) and 0 goalie spot(s) remaining

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Thursday, December 15, 2016 10:15 PM

    Tartan Arena

    Pickup Hockey
    Organized By: timmy goebel
    60 Minutes — All are Welcome

    20 player spot(s) and 2 goalie spot(s) remaining

    740 Greenway Ave N
    Oakdale, MN 55128
    651-714-9251