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=104
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_628e0e60d9f885_52901498` 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
When your naturally growing hair begins to thin, or shedding causes your hair replacement system to lose its fullness, hair loss concealers can provide an effective short-term solution. Available from brands like Vapon, in formats such as spray-on, fiber, lotion, cream, and powder formulas, concealers bond to existing hair strands increasing hair volume. To help you hide or mask early-stage hair loss, HairDirect carries hair loss concealers in brown, black, gray, and blond to blend with your natural hair color and mask your hair loss.
JOIN OUR MAILING LIST
SIGN UP FOR NEW ARRIVALS AND INSIDER-ONLY DISCOUNTS
SIGN UP FOR NEW ARRIVALS AND INSIDER-ONLY DISCOUNTS