Start Processing : 2024-09-20 02:53:44<BR>0 rows affectedUPDATE db_cpm_content SET _createdDT = STR_TO_DATE(DATE_FORMAT(SUBSTRING_INDEX(_created,'T',1),'%m/%d/%Y'),'%m/%d/%Y') WHERE _created <> ''<BR>[1] 0.18 seconds -> 0 rows affected<BR>UPDATE db_cpm_content SET _completedDT = STR_TO_DATE(DATE_FORMAT(SUBSTRING_INDEX(_completedDate,'T',1),'%m/%d/%Y'),'%m/%d/%Y') WHERE _completedDate <> ''<BR>[5] 0.07 seconds -> 0 rows affected<BR>UPDATE db_cpm_content SET _dueDT = STR_TO_DATE(DATE_FORMAT(SUBSTRING_INDEX(_dueDate,'T',1),'%m/%d/%Y'),'%m/%d/%Y') WHERE _dueDate <> ''<BR>[10] 0.13 seconds -> 0 rows affected<BR>UPDATE db_cpm_content 
SET _predictCompleteDT = IF(_completedDT IS NULL, 
	IF(_dueDT IS NOT NULL, IF(NOW() >= _dueDT, 
		IF(NOW() >= DATE_ADD(_dueDT, INTERVAL 1 MONTH), _dueDT,NOW()), _dueDT),NULL), _completedDT)<BR>[15] 0.16 seconds -> 0 rows affected<BR>UPDATE db_cpm_content a
LEFT JOIN db_cpm_standard_workflow b
ON a._contentType = b._request
SET a._designBrandingHours = b._designBranding,
	 a._contentWritingHours = b._contentWriting,
	 a._videoAnimationHours = b._videoAnimation<BR>[20] 2.17 seconds -> 0 rows affected<BR>UPDATE db_cpm_content SET _predictCategory = IF(_predictCompleteDT = _completedDT, 'Completed', IF(_predictCompleteDT = _dueDT, 'Actual Due Date', CONCAT('delayed ',DATEDIFF(_predictCompleteDT,_dueDT),' day(s)')))<BR>[23] 0.12 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_createdDT, '%Y%m') AS _monthYear, COUNT(*) _taskCreated 
FROM db_cpm_content
WHERE _createdDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC) b
ON a._monthYear = b._monthYear
SET a._taskCreated = b._taskCreated<BR>[25] 0.09 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_completedDT, '%Y%m') AS _monthYear, COUNT(_completedDT) _taskCompleted 
FROM db_cpm_content 
WHERE _completedDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC ) b
ON a._monthYear = b._monthYear
SET a._taskCompleted = b._taskCompleted<BR>[30] 0.06 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot SET _designBrandingCapacity = (SELECT _headCount FROM db_cpm_team_headcount WHERE _team = 'Design/Branding')*_workingDays*8<BR>[33] 0.04 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot SET _contentWritingCapacity = (SELECT _headCount FROM db_cpm_team_headcount WHERE _team = 'Content/Writing')*_workingDays*8<BR>[50] 0 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot SET _videoAnimationCapacity = (SELECT _headCount FROM db_cpm_team_headcount WHERE _team = 'Video/Animation')*_workingDays*8<BR>[55] 0 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_completedDT, '%Y%m') AS _monthYear, SUM(_designBrandingHours) AS _designBrandingCompletedHours
FROM db_cpm_content 
WHERE _completedDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC ) b
ON a._monthYear = b._monthYear
SET a._designBrandingCompletedHours = b._designBrandingCompletedHours<BR>[70] 0.04 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_completedDT, '%Y%m') AS _monthYear, SUM(_contentWritingHours) AS _contentWritingCompletedHours
FROM db_cpm_content 
WHERE _completedDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC ) b
ON a._monthYear = b._monthYear
SET a._contentWritingCompletedHours = b._contentWritingCompletedHours<BR>[72] 0.09 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_completedDT, '%Y%m') AS _monthYear, SUM(_videoAnimationHours) AS _videoAnimationCompletedHours
FROM db_cpm_content 
WHERE _completedDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC ) b
ON a._monthYear = b._monthYear
SET a._videoAnimationCompletedHours = b._videoAnimationCompletedHours<BR>[76] 0.07 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot 
SET _designBrandingUtilization = _designBrandingCompletedHours/_designBrandingCapacity,
	 _contentWritingUtilization = _contentWritingCompletedHours/_contentWritingCapacity,
	 _videoAnimationUtilization = _videoAnimationCompletedHours/_videoAnimationCapacity<BR>[80] 0 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_predictCompleteDT, '%Y%m') AS _monthYear, SUM(_designBrandingHours) AS _designBrandingPredictedHours
FROM db_cpm_content 
WHERE _predictCompleteDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC ) b
ON a._monthYear = b._monthYear
SET a._designBrandingPredictedHours = b._designBrandingPredictedHours<BR>[83] 0.07 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_predictCompleteDT, '%Y%m') AS _monthYear, SUM(_contentWritingHours) AS _contentWritingPredictedHours
FROM db_cpm_content 
WHERE _predictCompleteDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC ) b
ON a._monthYear = b._monthYear
SET a._contentWritingPredictedHours = b._contentWritingPredictedHours<BR>[90] 0.1 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot a INNER JOIN 
(SELECT DATE_FORMAT(_predictCompleteDT, '%Y%m') AS _monthYear, SUM(_videoAnimationHours) AS _videoAnimationPredictedHours
FROM db_cpm_content 
WHERE _predictCompleteDT IS NOT NULL 
GROUP BY _monthYear 
ORDER BY _monthYear DESC ) b
ON a._monthYear = b._monthYear
SET a._videoAnimationPredictedHours = b._videoAnimationPredictedHours<BR>[100] 0.1 seconds -> 0 rows affected<BR>UPDATE db_cpm_month_snapshot 
SET _designBrandingPredictedUtilization = _designBrandingPredictedHours/_designBrandingCapacity,
	 _contentWritingPredictedUtilization = _contentWritingPredictedHours/_contentWritingCapacity,
	 _videoAnimationPredictedUtilization = _videoAnimationPredictedHours/_videoAnimationCapacity<BR>[101] 0 seconds -> 0 rows affected<BR>UPDATE db_cpm_day_snapshot a INNER JOIN (SELECT _completedDT, SUM(_designBrandingHours) AS _designBrandingCompletedHours, SUM(_contentWritingHours) AS _contentWritingCompletedHours, SUM(_videoAnimationHours) AS _videoAnimationCompletedHours
FROM db_cpm_content
WHERE _completedDT IS NOT NULL
		AND _completedDT >= '2019-06-01'
GROUP BY _completedDT
ORDER BY _completedDT DESC) b
ON a._date = b._completedDT
SET a._designBrandingCompletedHours = b._designBrandingCompletedHours,
	 a._contentWritingCompletedHours = b._contentWritingCompletedHours,
	 a._VideoAnimationCompletedHours = b._videoAnimationCompletedHours<BR>[110] 0.12 seconds -> 0 rows affected<BR>