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 (15 = Overrides.ControlId AND QCA.CustomerId = Overrides.CustomerId) where QCA.customerid = 33650 and ( QCA.control_id = 15 ) and QCA.show = 1
6 Woods street, Esperance WA 6450
Experience Australia’s only specialist fish and shark leather tannery. Sit down and relax while you discover in a delightful DVD presentation how Mermaid turns raw fish skins into a unique and exciting leather with international appeal.
Feel the sensual texture of Barramundi and Snapper, test the robust strength of Shark, and enjoy browsing through the Mermaid studio. This is a not to miss attraction that showcases some of the finest collection of unique leather goods you’ll ever come across. Entry is free.