To keep track of everything: maintenance, preparation, calibration, stock of spare or batteries to sensor calibration.
Please log in to Access this area.
Synoptic
Campe Erreur SQL ! SELECT m.equipment_id as equipid,login,s.id as subtypeid,s.subtype,s.equipmenttype_id as type,serial,date,m.note,g.name,su.version,
(SELECT health FROM statushistory h INNER JOIN deploymentstage st on st.id = h.deploymentstage_id WHERE h.equipment_id = m.equipment_id AND date = (SELECT max(date) FROM statushistory WHERE equipment_id = m.equipment_id AND date <= '2026-05-23 18:39:24') LIMIT 1) as status
FROM maintenancehistory m
INNER JOIN assembly a on a.maintenancehistory_id = m.id
INNER JOIN equipment e on e.id = m.equipment_id
INNER JOIN operator o on o.id = m.operator_id
INNER JOIN equipmentsubtype s on s.id = e.equipmentsubtype_id
INNER JOIN location l on l.id = a.location_id
LEFT JOIN glider g on g.equipment_id=e.id
LEFT JOIN softup su on su.maintenancehistory_id = m.id
WHERE destination = '501'
AND way = 'in'
AND s.id IN ('79','80','81','92','6','108','112','113','114')
AND date = (SELECT max( date )
FROM maintenancehistory h
INNER JOIN assembly a2 ON a2.maintenancehistory_id = h.id
WHERE h.equipment_id = m.equipment_id
AND date <= '2026-05-23 18:39:24' )
ORDER BY location DESC Disk full (/var/tmp/#sql_6204_0); waiting for someone to free some space...
