Get Instant Update On Discounts, Special Sales & New Arrivals
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1002' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1004' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1005' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1006' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1007' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='b9ngeb9somcrgpnm4pdtk9rfk6' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Yes, we can do custom orders for any Semi- Precious stones.
We have our own Lapidary in India.
We can make any custom Semi -Mount in 14K, 18K and Platinum.
Message us for details.
02
Sizing details
+
Our Rings comes in size 6.5.
We can resize all our rings. If Resizing is not possible, we can make a new one in your size.
03
Gift wrapping and packaging
+
All our Rings, Earrings and Pendants comes in a Beautiful perfect box ideal for Gifting Purpose.
If you want to Include a Birthday or Anniversary card, Let us know.
We will be happy to do it.
About Bestingems
Best In Gems, Inc. features a collection of natural gemstones from around the world since March 1999. Our goal is not only to provide gemstones for sale, but also educate and update the buyer about the quality and characteristics of the gemstones. Buying from Best In Gems, Inc. is just not a transaction of gemstones; it is a commitment. Commitment of RELIABILITY, commitment of SERVICE and commitment of DEPENDABILITY.
We do not display or sell any type of artificial, synthetic or simulated gemstones. Our team of qualified workers consistently travel all over the world to find rare and exquisite gemstones. In order to provide the best possible value of money, we buy roughs and get it cut in our Jaipur, India factory, where more than 40 people consistently cut the gemstones round the clock. We not only replace our stones as quickly as we sell but keep on adding more and more stones in order to provide the large variety and options to our customers. We specialize in small custom orders. We at Best In Gems, Inc. do not care about the size of order, but give top priority to each and every request.
Email
614-742-7466
