SELECT DATE_FORMAT(data, '%d.%m.%Y') AS data_new_x, turnirs.turnir, player1, schet, player2, winf, id_games, turnirs.id_turnirs, kod_sezon, katki.katki, timegame As timeg, katki.id_katki FROM (SELECT DATE_FORMAT(data, '%d.%m.%Y') AS data_new_x, turnirs.turnir, player1, schet, player2, winf, id_games, turnirs.id_turnirs, kod_sezon, katki.katki, timegame As timeg, katki.id_katki FROM  katki INNER JOIN (turnirs INNER JOIN games ON turnirs.id_turnirs = games.kod_turnirs) ON katki.id_katki = games.kod_katki
           WHERE (kod_sezon = '4') AND (winf <> '') ORDER BY data DESC, timeg DESC LIMIT 9) ORDER BY data ASC, timeg ASC