Сделай этот запрос более выразительным:

SELECT
	COUNT(`nq_1`.user_id) `Новые`,
	COUNT(`nq_2`.user_id) `Активировали тест`,
	COUNT(`nq_3`.user_id) `Подключились к VPN`,
	COUNT(`nq_4`.user_id) `Закончился тестовый период`,
	COUNT(`nq_5`.user_id) `Купили подписку`,
	COUNT(`nq_6`.user_id) `Продлили подписку`
FROM 
	(
		SELECT
		  `shm_u`.user_id,
		  `shm_u`.login,
		  `shm_u`.created,
		  `shm_u`.full_name
		FROM
		  shm.users `shm_u`
		WHERE
		  `shm_u`.created >= concat( $__timeFrom(),' 00:00:00')
		  AND `shm_u`.created < concat( $__timeTo(),' 00:00:00')
	) `nq_1`
	LEFT JOIN (
		SELECT
		  `shm_u`.user_id,
		  `shm_u`.login,
		  `shm_u`.created,
		  `shm_u`.full_name
		FROM
		  shm.users `shm_u`
			INNER JOIN shm.user_services `shm_us` ON (
		    `shm_u`.user_id = `shm_us`.user_id
		    AND `shm_us`.service_id = 3
		  )
		WHERE
		  `shm_u`.created >= concat( $__timeFrom(),' 00:00:00')
		  AND `shm_u`.created < concat( $__timeTo(),' 00:00:00')
		  AND JSON_EXTRACT(`shm_u`.settings, '$.test_already_activated') = TRUE 
	) `nq_2` ON (`nq_2`.user_id = `nq_1`.user_id)
	LEFT JOIN (
		SELECT
		  `shm_u`.user_id,
		  `shm_u`.login,
		  `shm_u`.created,
		  `shm_u`.full_name
		FROM
		  shm.users `shm_u`
		  LEFT JOIN marzban.users `marz_u` ON (
		  	`marz_u`.username = CONCAT('user_', `shm_u`.user_id)
		  )
			INNER JOIN shm.user_services `shm_us` ON (
		    `shm_u`.user_id = `shm_us`.user_id
		    AND `shm_us`.service_id = 3
		  )
		WHERE
		  `shm_u`.created >= concat( $__timeFrom(),' 00:00:00')
		  AND `shm_u`.created < concat( $__timeTo(),' 00:00:00')
		  AND JSON_EXTRACT(`shm_u`.settings, '$.test_already_activated') = TRUE
		  AND `marz_u`.online_at IS NOT NULL
	) `nq_3` ON (`nq_3`.user_id = `nq_1`.user_id)
	LEFT JOIN (
		SELECT
		  `shm_u`.user_id,
		  `shm_u`.login,
		  `shm_u`.created,
		  `shm_u`.full_name
		FROM
		  shm.users `shm_u`
		  LEFT JOIN marzban.users `marz_u` ON (
		  	`marz_u`.username = CONCAT('user_', `shm_u`.user_id)
		  )
		  INNER JOIN shm.user_services `shm_us` ON (
		    `shm_u`.user_id = `shm_us`.user_id
		    AND `shm_us`.service_id = 3
		  )
		WHERE
		  `shm_u`.created >= concat( $__timeFrom(),' 00:00:00')
		  AND `shm_u`.created < concat( $__timeTo(),' 00:00:00')
		  AND JSON_EXTRACT(`shm_u`.settings, '$.test_already_activated') = TRUE
		  AND `marz_u`.online_at IS NOT NULL
		  AND `shm_us`.status = 'REMOVED'
	) `nq_4` ON (`nq_4`.user_id = `nq_1`.user_id)
	LEFT JOIN (
		SELECT
		  `shm_u`.user_id
		FROM
		  shm.users `shm_u`
		  LEFT JOIN marzban.users `marz_u` ON (
		  	`marz_u`.username = CONCAT('user_', `shm_u`.user_id)
		  )
		  INNER JOIN shm.user_services `shm_us` ON (
		    `shm_u`.user_id = `shm_us`.user_id
		    AND `shm_us`.service_id = 3
		  )
		  INNER JOIN shm.pays_history `shm_ph` ON (
		  	`shm_ph`.user_id = `shm_u`.user_id
		  )
		WHERE
		  `shm_u`.created >= concat( $__timeFrom(),' 00:00:00')
		  AND `shm_u`.created < concat( $__timeTo(),' 00:00:00')
		  AND JSON_EXTRACT(`shm_u`.settings, '$.test_already_activated') = TRUE
		  AND `marz_u`.online_at IS NOT NULL
		  AND `shm_us`.status = 'REMOVED'
		GROUP BY
		  `shm_u`.user_id
		HAVING
		  COUNT(`shm_ph`.id) >= 1
	) `nq_5` ON (`nq_5`.user_id = `nq_1`.user_id)
	LEFT JOIN (
		SELECT
		  `shm_u`.user_id
		FROM
		  shm.users `shm_u`
		  LEFT JOIN marzban.users `marz_u` ON (
		  	`marz_u`.username = CONCAT('user_', `shm_u`.user_id)
		  )
		  INNER JOIN shm.user_services `shm_us` ON (
		    `shm_u`.user_id = `shm_us`.user_id
		    AND `shm_us`.service_id = 3
		  )
		  INNER JOIN shm.pays_history `shm_ph` ON (
		  	`shm_ph`.user_id = `shm_u`.user_id
		  )
		WHERE
		  `shm_u`.created >= concat( $__timeFrom(),' 00:00:00')
		  AND `shm_u`.created < concat( $__timeTo(),' 00:00:00')
		  AND JSON_EXTRACT(`shm_u`.settings, '$.test_already_activated') = TRUE
		  AND `marz_u`.online_at IS NOT NULL
		  AND `shm_us`.status = 'REMOVED'
		GROUP BY
		  `shm_u`.user_id
		HAVING
		  COUNT(`shm_ph`.id) > 1
	) `nq_6` ON (`nq_6`.user_id = `nq_1`.user_id)