select distinct fldProductId from TBL_Product_Category_Detail where fldCatSubCatId in() and fldcatSubCatId<>0 and fldcatSubCatFlag=1