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
...
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
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
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
