FootyHub - Friendlies
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] => 86 [total_home_goals] => 47 [total_away_goals] => 39 )

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 1772150399 ) 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='907' AND leagues.active='yes' AND stats.type='full' AND events.season='474' ORDER BY events.time ASC
row counr = 22
Thu - February 12th
-
14:00
17:00
-PositionplayedPPGFormWin %GFGAOver 1.5Over 2.5CornersCards
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
These statistics only include competative fixtures.
Fri - February 13th
-
11:00
14:00
15:00
16:00
-PositionplayedPPGFormWin %GFGAOver 1.5Over 2.5CornersCards
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
These statistics only include competative fixtures.
Sat - February 14th
Sun - February 15th
Tue - February 17th
Wed - February 18th
Thu - February 19th
Sat - February 21st
Mon - February 23rd
Thu - February 26th
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 1769990400 AND 1770940799 AND seasons.current='1' AND events.league='907' AND events.status IN ('FT','AET','PEN') AND leagues.active='yes' AND stats.type='full' ORDER BY events.time DESC
12:00 2nd 02 2026 - 12:00 11th 02 2026
Tue - February 10th 2026
1770249600
-
-
0
0
0%
0%
0
0
0
0
0
0
0
0
0
0
-
-
0
0
0
0
0%
0%
0
0
0
0
0
0
0
0
0
0
-
-
0
0
Mon - February 9th 2026
-
-
0
0
0%
0%
0
0
0
0
0
0
0
0
0
0
-
-
0
0
Sun - February 8th 2026
-
-
-
0
0
0%
0%
0
0
0
0
0
0
0
0
0
0
-
-
0
0
Thu - February 5th 2026
-
-
0
0
0%
0%
0
0
0
0
0
0
0
0
0
0
-
-
0
0
1
0
0%
0%
0
0
0
0
0
0
0
0
0
0
-
-
0
0
result count = 6
1770681600
Luxembourg U18
0
0
2 - 1
0
0
Turkey U18
Turkey U19
0
0
0 - 0
0
0
Greece U19
1770595200
China PR U20
0
0
1 - 1
0
0
Uzbekistan U20
1770508800
1770249600
row counbt => 116
tablerow counbt => 0Array ( ) SELECT group_id,MAX(mycount) FROM ( SELECT id,group_id, COUNT(group_id) AS mycount FROM events WHERE events.league='907' AND events.season='474' GROUP BY group_id ) events
THSI NEEDDSSSSS SORTING FOR NEW LEAGUES WITH NO DATA <--------------------
Array ( [0] => Array ( [group_id] => 554 [MAX(mycount)] => 68 ) )
dd count = 1


Array ( [873] => 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] => ) ) [555] => 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] => ) ) [556] => 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] => ) ) [554] => 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] => ) ) [557] => 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 = 33
team count = 5
873
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-
555
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-
556
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-
554
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-
557
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-
873
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-
555
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-
556
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-
554
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-
557
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-
873
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-
555
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-
556
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-
554
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-
557
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 =