fbpx

The Finest Properties Available in Alabama

'listingsadmin', //change the post type here 'post_status' => 'publish', 'posts_per_page' => -1, 'post_parent__in' => array( 5825 ), 'orderby' => array('lstato'=>'ASC','priceo'=>'DESC'), 'meta_query' => array( 'priceo'=>array('key'=>'price','type'=>'numeric'), 'lstato'=>array('key'=>'listing_status','value'=>'Sold','compare'=>'!='), array('key'=>'frontend_status','value'=>1,'compare'=>'=')) ); // $loop = new WP_Query( $args ); $fullqA = "SELECT wpue_posts.* FROM wpue_posts INNER JOIN wpue_postmeta ON ( wpue_posts.ID = wpue_postmeta.post_id ) INNER JOIN wpue_postmeta AS mt1 ON ( wpue_posts.ID = mt1.post_id ) INNER JOIN wpue_postmeta AS mt2 ON ( wpue_posts.ID = mt2.post_id ) WHERE 1=1 AND wpue_posts.post_parent IN (5825) AND ( wpue_postmeta.meta_key = 'price' AND ( mt1.meta_key = 'listing_status' AND mt1.meta_value != 'Sold' ) AND ( mt2.meta_key = 'frontend_status' AND mt2.meta_value = '1' ) ) AND wpue_posts.post_type = 'listingsadmin' AND ((wpue_posts.post_status = 'publish')) GROUP BY wpue_posts.ID ORDER BY FIELD (CAST(mt1.meta_value AS CHAR), 'Auction') DESC, CAST(wpue_postmeta.meta_value AS SIGNED) DESC"; //$fullqF = $loop->request; //$maxnum = $loop->max_num_pages; ?>

Alabama

The Kohler & Associate's
Difference

Didn’t Find What You Were Looking for? Or Want to Discuss the Market with the Leader in this Niche?

Contact us to discuss one of our properties, for information on properties that are not yet released to the market or to discuss the market.

Knowledge is Power – Be in the Know

Previous Next
Close
Test Caption
Test Description goes like this