Форум пользователей MySQL

           SELECT * FROM
            (SELECT * FROM
            (SELECT
            m.id,
            tournament_id,
            (CASE tournament_id
                   WHEN 257 THEN 'MHA'
                   WHEN 258 THEN 'MHB'
                   WHEN 260 THEN 'M1A'
                   WHEN 261 THEN 'M1B'
                   WHEN 265 THEN 'M2A'
                   WHEN 266 THEN 'M2B'
                   WHEN 268 THEN 'M3A'
                   WHEN 269 THEN 'M3B'
                   WHEN 270 THEN 'M3C'
                   WHEN 271 THEN 'M3D'
                   WHEN 273 THEN 'M4A'
                   WHEN 274 THEN 'M4B'
                   WHEN 275 THEN 'M4C'
                   WHEN 276 THEN 'M4D'
                   WHEN 277 THEN 'WH'
                   WHEN 279 THEN 'W1A'
                   WHEN 280 THEN 'W1B'
                   WHEN 283 THEN 'W2A'
                   WHEN 284 THEN 'W2B'
                ELSE 'n/a'
            END) as gruppa,
            t1.name as Team1Name,
                        t1.contact_id as Team1ContactId,
            t2.name as Team2Name,
                        t2.contact_id as Team2ContactId,
            m.dt,
            DATE_FORMAT(m.dt, '%Y-%M-%d') AS formatted_date,
            mr.dt_accept,
            mr.status,
            mr.team1_set1_point,
            mr.team2_set1_point,
            mr.team1_set2_point,
            mr.team2_set2_point,
            mr.team1_set3_point,
            mr.team2_set3_point,
            mr.team1_set4_point,
            mr.team2_set4_point,
            mr.team1_set5_point,
            mr.team2_set5_point,
                        mr.arbiter1_id,
                        mr.arbiter2_id,
                        mr.arbiter1_mark,
            mr.author_id,
            mr.comment,
            mr.moder_comment
            FROM `match` m
            JOIN match_raw AS mr ON match_id = m.id
            JOIN team AS t1 ON m.team1 = t1.id
            JOIN team AS t2 ON m.team2 = t2.id
            WHERE mr.dt_accept > NOW() - INTERVAL 5 DAY
            ORDER BY  `m`.`id` ,  `m`.`dt` DESC , `mr`.`status` DESC) as res
            GROUP BY id) as rawresults
            UNION
            SELECT
            m.id,
            tournament_id,
            (CASE tournament_id
                   WHEN 257 THEN 'MHA'
                   WHEN 258 THEN 'MHB'
                   WHEN 260 THEN 'M1A'
                   WHEN 261 THEN 'M1B'
                   WHEN 265 THEN 'M2A'
                   WHEN 266 THEN 'M2B'
                   WHEN 268 THEN 'M3A'
                   WHEN 269 THEN 'M3B'
                   WHEN 270 THEN 'M3C'
                   WHEN 271 THEN 'M3D'
                   WHEN 273 THEN 'M4A'
                   WHEN 274 THEN 'M4B'
                   WHEN 275 THEN 'M4C'
                   WHEN 276 THEN 'M4D'
                   WHEN 277 THEN 'WH'
                   WHEN 279 THEN 'W1A'
                   WHEN 280 THEN 'W1B'
                   WHEN 283 THEN 'W2A'
                   WHEN 284 THEN 'W2B'
                ELSE 'n/a'
            END) as gruppa,
            t1.name as Team1Name,
                        t1.contact_id as Team1ContactId,
            t2.name as Team2Name,
                        t2.contact_id as Team2ContactId,
            m.dt,
           DATE_FORMAT(m.dt, '%Y-%M-%d') AS formatted_date,
            NULL AS dt_accept,
            0 AS status,
            '' AS team1_set1_point,
            '' AS team2_set1_point,
            '' AS team1_set2_point,
            '' AS team2_set2_point,
            '' AS team1_set3_point,
            '' AS team2_set3_point,
            '' AS team1_set4_point,
            '' AS team2_set4_point,
            '' AS team1_set5_point,
            '' AS team2_set5_point,
            '' AS arbiter1_id,
            '' AS arbiter2_id,
            '' AS arbiter1_mark,
            '' AS author_id,
            '' AS comment,
            '' AS moder_comment
            FROM `match` m
            JOIN team AS t1 ON m.team1 = t1.id
            JOIN team AS t2 ON m.team2 = t2.id
            WHERE dt < NOW() and HAVE_RESULT = 0 AND m.id not in (SELECT mr.match_id FROM match_raw mr)
ORDER BY formatted_date DESC, tournament_id

SELECT  `id` ,  `match_id` ,  `dt_accept`
FROM match_raw
WHERE match_id =6341
LIMIT 0 , 30
 

SELECT  `id` ,  `match_id` , MAX(  `dt_accept` ) AS  `latest_date` ,  `dt_accept`
FROM match_raw
WHERE match_id =6341
GROUP BY  `match_id`
LIMIT 0 , 30