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

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 '0307%' and bodytype > 0 order by left(Gubun,2)*1000000+Menu1*10000+Menu2*100+Menu3, Gubun

Select num From english_count Where [date] = '20170821' and countid = '00'

select count(*) from english_procount where uid='2515' and wdate='20170821'



insert into english_procount(uid,wdate) values('2515','20170821')