Return to Previous Page
x

Necklaces

SELECT `e`.*, `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`, `stock_status_index`.`stock_status` AS `is_salable`, `at_bestsellers`.`qty_ordered` AS `bestsellers`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '5' 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 LEFT JOIN `amasty_sorting_bestsellers` AS `at_bestsellers` ON (at_bestsellers.`product_id`=e.entity_id) AND (at_bestsellers.store_id = '5') LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (24925, 28382, 33899, 33937, 43307, 49586, 49623, 53308, 53313, 74783, 74786, 74790, 74794, 74795, 74796, 74807, 74808, 74814, 74817, 63022, 63023, 67996, 67999, 68000, 68003, 68004, 68040, 68042, 79545, 79546, 79551, 79552)) ORDER BY FIELD(e.entity_id,24925,28382,33899,33937,43307,49586,49623,53308,53313,74783,74786,74790,74794,74795,74796,74807,74808,74814,74817,63022,63023,67996,67999,68000,68003,68004,68040,68042,79545,79546,79551,79552)

Items 1-32 of 65

Set Ascending Direction
per page
Page

Items 1-32 of 65

Set Ascending Direction
per page
Page
Trending In This Category
Rainbow Carnival Full Necklace
Rainbow Carnival Full Necklace
Special Price $33.30 Regular Price $37.00
Emerald Tiles Spaced Necklace
Emerald Tiles Spaced Necklace
Special Price $24.30 Regular Price $27.00
Out of stock
Turquoise Mosaic Coins Necklace
Turquoise Mosaic Coins Necklace
Special Price $19.80 Regular Price $22.00
Out of stock
Spring Millefiori Link Necklace
Spring Millefiori Link Necklace
Special Price $24.30 Regular Price $27.00
Out of stock
Teal & Green Filaments Spaced Necklace
Teal & Green Filaments Spaced Necklace
Special Price $27.00 Regular Price $30.00
Botanicals Spaced Necklace
Botanicals Spaced Necklace
Special Price $33.30 Regular Price $37.00
Rainbow Strata Spaced Necklace
Rainbow Strata Spaced Necklace
Special Price $24.30 Regular Price $27.00
Rainbow Satin Cubes Links Necklace
Rainbow Satin Cubes Links Necklace
Special Price $27.00 Regular Price $30.00
Rainbow Jasper Full Necklace
Rainbow Jasper Full Necklace
Special Price $54.00 Regular Price $60.00
Pale Blue Hurricane Glass Necklace
Pale Blue Hurricane Glass Necklace
Special Price $19.80 Regular Price $22.00
Out of stock
Fast and secure payment with:
Secure Payment Options
© 2023 - 2025