Query editor
SELECTCOALESCE((SELECT newShareLimit / 1e18FROM makina_ethereum.dbit_machine_evt_sharelimitchangedORDER BY evt_block_time DESCLIMIT 1),100) AS max_cap
Query editor
12SELECT3COALESCE(4(5SELECT newShareLimit / 1e186FROM makina_ethereum.dbit_machine_evt_sharelimitchanged7ORDER BY evt_block_time DESC8LIMIT 19),1010011) AS max_cap