SELECT `t_d`.`attribute_id`, `e`.`entity_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.row_id = t_d.row_id AND (e.created_in <= 1 AND e.updated_in > 1) LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 76 WHERE (e.entity_id IN (97, 478, 589)) AND (t_d.attribute_id IN ('136', '367')) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) | 18k White Gold | White Gold

All Mikimoto boutiques are now open. Mikimoto Ambassadors are available for virtual appointments and can answer any questions here. Mikimoto

Mikimoto

Please select a location and what language you would like to see the website in.

VISIT SITE