Place your credit card on the screen according to the template below. Use the + and - buttons to adjust the slider until the bronze lines match the height of your card.
SELECT `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `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=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
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'))
INNER JOIN `temp_fff208a04e27ba717977ca925fe3699390cb03cb` AS `search_result` ON `e`.`entity_id` = `search_result`.`entity_id`
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 WHERE ((`e`.`entity_id` IN('3902', '3901', '3900', '3899', '3898', '3897', '3896', '3895', '3894', '3893', '3892', '3891', '3890', '3889', '3888', '3887', '3886', '3885', '3884', '3883', '3882', '3881', '3880', '3879', '3878'))) AND (e.created_in <= '1582717500') AND (e.updated_in > '1582717500') ORDER BY `cat_index`.`position` asc, `cat_index`.`position` asc, `e`.`entity_id` DESC, `e`.`entity_id` ASC
LIMIT 8
About
It’s not every day a business can say it got its start because Jay-Z requested a bracelet to be designed just for him. But that is exactly what happened with Shamballa. Founded in 2005 by brother Mads and Mikkel Kornerup, Shamballa, named after the mythical kingdom also known as Shangri-La, takes the traditional Buddhist prayer bead gives it a luxury twist. Rather than using sandalwood or lotus plant seeds, these beads are decked out in diamonds, made from precious metals or engraved with the brand’s Star of Shamballa logo. The brand has expanded to include fine-jewellery pieces not made from the beads, but they remain the most iconic part of the collection, seen on the likes of Helena Christensen, Leonardo DiCaprio and Jay-Z, of course.
Shamballa 18-karat rhodium plated white gold, diamond and onyx non-braided braceletAs low as £1,822.50