Wine× Moscato× White Wine×
Wine
  • No categories
Countries / State
Price
Filter
NOTE: For an specific vintage contact us “here”
	SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)  LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id)  LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (285) 
  AND 
  tt1.term_taxonomy_id IN (135) 
  AND 
  tt2.term_taxonomy_id IN (126,132,133,134,135,155,156,157,158)
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC LIMIT 0, 45	Array
(
    [post_type] => product
    [post_status] => publish
    [posts_per_page] => 45
    [orderby] => title
    [order] => ASC
    [suppress_filters] => 1
    [tax_query] => Array
        (
            [relation] => AND
            [0] => Array
                (
                    [taxonomy] => product_cat
                    [terms] => wine
                    [field] => slug
                    [operator] => IN
                )

            [1] => Array
                (
                    [taxonomy] => grapes
                    [terms] => moscato
                    [field] => slug
                    [operator] => IN
                )

            [2] => Array
                (
                    [taxonomy] => grapes
                    [terms] => white-wine
                    [field] => slug
                    [operator] => IN
                )

        )

)
	2

Showing all 2 results

  • Bartenura Moscato – 750ml

    $13.99
    Add to cart
  • Marcarini Moscato D’asti – 750ml

    $22.99
    Add to cart