SELECT
        [Leads].[Id] AS [Lead ID],
        [Leads].[IsDeleted] AS [Deleted],
        [Leads].[MasterRecordId] AS [Master Record ID],
        [Leads].[LastName] AS [Last Name],
        [Leads].[FirstName] AS [First Name],
        [Leads].[Salutation],
        [Leads].[Name] AS [Full Name],
        [Leads].[Title],
        [Leads].[Company],
        [Leads].[Street],
        [Leads].[City],
        [Leads].[State] AS [State/Province],
        [Leads].[PostalCode] AS [Zip/Postal Code],
        [Leads].[Country],
        [Leads].[Latitude],
        [Leads].[Longitude],
        [Leads].[Phone],
        [Leads].[MobilePhone] AS [Mobile Phone],
        [Leads].[Fax] AS [Fax (Leads)],
        [Leads].[Email],
        [Leads].[Website],
        [Leads].[PhotoUrl] AS [Photo URL],
        [Leads].[LeadSource] AS [Lead Source],
        [Leads].[Status],
        [Leads].[Industry],
        [Leads].[Rating],
        [Leads].[AnnualRevenue] AS [Annual Revenue],
        [Leads].[NumberOfEmployees] AS [Employees],
        [Leads].[OwnerId] AS [Owner ID],
        [Leads].[IsConverted] AS [Converted],
        [Leads].[ConvertedDate] AS [Converted Date],
        [Leads].[ConvertedAccountId] AS [Converted Account ID],
        [Leads].[ConvertedContactId] AS [Converted Contact ID],
        [Leads].[ConvertedOpportunityId] AS [Converted Opportunity ID],
        [Leads].[IsUnreadByOwner] AS [Unread By Owner],
        [Leads].[CreatedDate] AS [Created Date],
        [Leads].[CreatedById] AS [Created By ID],
        [Leads].[LastModifiedDate] AS [Last Modified Date],
        [Leads].[LastModifiedById] AS [Last Modified By ID],
        [Leads].[SystemModstamp] AS [System Modstamp],
        [Leads].[LastActivityDate] AS [Last Activity],
        [Leads].[LastViewedDate] AS [Last Viewed Date],
        [Leads].[LastReferencedDate] AS [Last Referenced Date],
        [Leads].[Jigsaw] AS [Data.com Key],
        [Leads].[JigsawContactId] AS [Jigsaw Contact ID],
        [Leads].[CleanStatus] AS [Clean Status],
        [Leads].[CompanyDunsNumber] AS [Company D-U-N-S Number],
        [Leads].[DandbCompanyId] AS [D&B Company ID],
        [Leads].[EmailBouncedReason] AS [Email Bounced Reason],
        [Leads].[EmailBouncedDate] AS [Email Bounced Date],
        [Leads].[SICCode__c] AS [SIC Code],
        [Leads].[ProductInterest__c] AS [Product Interest],
        [Leads].[Primary__c] AS [Primary],
        [Leads].[CurrentGenerators__c] AS [Current Generator(s)],
        [Leads].[NumberofLocations__c] AS [Number of Locations]
FROM
        [Lead] AS [Leads]

