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
6 FOR SALE

Kighill Lane

Ravenshead

£2,400,000
DJI_0531-Enhanced-NR-Edit-2 SOLD STC

Nottingham Road

Ravenshead

£1,950,000
P1106183-HDR SOLD STC

Westhorpe

Southwell

£1,500,000
Virtual Tour
Drone3 FOR SALE

Ricket Lane

Blidworth

offers in excess of £1,200,000
Untitled design - 2023-08-29T114116 FOR SALE

Bank Hill

Woodborough

£1,100,000
Virtual Tour
WhatsApp Image 2022-09-28 at 11 SOLD STC

Chapel Lane

Farnsfield

£995,000
P1077129-HDR-Edit SOLD STC

Manor Drive

Morton

£995,000
Virtual Tour
Avondale House, Southwell FOR SALE

Avondale Lane

Southwell

offers over £995,000
Virtual Tour
DSC_0003 FOR SALE

Kighill Lane

Ravenshead

£975,000
Virtual Tour
P1178284-HDR-Edit FOR SALE

Bleasby Road

Fiskerton

£950,000
Virtual Tour
DSC_0050 FOR SALE

Regina Crescent

Ravenshead

£950,000
Virtual Tour
RemoteMediaFile_6554017_0_2022_03_08_16_11_44 FOR SALE

Westhorpe

Southwell

£925,000
Virtual Tour

Your privacy and our use of cookies Read more about cookies and learn how to disable them.