Jewellery

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('1',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('1',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('1',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('1',`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`))) OR (`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('11',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('11',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('11',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('11',`stone_months`))) OR (`c_st_stoneid` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('8',`stone_months`)) OR `stone_1` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('8',`stone_months`)) OR `stone_2` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('8',`stone_months`)) OR `stone_3` IN (SELECT `id` FROM `stone` WHERE FIND_IN_SET('8',`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('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`)))) AND `gender` IN (2) GROUP BY `p_metal_id`,`j_id`