$args = array(
    \'p\'                      => $product_id,
    \'post_type\'              => array( \'product\' ),
    \'post_status\'            => array( \'publish\' ),
    \'meta_query\'             => array(
        \'relation\' => \'AND\',
        array(
            \'key\'     => \'_ywar_product_id\',
            \'value\'   => $product_id,
            \'compare\' => \'=\',
            \'type\'    => \'NUMERIC\',
        ),
        array(
            \'key\'     => \'recommend_it\',
            \'value\'   => \'yes\',
            \'compare\' => \'=\',
            \'type\'    => \'CHAR\',
        ),
    ),
);

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

echo $query->found_posts;