11123sdfs
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 = '11123' 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 Array
(
    [product_id] => 11123
    [name] => Prong Setting Pear Emerald Pendent
    [filter] => 7,12,13,14,15,129,489,490,509,510,512,532,579,580,581,582,583,584,588,599
    [dimension] => 2
    [design_id] => 12
    [multistone] => 0
    [default_metal_weight] => 1
    [category_id] => 5
    [category] => Halo Pendant
    [collection] => CLPD04003
    [variant] => PA0002005,PA0002006,PA0000825,PA0002007,PA0002008,PA0002009
    [default_image_view] => PA0000825@PER@1@0
    [product_image_view] => 
    [description] => 
    [meta_title] => Prong Setting Pear Emerald Pendent
    [meta_description] => 
    [meta_keyword] => 
    [tag] => 
    [model] => CLPD4003_EM_01
    [sku] => PA0000825
    [new_arrival] => 0
    [quantity] => 99
    [image] => clpd04003/pa0000825/detail/3d/ww/em1/0001.jpg
    [setting_price] => 0.0000
    [price] => 841.6667
    [price_min] => 461.9048
    [price_max] => 1372.6190
    [price_default] => 480.9524
    [image_information_id] => 0
    [rrp] => 0.75
    [tax_class_id] => 10
    [date_available] => 0000-00-00
    [date_shipping] => 0000-00-00
    [subtract] => 0
    [minimum] => 0
    [sort_order] => 2
    [status] => 1
    [date_added] => 2023-02-06 12:00:04
    [image_stone] => em1
    [date_modified] => 2023-10-06 09:46:54
    [viewed] => 2699
    [offtheshelf] => 0
    [markup] => 100000:0:0
    [markup_product_id] => 20
    [weight] => 1.30000000
    [fixed_price] => 0
    [favourites] => 0
    [diamond_selection] => 0
    [html_block_id] => 84
    [price_group] => 1
    [manufacturer_id] => 1
    [group_id] => 0
    [canonical_id] => 0
    [no_variant] => 
    [design] => 
    [keyword] => prong-setting-pear-emerald-pendent-clpd4003em01
    [categories] => 5,25,87,93,129,578,619,688
    [breadcrumb] => 25_619
    [finishing_id] => 0
    [home_trial] => 0
    [partner_id] => 0
    [metal_code] => 
)

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 = '11123'
    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 = '11123'
    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 = '11123' 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 = '11123' 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 








	
