›  › 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] => Kerenza Collection
    [2] => 24
    [3] => Kerenza 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] => Kerenza Collection
    [2] => 24
    [3] => Kerenza Collection
)
  • Kerenza Chunky Hammered Cufflinks

    Kerenza Chunky Hammered Cufflinks

    Chunky round cufflinks with a hammered finish. One of our most popular designs.

    £45.00

  • Kerenza Charm Bracelet - Heart

    Kerenza Charm Bracelet - Heart

    A silver link bracelet with five tin heart charms, each textured and polished to a high finish.

    £29.00

  • Kerenza Triple Disc Pendant

    Kerenza Triple Disc Pendant

    An eye-catching triple disc pendant from our Kerenza Collection. Each disc is individually textured for contrast.

    £39.00

  • Kerenza Triple Disc Earrings

    Kerenza Triple Disc Earrings

    A pair of eye-catching triple disc earrings from our Kerenza Collection. Each disc is individually textured for contrast.

    £39.00

  • Kerenza Domed Heart Pendant

    Kerenza Domed Heart Pendant

    Beautiful domed heart pendant with a textured, highly polished finish.

    £39.00

  • Kerenza Domed Heart Earrings

    Kerenza Domed Heart Earrings

    Beautiful domed heart earrings with a stunning textured and highly-polished finish.

    £39.00

  • Kerenza Double Heart Pendant

    Kerenza Double Heart Pendant

    An eye-catching double heart pendant from our Kerenza Collection. Each heart is individually textured for contrast.

    £35.00

  • Kerenza Heart Pendant

    Kerenza Heart Pendant

    Heart pendant with a modern textured finish that catches the eye.

    £35.00

  • Kerenza Heart Earrings

    Kerenza Heart Earrings

    Beautiful textured heart drop earrings made from rolled tin polished to a high finish.

    £35.00

  • Kerenza Heart Stud Earrings

    Kerenza Heart Stud Earrings

    Delicate stud earrings with a textured finish that really catches the light.

    £25.00

  • Kerenza Star Stud Earrings

    Kerenza Star Stud Earrings

    Delicate stud earrings with a textured finish that really catches the light.

    £25.00

  • Kerenza Disc Drop Earrings

    Kerenza Disc Drop Earrings

    A pair of delicate disc earrings from our Kerenza Collection.

    £25.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