select * from crosstab($$select DeviceId, OwnerAccount, serialnumber, "date" as indexdate, chanid as EnergyKind, tzid, "value" as val from (
select 
	dense_RANK() OVER (partition by c.id, d.chanid order by date desc) rank,
c.owneraccount, c.id as deviceid , 
c.serialnumber, d.date, d.chanid, d.tzid, d.value
from meter c join energysum d  
on c.id = d.meterid
where c.owneraccount='2501887' and id = 50600 
and 
date > '20211101' and date <='20211201') Q where rank = 1 
order by rank desc, deviceid, chanid, tzid
					   $$ ,$$SELECT unnest('{0,1,2,3}'::text[])$$
) 
AS ct ("DeviceId" int, "OwnerAccount" character varying(255), "Serialnumber" character varying(255), "IndexDate" timestamp, 
	   "EnergyKind" int, "T0" numeric(18,4), "T1" numeric(18,4), "T2" numeric(18,4), "T3" numeric(18,4));