REPORT ISSUE CLOSE

SUBMIT

TEST



thjis is a test
Array ( [total_goals] => 360 [total_home_goals] => 201 [total_away_goals] => 159 )

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 1776470399 ) 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='699' AND leagues.active='yes' AND stats.type='full' AND events.season='194' ORDER BY events.time ASC
row counr = 17
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 1762560000 AND 1773446399 AND seasons.current='1' AND events.league='699' AND events.status IN ('FT','AET','PEN') AND leagues.active='yes' AND stats.type='full' ORDER BY events.time DESC
12:00 8th 11 2025 - 12:00 13th 03 2026
result count = 46team count = 2
880
411
880
411
880
411