tx count

tx count

mysql> SELECT COUNT(*) FROM blockcenter.address_transactions where address_id = 3;
+----------+
| COUNT(*) |
+----------+
|    38283 |
+----------+
1 row in set (0.02 sec)



https://blockmeta.com/address/bm1qcxg0w7c70tdd46t7dxn204mkyeyudcz063s49e
38369

SELECT
count(*)
FROM
addresses
INNER JOIN address_transactions ON addresses.id = address_transactions.address_id
INNER JOIN transactions ON address_transactions.transaction_id = transactions.id
WHERE address_transactions.asset_id = 1
AND addresses.address = "bm1q9tmh0jn8z5psuq44c92mrhpfs7qmqn06725frg";