Array
(
    [config_cache_version] => 20240141
    [success] => 
    [country_name] => United Kingdom
    [server_url] => https://uk.diamondsfactory.org/
    [carat_min] => 0.2
    [carat_max] => 30
    [price_min] => 100
    [price_max] => 5000000
    [breadcrumbs] => Array
        (
            [0] => Array
                (
                    [text] => Home
                    [href] => https://uk.diamondsfactory.org/
                )

            [1] => Array
                (
                    [text] => Gemstones
                    [href] => https://uk.diamondsfactory.org/gemstones
                )

            [2] => Array
                (
                    [text] => Pendants
                    [href] => https://uk.diamondsfactory.org/gemstones/gemstones-pendants
                )

            [3] => Array
                (
                    [text] => Prong Setting Pear Emerald Pendent
                    [href] => https://uk.diamondsfactory.org/design/prong-setting-pear-emerald-pendent-clpd4003em01
                )

        )

    [config_email] => service@diamondsfactory.co.uk
    [subcategoryid] => 619
    [comp_in_stock] => 1
    [liveserver] => 0
    [hw] => 0
    [edit_product] => 0
    [tag_no] => 
    [select_size] => 
    [hidden_diamond_code] => 
    [carat_weight] => 
    [wishlisted] => no
    [matching_promo] => yes
    [vimeo_videos_json] => 
    [product_videos_json] => 
    [partner_images] => Array
        (
        )

    [partner_heading_title] => 
    [partner_id] => 0
    [group_id] => 0
    [instock] => no
    [current_div] => customize
    [category_title] => Gemstone
    [breadcrumb_url] => https://uk.diamondsfactory.org/gemstones/gemstones-pendants
    [sub_category] => Pendants
    [show_diamond_sticky] => 0
    [diamond_selection] => 0
    [heading_title] => Prong Setting Pear Emerald Pendent
    [text_minimum] => This product has a minimum quantity of 0
    [product_info] => Array
        (
            [product_id] => 11123
            [name] => Prong Setting Pear Emerald Pendent
            [filter] => 7,12,13,14,15,129,489,490,509,510,512,532,579,580,581,582,583,584,588,599
            [dimension] => 2
            [design_id] => 12
            [multistone] => 0
            [default_metal_weight] => 1
            [category_id] => 5
            [category] => Halo Pendant
            [collection] => CLPD04003
            [variant] => PA0002005,PA0002006,PA0000825,PA0002007,PA0002008,PA0002009
            [default_image_view] => PA0000825@PER@1@0
            [product_image_view] => 
            [description] => 
            [meta_title] => Prong Setting Pear Emerald Pendent
            [meta_description] => 
            [meta_keyword] => 
            [tag] => 
            [model] => CLPD4003_EM_01
            [sku] => PA0000825
            [new_arrival] => 0
            [quantity] => 99
            [image] => clpd04003/pa0000825/detail/3d/ww/em1/0001.jpg
            [setting_price] => 0.0000
            [price] => 841.6667
            [price_min] => 461.9048
            [price_max] => 1372.6190
            [price_default] => 480.9524
            [image_information_id] => 0
            [rrp] => 0.75
            [tax_class_id] => 10
            [date_available] => 0000-00-00
            [date_shipping] => 0000-00-00
            [subtract] => 0
            [minimum] => 0
            [sort_order] => 2
            [status] => 1
            [date_added] => 2023-02-06 12:00:04
            [image_stone] => em1
            [date_modified] => 2023-10-06 09:46:54
            [viewed] => 2699
            [offtheshelf] => 0
            [markup] => 100000:0:0
            [markup_product_id] => 20
            [weight] => 1.30000000
            [fixed_price] => 0
            [favourites] => 0
            [diamond_selection] => 0
            [html_block_id] => 84
            [price_group] => 1
            [manufacturer_id] => 1
            [group_id] => 0
            [canonical_id] => 0
            [no_variant] => 
            [design] => 
            [keyword] => prong-setting-pear-emerald-pendent-clpd4003em01
            [categories] => 5,25,87,93,129,578,619,688
            [breadcrumb] => 25_619
            [finishing_id] => 0
            [home_trial] => 0
            [partner_id] => 0
            [metal_code] => 
        )

    [product_type_id] => 12
    [product_id] => 11123
    [model] => CLPD4003_EM_01
    [viewed] => 2699
    [description] => 
    [image_angle] => 3d
    [image_stone] => em1
    [sku] => PA0000825
    [collection] => clpd04003
    [design_id] => 12
    [serverpath] => https://static.diamondsfactory.org/product_v2/
    [imagedir] => /var/www/dfredesign.diamondsfactory.org/capistrano/shared/image/
    [display_variant] => pa0000825
    [currency_code] => GBP
    [text_introheading] => We believe the below options are the best things to consider and customise when buying a 12.
    [product_currency] => GBP
    [currency_symbol] => £
    [config_language_id] => 2
    [config_store_id] => 1
    [pearl_text] => 
    [stores] => Array
        (
            [0] => United States
            [2] => Germany
            [3] => France
            [4] => Ireland
            [1] => United Kingdom
        )

    [brace_carat] => 
    [brace_style] => 
    [halfeter_carat] => 
    [halfeter_style] => 
    [whatsapp_url] => http://uk.diamondsfactory.org/design/prong-setting-pear-emerald-pendent-clpd4003em01?stone_shape=PER
    [popup] => 
    [thumb] => 
    [price] => £378
    [price_false] => 378
    [offer_price_false] => 365
    [discounted_price] => 274
    [product_price] => 378
    [tax] => £378
    [image_information_id] => 0
    [finance_available_store_id] => 1
    [advanced_options] => Array
        (
            [0] => stone_polish
            [1] => stone_symmetry
            [2] => stone_fluorescence
        )

    [chain_options] => Array
        (
            [0] => chain_type
            [1] => chain_length
        )

    [product_group_info] => Array
        (
        )

    [text_ring_diamond_text] => Pendant & Diamond Details
    [top_category_id] => 5
    [top_breadcrumb_category] => 25
    [product_url] => https://uk.diamondsfactory.org/design/prong-setting-pear-emerald-pendent-clpd4003em01
    [available_url] => 
    [sets_products] => 0
    [set_products_details] => Array
        (
        )

    [moissanite_shape] => 1
    [get_stone_size] => 
    [diamond_code] => 
    [coupon] => 
    [addtocart_data] => {"product_id":"11123","name":"Halo Pendant","model":"CLPD4003_EM_01","category":"Halo Pendant","sku":"PA0000825","currency_code":"GBP","price":387.30774127999996,"coupon":""}
    [custom_fixed_price] => 0
    [get_chain_type] => 
    [get_chain_length] => 
    [options] => Array
        (
            [stone_type] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 771
                                    [default] => 1
                                    [code] => EM
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => Emerald
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/emerald_jpg-28x55.jpg
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/emerald_jpg-28x55.jpg
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 3
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 6
                    [name] => Stone Type
                    [hover_url] => 
                    [description] => 
                    [custom_field] => stone_type
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 1
                    [sort_order] => 0
                )

            [metal_purity] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 3
                                    [default] => 1
                                    [code] => GL_9K_W
                                    [display] => 1,2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 9K White Gold
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/White%20Gold-144x144.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/White%20Gold-144x144.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 2
                                    [default_store] => 0
                                )

                            [1] => Array
                                (
                                    [option_value_id] => 2
                                    [default] => 0
                                    [code] => GL_9K_Y
                                    [display] => 1,2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 9K Yellow Gold
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Yellow%20Gold-144x144.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Yellow%20Gold-144x144.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 3
                                    [default_store] => 0
                                )

                            [2] => Array
                                (
                                    [option_value_id] => 4
                                    [default] => 0
                                    [code] => GL_9K_R
                                    [display] => 1,2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 9K Rose Gold
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Rose%20Gold-144x144.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Rose%20Gold-144x144.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 4
                                    [default_store] => 0
                                )

                            [3] => Array
                                (
                                    [option_value_id] => 15
                                    [default] => 0
                                    [code] => GL_18K_W
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 18K White Gold
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/White%20Gold-144x144.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/White%20Gold-144x144.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 15
                                    [default_store] => 0
                                )

                            [4] => Array
                                (
                                    [option_value_id] => 14
                                    [default] => 0
                                    [code] => GL_18K_Y
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 18K Yellow Gold
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Yellow%20Gold-144x144.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Yellow%20Gold-144x144.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 16
                                    [default_store] => 0
                                )

                            [5] => Array
                                (
                                    [option_value_id] => 16
                                    [default] => 0
                                    [code] => GL_18K_R
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 18K Rose Gold
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Rose%20Gold-144x144.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Rose%20Gold-144x144.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 17
                                    [default_store] => 0
                                )

                            [6] => Array
                                (
                                    [option_value_id] => 31
                                    [default] => 0
                                    [code] => PL_950_W
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => Platinum(950)
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Platinum-144x144.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Platinum-144x144.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 23
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 1
                    [name] => Metal
                    [hover_url] => 
                    [description] => 
                    [custom_field] => metal_purity
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 1
                    [sort_order] => 1
                )

            [stone_shape] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 131
                                    [default] => 1
                                    [code] => PER
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => Pear
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Pear-new-96x96.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/Pear-new-96x96.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 5
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 7
                    [name] => Shape
                    [hover_url] => https://uk.diamondsfactory.org/index.php?route=product/diamond_info&information_id=38
                    [description] => 
                    [custom_field] => stone_shape
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 1
                    [sort_order] => 4
                )

            [stone_quality] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 985
                                    [default] => 1
                                    [code] => A
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => A
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 1
                                    [default_store] => 0
                                )

                            [1] => Array
                                (
                                    [option_value_id] => 986
                                    [default] => 0
                                    [code] => AA
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => AA
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 2
                                    [default_store] => 0
                                )

                            [2] => Array
                                (
                                    [option_value_id] => 987
                                    [default] => 0
                                    [code] => AAA
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => AAA
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 3
                                    [default_store] => 0
                                )

                            [3] => Array
                                (
                                    [option_value_id] => 9674
                                    [default] => 0
                                    [code] => AAAA
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => AAAA
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 4
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 42
                    [name] => Gemstone Quality
                    [hover_url] => 
                    [description] => Gemstone Quality
                    [custom_field] => stone_quality
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 1
                    [sort_order] => 5
                )

            [stone_size] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 919
                                    [default] => 1
                                    [code] => PER-5X3
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 5X3mm
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 1
                                    [default_store] => 0
                                )

                            [1] => Array
                                (
                                    [option_value_id] => 920
                                    [default] => 0
                                    [code] => PER-6X4
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 6X4mm
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 2
                                    [default_store] => 0
                                )

                            [2] => Array
                                (
                                    [option_value_id] => 921
                                    [default] => 0
                                    [code] => PER-7X5
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 7X5mm
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 3
                                    [default_store] => 0
                                )

                            [3] => Array
                                (
                                    [option_value_id] => 912
                                    [default] => 0
                                    [code] => PER-8X6
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 8X6mm
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 4
                                    [default_store] => 0
                                )

                            [4] => Array
                                (
                                    [option_value_id] => 922
                                    [default] => 0
                                    [code] => PER-9X7
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 9X7mm
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 5
                                    [default_store] => 0
                                )

                            [5] => Array
                                (
                                    [option_value_id] => 923
                                    [default] => 0
                                    [code] => PER-10X8
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 10X8mm
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 6
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 35
                    [name] => Stone Size
                    [hover_url] => 
                    [description] => 
                    [custom_field] => stone_size
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 1
                    [sort_order] => 5
                )

            [stone_certificate] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 161
                                    [default] => 1
                                    [code] => DF
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => DF
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/certificate/cert-df-97x134.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/certificate/cert-df-97x134.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 1
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 12
                    [name] => Certificate
                    [hover_url] => https://uk.diamondsfactory.org/index.php?route=product/diamond_info&information_id=37
                    [description] => At Diamonds Factory every product comes with a Diamond Certificate.
                    [custom_field] => stone_certificate
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 1
                    [sort_order] => 10
                )

            [chain_length] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 244
                                    [default] => 1
                                    [code] => 16
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 16 inch
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 1
                                    [default_store] => 0
                                )

                            [1] => Array
                                (
                                    [option_value_id] => 245
                                    [default] => 0
                                    [code] => 18
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => 18 inch
                                    [image] => 
                                    [image_show] => 
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 2
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 16
                    [name] => Chain Length
                    [hover_url] => 
                    [description] => 
                    [custom_field] => chain_length
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 0
                    [sort_order] => 12
                )

            [chain_type] => Array
                (
                    [option_value] => Array
                        (
                            [0] => Array
                                (
                                    [option_value_id] => 763
                                    [default] => 1
                                    [code] => CBL
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => Cable
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/chain_type_2-68x41.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/chain_type_2-68x41.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 0
                                    [default_store] => 0
                                )

                            [1] => Array
                                (
                                    [option_value_id] => 235
                                    [default] => 0
                                    [code] => CRB
                                    [display] => 
                                    [lab_grown] => 0
                                    [lab] => 0
                                    [name] => Curb
                                    [image] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/chain_type_1-68x41.png
                                    [image_show] => https://uk.diamondsfactory.org/image/cache/catalog/product-icons/chain_type_1-68x41.png
                                    [price] => 
                                    [price_prefix] => +
                                    [sort_order] => 3
                                    [default_store] => 0
                                )

                        )

                    [option_id] => 17
                    [name] => Chain Type
                    [hover_url] => 
                    [description] => 
                    [custom_field] => chain_type
                    [display] => 
                    [lab_grown] => 0
                    [type] => select
                    [value] => 
                    [required] => 0
                    [sort_order] => 24
                )

        )

    [stone_size] => 1
    [total_carat_option] => 0
    [stone_type_count] => 1
    [cut_pol_symm] => 
    [pol_symm] => 
    [home_options] => no
    [stone_clarity_default] => 0
    [is_color_stone] => no
    [is_platinum] => 1
    [stone_type_di] => EM
    [default_shape] => per
    [default_clarity] => 
    [default_color] => 
    [image_options] => Array
        (
            [0] => metal_purity
            [1] => head_purity
            [2] => stone_shape
            [3] => thickness
            [4] => width
            [5] => bandwidth
            [6] => chain_type
            [7] => engraving_font
            [8] => band_width
            [9] => band_finish
            [10] => stone_quality
        )

    [diamond_options] => Array
        (
            [0] => diamond
            [1] => stone_type
            [2] => stone_shape
            [3] => stone_carat
            [4] => stone_clarity
            [5] => stone_color
            [6] => stone_cut
            [7] => stone_certificate
            [8] => stone_size
            [9] => size
            [10] => stone_intensity
            [11] => colored_stone_type
        )

    [prod_options] => Array
        (
            [0] => metal_purity
            [1] => ring_size
            [2] => thickness
            [3] => width
            [4] => bandwidth
            [5] => backing
            [6] => length
            [7] => band_width
            [8] => band_finish
            [9] => stone_quality
            [10] => band_profile
        )

    [blnk_img_flag] => 1
    [partner_options] => Array
        (
        )

    [minimum] => 1
    [customer_name] => 
    [metal_code] => ww
    [product_img] => https://static.diamondsfactory.org/product_v2/clpd04003/pa0000825/detail/3d/ww/em1/0001.jpg
    [share] => https://uk.diamondsfactory.org/design/prong-setting-pear-emerald-pendent-clpd4003em01
    [manufacturer_id] => 1
    [html_block_id] => 84
    [manufacturer_code] => NAV
    [finance_method] => v12
    [pay4later_min_loan_value] => 1,000
    [pay4later_max_loan_value] => 25,000
    [payment_pay4later_options] => Array
        (
            [0] => Array
                (
                    [product_id] => 27
                    [custom_name] => Free Finance (6 Months)
                    [tenure] => 6
                    [apr] => 0%
                    [code] => IFF6
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 20
                    [min_loan_value] => 500
                    [max_loan_value] => 25000
                    [default] => 1
                    [sort_order] => 1
                    [status] => 1
                )

            [1] => Array
                (
                    [product_id] => 28
                    [custom_name] => Free Finance (12 Months)
                    [tenure] => 12
                    [apr] => 0%
                    [code] => IFF12
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 20
                    [min_loan_value] => 2000
                    [max_loan_value] => 25000
                    [sort_order] => 2
                    [status] => 1
                )

            [2] => Array
                (
                    [product_id] => 350
                    [custom_name] => Deferred Interest Free Finance (3/12)
                    [tenure] => 12
                    [apr] => 0.0%
                    [code] => DIFF-3/12
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 10
                    [min_loan_value] => 2000
                    [max_loan_value] => 25000
                    [sort_order] => 3
                    [status] => 1
                )

            [3] => Array
                (
                    [product_id] => 162
                    [custom_name] => Classic Credit 12 Months
                    [tenure] => 12
                    [apr] => 9.9%
                    [code] => CC12-9.9
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 20
                    [min_loan_value] => 500
                    [max_loan_value] => 25000
                    [sort_order] => 4
                    [status] => 1
                )

            [4] => Array
                (
                    [product_id] => 54
                    [custom_name] => Classic Credit 24 Months
                    [tenure] => 24
                    [apr] => 9.9%
                    [code] => CC24-9.9
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 20
                    [min_loan_value] => 1000
                    [max_loan_value] => 25000
                    [sort_order] => 5
                    [status] => 1
                )

            [5] => Array
                (
                    [product_id] => 44
                    [custom_name] => Classic Credit 36 Months
                    [tenure] => 36
                    [apr] => 9.9%
                    [code] => CC36-9.9
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 20
                    [min_loan_value] => 1500
                    [max_loan_value] => 25000
                    [sort_order] => 6
                    [status] => 1
                )

            [6] => Array
                (
                    [product_id] => 573
                    [custom_name] => Buy Now Pay Later (6 Months/36) 11.9
                    [tenure] => 36
                    [apr] => 11.9%
                    [code] => BNPL6/36-11.9
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 10
                    [min_loan_value] => 500
                    [max_loan_value] => 25000
                    [sort_order] => 7
                    [status] => 1
                )

            [7] => Array
                (
                    [product_id] => 45
                    [custom_name] => Classic Credit 48 Months
                    [tenure] => 48
                    [apr] => 9.9%
                    [code] => CC48-9.9
                    [deposit_percentage] => 10
                    [deposit_percentage_default] => 20
                    [min_loan_value] => 4000
                    [max_loan_value] => 25000
                    [sort_order] => 8
                    [status] => 1
                )

        )

    [payment_pay4later_option_property_product_name] => Product Name
    [payment_pay4later_option_property_value_of_goods] => Value of Goods
    [payment_pay4later_option_property_percentage_of_deposit] => Percentage of Deposit
    [payment_pay4later_option_property_amount_of_deposit] => Amount of Deposit
    [payment_pay4later_option_property_amount_of_loan] => Amount of Loan
    [payment_pay4later_option_property_term_of_agreement] => Term of Agreement
    [payment_pay4later_option_property_apr] => APR
    [payment_pay4later_option_property_monthly_instalment] => Monthly Instalment
    [payment_pay4later_option_property_loan_repayment] => Loan Repayment
    [payment_pay4later_option_property_total_amount_payable] => Total Amount Payable
    [payment_pay4later_option_property_cost_of_loan] => Cost of Loan
    [payment_pay4later_options_unavailable] => unavailable
    [schema_description] => Shop Prong Setting Pear Emerald Pendent Online UK with 9K White Gold set in Pear Shape  Carat at Diamonds Factory. Price: £365 & EasyReturns.
    [telephone] => 020 7138 3672
    [text_delivery_msg] => . Need it Sooner? Click here
    [text_message] => Please contact a member of our sales team regarding your combination. We would be delighted to help you. Our team can be contacted on 020 7138 3672.
    [text_telephone] => 0207 138 3672
    [lab_grown_modal] => 
  




    [content_top] => 
    [content_bottom] => 


    


        

							

					You May Also Like 
				

			        


        

                    

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£792
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Black Diamond Pendant
                    

                    
4 Prong Setting Halo Black Diamond Pendant

                    

						From
						£793
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£567
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Black Diamond Pendant
                    

                    
4 Prong Setting Halo Black Diamond Pendant

                    

						From
						£509
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£920
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£631
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£961
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£664
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£841
					

                
            


                        

			 

            	                
                    
                
                                
                    

                        4 Prong Setting Halo Pendant
                    

                    
