That is the issue...the correct pricing does display except....here is an example:

If the customer searches by spr (using query #2 in the original message):

Records returned are with incorrect pricing:

...