select a.gubun, a.skin from english_cmsPdata a inner join english_Master b on(a.gubun = b.gubun) where a.uid = '2601'

select top 1 Gubun,Title,BodyType,LinkPage=isnull(LinkPage,''), auth, flag1, flag2, flag3, flag4,flag5,Remark1,cgnpronum=isnull(cgnpronum,'0'),Contents from english_Master where Gubun like '%' and bodytype > 0 order by left(Gubun,2)*1000000+Menu1*10000+Menu2*100+Menu3, Gubun



select count(*) from english_procount where uid='2601' and wdate='20170627'



Update [english_procount] Set wnum = wnum + 1 Where uid='2601' and wdate='20170627'