Jewellery | birthstone, june,september,july, gender, unisex,female, metal, 9karat rose gold, 9karat_rose_gold | GemTrove 139
0 0 0

Post Your Comment

Write a Rate


Submit
×

SELECT * FROM `jewellery_stocks` WHERE `status`=? AND (`p_metal_id` IN (16)) AND ((`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('6',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('6',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('6',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('6',`stone_months`))) OR (`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('7',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('7',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('7',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('7',`stone_months`)))) AND `gender` IN (3,2) GROUP BY `p_metal_id`,`j_id`