4 Prong Setting Halo Pendant

                    

						From
						£1,067
					

                
            


            			
        
   
			   
    










	
See what customers have to say

  	
 
    	Trustpilot 
  	














    [footer] => 
	
 
	

 














	






		
		
		
		
		
		
		 


		



















			
	










    [header] => 








	
	
	
	
	Prong Setting Pear Emerald Pendent
	
	
	
	
			
			
		
		
	
	
	
	
	
	
		
			
	
		
		
	
	
				
	
	
			
				
		
			
	
	
			
			
			

		
		

	
	
	
	
	


	
	
	
	

	

	
	

	
	

		
	
	
	
	

		
		
	


	
		
		

		

 
	


	
	
	

		
	


		

		

	
	
	
	
	


		
		
		
			
		
	

	
	
	
	
	
		
	
	
		

		
	



				
	
	
		

	

	
	
	
		
	
	
	
	
	
	
		
	

	
	

	
	
	
	

	
	
	
	
	
	

				
	
	
	

	






		

	

	

	

	
	

	

	



		

	


	
	

	



	
		
		

	

	

		

			

				

										
Learn more - 





Learn more about Klarna


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!
    • 






Learn more

									

			

		

	


	
	
	
	

	
	

		

			

				


					
				

			

		

	

	
	
	
	
	
	
	
	
	
	

	
	

	

	

	

	
	
	

	

	


	

	

	
	

	


    [reviews] => 

	

		
		
