select ...
from ...
...
, left join
(
  select S.SERVICE_ID
  , wm_concat(regexp_replace(ST.NAME, '^.*[0-9]. ТО ТВ1 (.+) ([A-Z0-9]+).*$', '\1')) as NAMES
  , wm_concat(lower(substr(SS.LOGIN, length(S.LOGIN)+2))) as CODES
  , count(*) as COUNT
  from SERVICES S
  join CUSTOMERS C on (C.CUSTOMER_ID = S.CUSTOMER_ID)
  join SERVICES S0 on (S0.TYPE_ID = 14 and S0.LOGIN = S.LOGIN and S0.STATUS != -20)
  join SERVICES SS on (SS.CUSTOMER_ID = S.CUSTOMER_ID and SS.TYPE_ID = S.TYPE_ID and SS.STATUS != -20 and SS.LOGIN like S.LOGIN||':%')
  join BM_TARIFF ST on (ST.TARIFF_ID = SS.TARIFF_ID)
  where S.STATUS != -20
  and S.TYPE_ID = 202
  and C.GROUP_ID in (select ID from IDGROUPS where SCOPE = 'client-groups')
  and S.TARIFF_ID in (select ID from IDGROUPS where SCOPE = 'custom-plans' and EXTRA = 'iptv:base')
  group by S.SERVICE_ID
) TV3 on (TV3.SERVICE_ID = S.SERVICE_ID)
...