SELECT
CASE max(status_pipe)
WHEN '143' THEN concat('9 ', name_pipe)
WHEN '142' THEN concat('8 ', name_pipe)
WHEN '11260189' THEN concat('7 ', name_pipe)
WHEN '11124342' THEN concat('6 ', name_pipe)
WHEN '11124339' THEN concat('5 ', name_pipe)
WHEN '12672453' THEN concat('4 ', name_pipe)
WHEN '11124336' THEN concat('3 ', name_pipe)
WHEN '11165964' THEN concat('2 ', name_pipe)
WHEN '11124333' THEN concat('1 ', name_pipe)
END as IDNAME,
sum(price) as sumprice,
count(status_pipe) as deals
FROM amocrm_pipe GROUP BY name_pipe order by ID;