SELECT type.typename, unit.user_ID,equipment.description, equipment.id, sum(distance) AS mydistance
FROM unit 
LEFT JOIN equipment ON unit.equipment_id = equipment.id
LEFT JOIN type ON equipment.type_id = type.id
WHERE unit.user_id = 24 GROUP by equipment_id ORDER BY mydistance