Pahare horeca pentru vin, apa, sampanie, cocktail / Inaltime: 63 mm, / Inaltime: 105 mm, / Inaltime: 133 mm, / Inaltime: 135 mm, / Inaltime: 151 mm, / Inaltime: 157 mm, / Inaltime: 163 mm, / Inaltime: 170 mm, / Inaltime: 216 mm

Category ID: 3123
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 (12822,12841,12859,12860,12869,12873,12878,12881,12905) 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(13) { [0]=> array(21) { ["entity_id"]=> string(5) "55500" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230081" ["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) "130.0000" } [1]=> array(21) { ["entity_id"]=> string(5) "55467" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230048" ["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) "510.0000" } [2]=> array(21) { ["entity_id"]=> string(5) "55483" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230064" ["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) "660.0000" } [3]=> array(21) { ["entity_id"]=> string(5) "55446" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230027" ["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) "700.0000" } [4]=> array(21) { ["entity_id"]=> string(5) "55454" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230035" ["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) "780.0000" } [5]=> array(21) { ["entity_id"]=> string(5) "55484" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230065" ["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) "980.0000" } [6]=> array(21) { ["entity_id"]=> string(5) "55479" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230060" ["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) "1010.0000" } [7]=> array(21) { ["entity_id"]=> string(5) "55528" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230195" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:15:28" ["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) "1320.0000" } [8]=> array(21) { ["entity_id"]=> string(5) "55530" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230162" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:16:31" ["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) "1440.0000" } [9]=> array(21) { ["entity_id"]=> string(5) "55592" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230144" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 07:23:35" ["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) "1470.0000" } [10]=> array(21) { ["entity_id"]=> string(5) "55550" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230182" ["has_options"]=> string(1) "0" ["required_options"]=> string(1) "0" ["created_at"]=> string(19) "2022-03-23 05:16:31" ["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) "101730.0000" } [11]=> array(21) { ["entity_id"]=> string(5) "55607" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230114" ["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) "101790.0000" } [12]=> array(21) { ["entity_id"]=> string(5) "55611" ["entity_type_id"]=> string(1) "4" ["attribute_set_id"]=> string(3) "548" ["type_id"]=> string(6) "simple" ["sku"]=> string(8) "12230118" ["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) "101830.0000" } }
Articole pentru masa / Pahare horeca pentru vin, apa, sampanie, cocktail
Setare Directie Descendenta
  • Adauga la Comparare In STOC Pahar sampanie si prosecco cu picior WMF Germania colectia Royal, 250 ml, din sticla cristalina Pahar sampanie si prosecco cu picior WMF Germania colectia Royal, 250 ml, din sticla cristalina

    Pahar sampanie si prosecco cu picior WMF Germania colectia Royal, 250 ml, din sticla cristalina

    In STOC
    12230081
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Pahar vin cu picior Bormioli Rocco colectia Electra, 440 ml, din sticla cristalina Pahar vin cu picior Bormioli Rocco colectia Electra, 440 ml, din sticla cristalina

    Pahar vin cu picior Bormioli Rocco colectia Electra, 440 ml, din sticla cristalina

    In STOC
    12230048
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Pahar cocktail cu picior tip Martini Bormioli Rocco colectia Diamante, 170 ml, din sticla cristalina Pahar cocktail cu picior tip Martini Bormioli Rocco colectia Diamante, 170 ml, din sticla cristalina

    Pahar cocktail cu picior tip Martini Bormioli Rocco colectia Diamante, 170 ml, din sticla cristalina

    In STOC
    12230064
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Pahar aperitiv-digestiv-lichior cu picior Bormioli Rocco colectia Riserva, 81 ml, din sticla cristalina Pahar aperitiv-digestiv-lichior cu picior Bormioli Rocco colectia Riserva, 81 ml, din sticla cristalina

    Pahar aperitiv-digestiv-lichior cu picior Bormioli Rocco colectia Riserva, 81 ml, din sticla cristalina

    In STOC
    12230027
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Cantitate limitata Pahar apa-suc-cocktail Bormioli Rocco colectia Riserva, 480 ml, din sticla cristalina Pahar apa-suc-cocktail Bormioli Rocco colectia Riserva, 480 ml, din sticla cristalina

    Pahar apa-suc-cocktail Bormioli Rocco colectia Riserva, 480 ml, din sticla cristalina

    In STOC Cantitate limitata
    12230035
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Cantitate limitata Pahar apa-suc-cocktail cu picior Bormioli Rocco colectia Regolo, 227 ml, din sticla Pahar apa-suc-cocktail cu picior Bormioli Rocco colectia Regolo, 227 ml, din sticla

    Pahar apa-suc-cocktail cu picior Bormioli Rocco colectia Regolo, 227 ml, din sticla

    In STOC Cantitate limitata
    12230065
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Cantitate limitata Pahar vin cu picior Bormioli Rocco colectia Onyx, 200 ml, din sticla temperata Pahar vin cu picior Bormioli Rocco colectia Onyx, 200 ml, din sticla temperata

    Pahar vin cu picior Bormioli Rocco colectia Onyx, 200 ml, din sticla temperata

    In STOC Cantitate limitata
    12230060
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Pahar apa-suc-cocktail cu picior Uniglass colectia King, 380 ml, din sticla Pahar apa-suc-cocktail cu picior Uniglass colectia King, 380 ml, din sticla

    Pahar apa-suc-cocktail cu picior Uniglass colectia King, 380 ml, din sticla

    In STOC
    12230195
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Pahar vin cu picior Uniglass colectia Kouros, 165 ml, din sticla Pahar vin cu picior Uniglass colectia Kouros, 165 ml, din sticla

    Pahar vin cu picior Uniglass colectia Kouros, 165 ml, din sticla

    In STOC
    12230162
    Livrare in aprox. 2 zile
  • Adauga la Comparare In STOC Pahar frappe Uniglass colectia Café, 290 ml, din sticla Pahar frappe Uniglass colectia Café, 290 ml, din sticla

    Pahar frappe Uniglass colectia Café, 290 ml, din sticla

    In STOC
    12230144
    Livrare in aprox. 2 zile
  • Adauga la Comparare Pahar aperitiv-digestiv-lichior Uniglass colectia Viva, 55 ml, din sticla Pahar aperitiv-digestiv-lichior Uniglass colectia Viva, 55 ml, din sticla

    Pahar aperitiv-digestiv-lichior Uniglass colectia Viva, 55 ml, din sticla

    12230182
    Livrare in aprox. 10 zile
  • Adauga la Comparare Pahar apa-suc-cocktail tip sonda Paderno colectia Pool, 480 ml, din plastic special Pahar apa-suc-cocktail tip sonda Paderno colectia Pool, 480 ml, din plastic special

    Pahar apa-suc-cocktail tip sonda Paderno colectia Pool, 480 ml, din plastic special

    12230114
    Livrare in aprox. 35 zile
  • Adauga la Comparare Pahar cocktail cu picior tip Martini Paderno colectia Pool, 240 ml, din plastic special Pahar cocktail cu picior tip Martini Paderno colectia Pool, 240 ml, din plastic special

    Pahar cocktail cu picior tip Martini Paderno colectia Pool, 240 ml, din plastic special

    12230118
    Livrare in aprox. 35 zile

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!

Suport