Timetable

SELECT min(TIME_FORMAT(t1.start, '{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}H:{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}i')) AS min, max(REPLACE(TIME_FORMAT(t1.end, '{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}H:{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}i'), '00:00', '24:00')) AS max FROM wp_class_hours AS t1 LEFT JOIN wp_posts AS t2 ON t1.class_id=t2.ID LEFT JOIN wp_posts AS t3 ON t1.weekday_id=t3.ID WHERE t2.post_type='classes' AND t2.post_status='publish'stdClass Object ( [min] => 18:30 [max] => 21:15 )

kuku

18-18:00 - 19:00
19-19:00 - 20:00
20-20:00 - 21:00
21-21:00 - 22:00
SELECT min(TIME_FORMAT(t1.start, '{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}H:{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}i')) AS min, max(REPLACE(TIME_FORMAT(t1.end, '{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}H:{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}i'), '00:00', '24:00')) AS max FROM wp_class_hours AS t1 LEFT JOIN wp_posts AS t2 ON t1.class_id=t2.ID LEFT JOIN wp_posts AS t3 ON t1.weekday_id=t3.ID WHERE t2.post_type='classes' AND t2.post_status='publish'stdClass Object ( [min] => 19:45 [max] => 21:15 )

kuku

19-19:00 - 20:00
20-20:00 - 21:00
21-21:00 - 22:00
SELECT min(TIME_FORMAT(t1.start, '{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}H:{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}i')) AS min, max(REPLACE(TIME_FORMAT(t1.end, '{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}H:{0f3e3b1dff16060d8b93d05d2940047dd1fd97f3c4188cc33173d81aeb7af5a7}i'), '00:00', '24:00')) AS max FROM wp_class_hours AS t1 LEFT JOIN wp_posts AS t2 ON t1.class_id=t2.ID LEFT JOIN wp_posts AS t3 ON t1.weekday_id=t3.ID WHERE t2.post_type='classes' AND t2.post_status='publish'stdClass Object ( [min] => 18:30 [max] => 19:45 )

kuku

18-18:00 - 19:00
19-19:00 - 20:00