SELECT 
        m.*, 
        t.fld_name AS tournament, 
        t.fld_countryId as countryId, 
        t.fld_flag AS flag,
        t.fld_code AS tCode,
        msc.fld_HomeTeam, 
        msc.fld_AwayTeam,
        msh.fld_HomeTeam AS ht1, 
        msh.fld_AwayTeam AS ht2,
        th.fld_name AS HomeTeam, 
        th.fld_shortName AS HomeTeamShort, 
        ta.fld_name AS AwayTeam, 
        ta.fld_shortName AS AwayTeamShort
        FROM 
        db_stats.tbl_match AS m 
        LEFT JOIN db_stats.tbl_tournament AS t ON m.fld_tournamentId = t.fld_epid
        LEFT JOIN db_stats.tbl_match_score msc ON m.fld_epid = msc.fld_epMatchId AND msc.fld_type = 'Current'
        LEFT JOIN db_stats.tbl_match_score msh ON m.fld_epid = msh.fld_epMatchId AND msh.fld_type = 'HalfTime'
        LEFT JOIN db_stats.tbl_team th ON m.fld_HomeTeamId=th.fld_epid
        LEFT JOIN db_stats.tbl_team ta ON m.fld_AwayTeamId=ta.fld_epid
        WHERE m.fld_epid = '4820656'
        

Array
(
    [0] => Array
        (
            [0] => 1844694
            [fld_matchId] => 1844694
            [1] => 4820656
            [fld_id] => 4820656
            [2] => 4820656
            [fld_epid] => 4820656
            [3] => 0
            [fld_contentId] => 0
            [4] => 489
            [fld_tournamentId] => 489
            [5] => 24396
            [fld_seasonId] => 24396
            [6] => 896100
            [fld_stageId] => 896100
            [7] => 89
            [fld_seriesId] => 89
            [8] => 
            [fld_drawName] => 
            [9] => 0
            [fld_code] => 0
            [10] => 
            [fld_specialEventCode] => 
            [11] => SV Terwolde-Go Ahead Eagles
            [fld_name] => SV Terwolde-Go Ahead Eagles
            [12] => 1
            [fld_round] => 1
            [13] => 
            [fld_stadiumId] => 
            [14] => 
            [fld_refereeId] => 
            [15] => 
            [fld_weather] => 
            [16] => 1375240
            [fld_HomeTeamId] => 1375240
            [17] => 6433
            [fld_AwayTeamId] => 6433
            [18] => 14
            [fld_statusId] => 14
            [19] => 2025-06-22 14:00:00
            [fld_startDate] => 2025-06-22 14:00:00
            [20] => 0000-00-00 00:00:00
            [fld_startDateUpt] => 0000-00-00 00:00:00
            [21] => N
            [fld_crowdless] => N
            [22] => N
            [fld_neutralField] => N
            [23] => 0
            [fld_brId] => 0
            [24] => 0
            [fld_opta_team1Id] => 0
            [25] => 0
            [fld_opta_team2Id] => 0
            [26] => N
            [fld_duello] => N
            [27] => 0
            [fld_originalMatch1Id] => 0
            [28] => 0
            [fld_originalMatch2Id] => 0
            [29] => 0
            [fld_matchCenter] => 0
            [30] => 0
            [fld_opId] => 0
            [31] => 0
            [fld_ocId] => 0
            [32] => 0
            [fld_mackolikId] => 0
            [33] => 0
            [fld_broadageId] => 0
            [34] => 0000-00-00 00:00:00
            [fld_lastUpdated] => 0000-00-00 00:00:00
            [35] => Club Friendlies 1
            [tournament] => Club Friendlies 1
            [36] => 
            [countryId] => 
            [37] => 
            [flag] => 
            [38] => 
            [tCode] => 
            [39] => 0
            [fld_HomeTeam] => 0
            [40] => 19
            [fld_AwayTeam] => 19
            [41] => 0
            [ht1] => 0
            [42] => 7
            [ht2] => 7
            [43] => SV Terwolde
            [HomeTeam] => SV Terwolde
            [44] => 
            [HomeTeamShort] => 
            [45] => Go Ahead Eagles
            [AwayTeam] => Go Ahead Eagles
            [46] => 
            [AwayTeamShort] => 
        )

)