select
	distinct tag.tagid
from 
	discuz40.supe_tags tag,
	discuz40.supe_spacetags space_tag,
	discuz40.supe_spaceitems item,
	discuz40.supe_userspaces bloger,
	discuz40.cdb_members mem
where
	1=1
	and tag.tagid = space_tag.tagid
	and space_tag.itemid=item.itemid
	and item.uid=mem.uid
	and bloger.uid = item.uid
	and space_tag.type = 'blog'
	and mem.groupid  in (26,27,28)
	and bloger.islock = 0 
	and item.folder = 1 
	and discuz40.space_ifhide(item.itemtypeid)=0
	and tag.close = 0
	
order by 
	rand()
limit 
	0,100
以下是商家们常常用到的标签：全部标签 >>
  • cosplay(1)
    • 标签的内容长度:7,日志数量长度:1,一共有,总的长度为:10.54
  • mousse(6)
    • 标签的内容长度:13,日志数量长度:2,一共有,总的长度为:20.08
  • Villa(8)
    • 标签的内容长度:18,日志数量长度:3,一共有,总的长度为:28.62
  • WALL-E(1)
    • 标签的内容长度:24,日志数量长度:4,一共有,总的长度为:38.16
  • 阿里山(1)
    • 标签的内容长度:27,日志数量长度:5,一共有,总的长度为:44.7
  • 爱玉冻(1)
    • 标签的内容长度:30,日志数量长度:6,一共有,总的长度为:51.24
  • 奥克兰(1)
    • 标签的内容长度:33,日志数量长度:7,一共有,总的长度为:57.78
  • 八爷烤鸭(1)
    • 标签的内容长度:37,日志数量长度:8,一共有,总的长度为:65.32
  • 佰程(1)
    • 标签的内容长度:39,日志数量长度:9,一共有,总的长度为:70.86
  • 报名电话(8)
    • 标签的内容长度:43,日志数量长度:10,一共有,总的长度为:78.4
  • 北京东湖港(1)
    • 标签的内容长度:48,日志数量长度:11,一共有,总的长度为:86.94
  • 避暑(1)
    • 标签的内容长度:50,日志数量长度:12,一共有,总的长度为:92.48
  • 采茶(1)
    • 标签的内容长度:52,日志数量长度:13,一共有,总的长度为:98.02
  • 测试(1)
    • 标签的内容长度:54,日志数量长度:14,一共有,总的长度为:103.56
  • 朝阳公园(1)
    • 标签的内容长度:58,日志数量长度:15,一共有,总的长度为:111.1
  • 瓷器(1)
    • 标签的内容长度:60,日志数量长度:16,一共有,总的长度为:116.64
  • 刺身(6)
    • 标签的内容长度:62,日志数量长度:17,一共有,总的长度为:122.18
  • 大不列颠(1)
    • 标签的内容长度:66,日志数量长度:18,一共有,总的长度为:129.72
  • 袋鼠(1)
    • 标签的内容长度:68,日志数量长度:19,一共有,总的长度为:135.26
  • 东方银尊(1)
    • 标签的内容长度:72,日志数量长度:20,一共有,总的长度为:142.8
  • 放大假(48)
    • 标签的内容长度:75,日志数量长度:22,一共有,总的长度为:150.02
  • 飞瀑涧(1)
    • 标签的内容长度:78,日志数量长度:23,一共有,总的长度为:156.56
  • 嘎嘎(1)
    • 标签的内容长度:80,日志数量长度:24,一共有,总的长度为:162.1
  • 戈尔特斯(1)
    • 标签的内容长度:84,日志数量长度:25,一共有,总的长度为:169.64
  • 广东(1)
    • 标签的内容长度:86,日志数量长度:26,一共有,总的长度为:175.18
  • 广州(1)
    • 标签的内容长度:88,日志数量长度:27,一共有,总的长度为:180.72
  • 逛街(2)
    • 标签的内容长度:90,日志数量长度:28,一共有,总的长度为:186.26
  • 海边旅游(4)
    • 标签的内容长度:94,日志数量长度:29,一共有,总的长度为:193.8
  • 海滩(2)
    • 标签的内容长度:96,日志数量长度:30,一共有,总的长度为:199.34

