I think it would need to be an item search with a join to transactions, if you need to have result rows even if there are no transactions