SELECT * FROM (

SELECT ct.customers_id
, ct.order_paid_total
, ct.orders_count
, t.fias_region_name
, t.fias_district_name
, ROW_NUMBER() OVER w AS 'row_number'
 from customers_total AS ct
JOIN (

SELECT
distinct
o.customers_id
    , f.fias_region_id
    , f.fias_region_name
    , f.fias_district_id
    , f.fias_district_name
FROM orders AS o
JOIN dwh_fias AS f ON f.fias_id = o.customers_fias_id
WHERE o.date_purchased >= DATE_ADD(NOW(), INTERVAL -60 DAY)
AND f.fias_region_id IN(238025, 452231, 891320, 779782, 335031)
-- AND f.fias_region_name LIKE '%свердло%'

) AS t ON t.customers_id = ct.customers_id
WINDOW w AS (PARTITION BY t.fias_region_id ORDER BY ct.order_paid_total DESC)
) AS tt
WHERE row_number <= 100