商家推荐



select 
	item.itemid
from 
	discuz40.supe_userspaces bloger, 
	discuz40.supe_spaceitems item,
	discuz40.cdb_members mem
where 
	1=1
	and mem.uid=item.uid
	and bloger.uid = item.uid
	and item.vouch = 1
	and mem.groupid  in (26,27,28)
	and bloger.islock = 0 
	and item.folder = 1 
	and discuz40.space_ifhide(item.itemtypeid)=0
order by 
	item.dateline desc
limit 0,5;
:	select  
					item.itemid as itemid,		
					count(comments.cid) as commNum
				from 
					discuz40.supe_userspaces bloger,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates = 0
					and length(comments.message) > 0
				where 
					1=1
					and bloger.uid = item.uid
					and item.itemid in (28021,27942,27901,27797,27778)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid 
				order by 
					commNum desc
					;
:
		select 
			img.itemid,
			img.image
		from 
			discuz40.supe_spaceimages img
		where
			1=1
			and img.image <> ''
			and img.itemid in (28021,27942,27901,27797,27778);
:	select  
					item.itemid as itemid,
					item.subject as subject,
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					from_unixtime(item.dateline, '%y-%m-%d %H:%i') as date_1,
					from_unixtime(item.lastpost, '%y-%m-%d %H:%i') as lastpost,
					item.dateline as alldate,
					item.destination as destination,
					item.replynum as replynum,
					bloger.uid as uid, 
					bloger.spacename as username, 
					bloger.spacename as spacename, 
					bloger.photo as photo,				
					count(comments.cid) as rateNum,
					left(blogs.message,4000) as message,
					category.name as categoryName 
				from 
					discuz40.supe_spaceblogs blogs,
					discuz40.supe_userspaces bloger,
					discuz40.supe_categories category,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates > 0
					and comments.message = ''
					and comments.dateline >= unix_timestamp() -  24*60*60*360
					and comments.dateline <= unix_timestamp() -  24*60*60*0
				where 
					1=1
					and blogs.itemid=item.itemid
					and bloger.uid = item.uid
					and item.catid=category.catid
					and item.itemid in (28021,27942,27901,27797,27778)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid 
					
				union all
				
				select  
					item.itemid as itemid,
					item.subject as subject,
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					from_unixtime(item.dateline, '%y-%m-%d %H:%i') as date_1,
					from_unixtime(item.lastpost, '%y-%m-%d %H:%i') as lastpost,
					item.dateline as alldate,
					item.destination as destination,
					item.replynum as replynum,
					bloger.uid as uid, 
					bloger.spacename as username, 
					bloger.spacename as spacename, 
					bloger.photo as photo,								
					count(comments.cid) as rateNum,
					left(images.message,2000) as message,
					category.name as categoryName  
				from 
					discuz40.supe_spaceimages images,
					discuz40.supe_userspaces bloger,
					discuz40.supe_categories category,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates > 0
					and comments.message = ''
					and comments.dateline >= unix_timestamp() -  24*60*60*360
					and comments.dateline <= unix_timestamp() -  24*60*60*0
				where 
					1=1
					and images.itemid=item.itemid
					and bloger.uid = item.uid
					and item.catid=category.catid
					and item.itemid in (28021,27942,27901,27797,27778)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
					
				group by 
					item.itemid 
				order by 
						lastpost desc,
							rateNum desc,
							replynum desc
					;

[新品主题]　苏格兰古城的自助公寓08-20 18:07
英国旅游局
目的地：英国
3个推荐　　0条评论
苏格兰敦克尔德（Dunkeld）前市政厅（CityHall）大楼的上面几层已经被改...

[新品主题]　加放海岸假期9日精华之旅火热报名中...08-20 17:24
凤凰国旅
目的地：美国
0个推荐　　0条评论
4晚时间深入游览美国西海岸的国际化大都市——洛杉矶；风光旖旎的西海岸，特别...

