上海站　北京站　南京站 | ENGLISH 日本語
欢迎光临浙江锦旅 服务电话:0571-87131300 87131399 服务时间：9:00-17:00
出境旅游： 澳新美加　| 东南亚　| 日韩游　| 欧洲游　| 港澳游　| 中东非洲
线路列表
   
select * from hw_xl where xlmc<>''and Exists(select * from hw_td where hw_td.xl=hw_xl.dm and th<>'' and ys=1 and th not like '%zz' and bm<>'yscrj' and qcts<>0 and wdjhrs<>0 and wdjhrs<>wdsprs and bj1<>0 and cfrq>GETDATE() and th not like '%wd%' and ((priceinclude is not null) or (pricememo is not null) or (tdfeature is not null) or (tdmemo is not null)) ) and xlmc not like '%订房%' and xlmc not like '%签%' order by qcts desc