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 = '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 = '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 = '13402'
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 = '13402'
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 = '13399'
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 = '13399'
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 = '13349'
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 = '13349'
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 = '13348'
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 = '13348'
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 = '13347'
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 = '13347'
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 = '13345'
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 = '13345'
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 = '13344'
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 = '13344'
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 = '11992'
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 = '11992'
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 = '11991'
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 = '11991'
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 = '11990'
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 = '11990'
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 = '11989'
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 = '11989'
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 = '11987'
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 = '11987'
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 = '11986'
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 = '11986'
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 = '11985'
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 = '11985'
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 = '11983'
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 = '11983'
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 = '11982'
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 = '11982'
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 = '10848'
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 = '10848'
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 = '10847'
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 = '10847'
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 = '10845'
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 = '10845'
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 = '471'
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 = '471'
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
Buy Emerald Classic Solitaire Engagement Rings in 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!
A solitaire diamond stands solitary on the ring’s band, gorgeous enough to spread its sparkling flair and glorify the entire ring by itself. The dazzling rock steals the show by making an iconic statement with its sheer simplicity and allure. The solitaire engagement ring lives up to the quote, ‘Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away’.
Diamonds Factory Emerald Classic Solitaire Engagement Ring is a contemporary design that gives a trendy twist to the round classic solitaire ring with its glamorous emerald cut diamond. The ostentatious emerald cut solitaire is an outstanding jewel to present as an engagement ring.
Emerald Classic Solitaire Engagement Rings can be paired with the emerald-cut Solitaire Pendant to complete and beautify your look. Their matching emerald cut solitaires bring an even and pleasing consistency to your outfit.
With Diamonds Factory proficient craftsmanship, commitment to superior quality, and superb value offerings, you can be assured of the worth and quality of every single 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.
