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 (172,172,175,175,179,179,182,182,185,185,186,186,187,187,191,191,193,193,194,194,196,196,197,197,198,198,199,199,200,200,201,201,202,202,205,205,207,207,209,209,214,214,219,219,220,220,172,175,179,182,185,186,187,191,193,194,196,197,198,199,200,201,202,205,207,209,214,219,220,170) AND p.products_name LIKE 'K%' GROUP BY p.products_id ORDER BY p.products_name, p.sort_order LIMIT 0, 50

Your Selections

  • Categories:
  • Plant Culture Tested Chemical (4) Close

Categories

  • Adsorbent (4)
  • Amino acids (22)
  • Antibiotic solutions (sterile filtered) (7)
  • Antibiotics and antifungals (48)
  • Auxins (15)
  • Buffers (1)
  • Carbohydrates (carbon source) (15)
  • Cytokinins (17)
  • Disinfectants (9)
  • Dyes and stains (6)
  • Enzymes (4)
  • Gibberellins (1)
  • Indicators (10)
  • Macro elements (16)
  • Media dyes (4)
  • Metabolites (6)
  • Micro elements (22)
  • Miscellaneous chemicals (35)
  • Organic acids (5)
  • Organic supplements (13)
  • Others (25)
  • Steroids/sterols (6)
  • Vitamins (15)

Grades

  • Plant Culture Tested (PTC) (4)