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 (29)
filters
Array ( [categorys] => Array ( ) [manufacturers] => Array ( [0] => 29 ) [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 (29)
filters
Array ( [categorys] => Array ( ) [manufacturers] => Array ( [0] => 29 ) [price_from] => 0 [price_to] => 0 [labels] => Array ( ) [vendors] => Array ( ) [extra_fields] => Array ( ) [extra_fields_t] => Array ( ) )
MEET THE CLUB
SELECT CLUB CANADIAN WHISKY "you'll crave every sip"
Welcome to the wonderful world of Select Club Whisky.
Handcrafted with careful attention to balanced flavors and a smooth finish.
The finest North American Corn & Rye is selected for the mash bill, which is then introduced to pristine water.
After intensive ageing in the American Oak Bourbon barrels, the aromatic smooth amber whiskey is placed in unique hand-crafted bottles
Enjoy neat, poured over ice or mixed in your favorite craft cocktail.
You'll crave every sip of this delicious whisky.
JoomShopping Download & Support