Topic: [ANN][0.8.6] Hirocoin - X11 - NGW - Secured Blockchain - Time Warp Limitation - page 96. (Read 271668 times)

mysql> select hash as txid, block as block_height, outputs as total_outputs, size, version, coinbase, inactive, rtime as `time` from tx where block = 29360 and inactive = 1;
+------------------------------------------------------------------+--------------+---------------+------+---------+----------+----------+----------------+
| txid                                                             | block_height | total_outputs | size | version | coinbase | inactive | time           |
+------------------------------------------------------------------+--------------+---------------+------+---------+----------+----------+----------------+
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |        29360 |   40000000000 |  936 |       1 |        1 |        1 | 13958886888208 |
+------------------------------------------------------------------+--------------+---------------+------+---------+----------+----------+----------------+
1 row in set (0.08 sec)

mysql> select A.tx_db_id as txid, A.value, A.n, B.address from vout as A join (select address, vout_id from vout_address) as B on A.id = B.vout_id where A.tx_db_id = 89097 and A.inactive = 1;
+------------------------------------------------------------------+-------------+------+------------------------------------+
| txid                                                             | value       | n    | address                            |
+------------------------------------------------------------------+-------------+------+------------------------------------+
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |     5780932 |    0 | HVqE4LkN8DKXzihXNfbg92jAenfRLKbcDq |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |     6650640 |    1 | HHBa8NKsSQLddhS6nBbyGrBcJUg5LfmLZJ |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |     7291027 |    2 | HT3fuTdgDbueCpqL7CHw63TxDGhSk4oQwb |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |     7390056 |    3 | HUoEuDthDAu1gG8xbpxWLFxPSDWTy7HSWr |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |    45560429 |    4 | HReaeFyMrPkMjkeVr8RNuZD6cKNq8C2CQL |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |    47373183 |    5 | HAPN8YwGrfcEwe7kHHwRSC5XngRhzD5c5D |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |    80776611 |    6 | HKBS7MyGxeJKrwqrqk4N3joFQxWNsAod8R |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   100451315 |    7 | H7Amzw38Pu6DnX2Nu3vzFNF7WgSvrr8Crp |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   120717831 |    8 | HJynppW9Js3jiYesyMHh9UCRAMzJ6ErGHo |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   157394091 |    9 | HVnga8sMzALX6FNZZTdRD1pPds6RLzahhb |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   194767630 |   10 | H8NwcDge1eL8G1SiYkK8Qa7depcaxqDT4T |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   367174160 |   11 | HAuUi5W1N2Cti9Cr6WxT6EU4vHzomGXXD5 |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   395790437 |   12 | HE15QSj9pfcw89gHAfoHZyayPKW987SWv1 |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   418600258 |   13 | HD85siN66uZ4uC2DtXpq4XJVqwUa71VKW2 |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |   789897387 |   14 | H7U6bikTr4xx7KLt38BxitWSxxdT1jMM1C |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |  1584450798 |   15 | HMensM29h2zS9HJJi1cuYjTQHBmazVdsDZ |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |  2076138496 |   16 | HLsusCrXnbfcw2sovmJ9WA3U7zD2pmD4t3 |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |  4178209320 |   17 | HV5Kse8151YGCnNWuAwS8fbrrLbLnJsugf |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |  4533907086 |   18 | HCLbSFgdsLvrmAZDeXeBGBwGNjfdNmWUjx |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |  4561031775 |   19 | HSoTpdjU4YtRmeMxUWmezMA35KYqEBb9Eq |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |  8157245169 |   20 | HJ4cxjuq2N4kSSHAKKEExBiL1dB1BYR6Wr |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec | 12163401358 |   21 | HHfiPNNLa7M2LQwkT4SFsCHvGVgWXvvyCm |
| 381867c1b4eaf8d3617a6014c0072ab40da15f87a7f9b29c0a3eb82dba9123ec |          11 |   22 | HRWCnvPud6ruSR2JUsD19nzyjsS5FrsFtG |
+------------------------------------------------------------------+-------------+------+------------------------------------+
23 rows in set (0.33 sec)