苏州至普陀山2日游-苏州吴江到

卖家：苏州青年旅行社股份有限公司

￥620

苏州到西安旅游_西安旅游_苏州

卖家：苏州康辉国旅平江新城营业部

￥2200

6月苏州出发到巴厘岛旅游线路-

卖家：苏州青年旅行社股份有限公司

￥6450

declare @indextable table(id int identity(1,1) primary key,lineid int,flag int); insert into @indextable(lineid,flag) select top 6 t1.id as lineid,1 as flag from [TCB2bTouristBiz].[dbo].[cn_tradeleads_to_tourist] as t1 with (nolock) left join B2bCnMemberSortValue as t2 with (nolock) on(t1.memberid = t2.b2bmemberid and t2.ordertype = 2) left join [17u_net].[dbo].[qyml] as t3 with (nolock) on (t1.memberid=t3.id) where t1.ifvalid=1 and t1.updatetime>'2012-2-26' and t1.TypeOfArea < 4 and t1.PublisherCityId = 226 and t1.subject like '%自由行%' and t2.EndDate > '2012-5-25' order by t1.adddate desc,t1.listorder desc,t2.ordervalue desc,t1.updatetime desc;insert into @indextable(lineid,flag) select top 6 t1.id as lineid,2 as flag from [TCB2bTouristBiz].[dbo].[cn_tradeleads_to_tourist] as t1 with (nolock) where t1.ifvalid=1 and t1.TypeOfArea = 1 and t1.subject like '%自由行%' and t1.PublisherCityId <> 226 order by t1.adddate desc,t1.listorder desc; select top 6 t0.lineid,t0.flag,t1.subject as title,t1.pricelow as msprice,t1.priceforbooking as tcprice, t1.ifNewLineType,t1.relativeScenerys,t2.id as memberid,t2.qymc,t2.sf as province,t2.city,t3.ordervalue from @indextable as t0,[TCB2bTouristBiz].[dbo].[cn_tradeleads_to_tourist] as t1 with (nolock),[17u_net].[dbo].[qyml] as t2 with (nolock) left join B2bCnMemberSortValue as t3 with (nolock) on(t2.id = t3.b2bmemberid and t3.ordertype=2) where t0.lineid=t1.id and t1.memberid=t2.id order by t0.id asc ;--Flat:net/Author:吴振华/For:调取线路/File:\inc_asp\function_travel_service.asp/Fun:getLineByNameAndCity;