remove a join that isn't necessary (can go straight from items to the path view, without needing the item group table)
short circuit on non-matches for price checks, and include items' base price with the results