SELECT * FROM logs GROUP BY (order_id, log_name) ORDER BY order_id DESC LIMIT 0,1;

select distinct subtbl.Name from (select first_name + last_name as "Name" from log) as subtbl;

select subtbl.Name from (select first_name + last_name as "Name" from log) as subtbnl group by subtbl.Name limit 0, 1; -- this will take the first value

select * from log order by id desc limit 0, 1;