5 DB hits
--> On Search:
--> On _Default:
--> On Search:
SELECT [t0].[DomainId], [t0].[CreatedDateTime], [t0].[AmendedDateTime], [t0].[CountryId], [t0].[Name], [t0].[GoogleMapKey], [t0].[GoogleAnalyticsKey], [t0].[PayPalLive], [t0].[PayPalBusinessId], [t0].[Gateway], [t0].[DirectoryIntro], [t0].[RegisterIntro], [t0].[DirectoryTitle], [t0].[DirectoryRolesHeading], [t0].[CssLink], [t0].[Description], [t1].[CountryId] AS [CountryId2], [t1].[CurrencyId], [t1].[ResponsableOfficeId], [t1].[EmailFooterTemplateId], [t1].[DefaultNewsletterId], [t1].[DefaultSMTPAccountId], [t1].[EventCategoryId], [t1].[ExaminationCategoryId], [t1].[MembershipCategoryId], [t1].[ExamExemptionGrade], [t1].[ExamDNAGrade], [t1].[ExamNSGrade], [t1].[ExamNCGrade], [t1].[Name] AS [Name2], [t1].[ISOCode], [t1].[Enabled], [t1].[ISO3Code], [t1].[DefaultLocationAddressId], [t1].[GoogleZoomLevel], [t1].[DirectoryEnabled], [t1].[MyBusinessEnabled], [t1].[Forum_Header], [t1].[Forum_Footer], [t1].[Forum_EmailNotificationId], [t1].[TwitterAccount]
FROM [dbo].[Domain] AS [t0]
INNER JOIN [dbo].[Country] AS [t1] ON [t1].[CountryId] = [t0].[CountryId]
WHERE [t0].[Name] = @p0
-- @p0: Input NVarChar (Size = 18; Prec = 0; Scale = 0) [bookkeepers.org.uk]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT [t0].[DomainId], [t0].[CreatedDateTime], [t0].[AmendedDateTime], [t0].[CountryId], [t0].[Name], [t0].[GoogleMapKey], [t0].[GoogleAnalyticsKey], [t0].[PayPalLive], [t0].[PayPalBusinessId], [t0].[Gateway], [t0].[DirectoryIntro], [t0].[RegisterIntro], [t0].[DirectoryTitle], [t0].[DirectoryRolesHeading], [t0].[CssLink], [t0].[Description], [t1].[CountryId] AS [CountryId2], [t1].[CurrencyId], [t1].[ResponsableOfficeId], [t1].[EmailFooterTemplateId], [t1].[DefaultNewsletterId], [t1].[DefaultSMTPAccountId], [t1].[EventCategoryId], [t1].[ExaminationCategoryId], [t1].[MembershipCategoryId], [t1].[ExamExemptionGrade], [t1].[ExamDNAGrade], [t1].[ExamNSGrade], [t1].[ExamNCGrade], [t1].[Name] AS [Name2], [t1].[ISOCode], [t1].[Enabled], [t1].[ISO3Code], [t1].[DefaultLocationAddressId], [t1].[GoogleZoomLevel], [t1].[DirectoryEnabled], [t1].[MyBusinessEnabled], [t1].[Forum_Header], [t1].[Forum_Footer], [t1].[Forum_EmailNotificationId], [t1].[TwitterAccount]
FROM [dbo].[Domain] AS [t0]
INNER JOIN [dbo].[Country] AS [t1] ON [t1].[CountryId] = [t0].[CountryId]
WHERE [t0].[Name] = @p0
-- @p0: Input NVarChar (Size = 18; Prec = 0; Scale = 0) [bookkeepers.org.uk]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT [t0].[AddressId], [t0].[CountryId], [t0].[CountyId], [t0].[AddressLine1], [t0].[AddressLine2], [t0].[AddressLine3], [t0].[AddressLine4], [t0].[PostCode], [t0].[GeoLocated], [t0].[GeoAttemptCount], [t0].[CreatedDate]
FROM [dbo].[Address] AS [t0]
WHERE [t0].[AddressId] = @p0
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [406752]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
EXEC @RETURN_VALUE = [dbo].[usp_GeoGetLatLong] @AddressId = @p0
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [406752]
-- @RETURN_VALUE: Output Int (Size = 0; Prec = 0; Scale = 0) [Null]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT TOP (1) [t0].[GoogleMapKey]
FROM [dbo].[Domain] AS [t0]
WHERE ([t0].[Name] = @p0) AND (LEN([t0].[GoogleMapKey]) > @p1)
-- @p0: Input NVarChar (Size = 18; Prec = 0; Scale = 0) [bookkeepers.org.uk]
-- @p1: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1