SELECT 
 self.title, 
 line_start.title, 
 line_start.time_in, 
 line_end.title, 
 line_end.time_in
FROM 
 admin1038.admin1038_bus_line as self
LEFT JOIN
( 
 SELECT 
  line.id, 
  city.title, 
  tt1.time_in 
 FROM 
  admin1038.admin1038_bus_line as line
 LEFT JOIN
  admin1038.admin1038_bus_timetable as tt1
 ON tt1.line_id = line.id 
 AND tt1.time_in = (
  SELECT MIN(tt2.time_in) FROM admin1038.admin1038_bus_timetable as tt2 WHERE tt2.line_id = line.id
 )
 LEFT JOIN admin1038.admin1038_dict_city as city 
 ON city.id = tt1.city_id
) as line_start 
ON line_start.id = self.id
LEFT JOIN
(
 SELECT 
  line.id, 
  city.title, 
  tt1.time_in 
 FROM
  admin1038.admin1038_bus_line as line
 LEFT JOIN 
  admin1038.admin1038_bus_timetable as tt1
 ON tt1.line_id = line.id
 AND tt1.time_in = (
  SELECT MAX(tt2.time_in) FROM admin1038.admin1038_bus_timetable as tt2 WHERE tt2.line_id = line.id
 )
 LEFT JOIN admin1038.admin1038_dict_city as city 
 ON city.id = tt1.city_id
) as line_end 
ON line_end.id = self.id