Start Processing : 2025-06-25 06:43:44
0 rows affectedUPDATE db_pardot_prospects SET _createdTS = STR_TO_DATE(_createdDate, '%c/%e/%Y %H:%i');
[10] 0.15 seconds -> -1 rows affected
UPDATE db_pardot_prospects SET _crmContactFid = (select nullif(_crmContactFid, '')), _crmLeadFid = (select nullif(_crmLeadFid, '')), _industry = (select nullif(_industry, '')), _phoenixSegment = (select nullif(_phoenixSegment, '')), _ownersSegment = (select nullif(_ownersSegment, ''));
[40] 2.86 seconds -> 0 rows affected
UPDATE db_pardot_prospects SET _2xSegment = coalesce(_phoenixSegment, _ownersSegment, _industry);
[50] 0.96 seconds -> 0 rows affected
UPDATE db_pardot_prospects SET _contactID = coalesce(_crmContactFid, _crmLeadFid);
[60] 0.94 seconds -> 0 rows affected
INSERT INTO db_contacts (_contactID, _firstName, _lastName, _email, _title, _phone, _mobile, _contactStatus, _doNotEmail, _doNotCall, _accountName, _accountID, _accountType, _mailingStreet, _mailingCity, _mailingStateprovince, _mailingZippostalCode, _mailingCountry, _accountOwner, _segment, _createdTS, _source) select _contactID, _firstName, _lastName, _email, _jobTitle, _phone, null as _mobile, _currentStatus, _doNotEmail, _doNotCall, _company, null as _accountID, _phoenixAccountType, _addressOne, _city, _state, _zip, _country, null as _accountOwner, _2xSegment, _createdTS, 'Pardot' as _source from db_pardot_prospects ON DUPLICATE KEY UPDATE _contactID = VALUES(_contactID), _firstName = VALUES(_firstName), _lastName = VALUES(_lastName), _email = VALUES(_email), _title = VALUES(_title), _phone = VALUES(_phone), _mobile = VALUES(_mobile), _contactStatus = VALUES(_contactStatus), _doNotEmail = VALUES(_doNotEmail), _doNotCall = VALUES(_doNotCall), _accountName = VALUES(_accountName), _accountID = VALUES(_accountID), _accountType = VALUES(_accountType), _mailingStreet = VALUES(_mailingStreet), _mailingCity = VALUES(_mailingCity), _mailingStateprovince = VALUES(_mailingStateprovince), _mailingZippostalCode = VALUES(_mailingZippostalCode), _mailingCountry = VALUES(_mailingCountry), _accountOwner = VALUES(_accountOwner), _segment = VALUES(_segment), _createdTS = VALUES(_createdTS), _source = VALUES(_source)
[70] 6.16 seconds -> 1334 rows affected
UPDATE db_salesforce_leads SET _industry = (select nullif(_industry, '')), _segment = (select nullif(_segment, ''));
[80] 0.44 seconds -> 0 rows affected
UPDATE db_salesforce_leads SET _2xSegment = coalesce(_segment, _industry);
[90] 0.24 seconds -> 0 rows affected
INSERT IGNORE INTO db_contacts (_contactID, _firstName, _lastName, _email, _title, _phone, _mobile, _contactStatus, _doNotEmail, _doNotCall, _accountName, _accountID, _accountType, _mailingStreet, _mailingCity, _mailingStateprovince, _mailingZippostalCode, _mailingCountry, _accountOwner, _segment, _createdTS, _source) select _leadID, _firstName, _lastName, _email, _title, _phone, _mobile, _leadStatus, 0 as _doNotEmail, 0 as _doNotCall, _companyAccount, null as _accountID, _accountType, _street, _city, _stateprovince, _zippostalCode, _country, null as _accountOwner, _2xSegment, _createdTS, 'Leads' as _source from db_salesforce_leads where _email != '';
[100] 0.94 seconds -> 0 rows affected
UPDATE db_salesforce_contacts SET _industry = (select nullif(_industry, '')), _segment = (select nullif(_segment, ''));
[110] 0.25 seconds -> 0 rows affected
UPDATE db_salesforce_contacts SET _2xSegment = coalesce(_segment, _industry);
[120] 0.1 seconds -> 0 rows affected
INSERT IGNORE INTO db_contacts (_contactID, _firstName, _lastName, _email, _title, _phone, _mobile, _contactStatus, _doNotEmail, _doNotCall, _accountName, _accountID, _accountType, _mailingStreet, _mailingCity, _mailingStateprovince, _mailingZippostalCode, _mailingCountry, _accountOwner, _segment, _createdTS, _source) select _contactID, _firstName, _lastName, _email, _title, _phone, _mobile, _status, 0 as _doNotEmail, 0 as _doNotCall, _accountName, _accountID, _type, _mailingStreet, _mailingCity, _mailingStateprovince, _mailingZippostalCode, _mailingCountry, _accountOwner, _2xSegment, _createdTS, 'Contacts' as _source from (select a.*, b._stage from db_salesforce_contacts a left join db_opportunity_temp b on a._accountName = b._accountName) c where _email !='' && (_stage is null or _stage = 'Closed Lost');
[130] 0.53 seconds -> 0 rows affected