FootyHub - Copa del Rey
Setting
Change Display Format
Percentage (%)
Fractonal (1/4)
Change Fixture Scrolling
Scroll All Leagues
Quick
Fixtures
Results
Table
Goals
Players
Corners
Cards
Login
Change Theme
Streaks
League Ordering
Stats Ordering
Report Issue
Share to Facebook
Share to X
REGISTER
LOGIN
Login
Username / Email
Password
Keep me signed in?
(Uses cookies)
Fotgot password?
Login
Back to login
Forgot Password
Email
Reset Passord
Verification
Please check your emails and click the link to verify your account!
Resgister
Email
Username
Password
Repeat Password
Avatar
Register
RL
RT
RCF
Reset
ST
Up Teams
TEST



thjis is a test
Array ( [total_goals] => 410 [total_home_goals] => 148 [total_away_goals] => 262 )

SELECT events.id,events.time,events.home_team,events.away_team,events.status,events.statistics,events.league,events.has_agg,events.agg_event, stats.home_goals,stats.home_goals_et,stats.home_goals_pen, events.time_45,events.time_90, stats.away_goals,stats.away_goals_et,stats.away_goals_pen, stats.time as game_time, events.txt_file_updated,events.round, events.home_full_stats,events.away_full_stats, events.group_id, ht.name as home_name,at.name as away_name, ht.team_data_updated as home_updated,at.team_data_updated as away_updated, ht.logo as home_logo,at.logo as away_logo,leagues.international, leagues.name as league_name,leagues.name_off as lno, leagues.id as league_id,leagues.type,leagues.abv as league_abv ,leagues.list_order, leagues.fixtures_updated, country.name as country_name,country.id as country_id, league_groups.name as group_desc, seasons.reg_fixtures,seasons.fixtures FROM events LEFT JOIN statistics_v2 as stats ON stats.event_id=events.id LEFT JOIN seasons ON seasons.id=events.season LEFT JOIN ( SELECT fixtures_updated,name,name_off,id,type,abv,list_order,country,active,international FROM leagues ) leagues ON leagues.id=events.league LEFT JOIN league_groups ON league_groups.id=events.group_id INNER JOIN teams ht ON ht.id=events.home_team INNER JOIN teams at ON at.id=events.away_team INNER JOIN country ON leagues.country=country.id WHERE (( events.time BETWEEN 1770854400 AND 1772668799 ) OR ( events.status='1H' OR events.status='HT' OR events.status='2H' )) AND events.status!='PST' AND events.status!='FT' AND events.status!='AET' AND events.status!='PEN' AND events.league='288' AND leagues.active='yes' AND stats.type='full' AND events.season='461' ORDER BY events.time ASC
row counr = 3
Thu - February 12th
-
20:00
-PositionplayedPPGFormWin %GFGAOver 1.5Over 2.5CornersCards
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Viewing Overall Stats due to being Cup games!
Tue - March 3rd
-
20:00
-PositionplayedPPGFormWin %GFGAOver 1.5Over 2.5CornersCards
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Viewing Overall Stats due to being Cup games!
Wed - March 4th
Show More Fixtures
top results = 6
SELECT events.id,events.time,events.home_team,events.away_team,events.status,events.statistics,events.league,events.has_agg,events.agg_event, stats.home_goals,stats.home_goals_et,stats.home_goals_pen, events.time_45,events.time_90, stats.away_goals,stats.away_goals_et,stats.away_goals_pen, stats.time as game_time, stats.homeCorners,stats.homeYellowCards,stats.homeRedCards, stats.awayCorners,stats.awayYellowCards,stats.awayRedCards, stats.home_goals_halftime,stats.away_goals_halftime, stats.homePossession,stats.awayPossession, events.txt_file_updated,events.round, events.home_full_stats,events.away_full_stats, events.group_id, ht.name as home_name,at.name as away_name, ht.team_data_updated as home_updated,at.team_data_updated as away_updated, ht.logo as home_logo,at.logo as away_logo,leagues.international, leagues.name as league_name,leagues.name_off as lno, leagues.id as league_id,leagues.type,leagues.abv as league_abv ,leagues.list_order, leagues.fixtures_updated, country.name as country_name,country.id as country_id, league_groups.name as group_desc, seasons.reg_fixtures,seasons.fixtures, stats.homeTotalShots,stats.awayTotalShots, stats.homeShotsOn,stats.awayShotsOn, stats.homeFouls,stats.awayFouls, hts.ppg as home_ppg,ats.ppg as away_ppg FROM events LEFT JOIN statistics_v2 as stats ON stats.event_id=events.id LEFT JOIN seasons ON seasons.id=events.season LEFT JOIN ( SELECT fixtures_updated,name,name_off,id,type,abv,list_order,country,active,international FROM leagues ) leagues ON leagues.id=events.league LEFT JOIN league_groups ON league_groups.id=events.group_id LEFT JOIN teams ht ON ht.id=events.home_team LEFT JOIN teams at ON at.id=events.away_team LEFT JOIN new_team_stats_v2 hts ON hts.team=events.home_team AND hts.league=leagues.id AND hts.location='All' AND hts.duration='All' AND hts.season=seasons.id LEFT JOIN new_team_stats_v2 ats ON ats.team=events.away_team AND ats.league=leagues.id AND ats.location='All' AND ats.duration='All' AND ats.season=seasons.id LEFT JOIN country ON leagues.country=country.id WHERE events.time BETWEEN 1768348800 AND 1770940799 AND seasons.current='1' AND events.league='288' AND events.status IN ('FT','AET','PEN') AND leagues.active='yes' AND stats.type='full' ORDER BY events.time DESC
12:00 14th 01 2026 - 12:00 11th 02 2026
Wed - February 11th 2026
1768348800
-
-
0
0
47%
53%
4
4
1
2
0
0
13
12
3
6
-
8%
12
17
Thu - February 5th 2026
-
-
0
3
41%
59%
3
5
2
0
0
0
7
12
2
6
-
42%
11
11
Wed - February 4th 2026
-
-
1
1
52%
48%
4
3
1
1
0
0
11
12
3
3
9%
17%
13
8
2
1
46%
54%
3
6
2
4
0
0
7
11
3
6
29%
27%
16
18
Tue - February 3rd 2026
-
-
-
0
1
27%
73%
3
6
1
1
0
0
7
17
3
7
14%
12%
10
15
Thu - January 15th 2026
-
-
0
0
23%
77%
3
10
4
1
0
0
5
16
2
6
-
13%
13
11
0
1
48%
52%
8
1
2
2
0
0
10
6
2
3
-
33%
9
9
Wed - January 14th 2026
-
-
-
0
0
51%
49%
4
7
3
1
0
1
12
11
7
2
17%
-
14
13
0
0
38%
62%
1
5
3
2
0
0
12
13
3
4
17%
8%
13
12
1
1
22%
78%
3
11
0
2
0
0
10
20
5
5
30%
10%
11
12
result count = 10
1770768000
Athletic Club
1
4
0 - 1
4
2
Real Sociedad
1770249600
Real Betis
2
3
0 - 5
5
0
Atletico Madrid
1770163200
1770076800
1768435200
1768348800
row counbt => 136
tablerow counbt => 0Array ( ) SELECT group_id,MAX(mycount) FROM ( SELECT id,group_id, COUNT(group_id) AS mycount FROM events WHERE events.league='288' AND events.season='461' GROUP BY group_id ) events
THSI NEEDDSSSSS SORTING FOR NEW LEAGUES WITH NO DATA <--------------------
Array ( [0] => Array ( [group_id] => 25 [MAX(mycount)] => 56 ) )
dd count = 1


