select a.branchCode,a.categoryID,b.categoryTitle, b.categoryTitleEng from HM_T_BRANCH_CATEGORY as a join HM_T_CATEGORY as b on a.categoryID=b.caID where a.siteID='DAYBEAU' and a.branchCode='B9747715' and a.categoryID='20'