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
Ricket Lane
offers in excess of
£1,200,000
FOR SALE
FOR SALE
Willoughby Court
£800,000
Virtual Tour
FOR SALE
Plot 3 Kighill Lane
£780,000
FOR SALE
Plot 2 Kighill Lane
£775,000
FOR SALE
Goodwins Court
offers over
£759,500
Virtual Tour
FOR SALE
FOR SALE
Galley Hill Road
£710,000
FOR SALE
Old Great North Road
offers over
£700,000
Virtual Tour
FOR SALE
FOR SALE
Halloughton Road
£649,950
Virtual Tour
SOLD STC
The Ropewalk
offers in excess of
£600,000
Virtual Tour