Untitled

t1.[Id] AS [ProjectId],
t1.[Name] AS [ProjectName],
t1.[Account_Name__c] AS [AccountId],
# t2.[Name] AS [AccountName],
t1.[OwnerID] AS [OwnerId],
# t3.[Name] AS [OwnerName],
t1.[Brand_Owner__c] AS [BrandOwnerId],
# t4.[Name] AS [BrandOwnerName],
# NULL AS [OpportunityName],
t1.[Product__c] AS [PIM],
# t5.[Name] AS [PIMProductName],
# t6.[Name] AS [GlobalClientId],
t1.[Project_Type__c] AS [Type],
t1.[Stage__c] AS [Stage],
t1.[Status__c] AS [Status],
t1.[Reason_for_Closed_Lost__c] AS [ReasonForClosedLost],
t1.[Reason_for_Close_Lost__c] AS [SpecifyReasonForClosedLost],
t1.[Owner_Country__c] AS [OwnerCountry],
t1.[Business_Line_New__c] AS [BusinessLine],
t1.[Industry_Cluster_New__c] AS [IndustryCluster],
t1.[Sub_Industry_Cluster_New__c] AS [SubIndustryCluster],
t1.[Application_Text__c] AS [Application],
t1.[Product_Category_New__c] AS [ProductCategory],
t1.[Top_Project__c] AS [Top10ActiveProjects],
t1.[Have_you_used_DKSH_Customer_Portal_DKSH__c] AS [HaveYouUsedDKSHDiscover],
t1.[Project_emerged_from_a_Digital_Campaign__c] AS [ProjectEmergedFromADigitalChannel],
t1.[Project_emerged_from_an_exhibition__c] AS [ProjectEmergedFromAnExhibition],
t1.[Related_digital_activity_title__c] AS [RelatedDigitalActivity],
t1.[Related_digital_activity_id__c] AS [RelatedDigitalActivityID],
t1.[Probability__c] AS [Probability],
t1.[Kickoff__c] AS [StartDate],
t1.[Dateline__c] AS [EndDate],
t1.[CreatedDate] AS [CreatedDate],
t1.[Description__c] AS [Description],
# NULL AS [NextStep],
t1.[Project_Resource__c] AS [Comments],
t1.[CurrencyIsoCode],
t1.[Price_Year_1__c] AS [Price_Y1],
t1.[Net_Sales_Year_1_New__c] AS [NetSales_Y1],
t1.[GM1_V_Year_1__c] AS [GMI_V_Year1],
t1.[GM1_P_Year_1__c] AS [GMI_P_Y1],
t1.[Volume_Year_1__c] AS [Volume_Y1],
t1.[Price_Year_2__c] AS [Price_Y2],
t1.[Net_Sales_Year_1_New__c] AS [NetSales_Y2],
t1.[GM1_V_Year_2__c] AS [GMI_V_Year2],
t1.[GM1_P_Year_1__c] AS [GMI_P_Y2],
t1.[Volume_Year_2__c] AS [Volume_Y2],
t1.[Unit_of_Measure_UOM__c] AS [UOM],
NULL AS [State],
t1.[Close_Date__c] AS [ClosedDate]