Founded over 60 years ago in Antwerp, Belgium, the diamond capital of the world, Henri Daussi is an example of expertise and passion for diamonds passed on from generation to generation. Cutting the world's most brilliant diamonds and creating only the finest jewelry has forever been a Loots family tradition. We are humbled and honored to provide the same excellence in craftsmanship and design set forth by our founder, Henri Daussi Loots. We ensure every Henri Daussi hallmark piece will be a part of your family for years to come. Henri Daussi Loots, grandfather to Jeff and Kristiaan Loots who lead the family business today, was born and raised in Antwerp, Belgium. He was taught the art of diamond cutting at a young age by his father, who in turn learned the diamond trade from his father. After years of experience, Henri became a respected master diamond cutter and worked for other diamond manufacturers to cut only their most unique and significant diamonds. Today, Henri Daussi is headquartered in New York City and is available at only the finest jewelry retailers across the US and Canada.
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IF(at_product_brand.value_id > 0, at_product_brand.value, at_product_brand_default.value) AS `product_brand`, `at_name`.`value` AS `name` FROM `catalog_product_entity` AS `e`
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.visibility IN(2, 4) AND cat_index.category_id='2'
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 `catalog_product_entity_int` AS `at_product_brand_default` ON (`at_product_brand_default`.`entity_id` = `e`.`entity_id`) AND (`at_product_brand_default`.`attribute_id` = '198') AND `at_product_brand_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_product_brand` ON (`at_product_brand`.`entity_id` = `e`.`entity_id`) AND (`at_product_brand`.`attribute_id` = '198') AND (`at_product_brand`.`store_id` = 1)
LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '70') AND (`at_name`.`store_id` = 0) WHERE (IF(at_product_brand.value_id > 0, at_product_brand.value, at_product_brand_default.value) = '197') ORDER BY find_in_set(e.entity_id,'') ASC, `name` asc, `at_name`.`value` asc LIMIT 18 OFFSET 126