Query editor
WITHdb1 AS (SELECT"loanId","nftAsset"FROMbend_ethereum.LendingPoolLoan_evt_LoanCreated),db2 AS (SELECT"loanId"FROMbend_ethereum.LendingPoolLoan_evt_LoanRepaid),db3 AS (SELECT"loanId"FROMbend_ethereum.LendingPoolLoan_evt_LoanLiquidated),collateral AS (SELECTdb11."loanId" AS id,"nftAsset" AS assetFROMdb1 AS db11LEFT JOIN db2 AS db22 ON db11."loanId" = db22."loanId"LEFT JOIN db3 AS db33 ON db11."loanId" = db33."loanId"WHEREdb22."loanId" IS NULLAND db33."loanId" IS NULL),collateral_count AS (SELECTc1.asset,COUNT(c1.asset) AS ctFROMcollateral AS c1GROUP BY1),nft_price AS (SELECT"_nftContract" AS oracle_nft,"output_0" / CAST(1e18 AS DOUBLE) AS fp,"call_block_time" AS call_timeFROMbend_ethereum.NFTOracle_call_getAssetPriceWHERE"call_success" = TRUEORDER BYcall_time DESC),latest_table AS (SELECT DISTINCTnp1.oracle_nft,np1.fp,np1.call_timeFROMnft_price AS np1