SELECT id,
  SUM(CASE WHEN disposition ="ANSWERED" THEN 1 ELSE 0 END) as "отвеченных",
  SUM(CASE when disposition ="NO ANSWER" THEN 1 ELSE 0 END) AS "нет ответа",
  SUM(CASE WHEN disposition ="FAILED" THEN 1 ELSE 0 END) AS "сбой",
  SUM(CASE WHEN disposition ="BUSY" THEN 1 ELSE 0 END) AS "занят", phone
  FROM( 

 SELECT DISTINCT id,phone,disposition,AcctId FROM users_phones_temp upt JOIN calls_per_month_temp cpmt ON (CASE WHEN cpmt.dst LIKE '8938%'
     THEN SUBSTRING(cpmt.dst FROM 3) ELSE cpmt.dst END)=upt.phone
    )x
 GROUP BY id

Select GROUP_CONCAT(p.number)
FROM phones p LEFT JOIN cdr AS c
ON (CASE WHEN c.dst LIKE '8938%'
     THEN SUBSTRING(c.dst FROM 3) ELSE c.dst END)=p.number