Pahare horeca pentru vin, apa, sampanie, cocktail / Inaltime: 89.5 mm, / Inaltime: 95 mm, / Inaltime: 98 mm, / Inaltime: 175 mm, / Inaltime: 188.5 mm, / Inaltime: 210 mm, / Inaltime: 212 mm
Collection SQL: SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(( SELECT vm.view_mode AS required_options FROM catalog_product_option AS cpo LEFT JOIN mageworx_custom_options_option_view_mode AS vm ON cpo.option_id=vm.option_id AND (vm.store_id='2' OR vm.store_id=0) WHERE e.entity_id=cpo.product_id AND cpo.is_require=1 ORDER BY vm.store_id DESC LIMIT 0,1)='1','1','0') AS `required_options`, `at_pozitie_global`.`value` AS `pozitie_global` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '3123' AND cat_index.is_parent=1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `art_inaltime_filtru_idx` ON `art_inaltime_filtru_idx`.entity_id = e.entity_id AND `art_inaltime_filtru_idx`.attribute_id = '5154' AND `art_inaltime_filtru_idx`.store_id = 2 AND `art_inaltime_filtru_idx`.value in (12829,12835,12837,12884,12892,12900,12902) LEFT JOIN `catalog_product_entity_decimal` AS `at_pozitie_global` ON (`at_pozitie_global`.`entity_id` = `e`.`entity_id`) AND (`at_pozitie_global`.`attribute_id` = '5793') AND (`at_pozitie_global`.`store_id` = 0) ORDER BY `pozitie_global` ASC LIMIT 48
array(15) { [0]=> array(21) { ["entity_id"]=> string(5) "55496" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230077" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(7) "90.0000" } [1]=> array(21) { ["entity_id"]=> string(5) "55442" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230023" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(8) "450.0000" } [2]=> array(21) { ["entity_id"]=> string(5) "55462" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230043" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(8) "600.0000" } [3]=> array(21) { ["entity_id"]=> string(5) "55463" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230044" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(8) "610.0000" } [4]=> array(21) { ["entity_id"]=> string(5) "55448" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230029" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(8) "720.0000" } [5]=> array(21) { ["entity_id"]=> string(5) "55451" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230032" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(8) "750.0000" } [6]=> array(21) { ["entity_id"]=> string(5) "55453" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230034" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(8) "770.0000" } [7]=> array(21) { ["entity_id"]=> string(5) "55426" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230007" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(8) "820.0000" } [8]=> array(21) { ["entity_id"]=> string(5) "55478" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230059" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(9) "1000.0000" } [9]=> array(21) { ["entity_id"]=> string(5) "55459" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230040" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(9) "1050.0000" } [10]=> array(21) { ["entity_id"]=> string(5) "55489" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230070" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:02:44" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(11) "101130.0000" } [11]=> array(21) { ["entity_id"]=> string(5) "55615" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230122" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 07:31:55" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(11) "101870.0000" } [12]=> array(21) { ["entity_id"]=> string(5) "55555" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230124" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:17:56" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(11) "101890.0000" } [13]=> array(21) { ["entity_id"]=> string(5) "55559" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230128" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:17:56" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(11) "101930.0000" } [14]=> array(21) { ["entity_id"]=> string(5) "55561" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230130" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:17:56" ["updated_at"]=> string(19) "2024-11-15 16:43:26" ["absolute_price"]=> string(1) "0" ["absolute_weight"]=> string(1) "0" ["sku_policy"]=> string(1) "0" ["cat_index_position"]=> string(1) "1" ["price"]=> string(6) "0.0000" ["tax_class_id"]=> string(1) "2" ["final_price"]=> string(6) "0.0000" ["minimal_price"]=> string(6) "0.0000" ["min_price"]=> string(6) "0.0000" ["max_price"]=> string(6) "0.0000" ["tier_price"]=> NULL ["pozitie_global"]=> string(11) "101950.0000" } }
Articole pentru masa / Pahare horeca pentru vin, apa, sampanie, cocktail
-
Adauga la Comparare
Pahar vin cu picior WMF Germania colectia Royal, 390 ml, din sticla cristalina
In STOC12230077 -
Adauga la Comparare
Pahar apa-suc-cocktail Bormioli Rocco colectia Aurum, 360 ml, din sticla cristalina
In STOC12230023 -
Adauga la Comparare
Pahar apa-suc-cocktail tip sonda Bormioli Rocco colectia Ypsilon, 453 ml, din sticla
In STOC12230043 -
Adauga la Comparare
Pahar aperitiv-digestiv-lichior Bormioli Rocco colectia Ypsilon, 150 ml, din sticla
In STOC12230044 -
Adauga la Comparare
Pahar whiskey Bormioli Rocco colectia Riserva, 410 ml, din sticla
In STOC12230029 -
Adauga la Comparare
Pahar vin cu picior Bormioli Rocco colectia Riserva, 490 ml, din sticla cristalina
In STOC12230032 -
Adauga la Comparare
Pahar sampanie si prosecco cu picior Bormioli Rocco colectia Riserva, 390 ml, din sticla cristalina
In STOC Cantitate limitata12230034 -
Adauga la Comparare
Pahar vin cu picior Bormioli Rocco colectia New Kalix, 348 ml, din sticla temperata
In STOC12230007 -
Adauga la Comparare
Pahar sampanie si prosecco cu picior Bormioli Rocco colectia Onyx, 170 ml, din sticla temperata
In STOC Cantitate limitata12230059 -
Adauga la Comparare
Pahar whiskey Bormioli Rocco colectia Gina, 405 ml, din sticla
In STOC Cantitate limitata12230040 -
Adauga la Comparare
Pahar whiskey Bormioli Rocco colectia Bodega, 355 ml, din sticla temperata
-
Adauga la Comparare
Pahar vin cu picior Paderno colectia Pool, 300 ml, din plastic special
-
Adauga la Comparare
Pahar whiskey tip cilindric Paderno colectia Pool, 420 ml, din plastic special
-
Adauga la Comparare
Pahar cocktail cu picior Paderno colectia Pool, 460 ml, din plastic special
-
Adauga la Comparare
Pahar cocktail cu picior tip Margarita Paderno colectia Pool, 340 ml, din plastic special
Pahare cocktail
Descoperă colecția noastră variată de pahare HORECA pentru vin, apă, șampanie și cocktailuri, disponibile la Maxigel! Indiferent dacă ești un profesionist din industria ospitalității sau un pasionat de arta preparării băuturilor, avem paharele potrivite pentru a-ți oferi o experiență deosebită la servirea și savurarea acestora.
Paharele noastre HORECA sunt create cu atenție la detalii, pentru a satisface cele mai exigente cerințe ale industriei. Fie că dorești să servești un vin deosebit, apă răcoritoare, șampanie efervescentă sau cocktailuri spectaculoase, avem paharele ideale pentru fiecare băutură.
Realizate din sticlă de înaltă calitate sau cristal, paharele noastre sunt durabile, rezistente și elegante. Fiecare pahar este proiectat ergonomic, cu forme și dimensiuni adaptate tipului de băutură, pentru a evidenția aromele și bucuria gustului într-un mod deosebit.
Colecția noastră de pahare HORECA include modele clasice și rafinate, dar și opțiuni moderne și contemporane, pentru a se potrivi stilului și atmosferei locației tale. De la pahare cu picior lung și subțire, care adaugă un aer sofisticat, până la pahare cu forme inovatoare și captivante, poți alege designul care se potrivește cel mai bine personalității și conceptului tău.
Indiferent de evenimentul sau ocazia pe care o ai în plan, paharele noastre HORECA vor adăuga un plus de eleganță și rafinament. Fie că organizezi o cină elegantă, un eveniment special sau o petrecere relaxată, paharele noastre vor completa perfect atmosfera și vor încânta invitații.
Completează-ți arsenalul de accesorii pentru băuturi cu pahare HORECA de calitate superioară de la Maxigel. Comandă acum și bucură-te de servirea și degustarea băuturilor preferate în cele mai frumoase și elegante pahare. Transformă fiecare moment într-o experiență memorabilă și oferă un serviciu de cea mai înaltă calitate clienților tăi cu ajutorul paharelor noastre HORECA!