Jewellery | birthstone, december,march,may, shape, heart,special,princess,round, material, plain,gemstone, colour, red,black,brown, gemstone, tanzanite, tanzanite | GemTrove 139
0 0 0

Post Your Comment

Write a Rate


Submit
×

SELECT * FROM `jewellery_stocks` WHERE `status`=? AND (`p_id` != 'pmet' AND `c_id` = 'cmet' AND `c_st_id` = 'csto' AND `stone_1` = 's10' AND `stone_2` = 's20' AND `stone_3` = 's30' OR `c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE `id`!='629') ) AND `c_st_stoneid` IN (22) AND ((`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('12',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('12',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('12',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('12',`stone_months`))) OR (`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('3',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('3',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('3',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('3',`stone_months`))) OR (`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('5',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('5',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('5',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('5',`stone_months`)))) GROUP BY `p_metal_id`,`j_id`