Query editor
selectloan_start as start_date,date_add('day', CAST(duration as BIGINT), loan_start) as maturity,nft_collection_name as collection, amount as loan_size, token as currency, duration as loan_duration,((repay - amount) * 365 / duration) / amount AS aprfrom query_3715978where loan_status = 'Active'order by 2/*SELECTevt_block_time as start_date,date_add('day', CAST(loan_duration as BIGINT), evt_block_time) as maturity,name as collection,loan_amount_original as loan_size,loan_token_symbol as currency,loan_duration,aprFROMquery_3015748WHERE date_add('day', CAST(loan_duration as BIGINT), evt_block_time) > CAST(NOW() as timestamp)ORDER BY 2*/