SELECT
    customers_id,
    extract(request_headers, 'mamsy_sess=([a-f0-9]+)') AS session_id,
    extract(request_headers, 'new_last_tag_id=([a-f0-9]+)') AS new_last_tag_id,
    dictGetString('customers_status','customers_status_name',toUInt64( dictGetUInt32('customers','customers_status_id',toUInt64( customers_id ) )  ) ) AS customers_status_name,
    date,
    MAx(dictGetUInt32('ab_test_session','ab_test_part', tuple(session_id) )) AS ab_test_part,

    multiIf(
            match(user_agent, 'MamsyApp'), 'MamsyApp'
        , match(user_agent, 'iPhone|iPad|iPod|Android|Windows Phone'), 'Mobile'

        , 'Desktop'
        ) AS platform
        , MAx(if(request_uri = '/', 1, 0)) as on_main


FROM
    site_request

WHERE
        date>='2019-08-10'
  and date <= today()
  and customers_id IN(
    SELECT distinct
    customers_id
FROM
    site_request

WHERE
        date>='2019-08-10'
  and date <= today()
  and customers_id !=0
  and request_uri = '/'

)
-- and  like '%last_tag_id=2%
group by customers_id, date,  customers_status_name, platform, session_id, new_last_tag_id
having on_main = 1