facebook mattca
Cautare avansata

Nu ai niciun produs in cos

  1. Pagina principala
  2. Tehnica si aparatura medicala
  3. Aparatura medicala
  4. Dotari cabinete si laboratoare

Dotari cabinete si laboratoare

Pe mattca.ro gasesti tehnica si aparatura medicala: dotari cabinete si laboratoare, stetoscop, genti pentru doctori, mojar de la brand-ul de top F. BOSCH Medizintechnik.

La noi te asteapta mereu oferte, promotii si preturi accesibile!

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `at_price`.`value` AS `price`, ((at_price.value - final_price) / at_price.value) AS `discount_percent_value`, `e`.`strict_out_of_stock`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`simptome`, `e`.`afectiune`, `e`.`celmaimicpret`, `e`.`tip_rama`, `e`.`material_rama`, `e`.`culoare_lentila`, `e`.`in_stoc_furnizor`, `e`.`stil_ochelari`, `e`.`tip_lentila`, `e`.`dimensiune`, `e`.`filtru_uv`, `e`.`culoare_rama`, `e`.`culoare_rama_value`, `e`.`promo_icon`, `e`.`promo_categorie`, `e`.`strict_out_of_stock`, `e`.`culori_disponibile`, `e`.`afectiune_populara`, `e`.`afectiune_populara_value`, `e`.`sex`, `e`.`sex_value`, `e`.`stil_de_viata`, `e`.`stil_de_viata_value`, `e`.`adaos_pret_achizitie`, `e`.`produs_din_feed`, `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`, `e`.`strict_out_of_stock`, IF(`price_index`.price, ((`price_index`.price - IF(`price_index`.tier_price IS NOT NULL, LEAST(`price_index`.min_price, `price_index`.tier_price), `price_index`.min_price)) * 100 / `price_index`.price), 0) AS `saving` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2188' LEFT JOIN `catalog_product_entity_decimal` AS `at_price` ON (`at_price`.`entity_id` = `e`.`entity_id`) AND (`at_price`.`attribute_id` = '75') AND (`at_price`.`store_id` = 0) 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 WHERE (e.status = 1) AND (e.strict_out_of_stock = '0') ORDER BY `e`.`name` ASC, `e`.`strict_out_of_stock` ASC, `e`.`product_order_catalog_value` DESC LIMIT 12
Afiseaza filtre

6 Articol(e)

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `at_price`.`value` AS `price`, ((at_price.value - final_price) / at_price.value) AS `discount_percent_value`, `e`.`strict_out_of_stock`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`simptome`, `e`.`afectiune`, `e`.`celmaimicpret`, `e`.`tip_rama`, `e`.`material_rama`, `e`.`culoare_lentila`, `e`.`in_stoc_furnizor`, `e`.`stil_ochelari`, `e`.`tip_lentila`, `e`.`dimensiune`, `e`.`filtru_uv`, `e`.`culoare_rama`, `e`.`culoare_rama_value`, `e`.`promo_icon`, `e`.`promo_categorie`, `e`.`strict_out_of_stock`, `e`.`culori_disponibile`, `e`.`afectiune_populara`, `e`.`afectiune_populara_value`, `e`.`sex`, `e`.`sex_value`, `e`.`stil_de_viata`, `e`.`stil_de_viata_value`, `e`.`adaos_pret_achizitie`, `e`.`produs_din_feed`, `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`, `e`.`strict_out_of_stock`, IF(`price_index`.price, ((`price_index`.price - IF(`price_index`.tier_price IS NOT NULL, LEAST(`price_index`.min_price, `price_index`.tier_price), `price_index`.min_price)) * 100 / `price_index`.price), 0) AS `saving` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2188' LEFT JOIN `catalog_product_entity_decimal` AS `at_price` ON (`at_price`.`entity_id` = `e`.`entity_id`) AND (`at_price`.`attribute_id` = '75') AND (`at_price`.`store_id` = 0) 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 WHERE (e.status = 1) AND (e.strict_out_of_stock = '0') ORDER BY `e`.`name` ASC, `e`.`strict_out_of_stock` ASC, `e`.`product_order_catalog_value` DESC LIMIT 12
  • F.BOSCH - Stetoscop dual pentru nou-nascuti ALTO IV
    Dotari cabinete si l...

    livrare in 5 zile

    140 25 lei

    Pret cu TVA
  • Geanta mare pentru doctori F.BOSCH
    Dotari cabinete si l...

    livrare in 5 zile

    370 98 lei

    Pret cu TVA
  • F.BOSCH - Geanta mica pentru doctori
    Dotari cabinete si l...

    livrare in 5 zile

    271 45 lei

    Pret cu TVA
  • F.BOSCH - Stetoscop dual pentru copii ALTO III
    Dotari cabinete si l...

    livrare in 5 zile

    140 25 lei

    Pret cu TVA
  • Mojar 100mm
    Dotari cabinete si l...

    livrare in 5 zile

    28 57 lei

    Pret cu TVA
  • Mojar 160mm
    Dotari cabinete si l...

    in stoc

    54 12 lei

    Pret cu TVA

6 Articol(e)