Julez Bryant Fine Jewelry, founded in 2003, creates exquisite and wearable jewels that are designed to be layered; a bit of luxe for every day. Founder and Designer Julez Bryant DeCosta believes that jewelry is meant to be worn and enjoyed; that it must be both beautiful and personal, thereby empowering a women when she is adorned. It is the combination of Julez’ unique design vision and corporate ethics that has laid the groundwork for strong and lasting relationships with retail stores and the clientele who collect our jewelry.
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) = '190') ORDER BY find_in_set(e.entity_id,'') ASC, `name` asc, `at_name`.`value` asc LIMIT 18