binhachonFolks Finance Liquidation - #1
Updated 2022-07-13
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with fasset_list as (
select
asset_id,
creator_address,
asset_name,
case
when asset_id = 686505742 then 0
when asset_id = 686508050 then 31566704
when asset_id = 686509463 then 312769
when asset_id = 686510134 then 386192725
when asset_id = 694408528 then 386195940
when asset_id = 694474015 then 694432641
when asset_id = 751289888 then 27165954
when asset_id = 776184808 then 552888874
when asset_id = 776185076 then 701273234
when asset_id = 747244426 then 552647097
when asset_id = 747244580 then 620996279
when asset_id = 743689704 then 694683000
when asset_id = 743689819 then 701364134
end as borrowed_asset_id,
case
when asset_id = 686505742 then 686498781
when asset_id = 686508050 then 686500029
when asset_id = 686509463 then 686500844
when asset_id = 686510134 then 686501760
when asset_id = 694408528 then 694405065
when asset_id = 794060802 then 794055220
when asset_id = 694474015 then 694464549
when asset_id = 751289888 then 751285119
when asset_id = 776184808 then 776179559
when asset_id = 776185076 then 776176449
when asset_id = 747244426 then 747237154
when asset_id = 747244580 then 747239433
when asset_id = 743689704 then 743679535
when asset_id = 743689819 then 743685742
end as pool_app_id,
Run a query to Download Data