action: skate-times

Skate Times At Minnesota Made Ice Center

7300 Bush Lake Road
Edina, MN 55439

(952) 746-5728
http://www.minnesotamadehockey.com/
Rink managers -- update your info!

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)
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)
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()
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)
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: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: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
  • 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: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