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_cf4de942f8f0c3cc2f917bb34515222c9b36ba94` 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('3522', '3521', '3520', '3519', '3518', '3517', '3516', '3515', '3514', '3513', '3512', '3511', '3510', '3509', '3508', '3507', '3506', '3505', '3504', '3503', '3502', '3501', '3500', '3499', '3498', '3497', '3496', '3495', '3494', '3493', '3492', '3491', '3490', '3489', '3488', '3487', '3486', '3485', '3484', '3483', '3482', '3481', '3480', '3479', '3478', '3477', '3476', '3475', '3474', '3473', '3472', '3471', '3470', '3469', '3468', '3467', '3466', '3465', '3464', '3463', '3462', '3461', '3460', '3459', '3458', '3457', '3456', '3455', '3454', '3453', '3452', '3451', '3450', '3449', '3448', '3447', '3446', '3445', '3444', '3443', '3442', '3441', '3440', '3439', '3438', '3437', '3436', '3435', '3434', '3433', '3432', '3431', '3430', '3429', '3428', '3427'))) 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
The Boodles story started in Liverpool in 1798. Since then it has made silverware for royalty, trophies for the Grand National and hosted an international tennis tournament in Buckinghamshire’s famous Stoke Park Club. However, Boodles is most famous for is its exquisite fine jewellery. Known for making incredibly wearable collections, thanks to its willingness to explore new techniques as well as keeping traditional jewellery making crafts alive. From the playfulness of the Roulette collection to the colourful clusters of precious stones in their signature Raindance range, Boodles continues to delight fine jewellery lovers 222 years after it first opened its doors - this is British jewellery design at its best. Boodles’ flagship store is in the heart of Bond Street in London.
