select top 1 Topic,Url,ImgPath from likefar_HomeCommend where TypeID=1 and ImgPath<>'' Order by commendID desc

	欢迎访问远方自助游！

远方有多远？远方只是心灵到脚步间的一段旅程。当心灵沉淀进脚印的时候，远方就不再遥远。在远方网，你可以获知大量有价值的去处，可以结交一帮喜欢自助出游的朋友。跟读书一样认真地行路，如行路一样自由地生活…… ·网站地图　·新手指南　·联系我们

	推荐攻略		select top 1 formobjectlist from class where id = 13 #trim(listgetat(NatureList,i,chr(13)))#	欢迎投稿

select top 8 id,classid,subject,content,createdon,pic,hits,(select count(*) from articleComment where articlecomment.articlebasicid=articlebasic.id) as cid from articleBasic where ispublish = 1 and iscommend = 1 and classid = 13 order by id desc select top 8 articleBasic.id,articleBasic.classid from articleBasic,articleExtend where articleExtend.cellName = 'sID' and CAST(articleExtend.cellValue AS char(10))='#sID#' and articleExtend.classid = 19 and articleExtend.articlebasicid = articleBasic.id and articleBasic.ispublish = 1

#dateformat(createdon,"yyyy年mm月dd日") # #sID# 阅读：#hits#次评论：#cid#条

摘要：#maxlength(StripHTML(sIntro),100)##maxlength(StripHTML(content),100)# （图文版　简洁版）

更多攻略……

	热门攻略	more

select top 5 id,classid,subject,hits,pic,createdon from articleBasic where classid = 13 and ispublish = 1 order by hits desc

	#fTitle#
	更新：#dateformat(createdon,"yyyy年mm月dd日")# 人气：#hits#

	最近动向	more

select top 6 b.id,b.classid,b.subject from articleBasic as b,articleExtend as e where e.cellName = 'sType' and CAST(e.cellValue AS char(10))='站内公告' and e.classid = 15 and e.articlebasicid = b.id and b.ispublish = 1 order by b.id desc ·#subject##subject#

	即将推出的攻略	more

select top 6 b.id,b.classid,b.subject from articleBasic as b,articleExtend as e where e.cellName = 'sType' and CAST(e.cellValue AS char(10))='攻略预告' and e.classid = 15 and e.articlebasicid = b.id and b.ispublish = 1 order by b.id desc ·#subject##subject#

	行者达人	想做行者？

select top 3 id,subject,createdOn,content,pic,hits,classid from articleBasic where ispublish = 1 and classid = 19 order by id desc select count(*) as cid from articleBasic,articleExtend where articleExtend.cellName = 'sID' and CAST(articleExtend.cellValue AS char(10))='#sID#' and articleExtend.classid = 13 and articleExtend.articlebasicid = articleBasic.id and articleBasic.ispublish = 1

	特邀行者：#subject#
	验证攻略：#qCount.cid#　人气：#hits#

	合作客栈	more

	推荐客栈	more

select top 4 b.subject,b.id,b.classid from articleBasic as b, articleExtend as e where b.ispublish = 1 and b.classid = 14 and e.cellName='innpicad' and b.iscommend = 1 and b.id= e.articleBasicID order by b.id desc select top 12 subject,id,classid,province, (select name from class where id = articleBasic.province) as provinceArea from articleBasic where ispublish = 1 and classid = 14 and iscommend = 1 order by id desc

【#provinceArea#】#subject##subject#	【#provinceArea#】#subject##subject#

	老板故事	more

select top 2 subject,pic,content,id,classid from articleBasic where classid = 18 and ispublish = 1 and iscommend = 1 order by id desc

#subject#
#trim(maxlength(StripHTML(content),40))#

	新加入的客栈	more

select top 6 id,classid,subject from articleBasic where classid = 14 and ispublish = 1 order by id desc ·#fTitle##fTitle# 促销：#innprice#元/天

	接待报告	more

select top 4 subject,id,classid from articleBasic where classid = 17 and ispublish = 1 order by id desc ·#maxlength(subject,22)##maxlength(subject,22)#

	联盟规则	怎样加入？

欢迎各地客栈加入远方网客栈联盟，让更多自助游爱好者找到风景中的归宿，让您的小店生意兴隆,我们免费收录符合以下特点的客栈： 1、交通方便，窗户的视野中有好的风景； 2、干净整洁，配套齐全，可以上网； 3、价格合适，服务热情，邻里关系融洽； 4、最好有个独立的院子或阁楼。下载报名表……

	社区图片	more

select top 6 threadid,topic,otherTopic,titleimg from likefar_Threads where IsApproved = 1 and IsDel = 0 and forumid=5 and titleimg<>'null' order by newID() desc

#maxlength(StripHTML(otherTopic),8)##maxlength(StripHTML(Topic),8)#

	社区最新	more

人文地理：

select top 7 threadid,topic,otherTopic,titleimg from likefar_Threads where IsApproved = 1 and IsDel = 0 and forumid=4 order by threadid desc ·#maxlength(StripHTML(Topic),20)#

游记：
select top 7 threadid,topic,otherTopic,titleimg from likefar_Threads where IsApproved = 1 and IsDel = 0 and forumid=3 order by threadid desc ·#maxlength(StripHTML(Topic),20)#

视频： select top 4 threadid,topic,otherTopic,TitleMapImg from likefar_Threads where IsApproved = 1 and IsDel = 0 and forumid=9 and titleimg<>'null' order by threadid desc

#maxlength(StripHTML(Topic),15)#

	合作单位	more

select top 7 subject,id,classid,pic,iscommend from articlebasic where pic<>'' and classid = 21 and iscommend = 1 order by id desc

select top 20 subject,id,classid,pic,iscommend from articlebasic where pic = '' and classid = 21 and iscommend = 1 order by id desc #subject#