gistfile1.sql

SELECT `business_id`,`venue_id`, `VenueHour`.`days`,
GROUP_CONCAT(
    CONCAT(
        (`VenueHour`.`begin_hour` >> 4)%12,
        ':',
        LPAD((`VenueHour`.`begin_hour` & 15)*5,2,'0'),
        IF(`VenueHour`.`begin_hour` < 192, ' a.m.', ' p.m.'),
        ' - ',
        (`VenueHour`.`end_hour` >> 4)%12,
        ':',
        LPAD((`VenueHour`.`end_hour` & 15)*5,2,'0'),
        IF(`VenueHour`.`end_hour` < 192, ' a.m.', ' p.m.')
    ) SEPARATOR ',') as `hours`
FROM `venue_hours` AS `VenueHour`
GROUP BY `VenueHour`.`business_id`, `VenueHour`.`venue_id`,`VenueHour`.`days`
ORDER BY `VenueHour`.`begin_hour`