Array ( [25] => Array ( [0] => Array ( [position] => 1 [id] => overall [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [1] => Array ( [position] => 2 [id] => home [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [2] => Array ( [position] => 3 [id] => away [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) ) [31] => Array ( [0] => Array ( [position] => 1 [id] => overall [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [1] => Array ( [position] => 2 [id] => home [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [2] => Array ( [position] => 3 [id] => away [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) ) [30] => Array ( [0] => Array ( [position] => 1 [id] => overall [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [1] => Array ( [position] => 2 [id] => home [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [2] => Array ( [position] => 3 [id] => away [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) ) [29] => Array ( [0] => Array ( [position] => 1 [id] => overall [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [1] => Array ( [position] => 2 [id] => home [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [2] => Array ( [position] => 3 [id] => away [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) ) [852] => Array ( [0] => Array ( [position] => 1 [id] => overall [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [1] => Array ( [position] => 2 [id] => home [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [2] => Array ( [position] => 3 [id] => away [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) ) [827] => Array ( [0] => Array ( [position] => 1 [id] => overall [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [1] => Array ( [position] => 2 [id] => home [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [2] => Array ( [position] => 3 [id] => away [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) ) [826] => Array ( [0] => Array ( [position] => 1 [id] => overall [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [1] => Array ( [position] => 2 [id] => home [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) [2] => Array ( [position] => 3 [id] => away [played] => [win] => [draw] => [loss] => [points] => [for] => [against] => [goaldifference] => [over25] => [scored2plus] => [btts] => [corners] => [corners_for] => [corners_against] => [cards] => [cards_for] => [cards_against] => [goal_counts] => [corner_counts] => [card_counts] => [goal_overs] => [corner_overs] => [card_overs] => [no_stats] => [form] => ) ) )

finshed events = 105
team count = 7
25
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
31
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
30
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
29
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
852
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
827
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
826
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
25
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
31
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
30
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
29
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
852
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
827
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
826
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
25
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
31
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
30
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
29
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
852
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
827
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
826
We currently don't have offical ordering of this league, it's currenlty being ordered by (Points, Goal Difference, Goals Scored)
-
Team
-
Pts
PPG
Pld
W
D
L
GF
GA
GD
Form
Co
Co+
Co-
Ca
Ca+
Ca-
Scores
Table data
return_data
Show Data
time zone =