Select QCA.*, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Amenities)), ''), QCA.Amenities) as Amenities, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Directions)), ''), QCA.Directions) as Directions, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Description)), ''), QCA.Description) as Description, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Special)), ''), QCA.Special) as Special from qrycustomersall QCA LEFT JOIN (SELECT CO.* FROM CustomerOverrides CO WITH(NOLOCK) INNER JOIN ControlModule CM WITH(NOLOCK) ON CO.ControlId = CM.Control_Id WHERE (CM.ModuleId = 94)) Overrides ON (121 = Overrides.ControlId AND QCA.CustomerId = Overrides.CustomerId) where QCA.customerid = 58435 and ( QCA.control_id = 121 ) and QCA.show = 1
The specified operator could not be found. Please go back and try again.
Thank you for using Warrnambool Booking Service operated by the Warrnambool Visitor Information Centre. Any queries please call the Visitor Information Centre on 1800 637 725.