select cmssites.*, cmssitedomains.Domain, _languages.LanguageDescription, currencies.CurrencyCode, currencies.CurrencySymbol from cmssitedomains inner join cmssites on cmssitedomains.CMSSiteId = cmssites.CMSSiteID inner join _languages on cmssites.CMSSiteLanguageId = _languages.ID inner join currencies on cmssites.CMSSiteDefaultCurrency = currencies.CurrencyId where cmssitedomains.Domain = 'clubdanceholidays.com'