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)
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'
    • Minnesota  (11)
    • Wisconsin  (2)
By Game Type
By Skill Level
By Organizer
By Arena
  • Sunday, June 25, 2017 9:30 AM

    New Hope Ice Arena

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

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

    4949 Louisiana Ave N
    New Hope, MN 55428
    763-531-5181
  • Sunday, June 25, 2017 7:00 PM

    Superior Amateur Hockey Association — CANCELED

    Pickup Hockey
    Organized By: Twin Ports Hockey - Eckman
    60 Minutes — Level 2 - Beginner to Intermediate

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

    1015 Oakes Avenue
    Superior, WI 54880
    (715) 394-4899
  • Monday, June 26, 2017 8:10 PM

    Fogerty Arena

    Pickup Hockey
    Organized By: Don Giroux
    60 Minutes — Level 2.5

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

    9250 Lincoln St NE
    Blaine, MN 55434
    763-780-3328
  • Monday, June 26, 2017 9:15 PM

    Bloomington Ice Garden

    Pickup Hockey
    Organized By: Michael Watkins
    60 Minutes — Level 4 - Intermediate to Advanced

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

    3600 West 98th Street
    Bloomington, MN 55431
    +19525638842
  • Monday, June 26, 2017 9:20 PM

    Fogerty Arena

    Pickup Hockey
    Organized By: Don Giroux
    60 Minutes — Level 3.5

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

    9250 Lincoln St NE
    Blaine, MN 55434
    763-780-3328
  • Tuesday, June 27, 2017 9:40 PM

    Saint Thomas Ice Arena

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

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

    950 Mendota Heights Road
    Mendota Heights, MN 55120
  • Thursday, June 29, 2017 7:30 PM

    Pleasant Arena

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

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

    848 Pleasant Ave
    St Paul, MN 55102
    651-215-9030
  • Thursday, June 29, 2017 9:15 PM

    Bloomington Ice Garden

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

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

    3600 West 98th Street
    Bloomington, MN 55431
    +19525638842
  • Thursday, June 29, 2017 9:25 PM

    West St Paul Arena

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

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

    60 Emerson Ave W
    West St Paul, MN 55118
    651-552-4155
  • Thursday, June 29, 2017 10:20 PM

    Highland Arena — CANCELED

    Pickup Hockey
    Organized By: Kevin Bergquist
    60 Minutes — Level 3.5

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

    800 S Snelling Ave
    St Paul, MN 55116
    651-695-3766
  • Friday, June 30, 2017 8: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, June 30, 2017 8:30 PM

    Superior Amateur Hockey Association

    Pickup Hockey
    Organized By: Twin Ports Hockey - Eckman
    60 Minutes — Level 3 - Intermediate

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

    1015 Oakes Avenue
    Superior, WI 54880
    (715) 394-4899
  • Saturday, July 1, 2017 8:15 AM

    Richfield Ice Arena

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

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

    636 East 66th Street
    Richfield, MN 55423
    612-861-9351