Cacher is the code snippet organizer for pro developers

SELECT computers.computerid, 
computers.name, 
computers.os, 
hotfixdata.KBID, 
max(patchjobs.finishdate),
date_format(now() - INTERVAL computers.uptime MINUTE, "%Y-%m-%d %H:%i") as `Reboot Date`
FROM labtech.hotfix
join hotfixdata on hotfix.hotfixid = hotfixdata.hotfixid
join computers on hotfix.computerid = computers.computerid
join patchjobs on hotfix.computerid = patchjobs.computerid
join patchjoblogdetails on patchjobs.PatchJobGuid = patchjoblogdetails.patchjobguid
where hotfixdata.KBID in (4530695 ,4530734)
and computers.OS like '%2008%'
and (patchjoblogdetails.logdetails like '%4530695%' or  patchjoblogdetails.logdetails like '%4530734%') 
and patchjoblogdetails.logdetails like '%successfull%'
and date(patchjobs.finishdate) > '2019-12-17'
group by computers.computerid