d.Starttime, d.Endtime,
- (select datediff(d.Starttime, d.Endtime)) as Lev ,
- case ( select datediff(d.Starttime, d.Endtime))
- when ( select datediff(d.Starttime, d.Endtime)) <=10 then '紧急维修'
- when 10<( select datediff(d.Starttime, d.Endtime))<=30 then '预计维修'
- else '无需维修' end as LevName
from cloud_componentlist a
- left join
- cloud_equipmentcomponen b on a.Id= b.component
left join cloud_equipment c on c.EquipmentId = b.EquipmentId
- left join (select * from cloud_componentrepairrecord limit 0, 1 order by CreateDate desc ) d
- on d.Cloud_componentId= a.Id where 1=1 order by Lev desc ) a limit 0,10;
来源: http://www.bubuko.com/infodetail-2615185.html