Compare Listings

deano#1
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta as pm ON (pm.post_id = wp_posts.ID) WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'fave_featured' AND wp_postmeta.meta_value = '1' ) ) AND wp_posts.post_type = 'property' AND ((wp_posts.post_status = 'publish')) AND ( pm.meta_key = 'fave_property_price' || pm.meta_key = 'fave_property_sec_price') GROUP BY wp_posts.ID ORDER BY (pm.meta_value)+0 ASC LIMIT 0, 10

174 Results Found

Sort by: