Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/med_portals/www/shared/includes/rude-php-mailgun/apps/mailgun-standalone/etc/database.php on line 49

Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/med_portals/www/shared/includes/bridge/classes/helpers/database/database.php on line 49

Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/trademed/medbiz/medbiz.net/www/index.php on line 86

Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/trademed/medbiz/shared/classes/DB.php on line 233
SELECT `user_id`,`is_seller`,`pass`,`email`,`login`,`personal_title`,`firstname`,`lastname`,`activation`,`registered_date`,`is_mail_confirm`,`is_activated`,`is_enabled`,`is_approved`,`is_spammer`,`zip`,`country_id`,`city`,`state`,`street`,`fax`,`phone`,`mobile`,`imported`,`status_to_receive_newsletters`,`status_to_receive_newsletters_date`,`fb_id`,`oauth_registration`,`user_id`
FROM users

WHERE users.user_id='4979'



SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3210'



SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3210'



| LO-23 THEA | Medical Equipment and devices for hospitals or institutions. | TradeMed SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3210'



En Es
Products
Covid-19
Companies
Pre-Owned
News
Events
About Us       Join now!
Categories

Browse Products by Category

Critical Care

Emergency Medicine

Intensive Care

Respiratory Care

Anesthesiology Systems

Home Care

Rehabilitation

Other

Hospital Infrastructure

IT Equipment

Transportation Systems

Other

Medical Imaging

Computed Tomography

Digital Radiography

Image Management Systems

Interventional Radiology

Magnetic Resonance Imaging

Mammography

PACS/RIS

Positron Emission Tomography

Radiation Safety

Radiography

Single-Photon Emission Computed Tomography

Ultrasound

Other

Patient Care

Bariatric Care

Beds

Examination Equipment

Other

Surgery

Endoscopy

Laparoscopy

Laser Surgery

Operating Room Equipment

Sterilization

Surgical Implants

Surgical Instruments

Waste Management

Other

Clinical Laboratory

Blood/Gas Analyzers

Cell Counters

Centrifuges

Clinical Chemistry Analyzer

Coagulation Analyzers

Hematology Analyzers

Immunoassay Systems

Lab Glassware

Microscopes

Pipettes

General Lab

Microplate Reader

Urine Analyzer

Ready-to-use kits for analysis

Rapid Tests

Other

Browse Products by Category

Close
SELECT `user_id`,`is_seller`,`pass`,`email`,`login`,`personal_title`,`firstname`,`lastname`,`activation`,`registered_date`,`is_mail_confirm`,`is_activated`,`is_enabled`,`is_approved`,`is_spammer`,`zip`,`country_id`,`city`,`state`,`street`,`fax`,`phone`,`mobile`,`imported`,`status_to_receive_newsletters`,`status_to_receive_newsletters_date`,`fb_id`,`oauth_registration`,`user_id`
FROM users

WHERE users.user_id='4979'



SELECT p.product_id,cat.category_id,cat.category_name_en as category_name
FROM products as p
JOIN products_to_categories AS pc ON pc.product_id=p.product_id
JOIN view_category_root vcr on vcr.category_id=pc.category_id
JOIN categories cat on cat.category_id=vcr.root_id
LEFT JOIN products_only_in_country as poic ON poic.product_id = p.product_id
LEFT JOIN companies_only_in_country as coic ON coic.company_id = p.user_id
WHERE p.user_id=4979 AND p.covid_19 = 1 AND p.is_enabled = 1 AND p.is_deleted = 0 AND (poic.product_id IS NULL OR poic.country_id = 225) AND (coic.company_id IS NULL OR coic.country_id = 225)
GROUP BY category_id,p.product_id
ORDER BY category_name ASC, p.posted DESC, p.product_id ASC

FAMED SA

Famed Żywiecis is a European producer of hospital equipment, including ICU beds, operating tables, trolleys, delivery beds, examination chairs and surgical lighting solutions, which are manufactured in accordance with ISO-9001 and ISO 13485 certified quality management systems. The company has also implemented and maintain ...
Products Summary
Close

About FAMED SA

Famed Żywiecis is a European producer of hospital equipment, including ICU beds, operating tables, trolleys, delivery beds, examination chairs and surgical lighting solutions, which are manufactured in accordance with ISO-9001 and ISO 13485 certified quality management systems. The company has also implemented and maintains an environmental management system that meets the Cleaner Production and ISO 14001 standards.
FaceBook Twitter Google+ Linked in

Model: LO-23 THEA
Request Information

Description:


SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3210'



Tags: [Surgery], [Operating Room Equipment], [OR Lighting and Surgical Tables]

Send A Message To This Supplier

* Required Information
* Email
To
FAMED SA (Operating Lamp)
* Message

SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3210'




Warning: Invalid argument supplied for foreach() in /home/www/trademed/medbiz/shared/mvc/Product/Block/View.php on line 37

Warning: array_shift() expects parameter 1 to be array, boolean given in /home/www/trademed/medbiz/shared/mvc/Product/Block/View.php on line 68

More Products From This Supplier or Category

SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='6154'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='6122'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2955'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3204'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3223'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='6156'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='8416'
Copyright © 2000-2024 TradeMed.com. All rights reserved. | Terms And Conditions