SELECT
  o.OrganisationID,
  o.OrganisationTypeID,
  o.Latitude,
  o.Longitude,
  oht.OpeningHoursType,
  oh.AdditionalOpeningDate,
  CASE
    WHEN oh.DayOfWeek = 7 THEN DATEDIFF(minute, 0, oh.OpeningTime)
    ELSE DATEDIFF(minute, 0, oh.OpeningTime) + (1440 * oh.DayOfWeek)
  END AS OpeningTimeAsOffset,
  CASE
    WHEN oh.DayOfWeek = 7 THEN DATEDIFF(minute, 0, oh.ClosingTime)
    ELSE DATEDIFF(minute, 0, oh.ClosingTime) + (1440 * oh.DayOfWeek)
  END AS ClosingTimeAsOffset,
  oh.DayOfWeek,
  oh.OpeningTime,
  oh.ClosingTime
FROM [choices].[Organisation] o
INNER JOIN choices.OpeningHours oh ON o.[OrganisationID] = oh.[OrganisationID]
INNER JOIN choices.OpeningHoursType oht ON oht.OpeningHoursTypeID = oh.OpeningHoursTypeID
WHERE o.OrganisationTypeID = 'PHA'