SELECT B.NAME_EN, B.SURNAME_EN, B.NICKNAME_EN, A.ID, A.MINUTE, A.MINUTE_ADD,
A.TYPE, A.CLUB, A.CLUB_AUTO, B.COUNTRY_PLAY1, A.PLAYER, A.MATCH, A.NONAME_EN
FROM TGOALS A
LEFT JOIN TPLAYER B ON (A.PLAYER=B.ID)
WHERE A.MATCH IN () ORDER BY A.MATCH, A.MINUTE+A.MINUTE_ADD