SELECT p.*,cat.category_id,cat.category_name_es 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
WHERE p.is_deleted = 0 AND p.is_enabled = 1 AND p.user_id = 2648 AND (poic.product_id IS NULL OR poic.country_id = 225)
GROUP BY p.product_id,cat.category_id
ORDER BY cat.category_id ASC, p.product_id DESC

West Medica - TradeMed
En Es
Categorías

West Medica

SELECT *
FROM (SELECT n.news_id as id,n.posted,n.title,n.description,n.user_id as user_id_or_advertno,"news" as type
FROM news as n

WHERE n.is_enabled = 1 AND n.is_deleted = 0 AND n.user_id =2648



UNION ALL (SELECT dp.id,dp.created as posted,dp.title,dp.description,dp.advertno as user_id_or_advertno,"article" as type
FROM jos_deeppockets as dp

WHERE dp.published = 1 AND dp.advertno =980107775

ORDER BY posted DESC

)
) as tmp



ORDER BY posted DESC

West Medica

West Medica feels strongly that innovation is the key to a brighter future and improves the quality of life for everyone. Development of “Vision” solutions for digital microscopy is a top priority and the main focus of West Medica. Technology is an increasingly influential factor in many fields as new methods are establishe ...
Productos Resumen
Close

Sobre West Medica

Ventas US$10 Million - US$49 Million
Número de empleados: 100-499
Exportar mercados
Asia, Europe, Asia Pacific, Caribbean, Africa, Central America, South America, North America
West Medica feels strongly that innovation is the key to a brighter future and improves the quality of life for everyone. Development of “Vision” solutions for digital microscopy is a top priority and the main focus of West Medica.

Technology is an increasingly influential factor in many fields as new methods are established every day and that’s the reason why West Medica always tries to be one-step ahead. New analytical procedures are regularly introduced onto the market and as a result customers are often looking for solutions to keep up-to-date on the latest scientific developments.

Continuous analysis and evaluation of our customers’ demands as well as close observation of market trends secures routine expansion of our product portfolio. Vision develops systems for specific applications that can be grouped in 6 categories, namely: hematology, microscopy, cytogenetics, quality control, clinical laboratory and general medicine. Each system is a result of company’s field experience and extensive research as well as analysis of customers’ needs.

Vision systems are designed to maximize the use of advanced technology features and capabilities, optimise and standardize workflow and staff productivity as well as foster professional growth. Specialists that are looking for professional development and recognize new digital technologies are presented with unlimited resources in their field.

Your friendship and trust are very significant to us and our goal is to provide you with high quality and professional support.
ISO 13845
ISO 9001
TUV

Actualizado

Imaging Analyzer
Vision Hema Bone Marrow Ultimate

The Vision Hema Bone Marrow Ultimate is an imaging analyzer that automatically scans slides, identifies, pre-classifies and counts bone marrow cells, allowing a specialist to validate the results on a computer. Other features include database for archive management, remote access and network capabilities, and bi-directional communication with LIS.
Mas detalles

Digital Micro Pipettes
V-Pipette

The V-Pipette autoclavable digital micro pipettes feature a built-in tip ejector, offer smooth and stepless setting, and are easy to maintain. Other features include variable volume, accuracy and precision, robust, light weight and compatibility with a wide range of tips.
Mas detalles

Clinical Centrifuge
V-Spin

The V-Spin clinical centrifuge offers easy programming to achieve high accuracy of speed control and allows the rotor speed to be set and displayed by RPM or G-force. Other features include quick spin function, lid with electric lock and automatic release function, automatic self-testing on startup and display of accumulative running time and last running parameters.
Mas detalles
Derecho de autor © 2000-2026 TradeMed.com. Todos los derechos reservados. | Términos y condiciones