[企业动态]　第15届北京国际图书展将易地天津开幕...08-18 14:37
土耳其大使馆文化新闻处
目的地：土耳其
1个推荐　　0条评论
2008年9月1日至4日，由于规避奥运会和残奥会而首次易地天津举办的第15届北京...

[新品主题]　东北全线08-15 15:42
星光之旅
目的地：吉林市 朝鲜
2个推荐　　2条评论
尊贵之选质量保证标准发团成人价儿童价特价篇1：吉林、松花湖、长白山、镜泊...

[优惠有理]　私享:香港迪士尼门票特价优惠08-15 14:53
雅程旅行网
目的地：香港
5个推荐　　4条评论
门票及订房香港迪士尼乐园引领全人类进入迪士尼奇妙的新纪元，我们诚意邀请您...

24小时推荐排行

:	select  
					bloger.uid, 
					bloger.username, 
					bloger.spacename, 
					bloger.photo,
					item.itemid, 
					item.subject, 
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					item.destination,
					item.type,
					item.replynum,
					count(comments.cid) as rateNum 
				from 
					discuz40.supe_userspaces bloger, 
					discuz40.supe_spaceitems item,
					discuz40.supe_spacecomments comments,
					discuz40.cdb_members mem 
				where 
					1=1
					and mem.uid=item.uid
					and item.itemid=comments.itemid
					and bloger.uid = item.uid
					 
					 and mem.groupid in (26,27,28) 
					
					
					 and item.type='blog' 
					
					and comments.dateline >= unix_timestamp() -  24*60*60*1
					and comments.dateline <= unix_timestamp() -  24*60*60*0
					and comments.rates > 0
					and comments.message = ''
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid		
				order by 
					rateNum desc,
					item.replynum desc,
					item.dateline desc  			
				limit 
					0,12
:	select  
					bloger.uid, 
					bloger.username, 
					bloger.spacename, 
					bloger.photo,
					item.itemid, 
					item.subject, 
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					item.destination,
					item.type,
					item.replynum,
					count(comments.cid) as rateNum 
				from 
					discuz40.supe_userspaces bloger, 
					discuz40.supe_spaceitems item,
					discuz40.supe_spacecomments comments,
					discuz40.cdb_members mem 
				where 
					1=1
					and mem.uid=item.uid
					and item.itemid=comments.itemid
					and bloger.uid = item.uid
					 
					 and mem.groupid in (26,27,28) 
					
					
					 and item.type='blog' 
					
					and comments.dateline >= unix_timestamp() -  24*60*60*1
					and comments.dateline <= unix_timestamp() -  24*60*60*0
					and comments.rates > 0
					and comments.message = ''
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid		
				order by 
					rateNum desc,
					item.replynum desc,
					item.dateline desc  			
				limit 
					0,12
:	select  
					item.itemid as itemid,		
					count(comments.cid) as commNum
				from 
					discuz40.supe_userspaces bloger,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates = 0
					and length(comments.message) > 0
				where 
					1=1
					and bloger.uid = item.uid
					and item.itemid in (27225,27942,27733,27609,27265,27741,27895,27519,27231,27482,27108,27960)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid 
				order by 
					commNum desc
					;
:
		select 
			img.itemid,
			img.image
		from 
			discuz40.supe_spaceimages img
		where
			1=1
			and img.image <> ''
			and img.itemid in (27225,27942,27733,27609,27265,27741,27895,27519,27231,27482,27108,27960);
