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'
    • Minnesota  (9)
By Game Type
By Skill Level
By Organizer
By Arena
  • Sunday, April 30, 2017 9:00 AM

    Brooklyn Park Activity Center

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

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

    5600 85th Avenue N
    Brooklyn Park, MN 55443
    763-493-8245
  • Sunday, April 30, 2017 8:30 PM

    Waconia Ice Arena

    Open Hockey
    Organized By: Gunnar Nagy
    90 Minutes — All are Welcome

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

    1250 Oak Avenue
    Waconia, MN 55387
    (952) 442-RINK
  • Sunday, April 30, 2017 8:50 PM

    Veterans Memorial Community Center

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

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

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Tuesday, May 2, 2017 9:00 PM

    West St Paul Arena

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

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

    60 Emerson Ave W
    West St Paul, MN 55118
    651-552-4155
  • Wednesday, May 3, 2017 3:30 PM

    Waconia Ice Arena

    Parent/Child
    Organized By: Gunnar Nagy
    75 Minutes — See Notes Below

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

    1250 Oak Avenue
    Waconia, MN 55387
    (952) 442-RINK
  • Thursday, May 4, 2017 8:20 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, May 4, 2017 8:45 PM

    Municipal Athletic Complex - MAC

    Pickup Hockey
    Organized By: Don Giroux
    60 Minutes — Level 3 - Intermediate

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

    5001 Veterans Drive
    St. Cloud, MN 56303
    320-255-7223
  • Thursday, May 4, 2017 9:30 PM

    Municipal Athletic Complex - MAC

    Pickup Hockey
    Organized By: Don Giroux
    60 Minutes — Level 3 - Intermediate

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

    5001 Veterans Drive
    St. Cloud, MN 56303
    320-255-7223
  • Friday, May 5, 2017 10:00 PM

    Fogerty Arena

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

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

    9250 Lincoln St NE
    Blaine, MN 55434
    763-780-3328