Query editor
select distinct lender from (select'arcade' as protocol,cast(lender as varchar) as lenderfrom query_3571586where loan_status = 'Active'union allselect'nftfi' as protocol,cast(lender as varchar) as lenderfrom query_3669461where loan_status = 'Active'union allselect'gondi' as protocol,cast(lender as varchar) as lenderfrom query_3532218where status = 'Active'union allselect'x2y2' as protocol,cast(lender as varchar) as lenderfrom query_3715094where loan_status = 'Active'union allselect'zharta' as protocol,cast(lender as varchar) as lenderfrom query_3688154where loan_status = 'Active')