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_74870071dbc572d493609c76e562242f32431976` 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('4008', '4007', '4006', '4005', '4004', '4003', '4002', '4001', '3862', '3861', '3860', '3859', '3858', '3857', '3856', '3855', '3854', '3853', '3852', '3851', '3850', '3849', '3848', '3847', '3846', '3845', '3361', '3360', '3359', '3358', '3357', '3356', '3355', '3354', '3353', '3352', '3351', '3350', '3349', '3348', '3347', '3346', '3345', '3344', '3343'))) 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
When your childhood coincides with the halcyon days of the pop art scene in New York, your parents are Mick and Bianca Jagger and you taught Andy Warhol how to play Monopoly when you were four, chances are you’re not going to become an accountant. Creativity has always been at the heart of Jade Jagger’s life. She started out as an artist in the late 1980s, after studying art in Florence, before turning her hand to one-of-a-kind jewellery pieces. These caught the eye of Asprey & Garrard and she spent seven years there as creative director, dragging the revered but ever-so-slightly stuffy fine jeweller into the 21st century. In the interim years, Jagger has turned her hand to designing everything from living spaces to bottle labels for Croix de Beaucaillou, one of Bordeaux’s greatest wines. She also dabbled in clothing design. However, she’s now returned to fine jewellery with her bold designs, which seem to exist on an intersection between modernity and antiquity, take traditional Indian materials and styles and rework them for the contemporary customer.