当前位置:楼宇经济 >> 杭州商业地产
select city from [KS_Province] where id in (select parentID from [KS_Province] where replace(City,'市','') in ('杭州'))
Select n.ID,n.Title,c.Folder,n.Changes,n.Fname,n.TitleFontColor,n.TitleFontType,n.city From [KS_Article] as n Left Join [KS_Class] c on n.Tid = c.ID Where n.DelTF=0 and n.Verific=1 and n.Tid in ('20081679187848') and (1=2 or (n.Province = '浙江省' and (n.City is null or n.City='')) or replace(n.City,'市','') in ('杭州')) order by n.AddDate desc
最新文章