also - this looks like you are doing an item search that joins to transaction table - that's a recipe for "never gonna get right results"