adv_from
LEFT JOIN `#__jshopping_products_to_extra_fields` AS prod_to_ef ON prod.product_id=prod_to_ef.product_id
adv_query
AND prod.access IN (1,5) AND cat.access IN (1,5) AND prod.product_manufacturer_id in (7)
filters
Array ( [categorys] => Array ( ) [manufacturers] => Array ( [0] => 7 ) [price_from] => 0 [price_to] => 0 [labels] => Array ( ) [vendors] => Array ( ) [extra_fields] => Array ( ) [extra_fields_t] => Array ( ) )
adv_from
LEFT JOIN `#__jshopping_products_to_extra_fields` AS prod_to_ef ON prod.product_id=prod_to_ef.product_id
adv_query
AND prod.access IN (1,5) AND cat.access IN (1,5) AND prod.product_manufacturer_id in (7)
filters
Array ( [categorys] => Array ( ) [manufacturers] => Array ( [0] => 7 ) [price_from] => 0 [price_to] => 0 [labels] => Array ( ) [vendors] => Array ( ) [extra_fields] => Array ( ) [extra_fields_t] => Array ( ) )
Andean Vineyards is a premium wine brand representing the synthesis of Argentinean viticulture diverse varietals from site selected, high altitude vineyards from the best sub regions for each varietal. These wines, grown in the foothills of the Andes, represent the dream to produce wine in harmony with the earth. We believe our environment is precious because our vineyards rely on a balance of nature to produce superior fruit. The packaging communicates the concept of “Wines from the Andes”, fresh, elegant, expressing from each of the valleys.
JoomShopping Download & Support