SELECT Name, Owner.name, Partner_Text__c, Auto_Gen_Opportunity_ID__c, Type,Partner__r.name,Partner__r.Zift_Partner_Id__c,Deal_Reg_Primary_Product_Interest_Text__c, End_Customer__r.Name, CreatedDate, CloseDate, Amount, CurrencyIsoCode, StageName, Lost_Reason__c, Won_Reason__c FROM Opportunity