SELECT
        [Owned By].[Id] AS [User ID],
        [Owned By].[Username],
        [Owned By].[LastName] AS [LastName (Owned By)],
        [Owned By].[FirstName] AS [FirstName (Owned By)],
        [Owned By].[Name] AS [Name (Owned By)],
        [Owned By].[CompanyName] AS [Company Name],
        [Owned By].[Division],
        [Owned By].[Department],
        [Owned By].[Title] AS [Title (Owned By)],
        [Owned By].[Street] AS [Street (Owned By)],
        [Owned By].[City] AS [City (Owned By)],
        [Owned By].[State] AS [State (Owned By)],
        [Owned By].[PostalCode] AS [PostalCode (Owned By)],
        [Owned By].[Country] AS [Country (Owned By)],
        [Owned By].[Latitude] AS [Latitude (Owned By)],
        [Owned By].[Longitude] AS [Longitude (Owned By)],
        [Owned By].[Email] AS [Email (Owned By)],
        [Owned By].[EmailPreferencesAutoBcc] AS [AutoBcc],
        [Owned By].[EmailPreferencesAutoBccStayInTouch] AS [AutoBccStayInTouch],
        [Owned By].[EmailPreferencesStayInTouchReminder] AS [StayInTouchReminder],
        [Owned By].[SenderEmail] AS [Email Sender Address],
        [Owned By].[SenderName] AS [Email Sender Name],
        [Owned By].[Signature] AS [Email Signature],
        [Owned By].[StayInTouchSubject] AS [Stay-in-Touch Email Subject],
        [Owned By].[StayInTouchSignature] AS [Stay-in-Touch Email Signature],
        [Owned By].[StayInTouchNote] AS [Stay-in-Touch Email Note],
        [Owned By].[Phone] AS [Phone (Owned By)],
        [Owned By].[Fax],
        [Owned By].[MobilePhone] AS [Cell],
        [Owned By].[Alias],
        [Owned By].[CommunityNickname] AS [Nickname],
        [Owned By].[IsBadged] AS [User Photo has a badge overlay],
        [Owned By].[IsActive] AS [Active],
        [Owned By].[TimeZoneSidKey] AS [Time Zone],
        [Owned By].[UserRoleId] AS [Role ID],
        [Owned By].[LocaleSidKey] AS [Locale],
        [Owned By].[ReceivesInfoEmails] AS [Info Emails],
        [Owned By].[ReceivesAdminInfoEmails] AS [Admin Info Emails],
        [Owned By].[EmailEncodingKey] AS [Email Encoding],
        [Owned By].[ProfileId] AS [Profile ID],
        [Owned By].[UserType] AS [User Type],
        [Owned By].[LanguageLocaleKey] AS [Language],
        [Owned By].[EmployeeNumber] AS [Employee Number],
        [Owned By].[DelegatedApproverId] AS [Delegated Approver ID],
        [Owned By].[ManagerId] AS [Manager ID],
        [Owned By].[LastLoginDate] AS [Last Login],
        [Owned By].[LastPasswordChangeDate] AS [Last Password Change or Reset],
        [Owned By].[CreatedDate] AS [CreatedDate (Owned By)],
        [Owned By].[CreatedById] AS [CreatedById (Owned By)],
        [Owned By].[LastModifiedDate] AS [LastModifiedDate (Owned By)],
        [Owned By].[LastModifiedById] AS [LastModifiedById (Owned By)],
        [Owned By].[SystemModstamp] AS [SystemModstamp (Owned By)],
        [Owned By].[OfflineTrialExpirationDate] AS [Offline Edition Trial Expiration Date],
        [Owned By].[OfflinePdaTrialExpirationDate] AS [Sales Anywhere Trial Expiration Date],
        [Owned By].[UserPermissionsMarketingUser] AS [Marketing User],
        [Owned By].[UserPermissionsOfflineUser] AS [Offline User],
        [Owned By].[UserPermissionsCallCenterAutoLogin] AS [Auto-login To Call Center],
        [Owned By].[UserPermissionsMobileUser] AS [Apex Mobile User],
        [Owned By].[UserPermissionsSFContentUser] AS [Salesforce CRM Content User],
        [Owned By].[UserPermissionsKnowledgeUser] AS [Knowledge User],
        [Owned By].[UserPermissionsInteractionUser] AS [Force.com Flow User],
        [Owned By].[UserPermissionsSupportUser] AS [Service Cloud User],
        [Owned By].[UserPermissionsJigsawProspectingUser] AS [Data.com User],
        [Owned By].[UserPermissionsSiteforceContributorUser] AS [Site.com Contributor User],
        [Owned By].[UserPermissionsSiteforcePublisherUser] AS [Site.com Publisher User],
        [Owned By].[UserPermissionsWorkDotComUserFeature] AS [Work.com User],
        [Owned By].[ForecastEnabled] AS [Allow Forecasting],
        [Owned By].[UserPreferencesActivityRemindersPopup] AS [ActivityRemindersPopup],
        [Owned By].[UserPreferencesEventRemindersCheckboxDefault] AS [EventRemindersCheckboxDefault],
        [Owned By].[UserPreferencesTaskRemindersCheckboxDefault] AS [TaskRemindersCheckboxDefault],
        [Owned By].[UserPreferencesReminderSoundOff] AS [ReminderSoundOff],
        [Owned By].[UserPreferencesDisableAllFeedsEmail] AS [DisableAllFeedsEmail],
        [Owned By].[UserPreferencesDisableFollowersEmail] AS [DisableFollowersEmail],
        [Owned By].[UserPreferencesDisableProfilePostEmail] AS [DisableProfilePostEmail],
        [Owned By].[UserPreferencesDisableChangeCommentEmail] AS [DisableChangeCommentEmail],
        [Owned By].[UserPreferencesDisableLaterCommentEmail] AS [DisableLaterCommentEmail],
        [Owned By].[UserPreferencesDisProfPostCommentEmail] AS [DisProfPostCommentEmail],
        [Owned By].[UserPreferencesContentNoEmail] AS [ContentNoEmail],
        [Owned By].[UserPreferencesContentEmailAsAndWhen] AS [ContentEmailAsAndWhen],
        [Owned By].[UserPreferencesApexPagesDeveloperMode] AS [ApexPagesDeveloperMode],
        [Owned By].[UserPreferencesHideCSNGetChatterMobileTask] AS [HideCSNGetChatterMobileTask],
        [Owned By].[UserPreferencesDisableMentionsPostEmail] AS [DisableMentionsPostEmail],
        [Owned By].[UserPreferencesDisMentionsCommentEmail] AS [DisMentionsCommentEmail],
        [Owned By].[UserPreferencesHideCSNDesktopTask] AS [HideCSNDesktopTask],
        [Owned By].[UserPreferencesHideChatterOnboardingSplash] AS [HideChatterOnboardingSplash],
        [Owned By].[UserPreferencesHideSecondChatterOnboardingSplash] AS [HideSecondChatterOnboardingSplash],
        [Owned By].[UserPreferencesDisCommentAfterLikeEmail] AS [DisCommentAfterLikeEmail],
        [Owned By].[UserPreferencesDisableLikeEmail] AS [DisableLikeEmail],
        [Owned By].[UserPreferencesSortFeedByComment] AS [SortFeedByComment],
        [Owned By].[UserPreferencesDisableMessageEmail] AS [DisableMessageEmail],
        [Owned By].[UserPreferencesJigsawListUser] AS [JigsawListUser],
        [Owned By].[UserPreferencesDisableBookmarkEmail] AS [DisableBookmarkEmail],
        [Owned By].[UserPreferencesDisableSharePostEmail] AS [DisableSharePostEmail],
        [Owned By].[UserPreferencesEnableAutoSubForFeeds] AS [EnableAutoSubForFeeds],
        [Owned By].[UserPreferencesDisableFileShareNotificationsForApi] AS [DisableFileShareNotificationsForApi],
        [Owned By].[UserPreferencesShowTitleToExternalUsers] AS [ShowTitleToExternalUsers],
        [Owned By].[UserPreferencesShowManagerToExternalUsers] AS [ShowManagerToExternalUsers],
        [Owned By].[UserPreferencesShowEmailToExternalUsers] AS [ShowEmailToExternalUsers],
        [Owned By].[UserPreferencesShowWorkPhoneToExternalUsers] AS [ShowWorkPhoneToExternalUsers],
        [Owned By].[UserPreferencesShowMobilePhoneToExternalUsers] AS [ShowMobilePhoneToExternalUsers],
        [Owned By].[UserPreferencesShowFaxToExternalUsers] AS [ShowFaxToExternalUsers],
        [Owned By].[UserPreferencesShowStreetAddressToExternalUsers] AS [ShowStreetAddressToExternalUsers],
        [Owned By].[UserPreferencesShowCityToExternalUsers] AS [ShowCityToExternalUsers],
        [Owned By].[UserPreferencesShowStateToExternalUsers] AS [ShowStateToExternalUsers],
        [Owned By].[UserPreferencesShowPostalCodeToExternalUsers] AS [ShowPostalCodeToExternalUsers],
        [Owned By].[UserPreferencesShowCountryToExternalUsers] AS [ShowCountryToExternalUsers],
        [Owned By].[UserPreferencesShowProfilePicToGuestUsers] AS [ShowProfilePicToGuestUsers],
        [Owned By].[UserPreferencesShowTitleToGuestUsers] AS [ShowTitleToGuestUsers],
        [Owned By].[UserPreferencesShowCityToGuestUsers] AS [ShowCityToGuestUsers],
        [Owned By].[UserPreferencesShowStateToGuestUsers] AS [ShowStateToGuestUsers],
        [Owned By].[UserPreferencesShowPostalCodeToGuestUsers] AS [ShowPostalCodeToGuestUsers],
        [Owned By].[UserPreferencesShowCountryToGuestUsers] AS [ShowCountryToGuestUsers],
        [Owned By].[UserPreferencesDisableFeedbackEmail] AS [DisableFeedbackEmail],
        [Owned By].[UserPreferencesDisableWorkEmail] AS [DisableWorkEmail],
        [Owned By].[UserPreferencesHideS1BrowserUI] AS [HideS1BrowserUI],
        [Owned By].[UserPreferencesDisableEndorsementEmail] AS [DisableEndorsementEmail],
        [Owned By].[UserPreferencesLightningExperiencePreferred] AS [LightningExperiencePreferred],
        [Owned By].[ContactId] AS [Contact ID],
        [Owned By].[AccountId] AS [Account ID],
        [Owned By].[CallCenterId] AS [Call Center ID],
        [Owned By].[Extension],
        [Owned By].[FederationIdentifier] AS [SAML Federation ID],
        [Owned By].[AboutMe] AS [About Me],
        [Owned By].[FullPhotoUrl] AS [Url for full-sized Photo],
        [Owned By].[SmallPhotoUrl] AS [Photo],
        [Owned By].[DigestFrequency] AS [Chatter Email Highlights Frequency],
        [Owned By].[DefaultGroupNotificationFrequency] AS [Default Notification Frequency when Joining Groups],
        [Owned By].[JigsawImportLimitOverride] AS [Data.com Monthly Addition Limit],
        [Owned By].[LastViewedDate] AS [LastViewedDate (Owned By)],
        [Owned By].[LastReferencedDate] AS [LastReferencedDate (Owned By)]
