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_274cb7b052efdb664b2dd329a86831549cfc21df` 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('3840', '3839', '3838', '3837', '3836', '3835', '3834', '3833', '3832', '3831', '3830', '3829', '3828', '3827', '3826', '3825', '3824', '3823'))) 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
There is something of the celestial about Franco-Cambodian Samantha Tea’s fine jewellery. The forms her pieces take reminds you of galaxies, starscapes and features stones that seem to be drenched in moonlight. There are moons of black onyx surrounded by a rainbow of precious stones to wear as a ring or star earrings made from abalone; the shell of a sea snail in which colours swirl like the end sequence of 2001: A Space Odyssey. Samantha designs all her fine jewellery to be wearable but uses the finest materials so that they are ones to cherish forever.
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_274cb7b052efdb664b2dd329a86831549cfc21df` 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('3840', '3839', '3838', '3837', '3836', '3835', '3834', '3833', '3832', '3831', '3830', '3829', '3828', '3827', '3826', '3825', '3824', '3823'))) AND (e.created_in <= '1582717500') AND (e.updated_in > '1582717500') AND (`e`.`entity_id` IN('3840', '3839', '3838', '3837', '3836', '3835', '3834', '3833', '3832', '3831', '3830', '3829', '3828', '3827', '3826', '3825', '3824', '3823')) ORDER BY `cat_index`.`position` asc, `cat_index`.`position` asc, `e`.`entity_id` DESC, `e`.`entity_id` ASC, `cat_index`.`position` asc
LIMIT 8
