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 = '17149'
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 = '17149'
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 = '17148'
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 = '17148'
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 = '17146'
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 = '17146'
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 = '17145'
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 = '17145'
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 = '17142'
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 = '17142'
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 = '17141'
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 = '17141'
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 = '17130'
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 = '17130'
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 = '17129'
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 = '17129'
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 = '16547'
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 = '16547'
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 = '16546'
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 = '16546'
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 = '16212'
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 = '16212'
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 = '16211'
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 = '16211'
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 = '16210'
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 = '16210'
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 = '16209'
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 = '16209'
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 = '16206'
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 = '16206'
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 = '16205'
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 = '16205'
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 = '16187'
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 = '16187'
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 = '16186'
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 = '16186'
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 = '16182'
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 = '16182'
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 = '16181'
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 = '16181'
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 = '16176'
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 = '16176'
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 = '16175'
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 = '16175'
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 = '16173'
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 = '16173'
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 = '16172'
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 = '16172'
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 Ruby Gemstone Rings Engagement 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!
Symbolising love, passion and success, a ruby ring or jewellery piece is the perfect choice if you’re looking for a gemstone rich in colour, vibrance and history too. From regal ruby engagement rings to pendant necklaces and earrings too. Shop our full range of Ruby jewellery pieces online today.
When it comes to gemstones that capture passion, power, and elegance, rubies reign supreme. Known for its deep, fiery red hue, the ruby stone has been cherished throughout history as a symbol of love, strength, and vitality. At Diamonds Factory, we offer a stunning collection of ruby gemstone jewellery that radiates luxury and timeless beauty. Whether you're looking for a bold ruby ring, a pair of statement earrings, or a sophisticated pendant, our offering has something for everyone. The gemstone’s vibrant colour pairs effortlessly with a range of metals, including white gold, yellow gold, and platinum, allowing you to create a piece that complements your style best. If you’re looking for something truly unique, why not explore our custom jewellery options, where you can design a one-of-a-kind piece? The options are endless. Browse our collection online or visit us in-store today.
Absolutely! Ruby makes for the perfect engagement ring choice. With its rich red colouring, rubies are often said to symbolise all things love and romance but they also boast incredible durability too. Rating a 9 on the MoHs hardness scale too, if your partner loves the colour red then a ruby engagement ring is definitely the way to go.
Yes, Ruby is one of the four stones that are considered precious stones, alongside diamond, sapphire and emerald. Precious stones are considered the most distinct and luxurious of them all, and can be distinguished by their rarity, rich and vibrant colouring and their grade quality.
Rubies are said to symbolise many things, with a popular symbolism being passion thanks to its rich red colouring. Whilst it's also a known gemstone of romance, you may have noticed that rubies are often worn by royalty too, so it comes to no surprise that rubies are said to represent power, strength and wealth. If you're looking for a piece of jewellery that boasts meaning, rubies really are the way to go.
Rubies are perfect for wearing every day. Rating a high 9 on the MoHs hardness scale, their durability comes just under diamonds meaning they're hardwearing and incredibly resilient to damage.
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.
