was not populating transactionTranslated in with values, fixed sql statement