Фудпейринг: мясо красное Casillero del Diablo Maximo Ribeauville сухое

• El Coto Maximo Tinto вино красное 0.75л
  199.00 грнопт 174.00 грн Купить
• Maximo Tempranillo вино красное 0.75л
  Rated 4.43 out of 5
  215.00 грнопт 166.00 грн Закончилось
• Sale! Casillero del Diablo Carmenere Reserva вино красное 0.75л
  394.00 грн Original price was: 394.00 грн.319.00 грнCurrent price is: 319.00 грн. Купить
• Sale! Casillero del Diablo Cabernet Sauvignon Reserva вино красное 0.75л
  394.00 грн Original price was: 394.00 грн.319.00 грнCurrent price is: 319.00 грн. Купить
• Cave de Ribeauville Pinot Noir Grande Cuvee Rodern вино красное 0.75л
  Rated 4.25 out of 5
  999.00 грнопт 934.00 грн Закончилось

			SELECT min( min_price ) as min_price, MAX( max_price ) as max_price
			FROM wp_wc_product_meta_lookup
			WHERE product_id IN (
				SELECT 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 wp_posts.post_type IN ('product')
				AND wp_posts.post_status = 'publish'
				 AND ( 
  wp_term_relationships.term_taxonomy_id IN (1472,1571,1592) 
  AND 
  (
				SELECT COUNT(1)
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (2078)
				AND object_id = wp_posts.ID
			) = 1 
  AND 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (6)
			) 
  AND 
  ( 
    tt1.term_taxonomy_id IN (1472,1571,1592) 
    AND 
    (
				SELECT COUNT(1)
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (2078)
				AND object_id = wp_posts.ID
			) = 1 
    AND 
    wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (6)
			) 
    AND 
    tt2.term_taxonomy_id IN (1879)
  )
)
			)