SELECT T.nId nId, sNenCode trx_code, T.bCancel bCancelled, T.bPaid bPaid,
             Ts.nAmount, Ts.nOperationFee, Ts.nServiceFee
      FROM TANHUB T, Transactions Ts
      WHERE T.nTransactionCashInId = Ts.nId
      AND trx_code = <cfqueryparam value="#code#" cfsqltype="cf_sql_varchar">
      AND Ts.nShopId = <cfqueryparam value="#shop_id#" cfsqltype="cf_sql_integer">