| | |
| | | me.id equId |
| | | FROM |
| | | EquipmentLog a |
| | | INNER JOIN ( SELECT EquipmentID, MAX ( CollectTime ) 'maxgdtime' FROM EquipmentLog GROUP BY EquipmentID ) b ON a.EquipmentID= b.EquipmentID |
| | | INNER JOIN ( SELECT EquipmentID, MAX ( CollectTime ) maxgdtime FROM EquipmentLog GROUP BY EquipmentID ) b ON a.EquipmentID= b.EquipmentID |
| | | INNER JOIN mdc_workshop_equipment mew ON mew.equipment_id = a.EquipmentID |
| | | INNER JOIN mdc_equipment me ON me.equipment_id = a.EquipmentID |
| | | INNER JOIN mdc_equipment_type met ON me.equipment_type = met.equipment_type_name |