Query editor
SELECTCOALESCE((SELECT newShareLimit / 1e18FROM makina_ethereum.deth_machine_evt_sharelimitchangedORDER BY evt_block_time DESCLIMIT 1),6500) AS max_cap
Query editor
12SELECT3COALESCE(4(5SELECT newShareLimit / 1e186FROM makina_ethereum.deth_machine_evt_sharelimitchanged7ORDER BY evt_block_time DESC8LIMIT 19),10650011) AS max_cap