products

// WP_Query arguments
$args = array(
	'post_type'              => array( 'products' ),
	'post_status'            => array( 'published' ),
	'nopaging'               => true,
	'posts_per_page'         => '-1',
	'tax_query'              => array(
		array(
			'taxonomy'         => 'product_categories',
			'terms'            => '374',
			'field'            => 'term_id',
			'operator'         => 'IN',
			'include_children' => true,
		),
	),
);

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