Вино дольчетто пино нуар сира/шираз турига насьйональ Венгрия

• Bolyki Indian Nyar вино красное 0.75л
  459.00 грнопт 399.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 ( 
  (
				SELECT COUNT(1)
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (3387)
				AND object_id = wp_posts.ID
			) = 1 
  AND 
  wp_term_relationships.term_taxonomy_id IN (2116,2164,3388,2192) 
  AND 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (6)
			) 
  AND 
  ( 
    (
				SELECT COUNT(1)
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (3387)
				AND object_id = wp_posts.ID
			) = 1 
    AND 
    tt1.term_taxonomy_id IN (2116,2164,3388,2192) 
    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 (1367)
  )
)
			)