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 = '17209'
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 = '17209'
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 = '17208'
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 = '17208'
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 = '17207'
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 = '17207'
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 = '17206'
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 = '17206'
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 = '16264'
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 = '16264'
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 = '16263'
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 = '16263'
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 = '15880'
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 = '15880'
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 = '15878'
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 = '15878'
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 = '15874'
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 = '15874'
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 = '15683'
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 = '15683'
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 = '15681'
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 = '15681'
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 = '15680'
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 = '15680'
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 = '15679'
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 = '15679'
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 = '15537'
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 = '15537'
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 = '15533'
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 = '15533'
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 = '15532'
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 = '15532'
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 = '15531'
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 = '15531'
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 = '15526'
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 = '15526'
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 = '15524'
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 = '15524'
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 = '15523'
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 = '15523'
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 = '15266'
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 = '15266'
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 = '15265'
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 = '15265'
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 = '14576'
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 = '14576'
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 = '14562'
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 = '14562'
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
Pear Shaped Engagement Rings | Teardrop Engagement Rings UK | Diamonds Factory
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!
Pear-shaped engagement rings bring a touch of romance and uniqueness to your proposal. With their teardrop silhouette and radiant sparkle, they symbolise both elegance and heartfelt emotion. Set in your choice of gold, platinum or silver and fully customisable through our design service, each pear-shaped engagement ring is made to stand out.
Browse our inclusive collection and find something exceptional, whatever your budget. With flexible finance options and a wide choice of styles, it’s easy to discover the ring that reflects both your love story and your lifestyle.
Often referred to as a teardrop diamond ring, a pear-shaped engagement ring features a pointed tip at one end and a more rounded edge at the other. It offers a contemporary look and is often referred to as a vintage-style ring. If you’re searching for a unique shape that exudes style and elegance, a pear-shaped engagement ring makes your proposal extra memorable.
How can I customise my pear-shaped engagement ring?
Pick your stone type: You have flexibility over the type of centre stone with natural diamonds, lab-grown diamonds, moissanite or even coloured diamonds, letting you match both your style and budget preferences.
Define your setting: From solitaires and side-stone styles to halos, three-stone rings, vintage and bridal sets, you can choose a setting that reflects your personality and enhances the pear shape.
Set your price range: Work within your budget by filtering price brackets. If you’re looking to spread the cost, we offer flexible payment options and interest-free finance too, making your big purchase that little bit easier.
"If you’ve got a unique vision or are starting from scratch, Diamonds Factory’s customised design service helps you create a one-of-a-kind pear-shaped diamond engagement ring. Share your ideas, and we’ll help bring them to life with expert guidance at every stage – from choosing your preferred diamond and setting style to selecting the perfect metal finish."
Learn more about diamond cut, clarity, colour, carat and shape with our Diamond Guide.
Contact us about pear-shaped engagement rings
Shop our full range of luxurious pear diamond engagement rings online now or book an appointment and visit us in-store for a face-to-face consultation to discuss your dream ring. You can also call us on 020 7138 3672.
Said to symbolise individuality and uniqueness, a pear shaped engagement ring mimics the shape of a tear, which is also said to symbolise tears of joy associated with love and marriage.
Traditionally speaking, when wearing a pear shaped engagement ring it's most commonly known to wear it so the point of the pear is worn facing upwards towards your fingertip.
Yes, over the years pear shaped engagement rings have grown in popularity massively. Full of character, they offer unique proportions different to the standard round or princess shape diamond.
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.
