Start Processing : 2024-09-20 02:45:27<BR>0 rows affectedUPDATE db_televerde
SET 
_calledOnTS = STR_TO_DATE(_calledondatetime, '%c/%e/%Y %l:%i %p')
where length (_calledondatetime) != 0;<BR>[1] 0.01 seconds -> -1 rows affected<BR>INSERT IGNORE INTO db_engagement_combined (_activityTypeID, _campaign, _email, _jobTitle, _accountName, _accountID, _activityTS)
select 'Televerde Call' as _type, 'Televerde Activity' as _campaign, _emailAddress, _title, _accountName, _accountID, _calledOnTS from (
select a._emailAddress, b._title, _callresult, _calledOnTS, b._accountName, b._accountID from db_televerde a
left join db_contacts b on a._emailAddress = b._email
where _calledOnTS between (select date_add(now(), interval -12 month)) and now() && a._callresult in ('Deliverable', 'Follow Up', 'InProgress', 'No Business Potential', 'Not Interested', 'Reschedule', 'Transfer') 
&& length(a._emailAddress) != 0
group by a._emailAddress, b._title, _callresult, _calledOnTS, b._accountName, b._accountID) tv;<BR>[2] 0.03 seconds -> -1 rows affected<BR>