select distinct c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.parent_id = '236' and cd.language_id = '1' and c.categories_id = cd.categories_id order by sort_order, cd.categories_name

These flasks come in different varieties with different features.  Each product has multiple sizes that can be purchased. 

Flasks
Click to shop partner's catalogs

Colonial Scientific has teamed up with the industry leaders, Fisher Scientific and VWR, and now offers their entire product line. Colonial Scientific provides any part from the Fisher Scientific site with a part number.
Fisher ScientificVWR Catalog