product_option_query:\n
SELECT *
FROM nj_product_option po
INNER JOIN `nj_option` o ON (po.option_id = o.option_id)
INNER JOIN nj_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '13478'
AND od.language_id = '2'
AND (o.display = '' OR FIND_IN_SET (1, o.display))
ORDER BY o.sort_order
product_option_value_query:\n
SELECT ov.*, ovd.*, pov.*, pov.default AS defaulter, pov.minimum AS minimumer
FROM nj_product_option_value pov
INNER JOIN nj_option_value ov ON (pov.option_value_id = ov.option_value_id)
INNER JOIN nj_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '13478'
AND ovd.language_id = '2'
AND (ov.display = '' OR FIND_IN_SET (1, ov.display))
ORDER BY ov.sort_order
product_option_query:\n
SELECT *
FROM nj_product_option po
INNER JOIN `nj_option` o ON (po.option_id = o.option_id)
INNER JOIN nj_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '4541'
AND od.language_id = '2'
AND (o.display = '' OR FIND_IN_SET (1, o.display))
ORDER BY o.sort_order
product_option_value_query:\n
SELECT ov.*, ovd.*, pov.*, pov.default AS defaulter, pov.minimum AS minimumer
FROM nj_product_option_value pov
INNER JOIN nj_option_value ov ON (pov.option_value_id = ov.option_value_id)
INNER JOIN nj_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '4541'
AND ovd.language_id = '2'
AND (ov.display = '' OR FIND_IN_SET (1, ov.display))
ORDER BY ov.sort_order
product_option_query:\n
SELECT *
FROM nj_product_option po
INNER JOIN `nj_option` o ON (po.option_id = o.option_id)
INNER JOIN nj_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '4731'
AND od.language_id = '2'
AND (o.display = '' OR FIND_IN_SET (1, o.display))
ORDER BY o.sort_order
product_option_value_query:\n
SELECT ov.*, ovd.*, pov.*, pov.default AS defaulter, pov.minimum AS minimumer
FROM nj_product_option_value pov
INNER JOIN nj_option_value ov ON (pov.option_value_id = ov.option_value_id)
INNER JOIN nj_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '4731'
AND ovd.language_id = '2'
AND (ov.display = '' OR FIND_IN_SET (1, ov.display))
ORDER BY ov.sort_order
product_option_query:\n
SELECT *
FROM nj_product_option po
INNER JOIN `nj_option` o ON (po.option_id = o.option_id)
INNER JOIN nj_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '9368'
AND od.language_id = '2'
AND (o.display = '' OR FIND_IN_SET (1, o.display))
ORDER BY o.sort_order
product_option_value_query:\n
SELECT ov.*, ovd.*, pov.*, pov.default AS defaulter, pov.minimum AS minimumer
FROM nj_product_option_value pov
INNER JOIN nj_option_value ov ON (pov.option_value_id = ov.option_value_id)
INNER JOIN nj_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '9368'
AND ovd.language_id = '2'
AND (ov.display = '' OR FIND_IN_SET (1, ov.display))
ORDER BY ov.sort_order
SELECT DISTINCT *, p.multistone as product_multistone, p2s.price as price_default, pt.name as category, p.price as setting_price, p.default_weight as default_metal_weight, p.manufacturer_id as mfg_id, pd.name AS name,pd.keyword as keyword, pd.product_image_view,pc.category_id as category_id FROM nj_product p LEFT JOIN nj_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN nj_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN nj_design_description pt ON (p.design_id = pt.design_id)
LEFT JOIN nj_product_to_category pc on (p.product_id= pc.product_id) WHERE p.product_id = '12757' AND pd.language_id = '2' AND p.date_available <= NOW() AND pt.language_id = '2' AND p2s.store_id = '1' AND p.status = '1' group by pt.language_id
SELECT DISTINCT *, p.multistone as product_multistone, p2s.price as price_default, pt.name as category, p.price as setting_price, p.default_weight as default_metal_weight, p.manufacturer_id as mfg_id, pd.name AS name,pd.keyword as keyword, pd.product_image_view,pc.category_id as category_id FROM nj_product p LEFT JOIN nj_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN nj_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN nj_design_description pt ON (p.design_id = pt.design_id)
LEFT JOIN nj_product_to_category pc on (p.product_id= pc.product_id) WHERE p.product_id = '12748' AND pd.language_id = '2' AND p.date_available <= NOW() AND pt.language_id = '2' AND p2s.store_id = '1' AND p.status = '1' group by pt.language_id
SELECT DISTINCT *, p.multistone as product_multistone, p2s.price as price_default, pt.name as category, p.price as setting_price, p.default_weight as default_metal_weight, p.manufacturer_id as mfg_id, pd.name AS name,pd.keyword as keyword, pd.product_image_view,pc.category_id as category_id FROM nj_product p LEFT JOIN nj_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN nj_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN nj_design_description pt ON (p.design_id = pt.design_id)
LEFT JOIN nj_product_to_category pc on (p.product_id= pc.product_id) WHERE p.product_id = '12749' AND pd.language_id = '2' AND p.date_available <= NOW() AND pt.language_id = '2' AND p2s.store_id = '1' AND p.status = '1' group by pt.language_id
SELECT DISTINCT *, p.multistone as product_multistone, p2s.price as price_default, pt.name as category, p.price as setting_price, p.default_weight as default_metal_weight, p.manufacturer_id as mfg_id, pd.name AS name,pd.keyword as keyword, pd.product_image_view,pc.category_id as category_id FROM nj_product p LEFT JOIN nj_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN nj_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN nj_design_description pt ON (p.design_id = pt.design_id)
LEFT JOIN nj_product_to_category pc on (p.product_id= pc.product_id) WHERE p.product_id = '12756' AND pd.language_id = '2' AND p.date_available <= NOW() AND pt.language_id = '2' AND p2s.store_id = '1' AND p.status = '1' group by pt.language_id
SELECT DISTINCT *, p.multistone as product_multistone, p2s.price as price_default, pt.name as category, p.price as setting_price, p.default_weight as default_metal_weight, p.manufacturer_id as mfg_id, pd.name AS name,pd.keyword as keyword, pd.product_image_view,pc.category_id as category_id FROM nj_product p LEFT JOIN nj_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN nj_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN nj_design_description pt ON (p.design_id = pt.design_id)
LEFT JOIN nj_product_to_category pc on (p.product_id= pc.product_id) WHERE p.product_id = '12760' AND pd.language_id = '2' AND p.date_available <= NOW() AND pt.language_id = '2' AND p2s.store_id = '1' AND p.status = '1' group by pt.language_id
Unique Diamond Earrings | Diamonds Factory UK
Pay with Klarna – Flexible Payment Options, Just for You!
We’ve teamed up with Klarna to provide flexible payment options, allowing you to shop the way you want. With Klarna, you can split your payment into 3 instalments or choose to pay later, making your shopping experience smoother and more convenient. Your order total must be between £100 and £499 to qualify.
Why Choose Klarna?
Flexible Payments: Pay in easy instalments that suit your budget.
Interest-Free: No interest if you pay on time.
Secure Transactions: Klarna uses industry-leading security to protect your data.
Fast & Simple: Quick approval process with no extra hassle.
How It Works:
Select Klarna at Checkout: When you’re ready to complete your purchase, choose Klarna as your payment method.
Choose Your Payment Plan: Klarna offers multiple ways to pay, whether you prefer to pay in 30 days or split your payments into instalments.
Complete Your Purchase: Klarna will guide you through the rest—no extra forms or paperwork!
Pay with Klarna – Flexible Payment Options, Just for You!
We’ve teamed up with Klarna to provide flexible payment options, allowing you to shop the way you want. With Klarna, you can split your payment into 3 instalments or choose to pay later, making your shopping experience smoother and more convenient. Your order total must be between £100 and £499 to qualify.
Why Choose Klarna?
Flexible Payments: Pay in easy instalments that suit your budget.
Interest-Free: No interest if you pay on time.
Secure Transactions: Klarna uses industry-leading security to protect your data.
Fast & Simple: Quick approval process with no extra hassle.
How It Works:
Select Klarna at Checkout: When you’re ready to complete your purchase, choose Klarna as your payment method.
Choose Your Payment Plan: Klarna offers multiple ways to pay, whether you prefer to pay in 30 days or split your payments into instalments.
Complete Your Purchase: Klarna will guide you through the rest—no extra forms or paperwork!
Perfect for those looking to stand out, our mixed-shape diamond earrings are a fusion of classic elegance and modern design. Featuring an array of different shapes and beautifully cut diamonds, Diamonds Factory’s wide selection of unique diamond earrings is designed to catch the eye. Available in a range of polished metals, from platinum to yellow gold and more, each pair offers a versatile yet distinct addition to your style.ed Shapes
Discover the captivating beauty of mix shaped diamond earrings at Diamonds Factory. Combining various shapes — think round, princess, pear, marquise, and more — to create a striking and unique design that stands out from traditional styles, each pair comes in your choice of polished metal, from platinum and silver to white, rose and yellow gold. Perfect for those who appreciate bold, unconventional elegance, mixed-shape diamond earrings offer a dynamic interplay of light that enhances their brilliance. Explore our collection and find a truly unique pair to reflect your individual flair.
Education
*individually for Diamond Earrings
How To Clean Your Diamond Earrings At Home In 5 Easy Steps
It is law within the UK that every item of precious metal sold such as Platinum, Gold, Silver is stamped labelling the item with the type of metal it is. Platinum pieces which weigh less than 0.5 grams, 18ct Gold and Palladium pieces weighing less than 1.0 gram and Silver pieces weighing less than 7.78 grams are except from hallmark.
At Diamonds Factory all our products are hallmarked as per UK hallmarking law from London Assay Office (The GoldSmith Company)
Where Hallmarking Began
The Goldsmiths' Company Assay Office is the oldest assay office in the United Kingdom. It has provided hallmarking services since The Goldsmiths' Company was founded in the 1300s. The company received its royal charter in 1327 and ranks 5th in order of precedence of the 12 Great Livery Companies of the City of London.
Hallmarking dates back to the 1300s when Edward I of England passed a law requiring any item made of silver, which was offered for sale, to be at least of equal quality as that of the coin of the realm (silver currency). The wardens of The Goldsmiths' Company were tasked with visiting workshops in the City of London to assay (test) silver articles. If these articles were found to be below standard they were originally destroyed and the metal forfeited to the King. If they passed, each article received the King's mark of authentication - the mark of a leopard's head. By 1478, there were several hundred workshops and merchants manufacturing silver articles in the City of London. It was not possible for the wardens to visit them all so the merchants were ordered to bring their items to Goldsmiths' Hall for testing and marking and a permanent Assay Office was established in the building. This is the origin of the term hallmark - struck with the King's mark at Goldsmiths' Hall.
In 1544 the Goldsmith's Company adopted the King's mark as their town mark and the mark of the leopard's head is now internationally recognised as the mark of this assay office.
Today
The Goldsmiths's Company Assay Office is still based at Goldsmiths's Hall and remains the oldest company in Britain to be continually trading from the same site. However, it also has two satellite offices; at Greville Street in Hatton Garden in the heart of the London jewellery quarter and within a high security complex near London's Heathrow airport. It now has a new off-site facility within the Dalston-based jewellery manufacturer, Allied Gold. This is the first time in the Assay Office's 700 year history that it has opened permanent hallmarking services on a customer's premises.
In addition to hallmarking, the office has now expanded its range of services to support the jewellery trade and enforcement authorities. It offers a variety of specialist analytical services including nickel, lead & cadmium testing, antique silver dating, non-destructive compositional analysis, plating thickness measurement and a melt and assay service for scrap precious metal carried out in their fully independent on-site laboratory. Other services offered are a jewellery valuation service, laser marking, trading standards assistance, high quality photography and a comprehensive range of training and educational seminars, lectures and specialist events.
