SELECT * FROM cutcode WHERE 1 = 1 ORDER BY CutCodeID ASC SELECT * FROM claritycode WHERE 1 = 1 ORDER BY ClarityCodeID ASC SELECT stonedetails.StoneID, stonedetails.Company, stonedetails.Price, stone_price.SellPrice FROM stonedetails, stone_price WHERE stonedetails.Shape IN ('BR','PR','EM','AS','MQ','OV','RA','PS','HS','CU','BA','FA','SQEC','Tril') AND stonedetails.IsActive = 'Y' AND stonedetails.StoneID = stone_price.StoneID AND stonedetails.CaratWeight BETWEEN 0.1 AND 15 AND stonedetails.DiamondColor IN ('Y') GROUP BY stonedetails.StoneID ORDER BY SellPrice ASC SELECT * FROM stonedetails WHERE StoneID = 1042 SELECT * FROM stonedetails WHERE StoneID = 382 SELECT * FROM stonedetails WHERE StoneID = 912 SELECT * FROM stonedetails WHERE StoneID = 1028 SELECT * FROM stonedetails WHERE StoneID = 641 SELECT * FROM stonedetails WHERE StoneID = 861 SELECT * FROM stonedetails WHERE StoneID = 1066 SELECT * FROM stonedetails WHERE StoneID = 393 SELECT * FROM stonedetails WHERE StoneID = 1051 SELECT * FROM stonedetails WHERE StoneID = 630 SELECT * FROM stonedetails WHERE StoneID = 1037 SELECT * FROM stonedetails WHERE StoneID = 876 SELECT * FROM stonedetails WHERE StoneID = 1110 SELECT * FROM stonedetails WHERE StoneID = 1061 SELECT * FROM stonedetails WHERE StoneID = 548 SELECT * FROM stonedetails WHERE StoneID = 162 SELECT * FROM stonedetails WHERE StoneID = 381 SELECT * FROM stonedetails WHERE StoneID = 1030 SELECT * FROM stonedetails WHERE StoneID = 378 SELECT * FROM stonedetails WHERE StoneID = 1067
Natural Fancy Colored Diamonds with Different Shapes