select '精彩读物' as '精彩读物',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/book%'
and sessionid is not null
union
select '在线演讲'as '在线演讲', count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/vod%'
and sessionid is not null
union
select '技术文章'as '技术文章',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/article%'
and sessionid is not null
union
select '专题活动'as '专题活动',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/event%'
and sessionid is not null
union
select '思科专家在线'as '思科专家在线',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/expert%'
and sessionid is not null
union
select 'NetWorkers Online'as 'NetWorkers Online',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/networkers%'
and sessionid is not null
union
select '社区建设'as '社区建设',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoforum.bizcom.com.cn%'
and sessionid is not null and querystring like '%forumID=17%'
union
select '技术交流专区'as '技术交流专区',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoforum.bizcom.com.cn%'
and sessionid is not null and querystring not like '%forumID=17%'这样的语句怎么样才能达到优化的目的
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/book%'
and sessionid is not null
union
select '在线演讲'as '在线演讲', count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/vod%'
and sessionid is not null
union
select '技术文章'as '技术文章',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/article%'
and sessionid is not null
union
select '专题活动'as '专题活动',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/event%'
and sessionid is not null
union
select '思科专家在线'as '思科专家在线',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/expert%'
and sessionid is not null
union
select 'NetWorkers Online'as 'NetWorkers Online',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoclub.bizcom.com.cn/networkers%'
and sessionid is not null
union
select '社区建设'as '社区建设',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoforum.bizcom.com.cn%'
and sessionid is not null and querystring like '%forumID=17%'
union
select '技术交流专区'as '技术交流专区',count(distinct sessionid) From trackingdb.dbo.TRACKING
where createdate > '2007-04-01 10:00:00' and createdate <'2007-04-30 10:00:00'
--and url not like '%http://cisconetworkers.bizcom.com.cn%'
and url like '%http://ciscoforum.bizcom.com.cn%'
and sessionid is not null and querystring not like '%forumID=17%'这样的语句怎么样才能达到优化的目的
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货