--explain
with summary as (
	select
		m.id,
		m."externalId",
		m."from",
		m.to,
		m.title,
		m."dateReceived",
		m.removed,
--		row_number() over (partition by m.title order by m."dateReceived" desc) / 10 as super_id,
		row_number() over w_date as rank
--	    count(*) over w_no_date as count,
--	    sum(cast(m.removed as int)) over w_no_date as "totalRemoved",
--	    count(*) over() as full_count
	from public."Mail" m
--	having rank = 1
	window
		w_date as (partition by m.title order by m."dateReceived" desc),
		w_no_date as (partition by m.title)
	order by m."dateReceived" desc
)
select
	*,
	row_number() over(partition by s.title, (s.rank - 1) / 10 order by s."dateReceived" desc, s.rank) as rank2
--	COUNT(*) over() as total_grouped
from summary s
--where rank = 1
where ((s.rank - 1) % 10) = 0
--order by s.title, s."dateReceived" desc
order by s."dateReceived" desc, s.rank
limit 10000 offset 0