gistfile1.txt

select Id, IsDeleted, MasterRecordId, LastName, FirstName, Salutation, Name, RecordTypeId, Title, Company, Street, City, State, PostalCode, Country, Latitude, Longitude, Address, Phone, MobilePhone, Fax, Email, Website, PhotoUrl, Description, LeadSource, Status, Industry, CurrencyIsoCode, OwnerId, HasOptedOutOfEmail, IsConverted, ConvertedDate, ConvertedAccountId, ConvertedContactId, ConvertedOpportunityId, IsUnreadByOwner, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastActivityDate, LastViewedDate, LastReferencedDate, Jigsaw, JigsawContactId, ConnectionReceivedId, ConnectionSentId, EmailBouncedReason, EmailBouncedDate, ProductsInterest__c, AdditionalComments__c, CTA__c, Channel__c, FormID__c, Solution_Family__c, Solution__c, CurrentSoftware__c, Tier__c, VerticalMarket__c, rrpu__Alert_Message__c, Software_Advice_Notes__c, No_Outreaches_since_LFFD__c, SalesLoft_Stage__c, Unqualified_Reason_2__c, Time_to_First_Follow_Up__c, Web_Form__c, ON24EventTitle__c, LastOutreachByRole__c, Lead_Type__c, Comments__c, Lead_Number__c, Record_Robin_ID__c, LastOutreachByRep__c, ON24_Engagement_Score__c, Suspect_Lead_Stage_Date_Stamp__c, Recycled_Reason__c, Lead_Age__c, Bills_Back_Utilities__c, Unqualified_Reason__c, Products_of_Interest__c, Buyer_Status__c, Current_Pain_Points__c, Property_Types__c, Description__c, Market_Size__c, EmailContactGroup__c, Last_Activity_Date__c, Bus_Days_Worked_Lead__c, Buyer_Status_Comments__c, Military_Properties_Sites__c, Military_Beds__c, Military_Units__c, Single_Family_Units__c, Single_Family_Properties__c, Owner_Change_Date__c, LID__LinkedIn_Company_Id__c, LID__LinkedIn_Member_Token__c, Commercial_Props__c, Commercial_Units__c, Days_Since_Created__c, opsROIunits__c, opsROIsites__c, Alternate_Phone__c, Web_Form_Name__c, No_of_Days_Assigned_to_Sales_Rep__c, Qualified_Date__c, Sales_First_Follow_Up__c, Time_to_Purchase__c, Original_PPC_Date__c, Campaign_Mapping__c, Original_PPC_Network__c, Original_PPC_Conversion__c, Original_PPC_Keyword__c, Original_PPC_URL__c, Brightcove_Referrer_Domain__c, Engagement_Score__c, Primary_Asset_Type__c, Last_Form_Fill_Detail__c, Engagement_Solution_of_Interest__c, Engagement_Area_of_Interest__c, Standardized_Title__c, Clean_Title__c, Engagement_Channel__c, Engagement_Behavior__c, Recycled_Date__c, LinkedIn_Profile__c, Current_Vendor__c, Property_Name__c, Lead_to_Opp_Conversion__c, MQL_Date__c, Other_Reason__c, Lead_Source_Campaign__c, Owner_Lead_Status__c, Unqualified_Date__c, Commercial_Account__c, Commercial_Contact__c, Industrial_Square_Footage__c, Number_of_Leases__c, Office_Square_Footage__c, Retail_Square_Footage__c, Total_Commercial_Square_Footage__c, First_Form_Fill_Date__c, Last_Form_Fill_Date__c, Lead_Source_Detail__c, ClientID__c, GCLID__c, Referrer__c, SessionID__c, utm_adgroup__c, utm_campaign__c, utm_content__c, utm_keyword__c, utm_medium__c, utm_source__c, Do_Not_Send_Email__c, Alternate_Email__c, Form_URL__c, Linked_In_Form_Name__c, RPX_Application__c, Date_of_Last_Outreach__c, Last_Date_Pardot_Task_Created__c, No_of_Days_Between_Engagement__c, No_of_Days_Between_Last_Outreach_LFFD__c, No_of_Days_Since_Last_Engagement__c, No_of_Touches__c, Total_No_of_Outreaches__c, No_of_Outreaches_since_Qualified__c, GACLIENTID__c, GATRACKID__c, GAUSERID__c, Vendor_Service_ID__c, Engaged_Lead_Stage_Date_Stamp__c, MQL_Lead_Stage_Date_Stamp__c, TQL_Lead_Stage_Date_Stamp__c, SAL_Lead_Stage_Date_Stamp__c, SQL_Lead_Stage_Date_Stamp__c, Lead_Stage__c from lead where LastModifiedDate >= 2000-01-01T00:00:00.000Z order by LastModifiedDate asc