SELECT * FROM tbl_products p, tbl_products_to_categories pc, tbl_categories c where p.products_id=pc.products_id and pc.categories_id=c.categories_id AND p.show_status=1 AND c.categories_id IN (173,173,174,174,176,176,177,177,178,178,180,180,181,181,183,183,184,184,188,188,189,189,190,190,192,192,195,195,203,203,204,204,206,206,208,208,210,210,211,211,212,212,213,213,215,215,216,216,217,217,218,218,173,174,176,177,178,180,181,183,184,188,189,190,192,195,203,204,206,208,210,211,212,213,215,216,217,218,171) AND p.products_name LIKE 'X%' GROUP BY p.products_id ORDER BY p.products_name, p.sort_order LIMIT 0, 50

Your Selections

  • Categories:
  • Cell Culture Tested Chemical (3) Close

Categories

  • Amino acids (36)
  • Antibiotics contamination control antibiotics (35)
  • Anticancer antibiotics (9)
  • Attachment factors (7)
  • Biochemichals and components (81)
  • Biological buffers (28)
  • Carbohydrates (18)
  • Carrier proteins (6)
  • Cell dissociation products (15)
  • Cell proliferation and cytotoxity indicators (6)
  • chemicals meeting pharmacopeial testing specifications (84)
  • Chemicals meeting pharmacopeial testing specifications (0)
  • Cryprotectants (3)
  • Cyclodextrins (4)
  • Cytotoxic anticancer antibiotics (3)
  • Detergents (5)
  • Differentiation reagents (5)
  • Enzymes (30)
  • Fatty acids (9)
  • Fmoc amino acids (25)
  • Gene selection antibiotics (6)
  • Hormones and hormone alternative (9)
  • Lipids (2)
  • Nucleotides and nucleosides (9)
  • Vaccine stabilizers and adjuvant (21)
  • Vitamins (18)

Grades

  • Cell Culture Tested (ATC) (3)