updated transactions query for better filtering