SELECT B.NAME_RU, B.SURNAME_RU, B.NICKNAME_RU, A.ID, A.MINUTE, A.MINUTE_ADD,
A.TYPE, A.CLUB, A.CLUB_AUTO, B.COUNTRY_PLAY1, A.PLAYER, A.MATCH, A.NONAME_RU
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