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 (58 = Overrides.ControlId AND QCA.CustomerId = Overrides.CustomerId) where QCA.customerid = 19153 and ( QCA.control_id = 58 ) and QCA.show = 1
Old Pearler Restaurant
71 Knight Tce
The Old Pearler Restaurant is the only restaurant in the world built entirely from coquina shell carved from Shell Beach.
Open 7 days a week, with full a-la-carte (menu). Fresh local seafood a specialty, with crabs and crayfish in season. Special occasions and groups catered for in restaurant or other venues. Coach tours catered for breakfast, lunches, picnic lunches or dinners. Group prices negotiable.