SELECT case WHEN dpacalarm_level = 0 then dpacalarm_threshold end di case WHEN dpacalarm_level = 1 then dpacalarm_threshold end gr case WHEN dpacalarm_level = 2 then dpacalarm_threshold end ggr

SELECT case WHEN dpac.alarm_level = 0 then dpac.alarm_threshold end AS 'di', case WHEN dpac.alarm_level = 1 then dpac.alarm_threshold end AS 'gr', case WHEN dpac.alarm_level = 2 then dpac.alarm_threshold end AS 'ggr', case WHEN dpac.alarm_level = 3 then dpac.alarm_threshold end AS 'lr', case WHEN dpac.alarm_level = 4 then dpac.alarm_threshold end AS 'llr', case WHEN dpac.alarm_level = 0 THEN 'DI' ELSE 'AI' END AS point_type, demp.point_desc, demp.point_id FROM device_extend_measure_point AS demp LEFT JOIN device_point_alarm_config AS dpac ON dpac.device_point_id = demp.id GROUP BY demp.point_id