UPDATE abm_account_domain a INNER JOIN (SELECT _domain,_stageLevel FROM abm_account_stagechange WHERE UNIX_TIMESTAMP(_datetime) >= UNIX_TIMESTAMP()-(86400*30) AND _stageLevel = 5) o SET a._changePeriod = 1, _changeBefore = o._stageLevel-1, _changeAfter = o._stageLevel WHERE a._domain = o._domain AND a._changePeriod = 0<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _domain,_stageLevel FROM abm_account_stagechange WHERE UNIX_TIMESTAMP(_datetime) >= UNIX_TIMESTAMP()-(86400*30) AND _stageLevel = 4) o SET a._changePeriod = 1, _changeBefore = o._stageLevel-1, _changeAfter = o._stageLevel WHERE a._domain = o._domain AND a._changePeriod = 0<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _domain,_stageLevel FROM abm_account_stagechange WHERE UNIX_TIMESTAMP(_datetime) >= UNIX_TIMESTAMP()-(86400*30) AND _stageLevel = 3) o SET a._changePeriod = 1, _changeBefore = o._stageLevel-1, _changeAfter = o._stageLevel WHERE a._domain = o._domain AND a._changePeriod = 0<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _domain,_stageLevel FROM abm_account_stagechange WHERE UNIX_TIMESTAMP(_datetime) >= UNIX_TIMESTAMP()-(86400*30) AND _stageLevel = 2) o SET a._changePeriod = 1, _changeBefore = o._stageLevel-1, _changeAfter = o._stageLevel WHERE a._domain = o._domain AND a._changePeriod = 0<BR>UPDATE abm_account_domain a INNER JOIN (SELECT _domain,_stageLevel FROM abm_account_stagechange WHERE UNIX_TIMESTAMP(_datetime) >= UNIX_TIMESTAMP()-(86400*30) AND _stageLevel = 1) o SET a._changePeriod = 1, _changeBefore = o._stageLevel-1, _changeAfter = o._stageLevel WHERE a._domain = o._domain AND a._changePeriod = 0<BR>UPDATE abm_accounts SET _changePeriod = 1, _changeBefore = -1, _changeAfter = 0 WHERE UNIX_TIMESTAMP(_dateAdded) >= UNIX_TIMESTAMP()-(86400*30) AND _changePeriod = 0<BR>INSERT IGNORE INTO abm_engagement_summary (_date, _segment1, _segment2) SELECT '2025-03-14', _segment1, _segment2 FROM abm_accounts WHERE LENGTH(_segment1)>0 GROUP BY _segment1, _segment2<BR>INSERT IGNORE INTO abm_engagement_summary (_date, _segment1, _segment2) SELECT '2025-03-15', _segment1, _segment2 FROM abm_accounts WHERE LENGTH(_segment1)>0 GROUP BY _segment1, _segment2<BR>UPDATE abm_engagement_summary s INNER JOIN (SELECT DATE_FORMAT(_datetime,'%Y-%m-%d') '_date',_segment1, _segment2,COUNT(DISTINCT(_email)) '_marketing',0 '_bdr' FROM abm_marketing m, abm_account_domain d WHERE m._domain = d._domain AND _type IN ('clicks','downloads') GROUP BY DATE_FORMAT(_datetime,'%Y-%m-%d'),_segment1,_segment2 ORDER BY DATE_FORMAT(_datetime,'%Y-%m-%d') DESC) o SET s._marketing = o._marketing WHERE s._date = o._date AND s._segment1 = o._segment1 AND s._segment2 = o._segment2<BR>