MySQL Error!
MySQL error in file: /engine/modules/zinter/matchcenter/functions/matches.php at line 558
Error Number: 1064
The Error returned was:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and mtc.away_id = ) or (mtc.home_id = and mtc.away_id = ))
order by da...' at line 19
SQL query:
select mtc.*,
hometm.id as home_id, if ( (hometm.name_rus = "" or hometm.name_rus is null), hometm.name_eng , hometm.name_rus) as home_name, hometm.name_eng as home_name_eng, hometm.slug as home_slug, hometm.code as home_code,hometm.tag as home_tag,
awaytm.id as away_id, if ( (awaytm.name_rus = "" or awaytm.name_rus is null), awaytm.name_eng , awaytm.name_rus) as away_name, awaytm.name_eng as away_name_eng, awaytm.slug as away_slug, awaytm.code as away_code, awaytm.tag as away_tag,
homecnt.slug as home_country_slug, homecnt.name_rus as home_country_name,
hometm.version as home_version,
awaycnt.slug as away_country_slug, awaycnt.name_rus as away_country_name,
awaytm.version as away_version,
tr.name_rus as tournament_name, tr.name_eng as tournament_name_eng, tr.slug as tournament_slug, tr.short_name as tournament_shortname,tr.code as tournament_code,
seas.name as season_name, seas.id as season_id, seas.date_start as season_startdate, seas.date_end as season_enddate
from
zinter_matches as mtc
left join zinter_teams as hometm on hometm.id = mtc.home_id
left join zinter_teams as awaytm on awaytm.id = mtc.away_id
left join zinter_countries as homecnt on homecnt.id = hometm.country_id
left join zinter_countries as awaycnt on awaycnt.id = awaytm.country_id
left join zinter_championship as tr on tr.id = mtc.tournament_id
left join zinter_seasons as seas on seas.id = mtc.season_id
where
mtc.status in (50) and mtc.date < "2022-12-18" and ((mtc.home_id = and mtc.away_id = ) or (mtc.home_id = and mtc.away_id = ))
order by date desc limit 10