The Official Website of the Alberta Junior Hockey League
Array
(
    [0] => Array
        (
            [PLAYERID] => 1646063
            [FIRSTNAME] => Cade
            [LASTNAME] => Mason
            [JERSEY] => 6
            [POSITION] => D
            [PICTURE] => 
            [TEAMID] => 
            [TEAMNAME] => storm
        )

    [1] => Array
        (
            [PLAYERID] => 1742894
            [FIRSTNAME] => Kadyn
            [LASTNAME] => Chabot
            [JERSEY] => 18
            [POSITION] => F
            [PICTURE] => 
            [TEAMID] => 
            [TEAMNAME] => thunder
        )

)
SELECT a.PLAYERID, a.FIRSTNAME, a.LASTNAME, a.JERSEY, a.POSITION, a.PICTURE, b.TEAMID, c.TEAMID, replace(d.name,' ','') AS TEAMNAME FROM tbl_players a LEFT JOIN tbl_players_RS b ON (a.PLAYERID = b.PLAYERID) LEFT JOIN tbl_players_goalies_RS c ON (a.PLAYERID = c.PLAYERID) INNER JOIN tbl_ajhl_teams d ON (b.TEAMID = d.esports_id OR c.TEAMID = d.esports_id)WHERE a.PLAYERID IN ('1742894','1646063','')
+
Player of the Week
Player of the Week
Defensive Player of the Week
Sponsored by
#18 [F]
Kadyn
Chabot ...
Sponsored by
#6 [D]
Cade
Mason ...
League Headlines
...
Team Headlines
...
North Standings
South Standings
Array
(
    [0] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Oil Barons
            [GP] => 4
            [W] => 4
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 8
        )

    [1] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Saints
            [GP] => 4
            [W] => 1
            [L] => 1
            [OTL] => 0
            [OTW] => 1
            [SOW] => 1
            [SOL] => 0
            [PTS] => 6
        )

    [2] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Storm
            [GP] => 4
            [W] => 2
            [L] => 1
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 1
            [PTS] => 5
        )

    [3] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Thunder
            [GP] => 4
            [W] => 2
            [L] => 2
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 4
        )

    [4] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Pontiacs
            [GP] => 4
            [W] => 1
            [L] => 2
            [OTL] => 0
            [OTW] => 1
            [SOW] => 0
            [SOL] => 0
            [PTS] => 4
        )

    [5] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Wolverines
            [GP] => 2
            [W] => 1
            [L] => 0
            [OTL] => 1
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 3
        )

    [6] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Crusaders
            [GP] => 4
            [W] => 0
            [L] => 3
            [OTL] => 1
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 1
        )

    [7] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Bobcats
            [GP] => 2
            [W] => 0
            [L] => 2
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [8] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Oilers
            [GP] => 3
            [W] => 3
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 6
        )

    [9] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Eagles
            [GP] => 2
            [W] => 2
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 4
        )

    [10] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Bandits
            [GP] => 2
            [W] => 2
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 4
        )

    [11] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Canucks
            [GP] => 2
            [W] => 0
            [L] => 2
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [12] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Dragons
            [GP] => 2
            [W] => 0
            [L] => 2
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [13] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Kodiaks
            [GP] => 2
            [W] => 0
            [L] => 2
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [14] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Grizzlys
            [GP] => 1
            [W] => 0
            [L] => 1
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

)
Viterra AJHL North - Regular Season
TEAM GP W L OTL PTS
Oil Barons 4 4 0 0 8
Saints 4 3 1 0 6
Storm 4 2 1 1 5
Thunder 4 2 2 0 4
Pontiacs 4 2 2 0 4
Wolverines 2 1 0 1 3
Crusaders 4 0 3 1 1
Bobcats 2 0 2 0 0
Viterra AJHL South - Regular Season
TEAM GP W L OTL PTS
Oilers 3 3 0 0 6
Eagles 2 2 0 0 4
Bandits 2 2 0 0 4
Canucks 2 0 2 0 0
Dragons 2 0 2 0 0
Kodiaks 2 0 2 0 0
Grizzlys 1 0 1 0 0
Data Feed by esportsdesk.com
AJHL Web TV
Watch this game on AJHL Web TV