WITH t AS (SELECT
ROW_NUMBER() OVER (ORDER BY rname) AS paging,
 q.* FROM
(SELECT MIN(d.id) AS id, mr.id AS mreg_id, MIN(mr.name) AS mr_name, MIN(d.reg_id) AS reg_id, MIN(d.tariff_id) AS tariff_id, MIN(f.name) AS tariff_name, MIN(d.office_storage) AS office_storage, MIN(d.dealer_storage) AS dealer_storage,
MIN(d.tech_storage) AS tech_storage, rs.id AS remains_id, rs.status_id, MIN(r.name) rname, rs.report_week, rs.report_year
FROM usim_remains_details d
JOIN usim_remains rs ON d.remain_id = rs.id
JOIN usim_region r ON d.reg_id = r.id
JOIN usim_macro_region mr ON r.mreg_id = mr.id
JOIN usim_tariff f ON d.tariff_id = f.id
GROUP BY mr.id, rs.id, rs.status_id, rs.report_week, rs.report_year,

CASE WHEN rs.status_id <> 2 THEN 2 ELSE d.id END) q

)
SELECT * FROM t WHERE paging BETWEEN 1 AND 200
ORDER BY paging;