FootyHub - Premier Division
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] => 79 [total_home_goals] => 46 [total_away_goals] => 33 )

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 1773360000 AND 1776988799 ) 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='962' AND leagues.active='yes' AND stats.type='full' AND events.season='469' ORDER BY events.time ASC
row counr = 30
Mon - March 16th
-PositionplayedPPGFormWin %GFGAOver 1.5Over 2.5CornersCards
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Fri - March 20th
-PositionplayedPPGFormWin %GFGAOver 1.5Over 2.5CornersCards
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Sat - March 21st
Fri - April 3rd
Mon - April 6th
Fri - April 10th
Fri - April 17th
Sat - April 18th
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 1772150400 AND 1773446399 AND seasons.current='1' AND events.league='962' AND events.status IN ('FT','AET','PEN') AND leagues.active='yes' AND stats.type='full' ORDER BY events.time DESC
12:00 27th 02 2026 - 12:00 13th 03 2026
Fri - March 13th 2026
1772150400
-
-
0.67
1.83
0
2
54%
46%
1
7
1
7
0
1
12
12
3
5
-
17%
7
16
1.17
0
1
68%
32%
3
1
1
2
0
0
23
5
7
3
17%
20%
9
14
1.17
0.33
2
0
53%
47%
9
5
0
2
0
0
25
11
12
3
20%
-
8
13
0.83
0
0
70%
30%
10
1
2
1
0
0
12
8
6
2
8%
-
12
12
1.17
1.00
1
2
57%
43%
7
2
0
2
0
0
17
6
4
4
6%
33%
11
7
1.17
0.40
2
0
53%
47%
9
5
0
2
0
0
25
11
12
3
20%
-
8
13
Mon - March 9th 2026
-
-
1.00
1.83
2
2
44%
56%
5
4
2
3
0
0
9
12
2
4
22%
17%
19
12
Sat - March 7th 2026
-
-
0.67
1.17
1
0
58%
42%
5
3
2
2
0
0
21
10
4
2
10%
10%
6
7
Fri - March 6th 2026
-
-
1.00
0
0
56%
44%
5
6
4
2
0
0
15
17
6
7
13%
18%
7
6
1.83
1.17
0
0
70%
30%
5
7
0
4
0
0
15
7
8
0
7%
-
13
20
0.40
0
1
36%
64%
7
6
0
1
0
0
9
18
0
5
-
6%
12
9
0.33
0
1
36%
64%
7
6
0
1
0
0
9
18
0
5
-
6%
12
9
0.83
1.17
0
1
43%
57%
3
10
3
1
0
0
7
16
4
6
29%
13%
17
9
Mon - March 2nd 2026
-
-
0.83
0
0
72%
28%
8
3
2
1
0
0
22
7
4
2
5%
-
13
16
Fri - February 27th 2026
-
-
1.83
1
0
42%
58%
6
7
2
4
0
0
10
8
4
3
30%
25%
13
12
1.17
1.00
1
0
36%
64%
2
7
3
4
0
0
10
17
3
5
10%
12%
11
10
0.83
0.67
1
0
41%
59%
4
2
1
2
0
0
15
7
6
2
7%
-
9
9
1.17
0.40
0
1
67%
33%
7
2
1
2
0
0
20
8
12
5
20%
25%
11
8
1.17
2
0
51%
49%
4
7
3
1
0
0
21
13
7
4
19%
-
19
8
1.17
0.33
0
1
67%
33%
7
2
1
2
0
0
20
8
12
5
20%
25%
11
8
result count = 20
1773360000
Sligo Rovers
1
1
0 - 2
7
7 (1)
Shamrock Rovers
St Patrick's Athl.
1
3
4 - 1
1
2
Drogheda United
Dundalk
0
9
5 - 0
5
2
Waterford
Bohemians
2
10
1 - 0
1
1
Galway United
Derry City
0
7
1 - 2
2
2
Shelbourne
Dundalk
0
9
5 - 0
5
2
Waterford
1773014400
Shelbourne
2
5
2 - 2
4
3
Shamrock Rovers
1772841600
1772755200
1772409600
1772150400
row counbt => 180
tablerow counbt => 0Array ( ) SELECT group_id,MAX(mycount) FROM ( SELECT id,group_id, COUNT(group_id) AS mycount FROM events WHERE events.league='962' AND events.season='469' GROUP BY group_id ) events
THSI NEEDDSSSSS SORTING FOR NEW LEAGUES WITH NO DATA <--------------------
Array ( [0] => Array ( [group_id] => 619 [MAX(mycount)] => 180 ) )
dd count = 1


Array ( [619] => 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 = 30
team count = 1
619
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-
619
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-
619
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 =