:	select  
					item.itemid as itemid,
					item.subject as subject,
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					from_unixtime(item.dateline, '%y-%m-%d %H:%i') as date_1,
					from_unixtime(item.lastpost, '%y-%m-%d %H:%i') as lastpost,
					item.dateline as alldate,
					item.destination as destination,
					item.replynum as replynum,
					bloger.uid as uid, 
					bloger.spacename as username, 
					bloger.spacename as spacename, 
					bloger.photo as photo,				
					count(comments.cid) as rateNum,
					left(blogs.message,4000) as message,
					category.name as categoryName 
				from 
					discuz40.supe_spaceblogs blogs,
					discuz40.supe_userspaces bloger,
					discuz40.supe_categories category,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates > 0
					and comments.message = ''
					and comments.dateline >= unix_timestamp() -  24*60*60*1
					and comments.dateline <= unix_timestamp() -  24*60*60*0
				where 
					1=1
					and blogs.itemid=item.itemid
					and bloger.uid = item.uid
					and item.catid=category.catid
					and item.itemid in (27225,27942,27733,27609,27265,27741,27895,27519,27231,27482,27108,27960)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid 
					
				union all
				
				select  
					item.itemid as itemid,
					item.subject as subject,
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					from_unixtime(item.dateline, '%y-%m-%d %H:%i') as date_1,
					from_unixtime(item.lastpost, '%y-%m-%d %H:%i') as lastpost,
					item.dateline as alldate,
					item.destination as destination,
					item.replynum as replynum,
					bloger.uid as uid, 
					bloger.spacename as username, 
					bloger.spacename as spacename, 
					bloger.photo as photo,								
					count(comments.cid) as rateNum,
					left(images.message,2000) as message,
					category.name as categoryName  
				from 
					discuz40.supe_spaceimages images,
					discuz40.supe_userspaces bloger,
					discuz40.supe_categories category,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates > 0
					and comments.message = ''
					and comments.dateline >= unix_timestamp() -  24*60*60*1
					and comments.dateline <= unix_timestamp() -  24*60*60*0
				where 
					1=1
					and images.itemid=item.itemid
					and bloger.uid = item.uid
					and item.catid=category.catid
					and item.itemid in (27225,27942,27733,27609,27265,27741,27895,27519,27231,27482,27108,27960)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
					
				group by 
					item.itemid 
				order by 
						rateNum desc,
							alldate desc,
							replynum desc
					;

[新品主题]　苏格兰古城的自助公寓08-19 09:55
英国旅游局
目的地：英国
2个推荐　　0条评论
苏格兰敦克尔德（Dunkeld）前市政厅（CityHall）大楼的上面几层已经被改...

[优惠有理]　三亚大东海海底潜水体验专线07-31 09:18
海南自游网
目的地：三亚
2个推荐　　3条评论
更多精彩假期，请点击这里了解★岸潜：88元/位（含一次岸潜、保险等）的消费★珊瑚...

[刚刚回来的攻略]　哪凉快哪玩去：埃及一地8日游08-19 14:24
玩家旅游杂志
目的地：埃及
1个推荐　　0条评论
文化探寻点评：也许短短的年假你哪里也不敢去，只有在家里发呆，但现在不同了。沙...

[新品主题]　利物浦举行披头士乐队纪念活动08-18 09:43
英国旅游局
目的地：英国
1个推荐　　1条评论
8月20日-26日，2008欧洲文化之都利物浦（Liverpool,EuropeanCapitalofCulture20...

[新品主题]　古城里的精美饮食08-12 19:27
英国旅游局
目的地：英国
1个推荐　　1条评论
9月份，在历史古城约克将举行英国规模最大的年度食品节活动。约克餐饮节（TheYo...

[优惠有理]　8月银泰+天域特惠套餐08-12 15:20
海南自游网
目的地：三亚
1个推荐　　8条评论
三亚最佳度假酒店，大东海银泰和亚龙湾天域，十分适合休闲度假，特别是那片海的浪...

