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