[wodenokoto]

But the SQL approach at best only answers which item type to present the customer.

How does the query make a good decision on the specific item?