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'
    •   (1)
    • Minnesota  (13)
    • Missouri  (2)
    • Wisconsin  (1)
By Game Type
By Skill Level
By Organizer
By Arena
  • Thursday, September 20, 2018 9:30 PM

    Drake Arena (St Paul Academy)

    Pickup Hockey
    Organized By: Casimir Semlak
    75 Minutes — Level 3.5

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

    1712 Randolph Ave
    St Paul, MN 55105
    651-698-2451
  • Friday, September 21, 2018 7:50 PM

    Pleasant Arena

    Pickup Hockey
    Organized By: Moose Hockey
    90 Minutes — All are Welcome

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

    848 Pleasant Ave
    St Paul, MN 55102
    651-215-9030
  • Friday, September 21, 2018 8:00 PM

    Superior Amateur Hockey Association

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

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

    1015 Oakes Avenue
    Superior, WI 54880
    (715) 394-4899
  • Friday, September 21, 2018 9:40 PM

    Minnesota Made Ice Center

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

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

    7300 Bush Lake Road
    Edina, MN 55439
    952-746-5728
  • Friday, September 21, 2018 9:50 PM

    Minnesota Made Ice Center

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

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

    7300 Bush Lake Road
    Edina, MN 55439
    952-746-5728
  • Friday, September 21, 2018 10:00 PM

    Fogerty Arena

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

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

    9250 Lincoln St NE
    Blaine, MN 55434
    763-780-3328
  • Friday, September 21, 2018 10:00 PM

    Coon Rapids Ice Center — CANCELED

    Pickup Hockey
    Organized By: Joe Perrella
    90 Minutes — All are Welcome

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

    11000 Crooked Lake Blvd
    Coon Rapids, MN 55433
    763-951-7222
  • Saturday, September 22, 2018 9:00 PM

    Minnesota Made Ice Center

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

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

    7300 Bush Lake Road
    Edina, MN 55439
    952-746-5728
  • Sunday, September 23, 2018 8:30 PM

    Blake Ice Arena

    Pickup Hockey
    Organized By: Church League
    75 Minutes — Level 2.5

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

    110 Blake Road South
    Hopkins, MN 55343
  • Sunday, September 23, 2018 9:00 PM

    City of Creve Coeur Ice Arena

    Pickup Hockey
    Organized By: Nate Kolda (for Jim Sheldon)
    90 Minutes — All are Welcome

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

    11400 Old Cabin Rd
    Creve Coeur, MO 63141
    314-432-3960
  • Monday, September 24, 2018 9:10 PM

    Veterans Memorial Community Center

    Pickup Hockey
    Organized By: Flyers Hockey
    70 Minutes — Level 2.9

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

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Monday, September 24, 2018 10:15 PM

    Hayes Arena

    Pickup Hockey
    Organized By: derrik dyka
    60 Minutes — Level 2.5

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

    14605 Hayes Rd
    Apple Valley, MN 55124
    952-953-2365
  • Tuesday, September 25, 2018 9:40 PM

    Veterans Memorial Community Center

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

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

    8055 Barbara Avenue East
    Inver Grove Heights, MN 55077
    651-450-2514
  • Tuesday, September 25, 2018 10:00 PM

    Vadnais Sports Center

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

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

    1490 County Road East
    Vadnais Heights, MN 55110
    651-481-1000
  • Wednesday, September 26, 2018 12:00 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
  • Wednesday, September 26, 2018 9:45 PM

    TRIA Rink — CANCELED

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

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

    400 Wabasha St N
    St Paul, MN 55101
    651-726-TRIA
  • Wednesday, September 26, 2018 10:15 PM

    City of Creve Coeur Ice Arena

    Pickup Hockey
    Organized By: Nate Kolda (for Jim Sheldon)
    90 Minutes — All are Welcome

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

    11400 Old Cabin Rd
    Creve Coeur, MO 63141
    314-432-3960