The Official Website of the Alberta Junior Hockey League
Array
(
    [0] => Array
        (
            [PLAYERID] => 1742312
            [FIRSTNAME] => Corson
            [LASTNAME] => Ceulemans
            [JERSEY] => 4
            [POSITION] => D
            [PICTURE] => /media/leagues/1705/graphics/corsonceulemans.jpg
            [TEAMID] => 
            [TEAMNAME] => bandits
        )

    [1] => Array
        (
            [PLAYERID] => 1774684
            [FIRSTNAME] => Evan
            [LASTNAME] => Fradette
            [JERSEY] => 1
            [POSITION] => G
            [PICTURE] => /media/leagues/1705/graphics/evan_fradette.jpg
            [TEAMID] => 553995
            [TEAMNAME] => oilbarons
        )

)
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 ('1774684','1742312','')
+
Player of the Week
Player of the Week
Defensive Player of the Week
Sponsored by
#1 [G]
Evan
Fradette ...
Sponsored by
#4 [D]
Corson
Ceulemans ...
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