Query editor
WITH all_domains AS (SELECTname,label_type,address AS ownerFROM labels.ensWHERE name LIKE '%.eth'),latest_registration AS (SELECTname,evt_block_time AS registration_date,expires AS expiry_unix,cost / 1e18 AS price_ethFROM (SELECT *,ROW_NUMBER() OVER (PARTITION BY name ORDER BY evt_block_time DESC) AS rnFROM ens.view_registrations) tWHERE rn = 1 -- latest registration per name)SELECTd.name,d.owner,d.label_type,l.registration_date,FROM_UNIXTIME(l.expiry_unix) AS expiry_date,l.price_eth,DATE_DIFF('day',CURRENT_TIMESTAMP,FROM_UNIXTIME(l.expiry_unix)) AS days_until_expiryFROM all_domains dLEFT JOIN latest_registration lON d.name = l.nameORDER BY days_until_expiry ASC NULLS LAST, d.name