SHAPE { SELECT TOP 1000 ReferSite.[Domain] AS [Referral Site], COUNT(Hit.ID) AS Hits FROM ((((Hit INNER JOIN xDateFilter ON Hit.DateTimeID = xDateFilter.ID) INNER JOIN Referral ON Hit.ReferralID = Referral.ID) INNER JOIN ReferURL ON Referral.URLID = ReferURL.ID) INNER JOIN ReferSite ON ReferURL.SiteID = ReferSite.ID) GROUP BY ReferSite.[Domain] ORDER BY COUNT(Hit.ID) DESC } APPEND ( { SELECT ReferSite.[Domain] AS Ref, File.FileName AS [Referred Page], COUNT(ReferSite.ID) AS Hits FROM ((xDateFilter INNER JOIN ((Hit INNER JOIN Referral ON Hit.ReferralID = Referral.ID) INNER JOIN (ReferURL INNER JOIN ReferSite ON ReferURL.SiteID = ReferSite.ID) ON Referral.URLID = ReferURL.ID) ON xDateFilter.ID = Hit.DateTimeID ) INNER JOIN File ON Hit.FileID = File.ID) GROUP BY ReferSite.[Domain], File.FileName ORDER BY COUNT(ReferSite.ID) DESC } RELATE [Referral Site] To Ref )