We use cookies to make your experience better.To comply with the new e-Privacy directive, we need to ask for your consent to set the cookies.Learn more
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `perm`.`grant_catalog_category_view`, `perm`.`grant_catalog_product_price`, `perm`.`grant_checkout_items`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, IFNULL(warehouse_index.stock_status, stock_status_index.stock_status) AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=65
LEFT JOIN `magento_catalogpermissions_index` AS `perm` ON perm.customer_group_id = 0 AND perm.category_id = cat_index.category_id AND perm.website_id = '1'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `search_tmp_628e05e1c362f5_91114381` AS `search_result` ON e.entity_id = search_result.entity_id
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `amasty_multiinventory_warehouse_item` AS `warehouse_index` ON e.entity_id = warehouse_index.product_id AND warehouse_index.warehouse_id = '2' WHERE ((perm.grant_catalog_category_view != -2 OR perm.grant_catalog_category_view IS NULL)) AND (e.created_in <= '1575176340') AND (e.updated_in > '1575176340') ORDER BY `cat_index`.`position` asc, `cat_index`.`position` asc, `e`.`entity_id` DESC
LIMIT 15
Enzyme protection sprays can help extend your hair replacement system attachment by blocking the enzymes that break down your adhesive’s bond. They also help avoid odor and extend the overall life of your system by preventing oil and bacteria buildup. Not sure if enzyme protection spray is what you need? We offer trial size bottles under 1 ounce. Our hair replacement consultants are always available to answer your questions, and we offer a 30-day money-back guarantee. Already a fan of enzyme protection? Find your favorite brand in a 3- or 5-ounce bottle.
JOIN OUR MAILING LIST
SIGN UP FOR NEW ARRIVALS AND INSIDER-ONLY DISCOUNTS
SIGN UP FOR NEW ARRIVALS AND INSIDER-ONLY DISCOUNTS