Sugar
SELECT *,CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) Price FROM wp_posts p inner join wp_postmeta minp on minp.post_id = p.Id and CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) >= CONVERT('',UNSIGNED INTEGER) and minp.meta_key = 'cp_price'inner join wp_term_relationships tr on tr.object_id = p.Id inner join wp_postmeta minpp on minpp.post_id = p.Id and minpp.meta_key = 'cp_price_qualifier' WHERE post_status='publish' and post_type='post' and (post_title LIKE '%%' or post_content like '%%') ORDER BY CONVERT(REPLACE(REPLACE(minp.meta_value,'£',''),',',''),UNSIGNED INTEGER) desc
FOR SALE
Brierley Heath, Brand Lane
£349,995
FOR SALE
FOR SALE
Lower Kirklington Road
£342,500
Virtual Tour
FOR SALE
Belle Vue Gardens
£330,000
FOR SALE
FOR SALE
Swallow Crescent
£325,000
FOR SALE
Brierley Heath, Brand Lane
£322,495
SOLD STC
SOLD STC
Chapel Lane
offers in excess of
£300,000
SOLD STC
De Vere Gardens
guide price
£300,000
FOR SALE
FOR SALE
Brierley Heath, Brand Lane
£299,995