SELECT fldKidsAgeFlag,TBL_Product_Master.fldProductId,fldAvgRating as average,fldRatingCount as ratecount, TBL_Product_Master.fldProductTitle,TBL_Product_Master.fldShortDescription,TBL_Product_Master.fldProductThumbnailImage,fldHTMLFlags,fldAbridgedUnabridgedFlag,fldKidsSectionFlag from TBL_Product_Master where TBL_Product_Master.fldProductId IN (0,) and TBL_Product_Master.fldPublishFlag=1 and TBL_Product_Master.fldSoundstrueFlag!=1 and fldKidsSectionFlag!=0 and fldKidsAgeFlag IN(1,4,5,7) order by average desc ,ratecount desc,TBL_Product_Master.fldProductTitle1 asc