FROM
        [User] AS [Owned By]

SELECT
        [Created By].[Id] AS [Id (Created By)],
        [Created By].[Username] AS [Username (Created By)],
        [Created By].[LastName] AS [LastName (Created By)],
        [Created By].[FirstName] AS [FirstName (Created By)],
        [Created By].[Name] AS [Name (Created By)],
        [Created By].[CompanyName] AS [CompanyName (Created By)],
        [Created By].[Division] AS [Division (Created By)],
        [Created By].[Department] AS [Department (Created By)],
        [Created By].[Title] AS [Title (Created By)],
        [Created By].[Street] AS [Street (Created By)],
        [Created By].[City] AS [City (Created By)],
        [Created By].[State] AS [State (Created By)],
        [Created By].[PostalCode] AS [PostalCode (Created By)],
        [Created By].[Country] AS [Country (Created By)],
        [Created By].[Latitude] AS [Latitude (Created By)],
        [Created By].[Longitude] AS [Longitude (Created By)],
        [Created By].[Email] AS [Email (Created By)],
        [Created By].[EmailPreferencesAutoBcc] AS [EmailPreferencesAutoBcc (Created By)],
        [Created By].[EmailPreferencesAutoBccStayInTouch] AS [EmailPreferencesAutoBccStayInTouch (Created By)],
        [Created By].[EmailPreferencesStayInTouchReminder] AS [EmailPreferencesStayInTouchReminder (Created By)],
        [Created By].[SenderEmail] AS [SenderEmail (Created By)],
        [Created By].[SenderName] AS [SenderName (Created By)],
        [Created By].[Signature] AS [Signature (Created By)],
        [Created By].[StayInTouchSubject] AS [StayInTouchSubject (Created By)],
        [Created By].[StayInTouchSignature] AS [StayInTouchSignature (Created By)],
        [Created By].[StayInTouchNote] AS [StayInTouchNote (Created By)],
        [Created By].[Phone] AS [Phone (Created By)],
        [Created By].[Fax] AS [Fax (Created By)],
        [Created By].[MobilePhone] AS [MobilePhone (Created By)],
        [Created By].[Alias] AS [Alias (Created By)],
        [Created By].[CommunityNickname] AS [CommunityNickname (Created By)],
        [Created By].[IsBadged] AS [IsBadged (Created By)],
        [Created By].[IsActive] AS [IsActive (Created By)],
        [Created By].[TimeZoneSidKey] AS [TimeZoneSidKey (Created By)],
        [Created By].[UserRoleId] AS [UserRoleId (Created By)],
        [Created By].[LocaleSidKey] AS [LocaleSidKey (Created By)],
        [Created By].[ReceivesInfoEmails] AS [ReceivesInfoEmails (Created By)],
        [Created By].[ReceivesAdminInfoEmails] AS [ReceivesAdminInfoEmails (Created By)],
        [Created By].[EmailEncodingKey] AS [EmailEncodingKey (Created By)],
        [Created By].[ProfileId] AS [ProfileId (Created By)],
        [Created By].[UserType] AS [UserType (Created By)],
        [Created By].[LanguageLocaleKey] AS [LanguageLocaleKey (Created By)],
        [Created By].[EmployeeNumber] AS [EmployeeNumber (Created By)],
        [Created By].[DelegatedApproverId] AS [DelegatedApproverId (Created By)],
        [Created By].[ManagerId] AS [ManagerId (Created By)],
        [Created By].[LastLoginDate] AS [LastLoginDate (Created By)],
        [Created By].[LastPasswordChangeDate] AS [LastPasswordChangeDate (Created By)],
        [Created By].[CreatedDate] AS [CreatedDate (Created By)],
        [Created By].[CreatedById] AS [CreatedById (Created By)],
        [Created By].[LastModifiedDate] AS [LastModifiedDate (Created By)],
        [Created By].[LastModifiedById] AS [LastModifiedById (Created By)],
        [Created By].[SystemModstamp] AS [SystemModstamp (Created By)],
        [Created By].[OfflineTrialExpirationDate] AS [OfflineTrialExpirationDate (Created By)],
        [Created By].[OfflinePdaTrialExpirationDate] AS [OfflinePdaTrialExpirationDate (Created By)],
        [Created By].[UserPermissionsMarketingUser] AS [UserPermissionsMarketingUser (Created By)],
        [Created By].[UserPermissionsOfflineUser] AS [UserPermissionsOfflineUser (Created By)],
        [Created By].[UserPermissionsCallCenterAutoLogin] AS [UserPermissionsCallCenterAutoLogin (Created By)],
        [Created By].[UserPermissionsMobileUser] AS [UserPermissionsMobileUser (Created By)],
        [Created By].[UserPermissionsSFContentUser] AS [UserPermissionsSFContentUser (Created By)],
        [Created By].[UserPermissionsKnowledgeUser] AS [UserPermissionsKnowledgeUser (Created By)],
        [Created By].[UserPermissionsInteractionUser] AS [UserPermissionsInteractionUser (Created By)],
        [Created By].[UserPermissionsSupportUser] AS [UserPermissionsSupportUser (Created By)],
        [Created By].[UserPermissionsJigsawProspectingUser] AS [UserPermissionsJigsawProspectingUser (Created By)],
        [Created By].[UserPermissionsSiteforceContributorUser] AS [UserPermissionsSiteforceContributorUser (Created By)],
        [Created By].[UserPermissionsSiteforcePublisherUser] AS [UserPermissionsSiteforcePublisherUser (Created By)],
        [Created By].[UserPermissionsWorkDotComUserFeature] AS [UserPermissionsWorkDotComUserFeature (Created By)],
        [Created By].[ForecastEnabled] AS [ForecastEnabled (Created By)],
        [Created By].[UserPreferencesActivityRemindersPopup] AS [UserPreferencesActivityRemindersPopup (Created By)],
        [Created By].[UserPreferencesEventRemindersCheckboxDefault] AS [UserPreferencesEventRemindersCheckboxDefault (Created By)],
        [Created By].[UserPreferencesTaskRemindersCheckboxDefault] AS [UserPreferencesTaskRemindersCheckboxDefault (Created By)],
        [Created By].[UserPreferencesReminderSoundOff] AS [UserPreferencesReminderSoundOff (Created By)],
        [Created By].[UserPreferencesDisableAllFeedsEmail] AS [UserPreferencesDisableAllFeedsEmail (Created By)],
        [Created By].[UserPreferencesDisableFollowersEmail] AS [UserPreferencesDisableFollowersEmail (Created By)],
        [Created By].[UserPreferencesDisableProfilePostEmail] AS [UserPreferencesDisableProfilePostEmail (Created By)],
        [Created By].[UserPreferencesDisableChangeCommentEmail] AS [UserPreferencesDisableChangeCommentEmail (Created By)],
        [Created By].[UserPreferencesDisableLaterCommentEmail] AS [UserPreferencesDisableLaterCommentEmail (Created By)],
        [Created By].[UserPreferencesDisProfPostCommentEmail] AS [UserPreferencesDisProfPostCommentEmail (Created By)],
        [Created By].[UserPreferencesContentNoEmail] AS [UserPreferencesContentNoEmail (Created By)],
        [Created By].[UserPreferencesContentEmailAsAndWhen] AS [UserPreferencesContentEmailAsAndWhen (Created By)],
        [Created By].[UserPreferencesApexPagesDeveloperMode] AS [UserPreferencesApexPagesDeveloperMode (Created By)],
        [Created By].[UserPreferencesHideCSNGetChatterMobileTask] AS [UserPreferencesHideCSNGetChatterMobileTask (Created By)],
        [Created By].[UserPreferencesDisableMentionsPostEmail] AS [UserPreferencesDisableMentionsPostEmail (Created By)],
        [Created By].[UserPreferencesDisMentionsCommentEmail] AS [UserPreferencesDisMentionsCommentEmail (Created By)],
        [Created By].[UserPreferencesHideCSNDesktopTask] AS [UserPreferencesHideCSNDesktopTask (Created By)],
        [Created By].[UserPreferencesHideChatterOnboardingSplash] AS [UserPreferencesHideChatterOnboardingSplash (Created By)],
        [Created By].[UserPreferencesHideSecondChatterOnboardingSplash] AS [UserPreferencesHideSecondChatterOnboardingSplash (Created By)],
        [Created By].[UserPreferencesDisCommentAfterLikeEmail] AS [UserPreferencesDisCommentAfterLikeEmail (Created By)],
        [Created By].[UserPreferencesDisableLikeEmail] AS [UserPreferencesDisableLikeEmail (Created By)],
        [Created By].[UserPreferencesSortFeedByComment] AS [UserPreferencesSortFeedByComment (Created By)],
        [Created By].[UserPreferencesDisableMessageEmail] AS [UserPreferencesDisableMessageEmail (Created By)],
        [Created By].[UserPreferencesJigsawListUser] AS [UserPreferencesJigsawListUser (Created By)],
        [Created By].[UserPreferencesDisableBookmarkEmail] AS [UserPreferencesDisableBookmarkEmail (Created By)],
        [Created By].[UserPreferencesDisableSharePostEmail] AS [UserPreferencesDisableSharePostEmail (Created By)],
        [Created By].[UserPreferencesEnableAutoSubForFeeds] AS [UserPreferencesEnableAutoSubForFeeds (Created By)],
        [Created By].[UserPreferencesDisableFileShareNotificationsForApi] AS [UserPreferencesDisableFileShareNotificationsForApi (Created By)],
        [Created By].[UserPreferencesShowTitleToExternalUsers] AS [UserPreferencesShowTitleToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowManagerToExternalUsers] AS [UserPreferencesShowManagerToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowEmailToExternalUsers] AS [UserPreferencesShowEmailToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowWorkPhoneToExternalUsers] AS [UserPreferencesShowWorkPhoneToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowMobilePhoneToExternalUsers] AS [UserPreferencesShowMobilePhoneToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowFaxToExternalUsers] AS [UserPreferencesShowFaxToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowStreetAddressToExternalUsers] AS [UserPreferencesShowStreetAddressToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowCityToExternalUsers] AS [UserPreferencesShowCityToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowStateToExternalUsers] AS [UserPreferencesShowStateToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowPostalCodeToExternalUsers] AS [UserPreferencesShowPostalCodeToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowCountryToExternalUsers] AS [UserPreferencesShowCountryToExternalUsers (Created By)],
        [Created By].[UserPreferencesShowProfilePicToGuestUsers] AS [UserPreferencesShowProfilePicToGuestUsers (Created By)],
        [Created By].[UserPreferencesShowTitleToGuestUsers] AS [UserPreferencesShowTitleToGuestUsers (Created By)],
        [Created By].[UserPreferencesShowCityToGuestUsers] AS [UserPreferencesShowCityToGuestUsers (Created By)],
        [Created By].[UserPreferencesShowStateToGuestUsers] AS [UserPreferencesShowStateToGuestUsers (Created By)],
        [Created By].[UserPreferencesShowPostalCodeToGuestUsers] AS [UserPreferencesShowPostalCodeToGuestUsers (Created By)],
        [Created By].[UserPreferencesShowCountryToGuestUsers] AS [UserPreferencesShowCountryToGuestUsers (Created By)],
        [Created By].[UserPreferencesDisableFeedbackEmail] AS [UserPreferencesDisableFeedbackEmail (Created By)],
        [Created By].[UserPreferencesDisableWorkEmail] AS [UserPreferencesDisableWorkEmail (Created By)],
        [Created By].[UserPreferencesHideS1BrowserUI] AS [UserPreferencesHideS1BrowserUI (Created By)],
        [Created By].[UserPreferencesDisableEndorsementEmail] AS [UserPreferencesDisableEndorsementEmail (Created By)],
        [Created By].[UserPreferencesLightningExperiencePreferred] AS [UserPreferencesLightningExperiencePreferred (Created By)],
        [Created By].[ContactId] AS [ContactId (Created By)],
        [Created By].[AccountId] AS [AccountId (Created By)],
        [Created By].[CallCenterId] AS [CallCenterId (Created By)],
        [Created By].[Extension] AS [Extension (Created By)],
        [Created By].[FederationIdentifier] AS [FederationIdentifier (Created By)],
        [Created By].[AboutMe] AS [AboutMe (Created By)],
        [Created By].[FullPhotoUrl] AS [FullPhotoUrl (Created By)],
        [Created By].[SmallPhotoUrl] AS [SmallPhotoUrl (Created By)],
        [Created By].[DigestFrequency] AS [DigestFrequency (Created By)],
        [Created By].[DefaultGroupNotificationFrequency] AS [DefaultGroupNotificationFrequency (Created By)],
        [Created By].[JigsawImportLimitOverride] AS [JigsawImportLimitOverride (Created By)],
        [Created By].[LastViewedDate] AS [LastViewedDate (Created By)],
        [Created By].[LastReferencedDate] AS [LastReferencedDate (Created By)]
