REPORT ISSUE CLOSE

SUBMIT

TEST



thjis is a test
Array ( [total_goals] => 421 [total_home_goals] => 200 [total_away_goals] => 221 )

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 1773014399 ) 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='132' AND leagues.active='yes' AND stats.type='full' AND events.season='400' ORDER BY events.time ASC
row counr = 13
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 1769385600 AND 1770940799 AND seasons.current='1' AND events.league='132' AND events.status IN ('FT','AET','PEN') AND leagues.active='yes' AND stats.type='full' ORDER BY events.time DESC
12:00 26th 01 2026 - 12:00 9th 02 2026
result count = 22team count = 1
636
636
636

Array ( )

Array ( [time_zone] => [cup_stats] => overall [league_stats] => league [position_view] => overall [fixture_stats] => overall [league_view_stats] => overall [scroll] => tog [league_order_active] => all [league_list] => Array ( [0] => 418 [1] => 839 [2] => 485 [3] => 1021 [4] => 413 [5] => 952 [6] => 262 [7] => 421 [8] => 988 [9] => 741 [10] => 951 [11] => 560 [12] => 443 [13] => 495 [14] => 432 [15] => 509 [16] => 950 [17] => 466 [18] => 442 [19] => 489 [20] => 416 [21] => 690 [22] => 531 [23] => 716 [24] => 434 [25] => 491 [26] => 490 [27] => 502 [28] => 493 [29] => 830 [30] => 425 [31] => 563 [32] => 611 [33] => 907 [34] => 987 [35] => 487 [36] => 444 [37] => 451 [38] => 953 [39] => 1012 [40] => 318 [41] => 499 [42] => 584 [43] => 414 [44] => 457 [45] => 946 [46] => 962 [47] => 935 [48] => 871 [49] => 835 [50] => 424 [51] => 646 [52] => 938 [53] => 459 [54] => 288 [55] => 1018 [56] => 975 [57] => 886 [58] => 898 [59] => 132 [60] => 234 [61] => 35 [62] => 642 [63] => 890 [64] => 1104 [65] => 561 [66] => 999 [67] => 458 [68] => 712 [69] => 176 [70] => 1038 [71] => 879 [72] => 1102 [73] => 1103 [74] => 997 [75] => 740 [76] => 64 [77] => 742 [78] => 920 [79] => 400 [80] => 546 [81] => 43 [82] => 533 [83] => 998 [84] => 616 [85] => 944 [86] => 934 [87] => 547 [88] => 971 [89] => 699 [90] => 467 [91] => 996 [92] => 615 [93] => 1046 [94] => 617 [95] => 367 [96] => 379 [97] => 486 [98] => 81 [99] => 69 [100] => 558 [101] => 68 [102] => 500 ) [statfinder_type] => overall [statfinder_loc] => all [statfinder_sort] => win [statfinder_stats] => fav [userLeagueOrder] => Array ( [0] => 69 [1] => 413P [2] => 741P [3] => 839 [4] => 987 [5] => 379 [6] => 907 [7] => 318 [8] => 234 [9] => 1103 [10] => 1104 [11] => 35 [12] => 64 [13] => 1102 [14] => 68 [15] => 418 [16] => 485 [17] => 442 [18] => 443 [19] => 533 [20] => 560P [21] => 444 [22] => 546 [23] => 547 [24] => 466 [25] => 1021 [26] => 1038 [27] => 975 [28] => 491 [29] => 490P [30] => 424 [31] => 531 [32] => 563 [33] => 952 [34] => 421 [35] => 951 [36] => 950 [37] => 416 [38] => 920P [39] => 509 [40] => 561 [41] => 712 [42] => 432 [43] => 467 [44] => 288P [45] => 434 [46] => 886 [47] => 890 [48] => 988 [49] => 487 [50] => 690 [51] => 502 [52] => 898 [53] => 871 [54] => 830 [55] => 835 [56] => 1018 [57] => 611 [58] => 742 [59] => 616 [60] => 617 [61] => 489 [62] => 414 [63] => 486 [64] => 457 [65] => 262 [66] => 953 [67] => 971 [68] => 997 [69] => 998 [70] => 996 [71] => 879 [72] => 934 [73] => 451 [74] => 495 [75] => 716 [76] => 740 [77] => 944 [78] => 615 [79] => 500 [80] => 642 [81] => 946 [82] => 458 [83] => 558 [84] => 493 [85] => 962 [86] => 1046 [87] => 1012 [88] => 499 [89] => 999 [90] => 459 [91] => 584 [92] => 699 [93] => 646 [94] => 935 [95] => 400 [96] => 938 [97] => 176 [98] => 43 [99] => 132 [100] => 425P [101] => 81 [102] => 367 ) [fixture_list_view] => league [userDataLocation] => overall [userCupView] => overall [userLeagueView] => league )

Show Data