query ::select distinct   fldProductId,fldProductTitle,fldShortDescription,fldProductThumbnailImage,fldHTMLFlags,fldAbridgedUnabridgedFlag from TBL_Product_Master where fldPublishFlag=1 and fldLearnSectionFlag!=1 and fldSoundstrueFlag!=1 and  fldKidsSectionFlag!=1  and fldProductId in()  order by  fldRelevanceCount DESC  , fldProductTitle1 ASC