Query editor
select a.*,CASEWHEN a.protocol = 'Arcade'THEN '<a href="https://app.arcade.xyz/terms/loan/' || cast(a.contract_address as varchar) || '-' || cast(loanId as varchar) || '" target="_blank">' || 'https://app.arcade.xyz/terms/loan/' || cast(a.contract_address as varchar) || '-' || cast(loanId as varchar) || '</a>'WHEN a.protocol = 'NFTfi'THEN '<a href="https://app.nftfi.com/assets/' || cast(a.nft_collection as varchar) || '/' || cast("NFT ID" as varchar) || '" target="_blank">' || 'https://app.nftfi.com/assets/' || cast(a.nft_collection as varchar) || '/' || cast("NFT ID" as varchar) || '</a>'END AS link,"Loan Principal" * price as loan_amount_usd,case when a.borrower in (select distinct borrower from query_3015748) then 'Yes' else 'No' end as "Has the Borrower Used NFTfi",al.od + n.od + g.od + x.od + z.od as "Borrower OD [in USD]",al.loans + n.loans + g.loans + x.loans + z.loans as "Borrower Active Loans",al.od as "OD on Arcade [in USD] Borrower",al.loans as "Number of Active Loans on Arcade Borrower",n.od as "OD on NFTfi [in USD] Borrower",n.loans as "Number of Active Loans on Nftfi Borrower",g.od as "OD on Gondi [in USD] Borrower",g.loans as "Number of Active Loans on Gondi Borrower",x.od as "OD on X2Y2 [in USD] Borrower",x.loans as "Number of Active Loans on X2Y2 Borrower",z.od as "OD on Zharta [in USD] Borrower",z.loans as "Number of Active Loans on Zharta Borrower"/*al_len.od + n_len.od + g_len.od + x_len.od + z_len.od as "Lender OD [in USD]",al_len.loans + n_len.loans + g_len.loans + x_len.loans + z_len.loans as "Lender Active Loans",al_len.od as "OD on Arcade [in USD] Lender",al_len.loans as "Number of Active Loans on Arcade Lender",n_len.od as "OD on NFTfi [in USD] Lender",n_len.loans as "Number of Active Loans on Nftfi Lender",g_len.od as "OD on Gondi [in USD] Lender",g_len.loans as "Number of Active Loans on Gondi Lender",x_len.od as "OD on X2Y2 [in USD] Lender",x_len.loans as "Number of Active Loans on X2Y2 Lender",z_len.od as "OD on Zharta [in USD] Lender",z_len.loans as "Number of Active Loans on Zharta Lender"*/from (selectEXTRACT(day from due_date - current_date) as "Loan Due in",Borrower,Lender,'Gondi' as Protocol,nft_collection_name as Collection,nft_token_id as "NFT ID",amount as "Loan Principal",token as "Currency",APR,Duration,due_date as "Due Date",tx_hash as "Loan Start tx",cast(loanId as varchar) as loanId,null as contract_address,nft_collection,null as version,loan_start as startDate,null as isProRatafrom query_3532218where status = 'Active'AND due_date >= CASEWHEN day_of_week(current_date) BETWEEN 1 AND 6THEN date_trunc('week', current_date) - INTERVAL '1' DAYELSE date_trunc('week', current_date) + INTERVAL '6' DAYEND