Chintesh Prajapati

Hi,
@umchal

I have created the solution by my understanding for this, code is below, Hope it may help you
also, you can change variables according to your requirement.

global $wpdb;
	$books = $wpdb->get_results("SELECT post_id,meta_value FROM $wpdb->postmeta WHERE (meta_key = '_shop_id')");
	$book_ids = array();
	foreach($books as $book){
		if ( 'publish' != get_post_status ( $book->meta_value ) ) {
			$book_ids[] = $book->post_id;
		}
	}

	foreach($book_ids as $book_id){
		$book_post = get_post($book_id); // Result
		//echo '<pre>'; print_r($book_post);
	}

Thanks.

Hi,
@brutex

I think WP_Query is more faster and reliable.

Thanks.

Hi,
@brutex

I have created the solution for this, code is below, Hope it may help you
also, you can change variables according to your requirement.

Put this code in your custom taxonomy archive page.

$term_id = get_queried_object()->term_id;

$products = get_posts(array(
  'post_type' => 'product', //put post-type slug here
  'post_status' => 'publish',
  'numberposts' => -1,
  'tax_query' => array(
    array(
      'taxonomy' => 'product_cat', //put taxonomy slug here
      'field' => 'id',
      'terms' => $term_id,
      'include_children' => true
    )
  )
));

$value1 = array();
foreach($products as $product){
	$product_id = $product->ID;
	$value1[] = get_post_meta($product_id,'value1',true); // mata key = value1
}

$max_price = max($value1); // result

Thanks.

• This reply was modified 6 years, 2 months ago by Chintesh Prajapati.