›  › All

SELECT DISTINCT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price`, IF((SELECT COUNT(*) FROM `mod_shop_prod_attr_value` WHERE `pdID` = `parentProd`.`pd_id` AND `pdcID` = `childProd`.`pd_id` AND `paramID` = ? AND (`attr_value` = ?)), `childProd`.`pd_id`, 0) AS `pd_child_id` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND ((SELECT COUNT(*) FROM `mod_shop_prod_attr_value` AS c WHERE `pdID` = `parentProd`.`pd_id` AND (`pdcID` = `childProd`.`pd_id` OR `pdcID` IS NULL OR `pdcID` = 0) AND `paramID` = ? AND (`attr_value` = ?)))  ORDER BY parentProd.`pd_featured` DESC, `pd_order` ASC
Array
(
    [0] => 24
    [1] => Eternity Collection
    [2] => 24
    [3] => Eternity Collection
)
Filters
Close

Refine by Clear All


  • For Him or Her
  • Featured Collections
  • Price
    •  – 

All

Sort by
Display per page
SELECT DISTINCT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price`, IF((SELECT COUNT(*) FROM `mod_shop_prod_attr_value` WHERE `pdID` = `parentProd`.`pd_id` AND `pdcID` = `childProd`.`pd_id` AND `paramID` = ? AND (`attr_value` = ?)), `childProd`.`pd_id`, 0) AS `pd_child_id` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND ((SELECT COUNT(*) FROM `mod_shop_prod_attr_value` AS c WHERE `pdID` = `parentProd`.`pd_id` AND (`pdcID` = `childProd`.`pd_id` OR `pdcID` IS NULL OR `pdcID` = 0) AND `paramID` = ? AND (`attr_value` = ?)))  ORDER BY parentProd.`pd_featured` DESC, `pd_order` ASC
Array
(
    [0] => 24
    [1] => Eternity Collection
    [2] => 24
    [3] => Eternity Collection
)
  • Eternity Infinity Necklace *New for 2019*

    Eternity Infinity Necklace *New for 2019*

    An infinity necklace on a sterling silver chain which is right on trend. Features a stunning diamond inset for extra sparkle.

    £79.00

    View Product
  • Eternity Infinity Drop Pendant *New for 2019*

    Eternity Infinity Drop Pendant *New for 2019*

    Stunning infinity pendant with a sparkling diamond inset.

    £89.00

  • Eternity Twist Pendant

    Eternity Twist Pendant

    This stylish pendant with a double twist has a modern feel which is right on trend. Features a diamond inset for extra sparkle.

    £89.00

  • Eternity Long Pendant

    Eternity Long Pendant

    A long pendant with a slight twist so it gleams from every angle. Features a diamond inset for a little extra sparkle.

    £89.00

  • Eternity Twist Earrings

    Eternity Twist Earrings

    These stylish earrings have a modern feel which is right on trend. Features diamonds inset for extra sparkle.

    £89.00

  • Eternity Long Earrings

    Eternity Long Earrings

    A pair of long earrings with a slight twist so they gleam from every angle. Features diamonds inset for a little extra sparkle.

    £89.00

  • Eternity Roman Numeral 'X' Pendant

    Eternity Roman Numeral 'X' Pendant

    This diamond pendant is in the shape of an X which can be taken to represent either a kiss or the Roman numeral for '10', making it a perfect 10th anniversary gift.

    £79.00

  • Eternity Horizon Cufflinks

    Eternity Horizon Cufflinks

    Luxury cufflinks with a textured 'horizon' finished and stunning diamonds inset. The perfect gift for your 10th wedding anniversary.

    £79.00

South Crofty Collection Wheal Jane Earth Science Park
Baldhu, Truro
Cornwall TR3 6EH

+441872560200

Payments accepted through:

JCB Maestro Mastercard Visa Visa Electron
Free shipping

Shipping:Worldwide