We've served over 100,000 happy Customers
98% Customer Satisfaction

	






	

			
						
    
			
  • 
					
					 
    Excellent 4.8/5
    
			
    • 
						
  • 
					
					
    Excellent 4.5/5
    
			
    • 
			

				

	






	

					

				

					
					

										
					

						
						
I'm a long time customer for the past 10 years

						
I'm a long time customer for the past 10 years. After an engagement and wedding rings I bought in the past, this latest purchase was a gift for my beautilicious wife. My wife loves them. Nancy from Diamond Factory is a diamond. She was there all the way helping me. She was very patient and extremely understanding. Speedy delivery abroad. I can't wait to get more purchases. I will be back. 
The items are genuine are they're a perfect fit for my beautilicious wife. Thank you Diamond Factory

						
  Christian 

					

										
					

						
						
An absolutely flawless service

						
An absolutely flawless service (pardon the pun) from the Diamonds Factory - James in particularly. I purchased both my wife’s engagement and wedding ring from here - they even made me a bespoke wedding ring using their CAD facilities, as my wife’s engagement ring is a marquee. Cannot recommend this fantastic company enough - excellent.

						
  John Higgins 

					

										
					

						
						
I am so pleased with my second purchase

						
I am so pleased with my second purchase from the Diamonds Factory. I had a ring made, a gift from my Mum, and it arrived just two weeks after the order. The staff at Hatton Garden are so helpful. I was recommended to the Diamonds Factory by my Nephew and after two visits that have resulted in excellent purchases, I would certainly recommend to others.

						
  SUE S. 

					

									


			

			
												

			

				
			

		

		

		VIEW MORE REVIEWS
		

    [finishing_id] => 0
    [newimage] => 0
    [cat_ids] => 
    [product_category_id] => 619
    [text_blackfridaysale] => January Sale | Use Code FLASH55 TO GET A FURTHER 55% OFF!
    [text_blackfridaysale_nz] => text_blackfridaysale_nz
    [text_blackfridaysalemob] => January Sale | Use Code FLASH55 TO GET A FURTHER 55% OFF!
    [text_blackfridaysalemob_nz] => text_blackfridaysalemob_nz
    [text_blackfriday_promo] => 
