In 1775, A.L. Breguet did not shy at the opportunity to set the bar exceedingly high for the premiere Swiss watch world. Inventing the tourbillion is only a fraction of the accomplishments he is legendary for. He left reminiscent talents within his descendants who are responsible for the impeccable standard that each assembled piece sees. Desired for their innovative blued hands, coin edged cases, and delicate porcelain dial; many competitors have borrowed their originality by adapting these key elements to their own lines in hope of being accepted in the same regard. Truly astonishing models adorn the line as there is so much to be respected. “Reine de Naples” is elaborately put together it’s no revelation that it was initially presented to The Queen of Naples herself. Many esteemed individuals were devoted clients to the brand; including: Marie Antoinette, Napolean Bonaparte and and Tsar Alexandrer I of Russia just to name a few. Whether it’s enjoying a luminous day on a yacht sporting a marine, or attending the most affluent black tie event with a tradition on your wrist, Breguet accurately identifies the necessary essentials required for each occasion. The brand has been running immaculately in the same motions that exhibit their inevitable accomplishments.
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) = '29') ORDER BY `name` asc, `at_name`.`value` asc LIMIT 30