SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`code` AS `t0_c2`, `t0`.`amount_min` AS `t0_c3`, `t0`.`amount_max` AS `t0_c4`, `t0`.`start_date` AS `t0_c5`, `t0`.`end_date` AS `t0_c6`, `t0`.`display_home` AS `t0_c7`, `t0`.`blog_post_id` AS `t0_c8`, `t0`.`include_client_ids` AS `t0_c9`, `t0`.`include_clients_group` AS `t0_c10`, `t0`.`include_country_ids` AS `t0_c11`, `t0`.`include_product_ids` AS `t0_c12`, `t0`.`include_product_ids_operator` AS `t0_c13`, `t0`.`include_product_groups` AS `t0_c14`, `t0`.`include_with_promotion` AS `t0_c15`, `t0`.`exclude_client_ids` AS `t0_c16`, `t0`.`exclude_clients_group` AS `t0_c17`, `t0`.`exclude_country_ids` AS `t0_c18`, `t0`.`exclude_product_ids` AS `t0_c19`, `t0`.`exclude_product_ids_operator` AS `t0_c20`, `t0`.`exclude_product_groups` AS `t0_c21`, `t0`.`discount_type` AS `t0_c22`, `t0`.`discount_value` AS `t0_c23`, `t0`.`percent_include_product_ids` AS `t0_c24`, `t0`.`percent_exclude_product_ids` AS `t0_c25`, `t0`.`free_product_unit_id` AS `t0_c26`, `t0`.`specific_value` AS `t0_c27`, `t0`.`status` AS `t0_c28`, `t0`.`rank` AS `t0_c29`, `t0`.`usage_per_client` AS `t0_c30`, `t0`.`usage_total` AS `t0_c31`, `t0`.`usage_count` AS `t0_c32`, `t0`.`target_audience_count` AS `t0_c33`, `t0`.`nb_client_orders_min` AS `t0_c34`, `t0`.`nb_client_orders_max` AS `t0_c35`, `t0`.`created_at` AS `t0_c36`, `t0`.`updated_at` AS `t0_c37`, `t1`.`id` AS `t1_c0`, `t1`.`promotion_id` AS `t1_c1`, `t1`.`lang_code` AS `t1_c2`, `t1`.`name` AS `t1_c3`, `t1`.`description` AS `t1_c4`, `t1`.`page_title` AS `t1_c5`, `t1`.`slug` AS `t1_c6`, `t1`.`meta_keywords` AS `t1_c7`, `t1`.`meta_description` AS `t1_c8`, `t1`.`image` AS `t1_c9`, `t1`.`image_block` AS `t1_c10`, `t1`.`image_detail` AS `t1_c11`, `t1`.`created_at` AS `t1_c12`, `t1`.`updated_at` AS `t1_c13` FROM `promotions` AS `t0` LEFT JOIN `promotion_descriptions` AS `t1` ON (`t0`.`id` = `t1`.`promotion_id` AND `t1`.`lang_code` = 'kr') WHERE `t0`.`status` = 'A' AND `t0`.`discount_type` IN ('percent', 'free_product') AND `t0`.`include_product_ids_operator` = 'and' AND `t0`.`include_product_ids` IS NOT null AND `t0`.`code` IS null AND (`t0`.`start_date` IS null OR ((`t0`.`start_date` <= '2025-05-12 14:14:09'))) AND (`t0`.`end_date` IS null OR ((`t0`.`end_date` >= '2025-05-12 14:14:09'))) AND (`t0`.`include_product_ids` LIKE '%;4633;%' OR ((`t0`.`include_product_ids` LIKE '%;4634;%'))) ORDER BY `t1`.`name` ASCSELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`code` AS `t0_c2`, `t0`.`amount_min` AS `t0_c3`, `t0`.`amount_max` AS `t0_c4`, `t0`.`start_date` AS `t0_c5`, `t0`.`end_date` AS `t0_c6`, `t0`.`display_home` AS `t0_c7`, `t0`.`blog_post_id` AS `t0_c8`, `t0`.`include_client_ids` AS `t0_c9`, `t0`.`include_clients_group` AS `t0_c10`, `t0`.`include_country_ids` AS `t0_c11`, `t0`.`include_product_ids` AS `t0_c12`, `t0`.`include_product_ids_operator` AS `t0_c13`, `t0`.`include_product_groups` AS `t0_c14`, `t0`.`include_with_promotion` AS `t0_c15`, `t0`.`exclude_client_ids` AS `t0_c16`, `t0`.`exclude_clients_group` AS `t0_c17`, `t0`.`exclude_country_ids` AS `t0_c18`, `t0`.`exclude_product_ids` AS `t0_c19`, `t0`.`exclude_product_ids_operator` AS `t0_c20`, `t0`.`exclude_product_groups` AS `t0_c21`, `t0`.`discount_type` AS `t0_c22`, `t0`.`discount_value` AS `t0_c23`, `t0`.`percent_include_product_ids` AS `t0_c24`, `t0`.`percent_exclude_product_ids` AS `t0_c25`, `t0`.`free_product_unit_id` AS `t0_c26`, `t0`.`specific_value` AS `t0_c27`, `t0`.`status` AS `t0_c28`, `t0`.`rank` AS `t0_c29`, `t0`.`usage_per_client` AS `t0_c30`, `t0`.`usage_total` AS `t0_c31`, `t0`.`usage_count` AS `t0_c32`, `t0`.`target_audience_count` AS `t0_c33`, `t0`.`nb_client_orders_min` AS `t0_c34`, `t0`.`nb_client_orders_max` AS `t0_c35`, `t0`.`created_at` AS `t0_c36`, `t0`.`updated_at` AS `t0_c37`, `t1`.`id` AS `t1_c0`, `t1`.`promotion_id` AS `t1_c1`, `t1`.`lang_code` AS `t1_c2`, `t1`.`name` AS `t1_c3`, `t1`.`description` AS `t1_c4`, `t1`.`page_title` AS `t1_c5`, `t1`.`slug` AS `t1_c6`, `t1`.`meta_keywords` AS `t1_c7`, `t1`.`meta_description` AS `t1_c8`, `t1`.`image` AS `t1_c9`, `t1`.`image_block` AS `t1_c10`, `t1`.`image_detail` AS `t1_c11`, `t1`.`created_at` AS `t1_c12`, `t1`.`updated_at` AS `t1_c13` FROM `promotions` AS `t0` LEFT JOIN `promotion_descriptions` AS `t1` ON (`t0`.`id` = `t1`.`promotion_id` AND `t1`.`lang_code` = 'kr') WHERE `t0`.`status` = 'A' AND `t0`.`discount_type` IN ('percent', 'free_product') AND `t0`.`include_product_ids_operator` = 'and' AND `t0`.`include_product_ids` IS NOT null AND `t0`.`code` IS null AND (`t0`.`start_date` IS null OR ((`t0`.`start_date` <= '2025-05-12 14:14:09'))) AND (`t0`.`end_date` IS null OR ((`t0`.`end_date` >= '2025-05-12 14:14:09'))) AND (`t0`.`include_product_ids` LIKE '%;4633;%' OR ((`t0`.`include_product_ids` LIKE '%;4634;%'))) ORDER BY `t1`.`name` ASC VEGAFINA (베가피나) Fortaleza 2 Magnum Reposado 10 Anos 2023 Box of 10 - 온라인으로 VEGAFINA 비쿠바산 시가 구매 - TopCubans.com - 당신의 공식 스위스 쿠바 시가 하바노스 판매점.

프리미엄 쿠바 아이콘이 돌아왔습니다! 몬테 2, 매그넘, 하프 코로나, 쇼츠 등 한정 번들로 만나보세요!

VEGAFINA (베가피나)

VEGAFINA (베가피나)의 역사

베가피나 시가의 매력적인 세계를 경험해 보세요. 도미니카의 유명한 타바칼레라 데 가르시아 공장에서 정밀하게 수공예로 제작된 이 시가는 완벽한 구성과 매력적인 블렌드로 유명합니다. 에콰도르 코네티컷 셰이드 래퍼의 부드럽고 크리미한 오리지널 VF부터 맛있는 베가피나 니카라과와 특별 에디션까지, 각 퍼프는 정제된 즐거움의 여정입니다.