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 = '17197'
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 = '17197'
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 = '17196'
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 = '17196'
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 = '17193'
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 = '17193'
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 = '17192'
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 = '17192'
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 = '17189'
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 = '17189'
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 = '17188'
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 = '17188'
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 = '16776'
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 = '16776'
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 = '16775'
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 = '16775'
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 = '16774'
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 = '16774'
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 = '16773'
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 = '16773'
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 = '16772'
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 = '16772'
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 = '16771'
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 = '16771'
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 = '16770'
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 = '16770'
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 = '16769'
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 = '16769'
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 = '16768'
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 = '16768'
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 = '16767'
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 = '16767'
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 = '16766'
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 = '16766'
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 = '16765'
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 = '16765'
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 = '16764'
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 = '16764'
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 = '16763'
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 = '16763'
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 = '16762'
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 = '16762'
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 = '16761'
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 = '16761'
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 = '16760'
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 = '16760'
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 = '16759'
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 = '16759'
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
Yellow Diamond Bracelets | 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!
Our yellow diamond bracelets are the perfect way to add a touch of brilliance to your everyday style or occasion wear. With their radiant hue and timeless sparkle, yellow diamonds are a symbol of optimism, warmth, and elegance. Diamonds Factory’s collection of yellow diamond bracelets offers a variety of designs, each crafted in high-quality metals such as white, yellow, and rose gold, as well as platinum and silver. Whether you're gifting a loved one or treating yourself to something special, explore our selection of yellow diamond bracelets online or in-store today.
What better way to add a burst of colour and luxury to your jewellery collection than with a yellow diamond bracelet? Here at Diamonds Factory, we’ve carefully curated a selection of yellow diamond bracelets that effortlessly blend the sparkle of diamonds with the warm, radiant hue. Whether you're looking for a delicate tennis bracelet or a bold bangle, our collection offers a variety of styles designed to suit every taste and occasion. Choose from white gold, yellow gold, rose gold, platinum, or silver to pair with your beautiful stone. Our yellow diamond bracelets make the perfect gift for someone special or a well-deserved treat to yourself. Browse our stunning selection online or visit us in-store today to discover the yellow diamond bracelet of your dreams.
Thanks to their desirable vibrant colouring, yellow diamond bracelets are a unique piece of jewellery that are sure to hold their value. It's important to note, the value of jewellery depends on many factors and is always subject to change.
Generally speaking, we always recommend not sleeping with any jewellery on. This is because when you sleep, your jewellery could catch on something or get damaged whilst you sleep.
Here at Diamonds Factory, we make shopping for jewellery easy by offering step by step options for you to choose from when designing your jewellery piece. When purchasing a yellow diamond bracelet, you'll see options available like metal type, shape and carat. The choice is then completely up to you, your taste and your budget.
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.
