Dimensioning

SELECT typ AS 'Type', CONCAT_WS('-', arbeitsmoment_von, arbeitsmoment) AS 'Working
Moment
[kgcm]', CONCAT_WS('-', fliehkraft_von, fliehkraft_bis) AS 'Centrifugal
[kN]', drehzahl as 'Number of
Revolutions
[min^-1]', gewicht AS 'Mass
[kg]', CONCAT_WS('-', snRecMin, snRecMax) AS 'Typical
Amplitude
[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 'Calculated
Amplitude
[mm]', CASE WHEN ((gewicht * 0) + 0) = '0' THEN '-' ELSE ((gewicht * 0) + 0) END AS 'Total Weight
[kg]', CASE WHEN ROUND((2 * arbeitsmoment)/(((0 * gewicht) + 0)*10),1) BETWEEN snRecMin AND snRecMax THEN '[true]' ELSE '[false]' END AS STROKECONDITION, step AS 'Downloads' FROM jvm_dim_richtereger