At all times and in all places women preferred to decorate their wrists with bracelets. The Hermitage Museum possesses a large collection of bracelets created by great masters around the world, which retain the impact of their ages and owners. The modern bracelets inspired by the works of art from the Hermitage collection will remind you of bygone centuries. As your exquisite dress accessories, they will add to your individuality and stress your refined taste.
[select p.products_weight, p.products_model, p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c INNER JOIN zen_categories c ON p2c.categories_id = c.categories_id left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and (c.categories_id = '199' OR c.parent_id = '199') order by p.products_sort_order, pd.products_name limit 0, 50]