[优惠有理]　暑期“唱”游[处女星号]，暑期报名参加[处女星号]行程即可获得三人...08-07 17:53
丽星邮轮
目的地：香港 三亚 下龙湾
1个推荐　　1条评论
处女星号精彩航次：3晚香港-三亚-下龙湾-香港之旅(逢周日出发每位只需RMB2,11...

[新品主题]　纪念查尔斯·达尔文08-06 08:29
英国旅游局
目的地：英国
1个推荐　　0条评论
明年是查尔斯·达尔文诞辰200周年。伦敦的自然历史博物馆（NaturalHistoryMus...

[品质看点]　伊兹密尔参选A1大奖赛主办08-05 10:23
土耳其大使馆文化新闻处
目的地：
1个推荐　　0条评论
日前，记者从土耳其有关部门了解到，伊兹密尔目前在争取代表土耳其主办A1大奖赛...

[新品主题]　夜间的恐怖体验08-01 10:09
英国旅游局
目的地：英国
1个推荐　　3条评论
英国将举行首次夏日户外恐怖娱乐活动。魔力收获（HexintheHarvest）将为游人们...

[新品主题]　奥尔索普庄园的圣诞节07-31 09:53
英国旅游局
目的地：英国
1个推荐　　0条评论
500年来，斯宾塞（Spencer）家族世代居住在英格兰北安普敦郡的奥尔索普庄园（Althor...

[活动策划]　狂欢土耳其美食之夜07-29 10:22
土耳其大使馆文化新闻处
目的地：
1个推荐　　0条评论
7月27号，由土耳其使馆文化新闻处和土耳其爱固闻旅行社共同主办的土耳其美食...

刚刚开通的官方博客
三亚乐享假期
08-14 14:49  正式开通
最新更新全部 >>
:	select  
					item.itemid as itemid,		
					count(comments.cid) as commNum
				from 
					discuz40.supe_userspaces bloger,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates = 0
					and length(comments.message) > 0
				where 
					1=1
					and bloger.uid = item.uid
					and item.itemid in (28023,28021,27942,27935,27901,27873,27866,27802,27778,27693)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid 
				order by 
					commNum desc
					;
:
		select 
			img.itemid,
			img.image
		from 
			discuz40.supe_spaceimages img
		where
			1=1
			and img.image <> ''
			and img.itemid in (28023,28021,27942,27935,27901,27873,27866,27802,27778,27693);
:	select  
					item.itemid as itemid,
					item.subject as subject,
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					from_unixtime(item.dateline, '%y-%m-%d %H:%i') as date_1,
					from_unixtime(item.lastpost, '%y-%m-%d %H:%i') as lastpost,
					item.dateline as alldate,
					item.destination as destination,
					item.replynum as replynum,
					bloger.uid as uid, 
					bloger.spacename as username, 
					bloger.spacename as spacename, 
					bloger.photo as photo,				
					count(comments.cid) as rateNum,
					left(blogs.message,4000) as message,
					category.name as categoryName 
				from 
					discuz40.supe_spaceblogs blogs,
					discuz40.supe_userspaces bloger,
					discuz40.supe_categories category,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates > 0
					and comments.message = ''
					and comments.dateline >= unix_timestamp() -  24*60*60*8
					and comments.dateline <= unix_timestamp() -  24*60*60*0
				where 
					1=1
					and blogs.itemid=item.itemid
					and bloger.uid = item.uid
					and item.catid=category.catid
					and item.itemid in (28023,28021,27942,27935,27901,27873,27866,27802,27778,27693)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
				group by 
					item.itemid 
					
				union all
				
				select  
					item.itemid as itemid,
					item.subject as subject,
					from_unixtime(item.dateline, '%m-%d %H:%i') as dateline,
					from_unixtime(item.dateline, '%y-%m-%d %H:%i') as date_1,
					from_unixtime(item.lastpost, '%y-%m-%d %H:%i') as lastpost,
					item.dateline as alldate,
					item.destination as destination,
					item.replynum as replynum,
					bloger.uid as uid, 
					bloger.spacename as username, 
					bloger.spacename as spacename, 
					bloger.photo as photo,								
					count(comments.cid) as rateNum,
					left(images.message,2000) as message,
					category.name as categoryName  
				from 
					discuz40.supe_spaceimages images,
					discuz40.supe_userspaces bloger,
					discuz40.supe_categories category,
					discuz40.supe_spaceitems item
					left join
					discuz40.supe_spacecomments comments
					on item.itemid=comments.itemid
					and comments.rates > 0
					and comments.message = ''
					and comments.dateline >= unix_timestamp() -  24*60*60*8
					and comments.dateline <= unix_timestamp() -  24*60*60*0
				where 
					1=1
					and images.itemid=item.itemid
					and bloger.uid = item.uid
					and item.catid=category.catid
					and item.itemid in (28023,28021,27942,27935,27901,27873,27866,27802,27778,27693)				
					and bloger.islock = 0 
					and item.folder = 1 
					and discuz40.space_ifhide(item.itemtypeid)=0
					
				group by 
					item.itemid 
				order by 
						alldate desc,
							rateNum desc,
							replynum desc
					;
[刚刚回来的攻略] 台湾6大夜市：士林－...
玩家旅游杂志08-20 17:55
[新品主题] 加放海岸假期9日...
凤凰国旅08-20 17:24
[新品主题] 苏格兰古城的自助...
英国旅游局08-19 09:55
[优惠有理] 魅力南疆风光民俗...
中国假日新疆游08-18 21:55
[企业动态] 第15届北京国际图...
土耳其大使馆文化新闻处08-18 11:03
[品质看点] 打造中国第一流游...
雅程旅行网08-16 10:25
[新品主题] 十渡风景区
北青旅朝阳营业部官方博客08-15 23:42
[品质看点] 三亚珠江花园滨海...
海南自游网08-15 09:46
[新品主题] 东北全线
星光之旅08-14 10:37
[新品主题] 祖山常规二日游...
祖山旅游08-11 11:02
最受关注的旅游局全部官方博客 >>

		
			select  
				bloger.uid, 
				bloger.username,
				bloger.spacename, 
				bloger.photo,
				count(comments.cid) as rateNum,
				field.xl
			from 
				discuz40.supe_userspaces bloger, 
				discuz40.supe_spacecomments comments,
				discuz40.cdb_members mem,
				discuz40.cdb_memberfields field
			where 
				1=1
				and mem.uid=bloger.uid
				and bloger.uid = comments.uid
				and bloger.uid = field.uid
				and field.xl like '%旅游局%'
				and mem.groupid in (26,27)
				and comments.dateline >= unix_timestamp() -  24*60*60*25
				and comments.dateline <= unix_timestamp() -  24*60*60*1 
				and comments.rates > 0
				and comments.message = ''
				and bloger.islock = 0 
			group by 
				bloger.uid
			order by 
				rateNum desc,
				bloger.uid
			limit 
				0,10
英国旅游局
45篇日志    27个推荐
土耳其大使馆文化新闻处
7篇日志    7个推荐
芬旅局
15篇日志    2个推荐
北欧旅游
5篇日志    1个推荐
瑞士旅游
2篇日志    1个推荐
最受关注的旅行社全部官方博客 >>

		
			select  
				bloger.uid, 
				bloger.username,
				bloger.spacename, 
				bloger.photo,
				count(comments.cid) as rateNum,
				field.xl
			from 
				discuz40.supe_userspaces bloger, 
				discuz40.supe_spacecomments comments,
				discuz40.cdb_members mem,
				discuz40.cdb_memberfields field
			where 
				1=1
				and mem.uid=bloger.uid
				and bloger.uid = comments.uid
				and bloger.uid = field.uid
				and field.xl like '%旅行社%'
				and mem.groupid in (26,27)
				and comments.dateline >= unix_timestamp() -  24*60*60*15
				and comments.dateline <= unix_timestamp() -  24*60*60*1 
				and comments.rates > 0
				and comments.message = ''
				and bloger.islock = 0 
			group by 
				bloger.uid
			order by 
				rateNum desc,
				bloger.uid
			limit 
				0,10
海南自游网
39篇日志    137个推荐
雅程旅行网
22篇日志    66个推荐
中国假日新疆游
91篇日志    40个推荐
凤凰国旅
16篇日志    8个推荐
丽星邮轮
1篇日志    8个推荐
星光之旅
7篇日志    2个推荐
北青旅朝阳营业部官方博客
52篇日志    1个推荐