SELECT `e`.*, `t_compare`.`product_id`, `t_compare`.`customer_id`, `t_compare`.`visitor_id`, `t_compare`.`store_id` AS `item_store_id`, `t_compare`.`catalog_compare_item_id`, `cat_index`.`position` AS `cat_index_position`, `cat_index`.`visibility`, `store_cat_index`.`visibility` AS `store_visibility` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_compare_item` AS `t_compare` ON (t_compare.product_id=e.entity_id) AND (t_compare.visitor_id = '12538') INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = '3' LEFT JOIN `core_store` AS `store_index` ON store_index.store_id = t_compare.store_id LEFT JOIN `core_store_group` AS `store_group_index` ON store_index.group_id = store_group_index.group_id LEFT JOIN `catalog_category_product_index` AS `store_cat_index` ON store_cat_index.product_id = e.entity_id AND store_cat_index.store_id = t_compare.store_id AND store_cat_index.category_id=store_group_index.root_category_id LEFT JOIN `catalog_product_entity_text` AS `_cp_def` ON _cp_def.entity_id = e.entity_id AND _cp_def.attribute_id = 1059 AND _cp_def.store_id = 0 LEFT JOIN `catalog_product_entity_text` AS `_catalogpermissions_store` ON _catalogpermissions_store.entity_id = e.entity_id AND _catalogpermissions_store.attribute_id = 1059 AND _catalogpermissions_store.store_id = 1 WHERE (cat_index.visibility IN(3, 2, 4) OR store_cat_index.visibility IN(3, 2, 4)) AND (IF(_catalogpermissions_store.value_id > 0, _catalogpermissions_store.value, _cp_def.value) NOT REGEXP '(^|,)-1(,|$)' OR (_catalogpermissions_store.value IS NULL AND _cp_def.value IS NULL))

Ameda Breast Pumps | Ameda Direct

Ameda Direct

View All Breast Pumps

Discover which Ameda Breast Pump is right for You!

Breast Feeding 101

Empowering Moms with information and knowledge throughout their exciting journey! View our resources to learn more.

Insurance Pumps - Where do I begin?

Everything You need to know in order to find out how to qualify for an Insurance covered Ameda Breast Pump.

Life Happens, Be Prepared

Shop  All Ameda Breast Pump Accessories and Supplies 

Accessories and Spare Parts

Increase Your Market ShareThrough Partnership 

-Offer a large variety of E0602, E0603,E0604 Accessories
-No minimum order requirments
-Take advantage of provider promotions
-Power to optimize ordering process and cash flow.
-Develop advantageous partnership

Learn More