Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
#
Nom du joueur
Nom de l’équipe
POS
GP
G
A
P
+/-
PIM
PIM5
HIT
HTT
SHT
OSB
OSM
SHT%
SB
MP
AMG
PPG
PPA
PPP
PPS
PPM
PKG
PKA
PKP
PKS
PKM
GW
GT
FO%
FOT
GA
TA
EG
HT
P/20
PSG
PSS
FW
FL
FT
S1
S2
S3
Astuces sur les filtres (anglais seulement)
Priority
Type
Description
1
| or OR
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
#
Nom du gardien
Nom de l’équipe
GP
W
L
OTL
PCT
GAA
MP
PIM
SO
GA
SA
SAR
A
EG
PS %
PSA
ST
BG
S1
S2
S3
Astuces sur les filtres (anglais seulement)
Priority
Type
Description
1
| or OR
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Victor Mete, Miro Heiskanen, Jack Johnson, Justin Schultz, Will Butcher
Astuces sur les filtres (anglais seulement)
Priority
Type
Description
1
| or OR
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Jour
Match
Équipe visiteuse
Score
Équipe locale
Score
ST
OT
SO
RI
Lien
Capacité de l’aréna - Tendance du prix des billets - %
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Espoir
Nom de l’équipe
Année de repêchage
Choix total
Information
Lien
Aku Raty
Oilers
Cameron Berg
Oilers
2
129
Cameron MacDonald
Oilers
2
161
Carson Bantle
Oilers
Daniil Chayka
Oilers
2
33
David Quenneville
Oilers
Dawson Mercer
Oilers
Dmitri Kostenko
Oilers
2
89
Hendrix Lapierre
Oilers
Ilya Solovyov
Oilers
Jacob Bernard-Docker
Oilers
Jeremiah Addison
Oilers
Joshua Roy
Oilers
2
65
Mathias Laferriere
Oilers
Mavrik Bourque
Oilers
Nathan Legare
Oilers
Nikita Chibrikov
Oilers
2
31
Owen Power
Oilers
2
1
Patrik Hamrla
Oilers
2
91
Taige Harding
Oilers
2
97
Tyson Kozak
Oilers
2
193
William Wallinder
Oilers
Yaroslav Askarov
Oilers
Choix au repêchage
Année
R1
R2
R3
R4
R5
R6
R7
3
4
5
6
7
La base de données des nouvelles n'a pas été trouvée. Veuillez en créer une du STHS.
[2022-05-02 15:28:00] - Condors didn't make playoff for year 2. [2022-05-02 15:28:00] - Oilers didn't make playoff for year 2. [2022-03-21 18:36:51] - TRADE : From Flyers to Oilers : Y:1-RND:0-. [2022-03-21 18:36:51] - TRADE : From Oilers to Flyers : Antoine Roussel (65). [2022-03-21 18:36:46] - TRADE : From Canucks to Oilers : Jordan Oesterle (67), Ryan Reaves (61), Y:1-RND:0-, Y:1-RND:0-. [2022-03-21 18:36:46] - TRADE : From Oilers to Canucks : Mattias Ekholm (73), Y:5-RND:1-VAN. [2022-03-21 15:40:51] - TRADE : From Flyers to Oilers : Y:3-RND:3-PHI. [2022-03-21 15:40:51] - TRADE : From Oilers to Flyers : Antoine Roussel. [2022-03-21 15:40:43] - TRADE : From Canucks to Oilers : Jordan Oesterle, Ryan Reaves, Y:5-RND:1-VAN, Y:6-RND:2-VAN. [2022-03-21 15:40:43] - TRADE : From Oilers to Canucks : Mattias Ekholm, Y:3-RND:5-EDM. [2022-03-16 20:03:06] - New Record for Team's Most Penalties Minutes (39) in 1 Game for Oilers! [2022-02-21 18:19:13] - TRADE : From Ducks to Oilers : Y:4-RND:4-ANA, Y:3-RND:3-BUF. [2022-02-21 18:19:13] - TRADE : From Oilers to Ducks : Brandon Duhaime. [2022-02-12 19:01:34] - New Record for Team's Most Shots (47) in 1 Game for Oilers! [2022-01-31 18:52:28] - New Record for Team's Most Hits (32) in 1 Game for Oilers! [2022-01-23 20:55:33] - TRADE : From Oilers to Blues : Nikita Zadorov. [2022-01-23 20:55:33] - TRADE : From Blues to Oilers : Mattias Ekholm. [2021-12-27 18:54:20] - New Record for Team's Most Shots (46) in 1 Game for Oilers! [2021-11-14 19:26:36] - New Record for Team's Most Shots Blocked (19) in 1 Game for Oilers! [2021-11-09 20:32:26] - New Record for Team's Most Penalties Minutes (33) in 1 Game for Oilers! [2021-10-31 19:22:26] - TRADE : From Oilers to Capitals : William Karlsson, Y:1-RND:0-. [2021-10-31 19:22:26] - TRADE : From Capitals to Oilers : Tyler Seguin. [2021-10-31 19:13:38] - TRADE : From Oilers to Capitals : William Karlsson, Y:1-RND:0-. [2021-10-31 19:13:38] - TRADE : From Capitals to Oilers : Tyler Seguin. [2021-10-31 19:13:09] - TRADE : From Oilers to Capitals : William Karlsson, Y:1-RND:0-. [2021-10-31 19:13:09] - TRADE : From Capitals to Oilers : Tyler Seguin. [2021-10-31 19:09:12] - Tyler Bertuzzi has been selected as assistant for Oilers. [2021-10-31 19:09:11] - Unknown Player is no longer as assistant for Oilers. [2021-10-31 19:09:02] - Tyler Seguin has been selected as assistant for Oilers. [2021-10-31 19:09:02] - Tyler Bertuzzi is no longer as assistant for Oilers. [2021-10-31 19:08:06] - TRADE : From Oilers to Capitals : William Karlsson, Y:3-RND:2-EDM. [2021-10-31 19:08:06] - TRADE : From Capitals to Oilers : Tyler Seguin.
[2022-04-07 18:55:48] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-03-28 21:54:16] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-03-22 20:32:32] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-03-22 20:32:25] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-03-21 18:36:51] TRADE : From Flyers to Oilers : Y:1-RND:0-.
[2022-03-21 18:36:51] TRADE : From Oilers to Flyers : Antoine Roussel (65).
[2022-03-21 18:36:46] TRADE : From Canucks to Oilers : Jordan Oesterle (67), Ryan Reaves (61), Y:1-RND:0-, Y:1-RND:0-.
[2022-03-21 18:36:46] TRADE : From Oilers to Canucks : Mattias Ekholm (73), Y:5-RND:1-VAN.
[2022-03-21 15:40:51] TRADE : From Flyers to Oilers : Y:3-RND:3-PHI.
[2022-03-21 15:40:51] TRADE : From Oilers to Flyers : Antoine Roussel.
[2022-03-21 15:40:43] TRADE : From Canucks to Oilers : Jordan Oesterle, Ryan Reaves, Y:5-RND:1-VAN, Y:6-RND:2-VAN.
[2022-03-21 15:40:43] TRADE : From Oilers to Canucks : Mattias Ekholm, Y:3-RND:5-EDM.
[2022-03-16 20:03:06] New Record for Team's Most Penalties Minutes (39) in 1 Game for Oilers!
[2022-03-09 18:57:37] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-03-09 18:57:00] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.