INSERT IGNORE INTO dashboard_significant_movement (_opportunityID, _changeText, _changeDT, _changeTS) SELECT _opportunityID,CONCAT(_stageBefore,' to ',_stageAfter), _changeDT, _changeTS FROM dashboard_monthly_stagechange WHERE _event = 'Best Few'<BR>INSERT IGNORE INTO dashboard_significant_movement (_opportunityID, _changeText, _changeDT, _changeTS) SELECT _opportunityID,CONCAT(_stageBefore,' to ',_stageAfter), _changeDT, _changeTS FROM dashboard_monthly_stagechange WHERE _event = 'VOC/Contracting'<BR>INSERT IGNORE INTO dashboard_significant_movement (_opportunityID, _changeText, _changeDT, _changeTS) SELECT _opportunityID,CONCAT(_stageBefore,' to ',_stageAfter), _changeDT, _changeTS FROM dashboard_monthly_stagechange WHERE _event = 'Closed Won'<BR>INSERT IGNORE INTO dashboard_significant_movement (_opportunityID, _changeText, _changeDT, _changeTS) SELECT s._opportunityID,CONCAT(_stageBefore,' to ',_stageAfter), _changeDT, _changeTS FROM dashboard_monthly_stagechange s INNER JOIN (SELECT _opportunityID, _maxStage FROM dashboard_opportunity_phase) o WHERE s._opportunityID = o._opportunityID AND o._maxStage IN ('Best Few','VOC/Contracting','Closed Won') AND  _event = 'Closed Lost' AND _stageBefore NOT IN ('Qualified','New','Non Qualified')<BR>INSERT IGNORE INTO dashboard_significant_movement (_opportunityID, _changeText, _changeDT, _changeTS) SELECT s._opportunityID,CONCAT(_stageBefore,' to ',_stageAfter), _changeDT, _changeTS FROM dashboard_monthly_stagechange s INNER JOIN (SELECT _opportunityID, _maxStage FROM dashboard_opportunity_phase) o WHERE s._opportunityID = o._opportunityID AND o._maxStage IN ('Qualified','Best Few','VOC/Contracting','Closed Won') AND  _event = 'Closed Lost' AND _stageBefore IN ('Qualified') AND _pipelineValue > 1000000<BR>INSERT IGNORE INTO dashboard_significant_movement (_opportunityID, _changeText, _changeDT, _changeTS) SELECT s._opportunityID,CONCAT('Close Date moved from Q',QUARTER(_before),'-',YEAR(_before),' to Q',QUARTER(_after),'-',YEAR(_after)), _editDT, _editTS FROM dashboard_opportunity_changelog s INNER JOIN (SELECT _opportunityID, _maxStage FROM dashboard_opportunity_phase) o WHERE s._opportunityID = o._opportunityID AND o._maxStage IN ('Best Few','VOC/Contracting','Closed Won') AND (_nextQ+_beyondNextQ)>0 AND _probabilityBefore > 20<BR>INSERT IGNORE INTO dashboard_significant_movement (_opportunityID, _changeText, _changeDT, _changeTS,_isSignificant) SELECT s._opportunityID,CONCAT(_stageBefore,' to ',_stageAfter), _changeDT, _changeTS,0 FROM dashboard_monthly_stagechange s INNER JOIN (SELECT _opportunityID, _maxStage FROM dashboard_opportunity_phase) o WHERE s._opportunityID = o._opportunityID AND o._maxStage IN ('Best Few','VOC/Contracting','Closed Won') AND  _event = 'Closed Lost' AND _stageBefore IN ('Qualified') AND _pipelineValue <= 1000000<BR>