SELECT m1.*,m2.* FROM msg_cate AS m1 LEFT JOIN msg m2 ON m1.id=m2.msgid LEFT JOIN msg AS m3 ON m1.parentId=m3.msgid WHERE ( m1.parentId ='48' || m1.parentId ='28' )AND m1.sdate <= current_date AND m1.edate >= current_date AND m3.available='1' AND m3.lang='E'AND m1.show2index='1' AND ((NOT EXISTS (select * from users_group_auth ug where type='msg' AND typeid=m1.id)) OR (EXISTS (select * from users_group_auth ug where type='msg' AND typeid=m1.id AND groupid IN (0) )) ) AND m2.lang='E' AND m2.available='1' ORDER BY sort desc,id desc limit 4
Major Science Fermenters and Bioreactors Manufacturers, Suppliers
With more than 20 years of experiences, the leading lab instrument manufacturer, Major Science, manufacture and design series of lab equipment such as fermentation bioreactor, power supply, digital peristaltic pump and related accessories. Major Science provides laboratory products and quality services to biotechnology companies, academic institutions and government research labs across the world. As a professional lab equipment manufacturer, Major Science is consistently delivering cutting-edge instruments for the bio-industry that cover nearly all of your laboratory needs. Feel free to contact us for all of your inquiries!