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_12c6b4adc44e3d2fc5d23ec936faf9d14f08c114` 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('3414', '3413', '3412', '3411', '3410', '3409', '3408', '3407', '3406', '3405', '3404', '3403', '3402', '3401', '3400', '3399', '3398', '3397', '3396', '3395', '3394', '3393', '3392', '3391', '3390', '3389'))) 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
Melissa Joy Manning may be the name on the fine-jewellery box, but this brand is first and foremost a passionate and highly skilled collective. It is one dedicated to making beautiful, joyful fine jewellery in a way that supports domestic craftspeople and doesn’t have the carbon footprint associated with this industry.
Every collection and every piece radiates happiness. The stones used, like the vibrant green chryoprases or the murky, mysterious dendritic agates, seem have colours that are especially vital.
And then there’s the feelgood factor of the brand’s ethical stance. All the stones are Canadian, reclaimed or sourced domestically where possible; the studio is run with a zero-waste policy and doesn’t use excessive water like traditional metalsmithing techniques and the precious metals are all recycled. This is fine jewellery that spreads joy even when it’s not being worn.
