in which case you are probably doing an item search that joins to transaction table instead of a transaction search that joins to item.