----Streaks----SELECT * FROM streaks WHERE date BETWEEN ( 1785369600 AND 1785455999 ) AND current_run>'4' AND season='current' ORDER BY date ASC
SELECT * FROM streaks WHERE date > 1785379333 AND current_run>'4' AND season='current' ORDER BY date ASC LIMIT 1
Array
(
[0] => Array
(
[id] => 6052
[type] => win
[event_id] => 120305
[league_id] => 425
[location] => overall
[date] => 1785434400
[team] => 802
[position] => all
[season] => current
[played] => 27
[average] => 85.19
[streak_count] => 23
[updated] => 1785350481
[current_run] => 5
)
)
30-07-2026
18:00
Vestri v Rīgas FS
over15
home
last
100.00
10
10
30-07-2026
18:00
Vestri v Rīgas FS
over15
home
overall
92.31
10
13
30-07-2026
18:00
Vestri v Rīgas FS
over15
home
league
90.91
8
11
30-07-2026
18:00
Vestri v Rīgas FS
unbeaten
home
last
100.00
10
10
30-07-2026
18:00
Vestri v Rīgas FS
unbeaten
all
overall
92.59
9
27
30-07-2026
18:00
Vestri v Rīgas FS
unbeaten
home
overall
92.31
10
13
30-07-2026
18:00
Vestri v Rīgas FS
unbeaten
all
league
91.67
6
24
30-07-2026
18:00
Vestri v Rīgas FS
unbeaten
home
league
90.91
8
11
30-07-2026
18:00
Vestri v Rīgas FS
unbeaten
all
last
90.00
9
10
30-07-2026
18:00
Vestri v Rīgas FS
win
all
overall
85.19
5
27
30-07-2026
18:00
Vestri v Rīgas FS
win
all
last
80.00
5
10
30-07-2026
18:00
CSKA Sofia v Qarabag
unbeaten
all
overall
100.00
5
5
30-07-2026
18:00
CSKA Sofia v Qarabag
unbeaten
all
last
50.00
5
10
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
over15
home
overall
100.00
5
5
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
over15
home
league
100.00
5
5
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
over15
all
overall
92.86
5
14
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
over15
all
league
92.86
5
14
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
over15
all
last
90.00
5
10
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
over15
home
last
50.00
5
10
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
unbeaten
home
overall
100.00
5
5
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
unbeaten
home
league
100.00
5
5
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
unbeaten
all
overall
92.86
6
14
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
unbeaten
all
league
92.86
6
14
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
unbeaten
all
last
90.00
6
10
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
unbeaten
home
last
50.00
5
10
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
win
all
league
78.57
5
14
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
win
all
overall
78.57
5
14
01-08-2026
11:00
Valmiera / BSS v Rīgas FS II
win
all
last
70.00
5
10
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
away
overall
100.00
7
7
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
away
league
100.00
7
7
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
all
last
90.00
9
10
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
all
overall
81.25
9
16
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
all
league
81.25
9
16
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
away
last
70.00
7
10
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
home
overall
66.67
6
9
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
home
league
66.67
6
9
01-08-2026
11:00
Ostersunds FK v Osters IF
over15
home
last
60.00
6
10
01-08-2026
11:00
Ostersunds FK v Osters IF
over25
all
last
80.00
7
10
01-08-2026
11:00
Ostersunds FK v Osters IF
over25
all
league
75.00
7
16
01-08-2026
11:00
Ostersunds FK v Osters IF
over25
all
overall
75.00
7
16
01-08-2026
11:00
Ostersunds FK v Osters IF
over25
home
overall
66.67
6
9
01-08-2026
11:00
Ostersunds FK v Osters IF
over25
home
league
66.67
6
9
01-08-2026
11:00
Ostersunds FK v Osters IF
over25
home
last
60.00
6
10
01-08-2026
13:00
Varbergs BoIS FC v Falkenbergs FF
over15
away
league
100.00
8
8
01-08-2026
13:00
Varbergs BoIS FC v Falkenbergs FF
over15
away
overall
100.00
8
8
01-08-2026
13:00
Varbergs BoIS FC v Falkenbergs FF
over15
all
last
90.00
7
10
01-08-2026
13:00
Varbergs BoIS FC v Falkenbergs FF
over15
all
league
87.50
7
16
01-08-2026
13:00
Varbergs BoIS FC v Falkenbergs FF
over15
all
overall
87.50
7
16
01-08-2026
13:00
Varbergs BoIS FC v Falkenbergs FF
over15
away
last
80.00
8
10
01-08-2026
14:00
Fredrikstad v Sandefjord
over15
home
overall
100.00
6
6
01-08-2026
14:00
Fredrikstad v Sandefjord
over15
home
league
100.00
6
6
01-08-2026
14:00
Fredrikstad v Sandefjord
over15
home
last
60.00
6
10
01-08-2026
14:00
Fredrikstad v Sandefjord
without_win
away
league
87.50
6
8
01-08-2026
14:00
Fredrikstad v Sandefjord
without_win
away
overall
87.50
6
8
01-08-2026
14:00
Fredrikstad v Sandefjord
without_win
away
last
70.00
6
10
01-08-2026
16:00
Riga FC II v Metta / LU
over15
home
league
100.00
8
8
01-08-2026
16:00
Riga FC II v Metta / LU
over15
home
overall
100.00
8
8
01-08-2026
16:00
Riga FC II v Metta / LU
over15
all
league
92.86
7
14
01-08-2026
16:00
Riga FC II v Metta / LU
over15
all
overall
92.86
7
14
01-08-2026
16:00
Riga FC II v Metta / LU
over15
all
last
90.00
7
10
01-08-2026
16:00
Riga FC II v Metta / LU
over15
home
last
80.00
8
10
01-08-2026
16:00
Riga FC II v Metta / LU
over25
all
last
90.00
7
10
01-08-2026
16:00
Riga FC II v Metta / LU
over25
home
overall
87.50
7
8
01-08-2026
16:00
Riga FC II v Metta / LU
over25
home
league
87.50
7
8
01-08-2026
16:00
Riga FC II v Metta / LU
over25
all
overall
85.71
7
14
01-08-2026
16:00
Riga FC II v Metta / LU
over25
all
league
85.71
7
14
01-08-2026
16:00
Riga FC II v Metta / LU
over25
home
last
70.00
7
10
01-08-2026
16:00
Riga FC II v Metta / LU
unbeaten
away
league
100.00
6
6
01-08-2026
16:00
Riga FC II v Metta / LU
unbeaten
away
overall
100.00
6
6
01-08-2026
16:00
Riga FC II v Metta / LU
unbeaten
all
overall
92.86
8
14
01-08-2026
16:00
Riga FC II v Metta / LU
unbeaten
all
league
92.86
8
14
01-08-2026
16:00
Riga FC II v Metta / LU
unbeaten
all
last
90.00
8
10
01-08-2026
16:00
Riga FC II v Metta / LU
unbeaten
away
last
60.00
6
10
01-08-2026
16:00
Riga FC II v Metta / LU
win
all
league
85.71
5
14
01-08-2026
16:00
Riga FC II v Metta / LU
win
all
overall
85.71
5
14
01-08-2026
16:00
Riga FC II v Metta / LU
win
all
last
80.00
5
10
01-08-2026
16:00
Riga FC II v Metta / LU
over15
away
league
100.00
7
7
01-08-2026
16:00
Riga FC II v Metta / LU
over15
all
league
100.00
14
14
01-08-2026
16:00
Riga FC II v Metta / LU
over15
home
overall
100.00
7
7
01-08-2026
16:00
Riga FC II v Metta / LU
over15
all
last
100.00
10
10
01-08-2026
16:00
Riga FC II v Metta / LU
over15
home
league
100.00
7
7
01-08-2026
16:00
Riga FC II v Metta / LU
over15
away
overall
100.00
7
7
01-08-2026
16:00
Riga FC II v Metta / LU
over15
all
overall
100.00
14
14
01-08-2026
16:00
Riga FC II v Metta / LU
over15
home
last
70.00
7
10
01-08-2026
16:00
Riga FC II v Metta / LU
over15
away
last
70.00
7
10
01-08-2026
16:00
Gnistan v KuPS
over15
away
league
100.00
8
8
01-08-2026
16:00
Gnistan v KuPS
over15
home
last
90.00
7
10
01-08-2026
16:00
Gnistan v KuPS
over15
all
league
88.24
10
17
01-08-2026
16:00
Gnistan v KuPS
over15
home
overall
81.82
7
11
01-08-2026
16:00
Gnistan v KuPS
over15
home
league
77.78
5
9
01-08-2026
16:00
Gnistan v KuPS
unbeaten
home
league
100.00
9
9
01-08-2026
16:00
Gnistan v KuPS
unbeaten
all
league
94.12
11
17
01-08-2026
16:00
Gnistan v KuPS
unbeaten
away
league
87.50
5
8
01-08-2026
16:00
Gnistan v KuPS
win
all
league
58.82
5
17
01-08-2026
16:30
Cobresal v Union La Calera
without_win
all
last
80.00
6
10
01-08-2026
16:30
Cobresal v Union La Calera
without_win
all
league
68.75
6
16
01-08-2026
16:30
Cobresal v Union La Calera
without_win
all
overall
68.75
6
16
01-08-2026
19:00
Everton de Vina v Colo Colo
cards_25
away
league
1.00
8
8
01-08-2026
19:00
Everton de Vina v Colo Colo
cards_25
away
overall
1.00
8
8
01-08-2026
19:00
Everton de Vina v Colo Colo
cards_25
away
last
0.80
8
10
01-08-2026
19:00
Everton de Vina v Colo Colo
over15
all
last
70.00
6
10
01-08-2026
19:00
Everton de Vina v Colo Colo
over15
all
league
62.50
6
16
01-08-2026
19:00
Everton de Vina v Colo Colo
over15
all
overall
62.50
6
16
02-08-2026
13:00
Tukums v FK Liepaja
over15
away
last
100.00
10
10
02-08-2026
13:00
Tukums v FK Liepaja
over15
away
league
100.00
12
12
02-08-2026
13:00
Tukums v FK Liepaja
over15
away
overall
100.00
12
12
02-08-2026
13:00
Tukums v FK Liepaja
over25
away
last
90.00
7
10
02-08-2026
13:00
Tukums v FK Liepaja
over25
away
league
83.33
7
12
02-08-2026
13:00
Tukums v FK Liepaja
over25
away
overall
83.33
7
12
02-08-2026
13:00
Tukums v FK Liepaja
without_win
away
league
100.00
12
12
02-08-2026
13:00
Tukums v FK Liepaja
without_win
away
overall
100.00
12
12
02-08-2026
13:00
Tukums v FK Liepaja
without_win
away
last
100.00
10
10
02-08-2026
13:00
Tukums v FK Liepaja
without_win
all
last
90.00
6
10
02-08-2026
13:00
Tukums v FK Liepaja
without_win
all
league
87.50
6
24
02-08-2026
13:00
Tukums v FK Liepaja
without_win
all
overall
87.50
6
24
02-08-2026
14:30
AIK Stockholm v Orgryte IS
unbeaten
away
league
87.50
6
8
02-08-2026
14:30
AIK Stockholm v Orgryte IS
unbeaten
away
overall
87.50
6
8
02-08-2026
14:30
AIK Stockholm v Orgryte IS
unbeaten
away
last
70.00
6
10
02-08-2026
15:00
Riga v Grobiņa
without_win
away
last
90.00
9
10
02-08-2026
15:00
Riga v Grobiņa
without_win
away
league
81.82
9
11
02-08-2026
15:00
Riga v Grobiņa
without_win
away
overall
81.82
9
11
02-08-2026
16:30
Concepción v U. Catolica
cards_25
away
overall
0.88
7
8
02-08-2026
16:30
Concepción v U. Catolica
cards_25
away
league
0.88
7
8
02-08-2026
16:30
Concepción v U. Catolica
cards_25
away
last
0.70
7
10
02-08-2026
16:30
Concepción v U. Catolica
cards_35
away
league
0.88
7
8
02-08-2026
16:30
Concepción v U. Catolica
cards_35
away
overall
0.88
7
8
02-08-2026
16:30
Concepción v U. Catolica
cards_35
away
last
0.70
7
10
02-08-2026
16:30
Concepción v U. Catolica
over15
home
league
87.50
5
8
02-08-2026
16:30
Concepción v U. Catolica
over15
home
overall
87.50
5
8
02-08-2026
16:30
Concepción v U. Catolica
over15
all
overall
75.00
5
16
02-08-2026
16:30
Concepción v U. Catolica
over15
all
league
75.00
5
16
02-08-2026
16:30
Concepción v U. Catolica
over15
home
last
70.00
5
10
02-08-2026
16:30
Concepción v U. Catolica
over15
all
last
70.00
5
10
02-08-2026
17:00
Rīgas FS v Super Nova
over15
home
last
100.00
10
10
02-08-2026
17:00
Rīgas FS v Super Nova
over15
home
overall
92.31
10
13
02-08-2026
17:00
Rīgas FS v Super Nova
over15
home
league
90.91
8
11
02-08-2026
17:00
Rīgas FS v Super Nova
unbeaten
home
last
100.00
10
10
02-08-2026
17:00
Rīgas FS v Super Nova
unbeaten
all
overall
92.59
9
27
02-08-2026
17:00
Rīgas FS v Super Nova
unbeaten
home
overall
92.31
10
13
02-08-2026
17:00
Rīgas FS v Super Nova
unbeaten
all
league
91.67
6
24
02-08-2026
17:00
Rīgas FS v Super Nova
unbeaten
home
league
90.91
8
11
02-08-2026
17:00
Rīgas FS v Super Nova
unbeaten
all
last
90.00
9
10
02-08-2026
17:00
Rīgas FS v Super Nova
win
all
overall
85.19
5
27
02-08-2026
17:00
Rīgas FS v Super Nova
win
all
last
80.00
5
10
02-08-2026
17:15
Brann v Rosenborg
over15
home
league
100.00
8
8
02-08-2026
17:15
Brann v Rosenborg
over15
home
overall
100.00
8
8
02-08-2026
17:15
Brann v Rosenborg
over15
all
league
92.86
9
14
02-08-2026
17:15
Brann v Rosenborg
over15
all
overall
92.86
9
14
02-08-2026
17:15
Brann v Rosenborg
over15
all
last
90.00
9
10
02-08-2026
17:15
Brann v Rosenborg
over15
home
last
80.00
8
10
02-08-2026
18:15
CSKA Sofia v Dunav Ruse
unbeaten
all
overall
100.00
5
5
02-08-2026
18:15
CSKA Sofia v Dunav Ruse
unbeaten
all
last
50.00
5
10
02-08-2026
19:00
D. La Serena v O'Higgins
cards_25
home
league
0.88
7
8
02-08-2026
19:00
D. La Serena v O'Higgins
cards_25
home
overall
0.88
7
8
02-08-2026
19:00
D. La Serena v O'Higgins
cards_25
home
last
0.70
7
10
02-08-2026
19:00
D. La Serena v O'Higgins
cards_35
home
overall
0.88
7
8
02-08-2026
19:00
D. La Serena v O'Higgins
cards_35
home
league
0.88
7
8
02-08-2026
19:00
D. La Serena v O'Higgins
cards_35
home
last
0.70
7
10
02-08-2026
19:00
D. La Serena v O'Higgins
cards_45
home
overall
0.75
6
8
02-08-2026
19:00
D. La Serena v O'Higgins
cards_45
home
league
0.75
6
8
02-08-2026
19:00
D. La Serena v O'Higgins
cards_45
home
last
0.60
6
10
02-08-2026
19:00
D. La Serena v O'Higgins
corners_75
home
overall
0.75
6
8
02-08-2026
19:00
D. La Serena v O'Higgins
corners_75
home
league
0.75
6
8
02-08-2026
19:00
D. La Serena v O'Higgins
corners_75
home
last
0.60
6
10
02-08-2026
19:00
D. La Serena v O'Higgins
without_win
all
last
70.00
5
10
02-08-2026
19:00
D. La Serena v O'Higgins
without_win
all
league
62.50
5
16
02-08-2026
19:00
D. La Serena v O'Higgins
without_win
all
overall
62.50
5
16