The Official Website of the Alberta Junior Hockey League
Array
(
    [0] => Array
        (
            [PLAYERID] => 1379764
            [FIRSTNAME] => Cody
            [LASTNAME] => Laskosky
            [JERSEY] => 26
            [POSITION] => F
            [PICTURE] => /media/leagues/1705/graphics/cody_laskosky.jpg
            [TEAMID] => 
            [TEAMNAME] => kodiaks
        )

    [1] => Array
        (
            [PLAYERID] => 1611366
            [FIRSTNAME] => Cayden
            [LASTNAME] => Shmyr
            [JERSEY] => 2
            [POSITION] => LD
            [PICTURE] => /media/leagues/1705/graphics/shmyr.JPG
            [TEAMID] => 
            [TEAMNAME] => pontiacs
        )

    [2] => Array
        (
            [PLAYERID] => 1770873
            [FIRSTNAME] => Grayson
            [LASTNAME] => Dietrich
            [JERSEY] => 16
            [POSITION] => F
            [PICTURE] => /media/leagues/1705/graphics/dietrich.jpg
            [TEAMID] => 
            [TEAMNAME] => dragons
        )

)
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_PO b ON (a.PLAYERID = b.PLAYERID) LEFT JOIN tbl_players_goalies_PO 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','1611366','1379764')
+
Player of the Week
Player of the Week
Defensive Player of the Week
Player of the Month
Sponsored by
#16 [F]
Grayson
Dietrich ...
Sponsored by
#2 [LD]
Cayden
Shmyr ...
Sponsored by
#26 [F]
Cody
Laskosky ...
League Headlines
...
Team Headlines
...
North Standings
South Standings
Array
(
    [0] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98397
            [TEAMSHORT] => Saints
            [GP] => 6
            [W] => 2
            [L] => 1
            [OTL] => 1
            [OTW] => 2
            [SOW] => 0
            [SOL] => 0
            [PTS] => 9
        )

    [1] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98397
            [TEAMSHORT] => Wolverines
            [GP] => 6
            [W] => 3
            [L] => 2
            [OTL] => 0
            [OTW] => 1
            [SOW] => 0
            [SOL] => 0
            [PTS] => 8
        )

    [2] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98397
            [TEAMSHORT] => Thunder
            [GP] => 6
            [W] => 2
            [L] => 2
            [OTL] => 0
            [OTW] => 2
            [SOW] => 0
            [SOL] => 0
            [PTS] => 8
        )

    [3] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98397
            [TEAMSHORT] => Pontiacs
            [GP] => 6
            [W] => 2
            [L] => 2
            [OTL] => 2
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 6
        )

    [4] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98397
            [TEAMSHORT] => Storm
            [GP] => 6
            [W] => 1
            [L] => 2
            [OTL] => 2
            [OTW] => 1
            [SOW] => 0
            [SOL] => 0
            [PTS] => 6
        )

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

    [6] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98397
            [TEAMSHORT] => Bobcats
            [GP] => 0
            [W] => 0
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [7] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98397
            [TEAMSHORT] => Crusaders
            [GP] => 0
            [W] => 0
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [8] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98398
            [TEAMSHORT] => Dragons
            [GP] => 5
            [W] => 3
            [L] => 1
            [OTL] => 0
            [OTW] => 1
            [SOW] => 0
            [SOL] => 0
            [PTS] => 8
        )

    [9] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98398
            [TEAMSHORT] => Kodiaks
            [GP] => 7
            [W] => 4
            [L] => 3
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 8
        )

    [10] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98398
            [TEAMSHORT] => Eagles
            [GP] => 7
            [W] => 3
            [L] => 4
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 6
        )

    [11] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98398
            [TEAMSHORT] => Grizzlys
            [GP] => 5
            [W] => 1
            [L] => 3
            [OTL] => 1
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 3
        )

    [12] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98398
            [TEAMSHORT] => Bandits
            [GP] => 0
            [W] => 0
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [13] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98398
            [TEAMSHORT] => Canucks
            [GP] => 0
            [W] => 0
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

    [14] => Array
        (
            [SEASONID] => 57841
            [DIVID] => 98398
            [TEAMSHORT] => Oilers
            [GP] => 0
            [W] => 0
            [L] => 0
            [OTL] => 0
            [OTW] => 0
            [SOW] => 0
            [SOL] => 0
            [PTS] => 0
        )

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