Previous boosted carryover is not considered for carryover calculation while redeploying a paused order

Current query which we are using to fetch the boosted carryover value is returning null date which is not showing data properly for the new pooled carryover and dedicated carryover values after redeployment.

current query:

SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`,
mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID` = c.`id` WHERE
c.`searchEngineUserId` = 3601 AND mc.`type` = 'boosted' AND mc.`date` = (SELECT MAX(DATE) FROM
monthlyCarryovers mc1 WHERE c.`searchEngineUserId` = 3601 AND mc1.`type` = 'boosted') ORDER
BY c.`id` DESC LIMIT 4

working query:

SELECT mc.`id`, mc.`campaignID`, mc.`date`, mc.`dedicatedCarryover`, mc.`pooledCarryover`,
mc.`type` FROM `monthlyCarryovers` mc JOIN `campaigns` c ON mc.`campaignID` = c.`id` WHERE
c.`searchEngineUserId` = 3601 AND mc.`type` = 'boosted' AND mc.`date` = (SELECT MAX(DATE) FROM
monthlyCarryovers mc1 WHERE mc1.`campaignID` = mc.`campaignID` AND mc1.`type` = 'boosted' AND c.`searchEngineUserId` = c.`searchEngineUserId`)
ORDER BY c.`id` DESC LIMIT 4