The Official Website of the Alberta Junior Hockey League
Array
(
    [0] => Array
        (
            [PLAYERID] => 1770873
            [FIRSTNAME] => Grayson
            [LASTNAME] => Dietrich
            [JERSEY] => 13
            [POSITION] => F
            [PICTURE] => /media/leagues/1705/graphics/dietrich.jpg
            [TEAMID] => 
            [TEAMNAME] => dragons
        )

    [1] => Array
        (
            [PLAYERID] => 1635715
            [FIRSTNAME] => Easton
            [LASTNAME] => Hesse
            [JERSEY] => 29
            [POSITION] => G
            [PICTURE] => /media/leagues/1705/graphics/hesse.JPG
            [TEAMID] => 553996
            [TEAMNAME] => pontiacs
        )

)
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_EX b ON (a.PLAYERID = b.PLAYERID) LEFT JOIN tbl_players_goalies_EX 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 ('1770873','1635715','')
+
Player of the Week
Player of the Week
Defensive Player of the Week
Sponsored by
#13 [F]
Grayson
Dietrich ...
Sponsored by
#29 [G]
Easton
Hesse ...
League Headlines
...
Team Headlines
...
North Standings
South Standings
Array
(
    [0] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102612
            [TEAMSHORT] => Thunder
            [GP] => 5
            [W] => 4
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 1
            [SOL] => 0
            [PTS] => 10
        )

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

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

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

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

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

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

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

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

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

    [10] => Array
        (
            [SEASONID] => 60409
            [DIVID] => 102613
            [TEAMSHORT] => Canucks
            [GP] => 6
            [W] => 2
            [L] => 1
            [OTL] => 3
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 7
        )

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

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

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

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

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