Color Me Happy

What's your favorite color? Our colored gemstone jewelry comes in every color of the rainbow, with multicolor and blue sapphires, rich rubies, blue topaz and aquamarines, emeralds in shades of green, and bold citrine jewelry that glows. Purple amethysts are our customers' favorite!
SELECT DISTINCT `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` FROM `magento_catalog_product_entity` AS `e` INNER JOIN `magento_catalog_category_product_index` 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='1737' INNER JOIN `magento_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 INNER JOIN `magento_catalog_product_index_eav` AS `gf_metal_color_idx` ON `gf_metal_color_idx`.entity_id = e.entity_id AND `gf_metal_color_idx`.attribute_id = '137' AND `gf_metal_color_idx`.store_id = 1 AND `gf_metal_color_idx`.value in (909) ORDER BY `cat_index`.`position` ASC LIMIT 24

6 Item(s)

per page
SELECT DISTINCT `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` FROM `magento_catalog_product_entity` AS `e` INNER JOIN `magento_catalog_category_product_index` 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='1737' INNER JOIN `magento_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 INNER JOIN `magento_catalog_product_index_eav` AS `gf_metal_color_idx` ON `gf_metal_color_idx`.entity_id = e.entity_id AND `gf_metal_color_idx`.attribute_id = '137' AND `gf_metal_color_idx`.store_id = 1 AND `gf_metal_color_idx`.value in (909) ORDER BY `cat_index`.`position` ASC LIMIT 24

6 Item(s)

per page