added longest trx query