carbon-website-2017/products-to-show-on-main-list

// WP_Query arguments
$args = array(
	'post_type'              => array( 'product_partnership' ),
	'order'                  => 'DESC',
	'orderby'                => 'date',
	'meta_query'             => array(
		'relation' => 'AND',
		array(
			'key'     => 'product_partnership_show_in_list',
			'value'   => 'yes',
			'compare' => '=',
			'type'    => 'CHAR',
		),
	),
);

// The Query
$query = new WP_Query( $args );