Dimensionnement

SELECT typ AS 'Type', CONCAT_WS('-', arbeitsmoment_von, arbeitsmoment) AS 'Moment
de travail
[kgcm]', CONCAT_WS('-', fliehkraft_von, fliehkraft_bis) AS 'Centrifugal
[kN]', drehzahl as 'Nombre de
révolutions
[min^-1]', gewicht AS 'Masse
[kg]', CONCAT_WS('-', snRecMin, snRecMax) AS 'Amplitude
typique
[mm]', CASE WHEN ROUND((0 * arbeitsmoment)/(((0 * gewicht) + 0)*10),1) IS NULL THEN '-' ELSE ROUND(100*(0 * arbeitsmoment)/(((0 * gewicht) + 0)*10),1) END AS 'Amplitude
calculée
[mm]', CASE WHEN ((gewicht * 0) + 0) = '0' THEN '-' ELSE ((gewicht * 0) + 0) END AS 'Poids total
[kg]', CASE WHEN ROUND((2 * arbeitsmoment)/(((0 * gewicht) + 0)*10),1) BETWEEN snRecMin AND snRecMax THEN '[true]' ELSE '[false]' END AS STROKECONDITION, step AS 'Téléchargements' FROM jvm_dim_richtereger