Receive a Free Jewellery Care Plan with Purchases Over £1,500*

    [text_blackfriday_promo2] => 
    [text_buyxgety_description] => 
    [text_september_sale] => January Sale Price
    [instock_gift_sets] => 0
    [manufacturer_name] => 
    [mfg] => 0
    [show_hand] => 0
    [sidestyle] => 0
    [gems_option_array] => Array
        (
            [0] => Array
                (
                    [code] => A
                    [head] => Good (A)
                    [para] => Entry-level quality for fine jewellery. A medium green emerald where light doesn’t pass through the gemstone
                )

            [1] => Array
                (
                    [code] => AA
                    [head] => Better (AA)
                    [para] => Most popular quality, as seen in most independent stores. A medium green emerald with moderate inclusions that are visible to the naked eye
                )

            [2] => Array
                (
                    [code] => AAA
                    [head] => Best (AAA)
                    [para] => Very high quality, as seen in top jewellery stores.A medium to rich green emerald with moderate inclusions and high brilliance. (Inclusions are very natural for all emeralds and those without any indicates the gemstone is fake.)
                )

            [3] => Array
                (
                    [code] => AAAA
                    [head] => Heirloom (AAAA)
                    [para] => Among the best quality available in the world. A rich green emerald with a small number of inclusions and incredible brilliance in both daylight and artificial light. (Inclusions are very natural for all emeralds and those without any indicates the gemstone is fake.)
                )

        )

    [is_colored_diamond] => no
    [is_colored_diamond_cdi_default] => 
    [user_logged_in] => no
    [xmas_delivery_banner_message] => NEED IT FOR CHRISTMAS, CALL US ON 0207 1383 672. 
 FOR QUICK DELIVERY ITEMS SHOP NOW 
 • RETURNS EXTENDED UNTIL 1ST FEB 2025 •
    [best_cat_name] => best_cat_name_5
    [min_carat_code] => 
    [min_carat_name] => 
    [carat_skip] => 
    [is_charm_product] => no
)