FROM
        [User] AS [Created By]

SELECT
        [Opportunity].[Id] AS [Opportunity ID],
        [Opportunity].[IsDeleted] AS [IsDeleted (Opportunity)],
        [Opportunity].[AccountId] AS [AccountId (Opportunity)],
        [Opportunity].[IsPrivate] AS [Private],
        [Opportunity].[Name],
        [Opportunity].[StageName] AS [Stage],
        [Opportunity].[Amount],
        [Opportunity].[Probability] AS [Probability (%)],
        [Opportunity].[ExpectedRevenue] AS [Expected Amount],
        [Opportunity].[TotalOpportunityQuantity] AS [Quantity],
        [Opportunity].[CloseDate] AS [Close Date],
        [Opportunity].[Type] AS [Opportunity Type],
        [Opportunity].[NextStep] AS [Next Step],
        [Opportunity].[LeadSource] AS [LeadSource (Opportunity)],
        [Opportunity].[IsClosed] AS [Closed],
        [Opportunity].[IsWon] AS [Won],
        [Opportunity].[ForecastCategory] AS [Forecast Category],
        [Opportunity].[ForecastCategoryName] AS [Forecast Category1],
        [Opportunity].[CampaignId] AS [Campaign ID],
        [Opportunity].[HasOpportunityLineItem] AS [Has Line Item],
        [Opportunity].[Pricebook2Id] AS [Price Book ID],
        [Opportunity].[OwnerId] AS [OwnerId (Opportunity)],
        [Opportunity].[CreatedDate] AS [CreatedDate (Opportunity)],
        [Opportunity].[CreatedById] AS [CreatedById (Opportunity)],
        [Opportunity].[LastModifiedDate] AS [LastModifiedDate (Opportunity)],
        [Opportunity].[LastModifiedById] AS [LastModifiedById (Opportunity)],
        [Opportunity].[SystemModstamp] AS [SystemModstamp (Opportunity)],
        [Opportunity].[LastActivityDate] AS [LastActivityDate (Opportunity)],
        [Opportunity].[FiscalQuarter] AS [Fiscal Quarter],
        [Opportunity].[FiscalYear] AS [Fiscal Year],
        [Opportunity].[Fiscal] AS [Fiscal Period],
        [Opportunity].[LastViewedDate] AS [LastViewedDate (Opportunity)],
        [Opportunity].[LastReferencedDate] AS [LastReferencedDate (Opportunity)],
        [Opportunity].[DeliveryInstallationStatus__c] AS [Delivery/Installation Status],
        [Opportunity].[TrackingNumber__c] AS [Tracking Number],
        [Opportunity].[OrderNumber__c] AS [Order Number],
        [Opportunity].[CurrentGenerators__c] AS [CurrentGenerators__c (Opportunity)],
        [Opportunity].[MainCompetitors__c] AS [Main Competitor(s)]
FROM
        [Opportunity]