SELECT dayfrom, place, MAX(dayto) AS dayto, grade, series, type, title, sunset FROM raceinfo_branch_export WHERE dayfrom BETWEEN '2008-05-27' AND '2013-05-27' GROUP BY dayfrom, place