mysql先排序后分组；先分组后排序

mysql默认先分组后排序

如何实现先排序后分组

以下这条sql为先排序后分组再排序

select *
		FROM (SELECT  DISTINCT m.id,
		m.message_name ,
        IF((r.user_account IS NOT NULL AND r.user_account = 15000000000), r.read_status , 0) AS readStatus ,
        m.content,m.create_date
        FROM c_push_message m 
        LEFT JOIN c_push_message_person p ON m.id = p.push_message_id 
        LEFT JOIN c_message_receive r ON r.push_message_id = m.id   
        WHERE (m.send_all = 'yes' OR p.user_account = 15000000000 )	
		AND m.push_type = 'web'
		ORDER BY readStatus DESC) as message
		GROUP BY message.id
		ORDER BY message.create_date DESC