Jewellery | gemstone, aquamarine,diamond,emerald,pearl,yellow sapphire,tanzanite, birthstone, september,february, shape, marquise,princess,round, colour, blue,brown,pink, metal, platinum, platinum | GemTrove 139

Post Your Comment

Write a Rate


Submit
SELECT * FROM `jewellery_stocks` WHERE `status`=? AND (`p_metal_id` IN (3)) AND `c_st_stoneid` IN (15,592,10,629,33,22) AND ((`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('9',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('9',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('9',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('9',`stone_months`))) OR (`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('2',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('2',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('2',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('2',`stone_months`)))) GROUP BY `p_metal_id`,`j_id`