action: skate-times

Skate Times

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) AND st.hidden = '0'
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 st.hidden = '0'
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 st.hidden = '0'
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.hidden = '0' 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) AND st.hidden = '0'
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 st.hidden = '0' AND c.country = 'United States'
    • Minnesota  (11)
    • Wisconsin  (1)
By Game Type
By Skill Level
By Organizer
By Arena
  • Sunday, November 19, 2017 8:00 AM

    Augsburg College Ice Arena

    Pickup Hockey
    Organized By: Bill Weldon
    75 Minutes — Level 2.5

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

    2323 Riverside Avenue
    Minneapolis, MN 55454
    612-330-1504
  • Sunday, November 19, 2017 9:15 PM

    Bloomington Ice Garden

    Pickup Hockey
    Organized By: mike montouri
    75 Minutes — Level 4 - Intermediate to Advanced

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

    3600 West 98th Street
    Bloomington, MN 55431
    +19525638842
  • Sunday, November 19, 2017 9:45 PM

    Veterans Memorial Community Center

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

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

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Monday, November 20, 2017 10:00 AM

    St. Louis Park

    Women's Ice Hockey
    Organized By: Caitlin Hillen
    75 Minutes — See Notes Below

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

    3700 Monterey Drive
    St. Louis Park, MN 55416
    952-924-2567
  • Tuesday, November 21, 2017 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, November 21, 2017 10:00 PM

    Oscar Johnson Arena

    Pickup Hockey
    Organized By: Street Factory
    60 Minutes — Level 3.5

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

    1039 DeCourcy Circle
    St Paul, MN 55105
    651-643-3000
  • Wednesday, November 22, 2017 9:15 PM

    Shakopee Arena

    Pickup Hockey
    Organized By: chris chu
    60 Minutes — Level 3 - Intermediate

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

    1255 Fuller St
    Shakopee, MN 55379
    952-233-9522
  • Thursday, November 23, 2017 10:00 PM

    Veterans Memorial Community Center — CANCELED

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

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

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Friday, November 24, 2017 9:15 PM

    Brooklyn Park Activity Center

    Pickup Hockey
    Organized By: Chris Norman
    90 Minutes — All are Welcome

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

    5600 85th Avenue N
    Brooklyn Park, MN 55443
    763-493-8245
  • Friday, November 24, 2017 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, November 24, 2017 10:15 PM

    Superior Amateur Hockey Association

    Pickup Hockey
    Organized By: Josh Pettit
    60 Minutes — All are Welcome

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

    1015 Oakes Avenue
    Superior, WI 54880
    (715) 394-4899
  • Saturday, November 25, 2017 10:15 PM

    Brooklyn Park Activity Center

    Pickup Hockey
    Organized By: Chris Norman
    90 Minutes — All are Welcome

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

    5600 85th Avenue N
    Brooklyn Park, MN 55443
    763-493-8245