may-december-july-september - Birthstone Jewelleries

SELECT * FROM `jewellery_stocks` WHERE `status`=? AND (`p_metal_id` IN (6)) AND `c_st_stoneid` IN (10,22,33,592) AND ((`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('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('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`))) 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`