SELECT product.*, product_category.category_id AS product_category_id FROM product, category, product_category WHERE product.status = '1' AND category.status = '1' AND (product.sku LIKE '%Amethyst%' OR product.display_sku LIKE '%Amethyst%' OR product.title LIKE 'Amethyst%' OR product.title LIKE '% Amethyst%' OR product.metal_type LIKE '%Amethyst%') AND product_category.category_id = '670' AND product_category.category_id = AND = product_category.product_id Amethyst
14K Yellow Freshwater Cultured Pearl ... $408.00
14K Yellow Amethyst 7.25" Bracelet $578.00
14K White 7x5 mm Oval Amethyst 7" Bra... $1372.00
14K Yellow Amethyst Cuff 6" Bracelet $1975.00
14K White Amethyst 7.15" Line Bracelet $4208.00
Saved Items (0)

Use this space to save the products you like. To add a product here, simply click the icon.