Start Processing : 2024-09-20 02:49:27<BR>0 rows affectedUPDATE IGNORE  db_task SET _createTS = STR_TO_DATE(_createdDate, '%m/%d/%Y') WHERE LENGTH(_createdDate)>0<BR>[1] 1.67 seconds -> 0 rows affected<BR>UPDATE IGNORE db_task SET _startTS= STR_TO_DATE(_start, '%m/%d/%Y') WHERE LENGTH(_start)>0<BR>[10] 0.81 seconds -> 0 rows affected<BR>UPDATE IGNORE db_task SET  _dateTS= STR_TO_DATE(_date, '%m/%d/%Y')  WHERE LENGTH(_date)>0<BR>[15] 0.71 seconds -> 0 rows affected<BR>INSERT IGNORE INTO deleted_meetings (_activityID, _deletedDate)
SELECT _activityID, _processed FROM db_task t, atom_batch b WHERE UNIX_TIMESTAMP(_createTS) > UNIX_TIMESTAMP()-(86400*7) AND _activityType = 'Discovery Call' AND b._id = t._batchID AND _batchID < (SELECT MAX(_batchID) FROM db_task WHERE UNIX_TIMESTAMP(_createTS) > UNIX_TIMESTAMP()-(86400*7) AND _activityType = 'Discovery Call');<BR>[20] 0.05 seconds -> 0 rows affected<BR>