Does Magento take Tier pricing into account in layered navigation? I am not able to filter products properly with tier pricing. That means price range selection is not working in layered navigation. I have searched a lot but am not able to get to the exact problem.
In the printed query itself is not having any condition for tier price, its having condition for price_index.min_price