I have a listing with properties. Right now I have ORDER BY property_price ASC. The point is, a property can be a special Offer (offer_price). if that is the case for that particular property the normal price(property_price) should not longer be counted for the ORDER BY, instead the offer_price should be the price! Is this possible?
Thank you in advance