SELECT
        [Activities - All].[ActivityId],
        [Activities - All].[ActivityType],
        [Activities - All].[ActivityDate],
        [Activities - All].[EmailAddress],
        [Activities - All].[ContactId],
        [Activities - All].[EmailRecipientId],
        [Activities - All].[AssetType],
        [Activities - All].[AssetId],
        [Activities - All].[AssetName],
        [Activities - All].[SubjectLine],
        [Activities - All].[EmailWebLink],
        [Activities - All].[CampaignId],
        [Activities - All].[ExternalId],
        [Activities - All].[DeploymentId],
        [Activities - All].[EmailSendType],
        [Activities - All].[VisitorId],
        [Activities - All].[VisitorExternalId],
        [Activities - All].[ReferrerUrl],
        [Activities - All].[IpAddress],
        [Activities - All].[NumberOfPages],
        [Activities - All].[FirstPageViewUrl],
        [Activities - All].[Duration],
        [Activities - All].[WebVisitId],
        [Activities - All].[Url],
        [Activities - All].[IsWebTrackingOptedIn],
        [Activities - All].[RawData],
        [Activities - All].[EmailClickedThruLink]
FROM
        [activitiesAll] AS [Activities - All]

SELECT
        [Campaigns].[actualCost],
        [Campaigns].[budgetedCost],
        [Campaigns].[campaignCategory],
        [Campaigns].[campaignType],
        [Campaigns].[createdAt],
        [Campaigns].[crmId],
        [Campaigns].[currentStatus],
        [Campaigns].[description],
        [Campaigns].[endAt],
        [Campaigns].[firstActivation],
        [Campaigns].[id],
        [Campaigns].[isEmailMarketingCampaign],
        [Campaigns].[isIncludedInROI],
        [Campaigns].[isMemberAllowedReEntry],
        [Campaigns].[isReadOnly],
        [Campaigns].[isSyncedWithCRM],
        [Campaigns].[memberCount],
        [Campaigns].[name],
        [Campaigns].[product],
        [Campaigns].[region],
        [Campaigns].[startAt],
        [Campaigns].[updatedAt],
        [Campaigns].[eloquacustomfield_3],
        [Campaigns].[eloquacustomfield_4],
        [Campaigns].[eloquacustomfield_5],
        [Campaigns].[eloquacustomfield_6],
        [Campaigns].[eloquacustomfield_7],
        [Campaigns].[eloquacustomfield_8],
        [Campaigns].[eloquacustomfield_9],
        [Campaigns].[eloquacustomfield_10],
        [Campaigns].[eloquacustomfield_12],
        [Campaigns].[eloquacustomfield_13],
        [Campaigns].[eloquacustomfield_16],
        [Campaigns].[eloquacustomfield_17],
        [Campaigns].[eloquacustomfield_18],
        [Campaigns].[eloquacustomfield_19],
        [Campaigns].[eloquacustomfield_20],
        [Campaigns].[eloquacustomfield_28],
        [Campaigns].[eloquacustomfield_29],
        [Campaigns].[eloquacustomfield_30],
        [Campaigns].[eloquacustomfield_31]
FROM
        [campaigns] AS [Campaigns]