[Arfey]

select `дата`, group_concat(еда) from (select * from table1 where `дата` between X and Y
union
select * from table2 `дата` between X and Y)t
group by `дата` desc limit 5;