SELECT COALESCE(to_char(ocal.default_opening_time,'hh24:mi:ss'), to_char(cw.opening_time, 'hh24:mi:ss')) "Opening time", COALESCE(to_char(ocal.default_closing_time,'hh24:mi:ss'), to_char(cw.closing_time, 'hh24:mi:ss'))"Closing time", wc.work_code_name, CASE cw.weekday_nr WHEN 0 THEN 'none'
                WHEN 1 THEN 'Monday'
                WHEN 2 THEN 'Tuersday'
                WHEN 3 THEN 'Wednesday'
                WHEN 4 THEN 'Thursday'
                WHEN 5 THEN 'Friday'
                WHEN 6 THEN 'Saturday'
                WHEN 7 THEN 'sunday'
END AS weekday
FROM cal_weekday cw, work_code wc, oc_calendar ocal, operation_center oc, vehicle_owner vo
WHERE cw.oc_calendar_id=ocal.oc_calendar_id
AND ocal.operation_center_id=oc.operation_center_id
AND vo.vehicle_owner_id=wc.vehicle_owner_id
AND vo.vehicle_owner_id IN (SELECT vehicle_owner_id FROM vehicle_owner WHERE company_name LIKE '%COBELBA%')
AND cw.is_open NOT LIKE 'N';