MYSQL ERROR SELECT DISTINCT
EX_001_ID AS id, EX_001_NAME AS name
FROM
EX_004_MATCH, EX_001_COMPETITION
WHERE
EX_004_MATCH.EX_001_COMPETITION_ID = EX_001_COMPETITION.EX_001_ID
AND ((EX_004_MATCH.EX_002_HOMETEAM_ID = 10424) OR (EX_004_MATCH.EX_002_AWAYTEAM_ID = 10424)) AND ((EX_002_HOMETEAM_ID = '10424' AND EX_004_IHOMECAT='A') OR (EX_002_AWAYTEAM_ID = '10424' AND EX_004_IAWAYCAT='A' )) AND (EX_004_MATCH.EX_004_SEASONEND = -1-) ORDER BY EX_001_NAME