Row_number() slow on large datasets

Question

Post reply

Row_number() slow on large datasets

stephane3d

Ten Centuries

Points: 1129
More actions
May 7, 2009 at 6:58 am

#384521

Hi,
I have this query going like this:
select * from (
select
id, row_number()over(partition by fk_tbl_visits_id order by id desc) as rn
from tbl_logs
where date between '2009-05-06 00:00:00' and '2009-05-06 23:59:00'
) x where rn = 1
I want to get the first page visited by a visitor. This query works fine but gets slower when the dataset gets bigger. The query execution plan shows costly sorts and table spool operations. Is there a way to make this query faster? Is there a way to put an index on the row_number() function? I guess not but we never know...
Is there another way of doing this while having a better performance?
Thanks a lot for any idea
Stephane

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Wouldn't this return the same thing?

Select

max(id) as id

From

tbl_logs

Where

date between '2009-05-06 00:00:00' and '2009-05-06 23:59:00'

Group By

fk_tbl_visits_id

Please take a look at the first article linked in my signature and post some test data and desired result and we can come up with a more accurate solution.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

stephane3d Ten Centuries Points: 1129 More actions · Answer 2

Hi,

I did some tests and the results are the same, but it's not quicker. There's a Table Spool in the query execution plan that takes 47%.

Here's the table and some data of a more complex example. See the table spools in the QEP.

IF OBJECT_ID('TempDB..#tbl_logs','U') IS NOT NULL

DROP TABLE #tbl_logs

CREATE TABLE #tbl_logs(

[date] [datetime] NOT NULL DEFAULT (getdate()),

[id] [bigint] NOT NULL,

[fk_tbl_visits_id] [bigint] NULL,

[cookieNumber] [float] NULL DEFAULT ((0)),

[nbPageViews] [int] NULL DEFAULT ((0)),

[visitLength] [int] NULL DEFAULT ((0)),

[isNewVisit] [bit] NULL DEFAULT ((0)),

[isRebound] [bit] NULL DEFAULT ((1)),

CONSTRAINT [PK_tbl_logs] PRIMARY KEY CLUSTERED

(

[date] ASC,

[id] ASC

)

) ON [PRIMARY]

insert into #tbl_logs(date, id, fk_tbl_visits_id, [cookieNumber], [nbPageViews], [visitLength], [isNewVisit], [isRebound])

SELECT 'Oct 18 2008 12:00AM','86598137','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598138','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598139','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598195','39864033','1.34132e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598140','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:01AM','86598141','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:01AM','86598142','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:05AM','86598143','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:05AM','86598144','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:05AM','86598360','39864096','1.71522e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:06AM','86598367','39864100','2.07625e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:06AM','86598368','39864101','1.81609e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:06AM','86598369','39864102','5.79382e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598145','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598146','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598147','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598148','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598149','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:08AM','86598427','39864125','1.98e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:08AM','86598429','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:11AM','86598430','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:11AM','86598431','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:11AM','86598150','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:12AM','86598151','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:12AM','86598432','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:12AM','86598433','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:14AM','86598434','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:15AM','86599083','39864208','1.84229e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:15AM','86598435','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598436','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86599059','39864220','1.36913e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598437','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598438','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598439','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:18AM','86599110','39864251','8.18458e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:19AM','86598440','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:19AM','86598441','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:20AM','86599054','39864290','2.14484e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:22AM','86599075','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:22AM','86599073','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:23AM','86598442','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:23AM','86599085','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:23AM','86598443','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:26AM','86598444','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:27AM','86598445','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:27AM','86598446','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:27AM','86598447','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:28AM','86598448','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:28AM','86598449','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:29AM','86599092','39864380','1.23927e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599071','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599067','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599096','39864392','1.37347e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599057','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:32AM','86599065','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:32AM','86599078','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:33AM','86599053','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:33AM','86599051','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:33AM','86600475','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:34AM','86600479','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:34AM','86599061','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:34AM','86600460','39864424','1.61507e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:35AM','86600458','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:36AM','86600467','39864438','1.22812e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:37AM','86600471','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:37AM','86600491','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:37AM','86600504','39864444','1.14802e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:38AM','86600473','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:47AM','86600533','39864537','2.05814e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:49AM','86600509','39864559','1.17807e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:49AM','86599064','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:51AM','86600462','39864582','1.8943e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:52AM','86600465','39864588','6.66527e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:52AM','86600489','39864590','3.71447e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:52AM','86599087','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:55AM','86600499','39864618','8.5501e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:58AM','86599063','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 1:01AM','86600495','39864683','1.47354e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:05AM','86600463','39864740','1.93774e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:06AM','86600501','39864749','2.1049e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:10AM','86600481','39864779','1.07581e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:10AM','86600483','39864786','5.25334e+008','3','208','1','0' UNION ALL

SELECT 'Oct 18 2008 1:12AM','86600485','39864786','5.25334e+008','3','208','1','0' UNION ALL

SELECT 'Oct 18 2008 1:14AM','86600487','39864786','5.25334e+008','3','208','1','0' UNION ALL

SELECT 'Oct 18 2008 1:19AM','86600528','39864869','1.39363e+009','2','250','0','0' UNION ALL

SELECT 'Oct 18 2008 1:23AM','86600497','39864909','2.77185e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:23AM','86600506','39864869','1.39363e+009','2','250','0','0' UNION ALL

SELECT 'Oct 18 2008 1:24AM','86600493','39864924','3.50627e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:34AM','86603730','39865029','1.47354e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 1:40AM','86603678','39865080','2.11723e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:42AM','86603748','39865109','1.86172e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:49AM','86603669','39865159','9.05993e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:54AM','86603714','39865243','1.08842e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 2:01AM','86603762','39865248','1.84313e+009','3','35','1','0' UNION ALL

SELECT 'Oct 18 2008 2:02AM','86603717','39865248','1.84313e+009','3','35','1','0' UNION ALL

SELECT 'Oct 18 2008 2:02AM','86603760','39865248','1.84313e+009','3','35','1','0' UNION ALL

SELECT 'Oct 18 2008 2:04AM','86603704','39865269','1.38991e+009','4','1114','1','0' UNION ALL

SELECT 'Oct 18 2008 2:08AM','86603673','39865269','1.38991e+009','4','1114','1','0' UNION ALL

SELECT 'Oct 18 2008 2:08AM','86603702','39865269','1.38991e+009','4','1114','1','0' UNION ALL

SELECT 'Oct 18 2008 2:22AM','86603700','39865269','1.38991e+009','4','1114','1','0'

select count(distinct cookieNumber) as nbvisitors,

count(distinct fk_tbl_visits_id) as nbVisits,

sum(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

sum(cast(isNewVisit as tinyint)) as nbNewVisits,

sum(cast(isRebound as tinyint)) as nbRebounds

from (

select

cookieNumber,

fk_tbl_visits_id,

nbPageViews,

visitLength,

isNewVisit,

isRebound,

row_number() over(partition by fk_tbl_visits_id order by id desc) as rn

from #tbl_logs

where date between '2008-10-06 00:00:00' and '2009-05-06 23:59:00'

) x where rn = 1

drop table #tbl_logs

Thanks a lot for your help,

Stephane

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Using Jack's query, try adding the following index and let us know what happens.

create index IX_tbllogs on #tbl_logs (

[fk_tbl_visits_id] asc,

[date] asc

)

include (

[id]

);

You may want to change the table name above. I used the name from the code you posted last.

stephane3d Ten Centuries Points: 1129 More actions · Answer 4

There still a table spool and the query take 3 seconds with 1000 rows. It's pretty much slow. Here's the new code:

IF OBJECT_ID('TempDB..#tbl_logs','U') IS NOT NULL

DROP TABLE #tbl_logs

CREATE TABLE #tbl_logs(

[date] [datetime] NOT NULL DEFAULT (getdate()),

[id] [bigint] NOT NULL,

[fk_tbl_visits_id] [bigint] NULL,

[cookieNumber] [float] NULL DEFAULT ((0)),

[nbPageViews] [int] NULL DEFAULT ((0)),

[visitLength] [int] NULL DEFAULT ((0)),

[isNewVisit] [bit] NULL DEFAULT ((0)),

[isRebound] [bit] NULL DEFAULT ((1)),

CONSTRAINT [PK_tbl_logs] PRIMARY KEY CLUSTERED

(

[date] ASC,

[id] ASC

)

) ON [PRIMARY]

create index IX_tbllogs on #tbl_logs (

[fk_tbl_visits_id] asc,

[date] asc

)

include (

[id]

);

insert into #tbl_logs(date, id, fk_tbl_visits_id, [cookieNumber], [nbPageViews], [visitLength], [isNewVisit], [isRebound])

SELECT 'Oct 18 2008 12:00AM','86598137','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598138','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598139','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598195','39864033','1.34132e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:00AM','86598140','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:01AM','86598141','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:01AM','86598142','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:05AM','86598143','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:05AM','86598144','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:05AM','86598360','39864096','1.71522e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:06AM','86598367','39864100','2.07625e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:06AM','86598368','39864101','1.81609e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:06AM','86598369','39864102','5.79382e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598145','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598146','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598147','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598148','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:07AM','86598149','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:08AM','86598427','39864125','1.98e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:08AM','86598429','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:11AM','86598430','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:11AM','86598431','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:11AM','86598150','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:12AM','86598151','39864024','7.60646e+008','15','703','0','0' UNION ALL

SELECT 'Oct 18 2008 12:12AM','86598432','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:12AM','86598433','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:14AM','86598434','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:15AM','86599083','39864208','1.84229e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:15AM','86598435','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598436','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86599059','39864220','1.36913e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598437','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598438','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:16AM','86598439','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:18AM','86599110','39864251','8.18458e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:19AM','86598440','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:19AM','86598441','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:20AM','86599054','39864290','2.14484e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:22AM','86599075','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:22AM','86599073','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:23AM','86598442','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:23AM','86599085','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:23AM','86598443','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:26AM','86598444','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:27AM','86598445','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:27AM','86598446','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:27AM','86598447','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:28AM','86598448','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:28AM','86598449','39864127','1.21004e+009','21','1221','0','0' UNION ALL

SELECT 'Oct 18 2008 12:29AM','86599092','39864380','1.23927e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599071','39864312','1.67987e+009','4','473','0','0' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599067','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599096','39864392','1.37347e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:30AM','86599057','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:32AM','86599065','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:32AM','86599078','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:33AM','86599053','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:33AM','86599051','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:33AM','86600475','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:34AM','86600479','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:34AM','86599061','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:34AM','86600460','39864424','1.61507e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:35AM','86600458','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:36AM','86600467','39864438','1.22812e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:37AM','86600471','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:37AM','86600491','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:37AM','86600504','39864444','1.14802e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:38AM','86600473','39864415','1.84378e+009','6','288','1','0' UNION ALL

SELECT 'Oct 18 2008 12:47AM','86600533','39864537','2.05814e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:49AM','86600509','39864559','1.17807e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:49AM','86599064','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:51AM','86600462','39864582','1.8943e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:52AM','86600465','39864588','6.66527e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:52AM','86600489','39864590','3.71447e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 12:52AM','86599087','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 12:55AM','86600499','39864618','8.5501e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 12:58AM','86599063','39864391','1.21004e+009','10','1648','0','0' UNION ALL

SELECT 'Oct 18 2008 1:01AM','86600495','39864683','1.47354e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:05AM','86600463','39864740','1.93774e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:06AM','86600501','39864749','2.1049e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:10AM','86600481','39864779','1.07581e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:10AM','86600483','39864786','5.25334e+008','3','208','1','0' UNION ALL

SELECT 'Oct 18 2008 1:12AM','86600485','39864786','5.25334e+008','3','208','1','0' UNION ALL

SELECT 'Oct 18 2008 1:14AM','86600487','39864786','5.25334e+008','3','208','1','0' UNION ALL

SELECT 'Oct 18 2008 1:19AM','86600528','39864869','1.39363e+009','2','250','0','0' UNION ALL

SELECT 'Oct 18 2008 1:23AM','86600497','39864909','2.77185e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:23AM','86600506','39864869','1.39363e+009','2','250','0','0' UNION ALL

SELECT 'Oct 18 2008 1:24AM','86600493','39864924','3.50627e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:34AM','86603730','39865029','1.47354e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 1:40AM','86603678','39865080','2.11723e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:42AM','86603748','39865109','1.86172e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:49AM','86603669','39865159','9.05993e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 1:54AM','86603714','39865243','1.08842e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 2:01AM','86603762','39865248','1.84313e+009','3','35','1','0' UNION ALL

SELECT 'Oct 18 2008 2:02AM','86603717','39865248','1.84313e+009','3','35','1','0' UNION ALL

SELECT 'Oct 18 2008 2:02AM','86603760','39865248','1.84313e+009','3','35','1','0' UNION ALL

SELECT 'Oct 18 2008 2:04AM','86603704','39865269','1.38991e+009','4','1114','1','0' UNION ALL

SELECT 'Oct 18 2008 2:08AM','86603673','39865269','1.38991e+009','4','1114','1','0' UNION ALL

SELECT 'Oct 18 2008 2:08AM','86603702','39865269','1.38991e+009','4','1114','1','0' UNION ALL

SELECT 'Oct 18 2008 2:22AM','86603700','39865269','1.38991e+009','4','1114','1','0' UNION ALL

SELECT 'Oct 18 2008 2:27AM','86603708','39865465','1.00163e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 2:40AM','86603737','39865583','1.38991e+009','3','860','0','0' UNION ALL

SELECT 'Oct 18 2008 2:42AM','86603689','39865605','1.18867e+007','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 2:43AM','86603696','39865583','1.38991e+009','3','860','0','0' UNION ALL

SELECT 'Oct 18 2008 2:43AM','86603685','39865624','1.45994e+009','6','49','0','0' UNION ALL

SELECT 'Oct 18 2008 2:44AM','86603779','39865624','1.45994e+009','6','49','0','0' UNION ALL

SELECT 'Oct 18 2008 2:44AM','86603771','39865624','1.45994e+009','6','49','0','0' UNION ALL

SELECT 'Oct 18 2008 2:44AM','86603777','39865624','1.45994e+009','6','49','0','0' UNION ALL

SELECT 'Oct 18 2008 2:44AM','86603683','39865624','1.45994e+009','6','49','0','0' UNION ALL

SELECT 'Oct 18 2008 2:44AM','86603773','39865624','1.45994e+009','6','49','0','0' UNION ALL

SELECT 'Oct 18 2008 2:44AM','86603775','39865633','4.19268e+008','2','310','0','1' UNION ALL

SELECT 'Oct 18 2008 2:48AM','86603752','39865654','1.83706e+009','2','69','1','0' UNION ALL

SELECT 'Oct 18 2008 2:49AM','86603785','39865654','1.83706e+009','2','69','1','0' UNION ALL

SELECT 'Oct 18 2008 2:50AM','86603682','39865633','4.19268e+008','2','310','0','1' UNION ALL

SELECT 'Oct 18 2008 2:54AM','86603715','39865698','8.73656e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 2:54AM','86603698','39865583','1.38991e+009','3','860','0','0' UNION ALL

SELECT 'Oct 18 2008 3:03AM','86603765','39865854','1.58494e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:05AM','86603712','39865803','1.65846e+009','2','4','1','0' UNION ALL

SELECT 'Oct 18 2008 3:05AM','86603710','39865803','1.65846e+009','2','4','1','0' UNION ALL

SELECT 'Oct 18 2008 3:06AM','86603758','39865823','6.44301e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:09AM','86603667','39865882','7.03781e+008','3','32','1','0' UNION ALL

SELECT 'Oct 18 2008 3:09AM','86603694','39865882','7.03781e+008','3','32','1','0' UNION ALL

SELECT 'Oct 18 2008 3:10AM','86603750','39865888','1.64095e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:10AM','86603706','39865891','5.39881e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:10AM','86603665','39865882','7.03781e+008','3','32','1','0' UNION ALL

SELECT 'Oct 18 2008 3:16AM','86605233','39865945','3.27472e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 3:17AM','86603680','39865954','1.52293e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:19AM','86603663','39865973','1.89902e+009','3','36','1','0' UNION ALL

SELECT 'Oct 18 2008 3:19AM','86603675','39865975','2.11117e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:19AM','86603729','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:19AM','86603754','39865977','6.59799e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:20AM','86603659','39865973','1.89902e+009','3','36','1','0' UNION ALL

SELECT 'Oct 18 2008 3:20AM','86603671','39865973','1.89902e+009','3','36','1','0' UNION ALL

SELECT 'Oct 18 2008 3:20AM','86603739','39866043','3.01754e+008','3','375','1','0' UNION ALL

SELECT 'Oct 18 2008 3:22AM','86603741','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:23AM','86603687','39865999','1.09248e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:25AM','86603837','39866043','3.01754e+008','3','375','1','0' UNION ALL

SELECT 'Oct 18 2008 3:26AM','86603839','39866043','3.01754e+008','3','375','1','0' UNION ALL

SELECT 'Oct 18 2008 3:27AM','86603742','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:27AM','86603733','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:27AM','86603727','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:28AM','86603732','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:28AM','86603728','39866084','1.53295e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:28AM','86603743','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:29AM','86603692','39866100','5.80237e+008','2','29','1','0' UNION ALL

SELECT 'Oct 18 2008 3:29AM','86603734','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:29AM','86603661','39866100','5.80237e+008','2','29','1','0' UNION ALL

SELECT 'Oct 18 2008 3:29AM','86603719','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:30AM','86603744','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:30AM','86603747','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:31AM','86603745','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:31AM','86603746','39865976','1.23884e+009','13','690','0','0' UNION ALL

SELECT 'Oct 18 2008 3:33AM','86603735','39866165','1.83706e+009','2','409','0','0' UNION ALL

SELECT 'Oct 18 2008 3:38AM','86603756','39866232','4.01519e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:40AM','86603787','39866165','1.83706e+009','2','409','0','0' UNION ALL

SELECT 'Oct 18 2008 3:40AM','86603676','39866251','1.02524e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:42AM','86603720','39866277','1.31268e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:43AM','86603690','39866288','1.18793e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:44AM','86609919','39866305','1.01166e+008','2','82','0','1' UNION ALL

SELECT 'Oct 18 2008 3:46AM','86609918','39866305','1.01166e+008','2','82','0','1' UNION ALL

SELECT 'Oct 18 2008 3:46AM','86609846','39866333','1.88677e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:47AM','86609923','39866428','6.33974e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 3:48AM','86609853','39866424','2.06693e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 3:48AM','86609992','39866421','7.2452e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:00AM','86609832','39866490','1.68319e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:00AM','86609922','39866497','2.14347e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:02AM','86609828','39866520','4.67698e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:06AM','86609776','39866570','2.16483e+008','2','206','1','0' UNION ALL

SELECT 'Oct 18 2008 4:06AM','86609920','39866577','1.01166e+008','2','1014','0','1' UNION ALL

SELECT 'Oct 18 2008 4:06AM','86606072','39866579','6.41149e+008','2','1','1','0' UNION ALL

SELECT 'Oct 18 2008 4:06AM','86606073','39866579','6.41149e+008','2','1','1','0' UNION ALL

SELECT 'Oct 18 2008 4:09AM','86609774','39866570','2.16483e+008','2','206','1','0' UNION ALL

SELECT 'Oct 18 2008 4:23AM','86610188','39866761','1.00272e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:23AM','86609917','39866577','1.01166e+008','2','1014','0','1' UNION ALL

SELECT 'Oct 18 2008 4:23AM','86609902','39866762','1.72184e+009','2','31','1','0' UNION ALL

SELECT 'Oct 18 2008 4:24AM','86609880','39866762','1.72184e+009','2','31','1','0' UNION ALL

SELECT 'Oct 18 2008 4:25AM','86609761','39866809','1.83706e+009','2','89','0','0' UNION ALL

SELECT 'Oct 18 2008 4:26AM','86609865','39866853','2.12701e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:27AM','86609855','39866809','1.83706e+009','2','89','0','0' UNION ALL

SELECT 'Oct 18 2008 4:31AM','86609859','39866925','2.1451e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:32AM','86609890','39866943','1.96375e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:33AM','86609772','39866981','1.99514e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:38AM','86609885','39867058','6.85153e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:38AM','86609881','39867067','5.33124e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:38AM','86612783','39867072','5.88592e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 4:41AM','86609871','39867099','1.56103e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 4:55AM','86605938','39867268','1.18077e+009','2','0','1','0' UNION ALL

SELECT 'Oct 18 2008 4:55AM','86605936','39867268','1.18077e+009','2','0','1','0' UNION ALL

SELECT 'Oct 18 2008 4:58AM','86609823','39867333','4.57407e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:01AM','86609883','39867439','1.43611e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:07AM','86609788','39867450','1.4292e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:08AM','86609824','39867462','1.09722e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:08AM','86609949','39867527','1.85423e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:09AM','86609867','39867482','8.89724e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:12AM','86609759','39867551','2.08178e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:14AM','86609861','39867570','1.7758e+009','4','276','1','0' UNION ALL

SELECT 'Oct 18 2008 5:14AM','86609951','39867570','1.7758e+009','4','276','1','0' UNION ALL

SELECT 'Oct 18 2008 5:14AM','86609798','39867581','1.7589e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:15AM','86609816','39867570','1.7758e+009','4','276','1','0' UNION ALL

SELECT 'Oct 18 2008 5:16AM','86609800','39867605','2.12833e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:18AM','86609953','39867570','1.7758e+009','4','276','1','0' UNION ALL

SELECT 'Oct 18 2008 5:20AM','86609833','39867667','1.14129e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:23AM','86609878','39867704','2.11808e+009','2','663','0','1' UNION ALL

SELECT 'Oct 18 2008 5:29AM','86609875','39867795','1.63265e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:29AM','86609907','39867798','1.18439e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:30AM','86609903','39867804','6.59065e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:30AM','86606301','39867810','1.40024e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:30AM','86609905','39867812','1.0686e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:30AM','86609869','39867818','3.58657e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:31AM','86605784','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86607998','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86605785','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86605786','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86609758','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86605790','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86609793','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86609852','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86609786','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86609913','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:32AM','86609915','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:33AM','86609826','39867852','7.81284e+008','3','42','1','0' UNION ALL

SELECT 'Oct 18 2008 5:33AM','86609782','39867852','7.81284e+008','3','42','1','0' UNION ALL

SELECT 'Oct 18 2008 5:33AM','86609810','39867852','7.81284e+008','3','42','1','0' UNION ALL

SELECT 'Oct 18 2008 5:34AM','86609911','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:34AM','86609787','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:34AM','86609977','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:34AM','86609979','39867830','1.85055e+009','15','143','1','0' UNION ALL

SELECT 'Oct 18 2008 5:34AM','86609877','39867704','2.11808e+009','2','663','0','1' UNION ALL

SELECT 'Oct 18 2008 5:36AM','86609797','39867902','7.53672e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:40AM','86606536','39867964','1.87989e+009','3','41','1','0' UNION ALL

SELECT 'Oct 18 2008 5:40AM','86606537','39867964','1.87989e+009','3','41','1','0' UNION ALL

SELECT 'Oct 18 2008 5:41AM','86609769','39867964','1.87989e+009','3','41','1','0' UNION ALL

SELECT 'Oct 18 2008 5:44AM','86609837','39868020','1.40468e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:48AM','86609784','39868084','1.53252e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:53AM','86609932','39868187','1.09565e+009','3','100','1','0' UNION ALL

SELECT 'Oct 18 2008 5:54AM','86605677','39868182','5.38717e+007','3','30','1','0' UNION ALL

SELECT 'Oct 18 2008 5:54AM','86609763','39868182','5.38717e+007','3','30','1','0' UNION ALL

SELECT 'Oct 18 2008 5:54AM','86609839','39868182','5.38717e+007','3','30','1','0' UNION ALL

SELECT 'Oct 18 2008 5:54AM','86609930','39868187','1.09565e+009','3','100','1','0' UNION ALL

SELECT 'Oct 18 2008 5:55AM','86609931','39868187','1.09565e+009','3','100','1','0' UNION ALL

SELECT 'Oct 18 2008 5:56AM','86609848','39868155','1.46764e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 5:56AM','86609886','39868164','1.22522e+009','3','37','1','0' UNION ALL

SELECT 'Oct 18 2008 5:56AM','86609778','39868194','1.83854e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:56AM','86609900','39868164','1.22522e+009','3','37','1','0' UNION ALL

SELECT 'Oct 18 2008 5:57AM','86609888','39868164','1.22522e+009','3','37','1','0' UNION ALL

SELECT 'Oct 18 2008 5:57AM','86609804','39868232','1.49669e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 5:58AM','86605670','39868245','8.50689e+008','5','18','0','0' UNION ALL

SELECT 'Oct 18 2008 5:58AM','86609765','39868245','8.50689e+008','5','18','0','0' UNION ALL

SELECT 'Oct 18 2008 5:58AM','86609795','39868245','8.50689e+008','5','18','0','0' UNION ALL

SELECT 'Oct 18 2008 5:58AM','86609767','39868245','8.50689e+008','5','18','0','0' UNION ALL

SELECT 'Oct 18 2008 5:58AM','86605664','39868245','8.50689e+008','5','18','0','0' UNION ALL

SELECT 'Oct 18 2008 5:59AM','86610014','39868211','1.21034e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:00AM','86609802','39868221','4.25395e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:00AM','86609879','39868290','4.98443e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:02AM','86609921','39868266','1.01166e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 6:02AM','86609863','39868268','6.2415e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:04AM','86609850','39868318','2.09425e+009','3','26','1','0' UNION ALL

SELECT 'Oct 18 2008 6:04AM','86609994','39868318','2.09425e+009','3','26','1','0' UNION ALL

SELECT 'Oct 18 2008 6:04AM','86609789','39868318','2.09425e+009','3','26','1','0' UNION ALL

SELECT 'Oct 18 2008 6:06AM','86609894','39868356','1.77791e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:08AM','86609840','39868377','1.99426e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:10AM','86609928','39868408','1.19761e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:10AM','86609909','39868417','2.09156e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:13AM','86609820','39868480','1.32528e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:13AM','86609791','39868484','3.97004e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:15AM','86609819','39868521','8.28294e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:16AM','86609963','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:16AM','86609990','39868529','5.8395e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:16AM','86609835','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:18AM','86609806','39868571','1.16718e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:21AM','86609965','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:22AM','86609969','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:22AM','86609873','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:22AM','86609842','39868643','1.89694e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:23AM','86609967','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:24AM','86609943','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:26AM','86609971','39868526','1.11005e+009','8','605','1','0' UNION ALL

SELECT 'Oct 18 2008 6:28AM','86609844','39868730','1.70521e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:29AM','86609947','39868749','1.53366e+009','5','461','1','0' UNION ALL

SELECT 'Oct 18 2008 6:31AM','86609780','39868749','1.53366e+009','5','461','1','0' UNION ALL

SELECT 'Oct 18 2008 6:32AM','86609945','39868749','1.53366e+009','5','461','1','0' UNION ALL

SELECT 'Oct 18 2008 6:35AM','86609857','39868850','1.63685e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:36AM','86609808','39868749','1.53366e+009','5','461','1','0' UNION ALL

SELECT 'Oct 18 2008 6:37AM','86609770','39868749','1.53366e+009','5','461','1','0' UNION ALL

SELECT 'Oct 18 2008 6:38AM','86609830','39868903','1.45037e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:39AM','86609812','39868909','5.38717e+007','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 6:39AM','86605517','39868925','6.00302e+008','3','24','0','0' UNION ALL

SELECT 'Oct 18 2008 6:39AM','86605518','39868925','6.00302e+008','3','24','0','0' UNION ALL

SELECT 'Oct 18 2008 6:40AM','86621488','39868925','6.00302e+008','3','24','0','0' UNION ALL

SELECT 'Oct 18 2008 6:42AM','86618389','39868961','1.08429e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:46AM','86618223','39869027','4.48171e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:49AM','86618182','39869078','1.65026e+009','2','194','1','0' UNION ALL

SELECT 'Oct 18 2008 6:50AM','86618487','39869101','2.1996e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:51AM','86618331','39869119','1.95518e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:52AM','86618183','39869078','1.65026e+009','2','194','1','0' UNION ALL

SELECT 'Oct 18 2008 6:53AM','86618470','39869166','1.98728e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:53AM','86614444','39869167','1.43611e+008','4','205','1','0' UNION ALL

SELECT 'Oct 18 2008 6:53AM','86614445','39869167','1.43611e+008','4','205','1','0' UNION ALL

SELECT 'Oct 18 2008 6:54AM','86618298','39869167','1.43611e+008','4','205','1','0' UNION ALL

SELECT 'Oct 18 2008 6:54AM','86618460','39869186','1.26995e+009','2','92','1','0' UNION ALL

SELECT 'Oct 18 2008 6:55AM','86618438','39869194','1.57278e+009','2','62','1','0' UNION ALL

SELECT 'Oct 18 2008 6:55AM','86618380','39869202','1.74338e+009','2','144','1','0' UNION ALL

SELECT 'Oct 18 2008 6:56AM','86618372','39869194','1.57278e+009','2','62','1','0' UNION ALL

SELECT 'Oct 18 2008 6:56AM','86618458','39869186','1.26995e+009','2','92','1','0' UNION ALL

SELECT 'Oct 18 2008 6:56AM','86618495','39869224','7.28826e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 6:56AM','86618381','39869231','1.07754e+009','3','306','1','0' UNION ALL

SELECT 'Oct 18 2008 6:57AM','86618297','39869167','1.43611e+008','4','205','1','0' UNION ALL

SELECT 'Oct 18 2008 6:57AM','86621575','39869202','1.74338e+009','2','144','1','0' UNION ALL

SELECT 'Oct 18 2008 6:58AM','86618928','39869255','3.61985e+008','2','453','1','1' UNION ALL

SELECT 'Oct 18 2008 6:58AM','86618245','39869257','5.66032e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:01AM','86618227','39869231','1.07754e+009','3','306','1','0' UNION ALL

SELECT 'Oct 18 2008 7:01AM','86618383','39869231','1.07754e+009','3','306','1','0' UNION ALL

SELECT 'Oct 18 2008 7:03AM','86618301','39869366','5.40125e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:05AM','86618248','39869408','5.87621e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:05AM','86618448','39869255','3.61985e+008','2','453','1','1' UNION ALL

SELECT 'Oct 18 2008 7:06AM','86618145','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:06AM','86618787','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:07AM','86618765','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:07AM','86618785','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:07AM','86618767','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618783','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618761','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618347','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618791','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618789','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618763','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618287','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:08AM','86618793','39869430','1.02046e+009','11','112','1','0' UNION ALL

SELECT 'Oct 18 2008 7:09AM','86618378','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:09AM','86618396','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:10AM','86618462','39869492','6.30904e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:11AM','86618339','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:12AM','86618285','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:12AM','86618341','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:12AM','86618398','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:12AM','86618219','39869536','4.87535e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:13AM','86618193','39869541','2.0174e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:13AM','86618343','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:13AM','86618283','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:14AM','86618415','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:14AM','86618221','39869577','1.89941e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:15AM','86618181','39869584','1.54317e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:15AM','86618427','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:15AM','86618370','39869591','8.42993e+007','3','723','1','0' UNION ALL

SELECT 'Oct 18 2008 7:15AM','86618345','39869453','3.5926e+008','13','452','0','0' UNION ALL

SELECT 'Oct 18 2008 7:16AM','86618360','39869611','4.77059e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:16AM','86618363','39869622','4.17413e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:19AM','86618365','39869655','1.3139e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:19AM','86613853','39869658','1.39169e+009','4','92','1','0' UNION ALL

SELECT 'Oct 18 2008 7:19AM','86613854','39869658','1.39169e+009','4','92','1','0' UNION ALL

SELECT 'Oct 18 2008 7:19AM','86618153','39869658','1.39169e+009','4','92','1','0' UNION ALL

SELECT 'Oct 18 2008 7:20AM','86618374','39869679','6.19978e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:20AM','86618155','39869658','1.39169e+009','4','92','1','0' UNION ALL

SELECT 'Oct 18 2008 7:22AM','86618157','39869730','8.16599e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 7:23AM','86621705','39869750','8.91112e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:24AM','86618175','39869756','1.30148e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:27AM','86618279','39869591','8.42993e+007','3','723','1','0' UNION ALL

SELECT 'Oct 18 2008 7:27AM','86618231','39869591','8.42993e+007','3','723','1','0' UNION ALL

SELECT 'Oct 18 2008 7:30AM','86618435','39869878','2.12781e+009','2','8','1','0' UNION ALL

SELECT 'Oct 18 2008 7:30AM','86618174','39869878','2.12781e+009','2','8','1','0' UNION ALL

SELECT 'Oct 18 2008 7:30AM','86618141','39869898','1.79648e+009','3','62','1','0' UNION ALL

SELECT 'Oct 18 2008 7:31AM','86618143','39869898','1.79648e+009','3','62','1','0' UNION ALL

SELECT 'Oct 18 2008 7:31AM','86618281','39869917','1.17221e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:31AM','86618217','39869898','1.79648e+009','3','62','1','0' UNION ALL

SELECT 'Oct 18 2008 7:37AM','86618163','39870025','9.74546e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:37AM','86618184','39870027','6.36612e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:41AM','86618371','39870133','1.82071e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:44AM','86613746','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:44AM','86618129','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:44AM','86618195','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:45AM','86618162','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:45AM','86618213','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:45AM','86618197','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:46AM','86618471','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:46AM','86618413','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:46AM','86618411','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:46AM','86618407','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:47AM','86618409','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:47AM','86618403','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:47AM','86618405','39870195','1.95992e+008','13','195','0','0' UNION ALL

SELECT 'Oct 18 2008 7:52AM','86618361','39870392','1.71157e+009','6','197','1','0' UNION ALL

SELECT 'Oct 18 2008 7:54AM','86618191','39870392','1.71157e+009','6','197','1','0' UNION ALL

SELECT 'Oct 18 2008 7:54AM','86613676','39870436','1.82904e+009','2','42','1','0' UNION ALL

SELECT 'Oct 18 2008 7:54AM','86618391','39870392','1.71157e+009','6','197','1','0' UNION ALL

SELECT 'Oct 18 2008 7:55AM','86613673','39870436','1.82904e+009','2','42','1','0' UNION ALL

SELECT 'Oct 18 2008 7:55AM','86618329','39870392','1.71157e+009','6','197','1','0' UNION ALL

SELECT 'Oct 18 2008 7:55AM','86618433','39870468','7.99109e+008','6','326','1','0' UNION ALL

SELECT 'Oct 18 2008 7:55AM','86618249','39870392','1.71157e+009','6','197','1','0' UNION ALL

SELECT 'Oct 18 2008 7:55AM','86618455','39870392','1.71157e+009','6','197','1','0' UNION ALL

SELECT 'Oct 18 2008 7:56AM','86618507','39870478','3.94948e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 7:56AM','86618131','39870468','7.99109e+008','6','326','1','0' UNION ALL

SELECT 'Oct 18 2008 7:58AM','86618139','39870468','7.99109e+008','6','326','1','0' UNION ALL

SELECT 'Oct 18 2008 7:58AM','86618315','39870540','8.48927e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 7:59AM','86618773','39870468','7.99109e+008','6','326','1','0' UNION ALL

SELECT 'Oct 18 2008 8:00AM','86618771','39870468','7.99109e+008','6','326','1','0' UNION ALL

SELECT 'Oct 18 2008 8:00AM','86618257','39870595','1.26444e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618319','39870468','7.99109e+008','6','326','1','0' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618165','39870609','2.11829e+009','5','283','1','0' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618151','39870611','1.50468e+009','4','52','0','0' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618443','39870618','1.71682e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618161','39870622','9.08794e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618187','39870611','1.50468e+009','4','52','0','0' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618327','39870609','2.11829e+009','5','283','1','0' UNION ALL

SELECT 'Oct 18 2008 8:01AM','86618189','39870611','1.50468e+009','4','52','0','0' UNION ALL

SELECT 'Oct 18 2008 8:02AM','86618393','39870611','1.50468e+009','4','52','0','0' UNION ALL

SELECT 'Oct 18 2008 8:04AM','86613230','39870609','2.11829e+009','5','283','1','0' UNION ALL

SELECT 'Oct 18 2008 8:04AM','86618333','39870686','3.60923e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:05AM','86613232','39870609','2.11829e+009','5','283','1','0' UNION ALL

SELECT 'Oct 18 2008 8:05AM','86618305','39870727','8.13748e+007','2','952','1','1' UNION ALL

SELECT 'Oct 18 2008 8:06AM','86616111','39870732','1.74479e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:06AM','86613235','39870609','2.11829e+009','5','283','1','0' UNION ALL

SELECT 'Oct 18 2008 8:08AM','86618445','39870798','7.48762e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:08AM','86618562','39870806','2.12167e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:09AM','86618295','39870816','1.62538e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:09AM','86618517','39870837','1.12113e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:11AM','86618576','39870889','2.0613e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:13AM','86618473','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:13AM','86618199','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:13AM','86618242','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:14AM','86618201','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:14AM','86618267','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:14AM','86618234','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618229','39870968','2.75291e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618238','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618236','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618299','39870982','1.16648e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618167','39870986','4.56935e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618440','39870992','1.87255e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618269','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:15AM','86618203','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:16AM','86618544','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:16AM','86618233','39871012','5.2014e+008','3','619','1','0' UNION ALL

SELECT 'Oct 18 2008 8:16AM','86618271','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618137','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618775','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618349','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618493','39871051','1.39034e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618290','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618420','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618770','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618425','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618353','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618423','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:17AM','86618351','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:18AM','86618421','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:18AM','86618417','39871049','3.76367e+008','9','31','0','0' UNION ALL

SELECT 'Oct 18 2008 8:18AM','86618332','39871012','5.2014e+008','3','619','1','0' UNION ALL

SELECT 'Oct 18 2008 8:19AM','86618255','39871114','8.23581e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:20AM','86618777','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:20AM','86618779','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:20AM','86618781','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:20AM','86618127','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:20AM','86618211','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:20AM','86618205','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:21AM','86618401','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:21AM','86618207','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:21AM','86618464','39871150','4.76225e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:21AM','86618273','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:21AM','86618240','39870918','1.95992e+008','25','512','0','0' UNION ALL

SELECT 'Oct 18 2008 8:21AM','86618303','39870727','8.13748e+007','2','952','1','1' UNION ALL

SELECT 'Oct 18 2008 8:22AM','86618441','39871177','1.1163e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:22AM','86618431','39871187','3.30299e+007','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:24AM','86618251','39871240','1.12155e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:24AM','86614446','39871242','2.34128e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:25AM','86613464','39871253','3.37002e+008','5','80','1','0' UNION ALL

SELECT 'Oct 18 2008 8:25AM','86618253','39871261','7.86206e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:25AM','86621489','39871253','3.37002e+008','5','80','1','0' UNION ALL

SELECT 'Oct 18 2008 8:25AM','86618180','39871253','3.37002e+008','5','80','1','0' UNION ALL

SELECT 'Oct 18 2008 8:26AM','86618124','39871253','3.37002e+008','5','80','1','0' UNION ALL

SELECT 'Oct 18 2008 8:26AM','86618179','39871253','3.37002e+008','5','80','1','0' UNION ALL

SELECT 'Oct 18 2008 8:26AM','86618133','39871012','5.2014e+008','3','619','1','0' UNION ALL

SELECT 'Oct 18 2008 8:26AM','86618357','39871282','1.28408e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:26AM','86618225','39871289','9.06232e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:27AM','86618323','39871306','3.67808e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 8:27AM','86618321','39871313','1.72675e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:27AM','86618309','39871323','1.07921e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:28AM','86618263','39871333','1.12987e+009','4','187','1','0' UNION ALL

SELECT 'Oct 18 2008 8:29AM','86618215','39871351','1.53864e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:30AM','86618169','39871410','6.65853e+008','3','81','1','0' UNION ALL

SELECT 'Oct 18 2008 8:30AM','86618160','39871419','1.04187e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 8:30AM','86618171','39871410','6.65853e+008','3','81','1','0' UNION ALL

SELECT 'Oct 18 2008 8:31AM','86618355','39871333','1.12987e+009','4','187','1','0' UNION ALL

SELECT 'Oct 18 2008 8:31AM','86618335','39871333','1.12987e+009','4','187','1','0' UNION ALL

SELECT 'Oct 18 2008 8:31AM','86618135','39871410','6.65853e+008','3','81','1','0' UNION ALL

SELECT 'Oct 18 2008 8:31AM','86618266','39871333','1.12987e+009','4','187','1','0' UNION ALL

SELECT 'Oct 18 2008 8:32AM','86618466','39871470','1.84627e+009','4','1110','1','0' UNION ALL

SELECT 'Oct 18 2008 8:32AM','86613407','39871489','1.12391e+009','2','2','1','0' UNION ALL

SELECT 'Oct 18 2008 8:32AM','86613408','39871489','1.12391e+009','2','2','1','0' UNION ALL

SELECT 'Oct 18 2008 8:35AM','86618437','39871564','8.94593e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:35AM','86618147','39871577','1.50122e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:37AM','86618367','39871633','1.26162e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 8:38AM','86618209','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:39AM','86618385','39871687','2.78724e+008','2','457','1','1' UNION ALL

SELECT 'Oct 18 2008 8:41AM','86613357','39871742','7.64876e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 8:41AM','86618307','39871710','1.74528e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:42AM','86618337','39871781','2.02934e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 8:42AM','86618325','39871788','1.83583e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:42AM','86618185','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:43AM','86618125','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:44AM','86618177','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:44AM','86618149','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:45AM','86618244','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:45AM','86618277','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:46AM','86618259','39871879','1.29646e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:46AM','86618293','39871886','1.63e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:46AM','86618275','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:46AM','86618262','39871894','1.91735e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:47AM','86627101','39871687','2.78724e+008','2','457','1','1' UNION ALL

SELECT 'Oct 18 2008 8:47AM','86626901','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:48AM','86626897','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:48AM','86626890','39871955','3.44882e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:48AM','86630431','39871963','6.98403e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 8:48AM','86626936','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:49AM','86626930','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:49AM','86626888','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:49AM','86627098','39871470','1.84627e+009','4','1110','1','0' UNION ALL

SELECT 'Oct 18 2008 8:49AM','86626893','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86626884','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86627026','39871470','1.84627e+009','4','1110','1','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86626899','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86626857','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86627096','39871470','1.84627e+009','4','1110','1','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86626882','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86626886','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86626937','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:50AM','86627116','39871661','1.86356e+009','8','727','0','0' UNION ALL

SELECT 'Oct 18 2008 8:51AM','86626949','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:51AM','86627050','39871837','1.74343e+009','15','422','1','0' UNION ALL

SELECT 'Oct 18 2008 8:51AM','86622682','39872047','1.5938e+009','3','40','1','0' UNION ALL

SELECT 'Oct 18 2008 8:51AM','86626832','39872062','1.74704e+009','2','6','0','0' UNION ALL

SELECT 'Oct 18 2008 8:52AM','86626928','39872062','1.74704e+009','2','6','0','0' UNION ALL

SELECT 'Oct 18 2008 8:52AM','86622661','39872047','1.5938e+009','3','40','1','0' UNION ALL

SELECT 'Oct 18 2008 8:52AM','86626892','39872047','1.5938e+009','3','40','1','0' UNION ALL

SELECT 'Oct 18 2008 8:53AM','86622666','39872099','1.43271e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:56AM','86622645','39872181','3.6606e+008','2','0','1','0' UNION ALL

SELECT 'Oct 18 2008 8:56AM','86622646','39872181','3.6606e+008','2','0','1','0' UNION ALL

SELECT 'Oct 18 2008 8:57AM','86627460','39872219','1.76826e+009','2','8','1','0' UNION ALL

SELECT 'Oct 18 2008 8:57AM','86627304','39872219','1.76826e+009','2','8','1','0' UNION ALL

SELECT 'Oct 18 2008 8:57AM','86626855','39872234','1.77359e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:58AM','86626927','39872254','1.45246e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 8:59AM','86622623','39872275','1.32988e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:00AM','86627143','39872308','5.6683e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:01AM','86626932','39872323','1.03161e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:01AM','86626974','39872342','4.24802e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:03AM','86627000','39872393','1.42149e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:06AM','86626941','39872499','1.84582e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:07AM','86626833','39872523','7.20872e+007','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:07AM','86626843','39872527','1.021e+009','4','105','1','0' UNION ALL

SELECT 'Oct 18 2008 9:07AM','86626989','39872527','1.021e+009','4','105','1','0' UNION ALL

SELECT 'Oct 18 2008 9:07AM','86627217','39872547','2.65652e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:08AM','86622568','39872554','1.35432e+009','4','96','1','0' UNION ALL

SELECT 'Oct 18 2008 9:08AM','86622569','39872554','1.35432e+009','4','96','1','0' UNION ALL

SELECT 'Oct 18 2008 9:08AM','86627090','39872527','1.021e+009','4','105','1','0' UNION ALL

SELECT 'Oct 18 2008 9:08AM','86626995','39872554','1.35432e+009','4','96','1','0' UNION ALL

SELECT 'Oct 18 2008 9:08AM','86627169','39872580','1.26775e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:09AM','86627008','39872527','1.021e+009','4','105','1','0' UNION ALL

SELECT 'Oct 18 2008 9:09AM','86626923','39872596','4.23647e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:09AM','86627135','39872554','1.35432e+009','4','96','1','0' UNION ALL

SELECT 'Oct 18 2008 9:10AM','86626841','39872631','1.97326e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:10AM','86626991','39872642','5.38266e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:10AM','86627137','39872664','1.19087e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:10AM','86626895','39872666','1.72572e+009','3','447','0','0' UNION ALL

SELECT 'Oct 18 2008 9:12AM','86622513','39872698','1.58254e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:13AM','86626881','39872719','1.34951e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:14AM','86627147','39872666','1.72572e+009','3','447','0','0' UNION ALL

SELECT 'Oct 18 2008 9:14AM','86626980','39872763','1.0904e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:16AM','86622492','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:16AM','86627235','39872840','1.21897e+009','2','11','1','0' UNION ALL

SELECT 'Oct 18 2008 9:16AM','86626978','39872840','1.21897e+009','2','11','1','0' UNION ALL

SELECT 'Oct 18 2008 9:17AM','86626845','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:17AM','86627063','39872892','1.00069e+009','2','57','1','0' UNION ALL

SELECT 'Oct 18 2008 9:17AM','86626839','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:18AM','86627171','39872666','1.72572e+009','3','447','0','0' UNION ALL

SELECT 'Oct 18 2008 9:18AM','86627069','39872915','8.23727e+008','7','330','1','0' UNION ALL

SELECT 'Oct 18 2008 9:18AM','86627061','39872892','1.00069e+009','2','57','1','0' UNION ALL

SELECT 'Oct 18 2008 9:18AM','86626861','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:19AM','86626939','39872957','1.54595e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:20AM','86627120','39872915','8.23727e+008','7','330','1','0' UNION ALL

SELECT 'Oct 18 2008 9:20AM','86627070','39872915','8.23727e+008','7','330','1','0' UNION ALL

SELECT 'Oct 18 2008 9:20AM','86627110','39872915','8.23727e+008','7','330','1','0' UNION ALL

SELECT 'Oct 18 2008 9:21AM','86626859','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:21AM','86622443','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:21AM','86622444','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86626926','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86627039','39873051','9.54509e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86626903','39873053','1.57853e+009','3','18','1','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86622451','39873055','1.52876e+009','3','15','0','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86626847','39873055','1.52876e+009','3','15','0','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86626929','39873060','5.03843e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86627024','39873055','1.52876e+009','3','15','0','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86626905','39873053','1.57853e+009','3','18','1','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86626907','39873053','1.57853e+009','3','18','1','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86622440','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:22AM','86626925','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:23AM','86627071','39872915','8.23727e+008','7','330','1','0' UNION ALL

SELECT 'Oct 18 2008 9:23AM','86627036','39873086','2.08606e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:23AM','86626853','39873097','7.75767e+008','6','164','0','0' UNION ALL

SELECT 'Oct 18 2008 9:23AM','86627121','39872915','8.23727e+008','7','330','1','0' UNION ALL

SELECT 'Oct 18 2008 9:23AM','86627080','39873110','1.61225e+009','2','197','1','0' UNION ALL

SELECT 'Oct 18 2008 9:23AM','86627072','39872915','8.23727e+008','7','330','1','0' UNION ALL

SELECT 'Oct 18 2008 9:24AM','86626994','39873097','7.75767e+008','6','164','0','0' UNION ALL

SELECT 'Oct 18 2008 9:24AM','86626938','39873097','7.75767e+008','6','164','0','0' UNION ALL

SELECT 'Oct 18 2008 9:25AM','86626911','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:25AM','86626993','39873097','7.75767e+008','6','164','0','0' UNION ALL

SELECT 'Oct 18 2008 9:25AM','86627145','39873162','1.66191e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:25AM','86626968','39873097','7.75767e+008','6','164','0','0' UNION ALL

SELECT 'Oct 18 2008 9:26AM','86627034','39873097','7.75767e+008','6','164','0','0' UNION ALL

SELECT 'Oct 18 2008 9:27AM','86627082','39873110','1.61225e+009','2','197','1','0' UNION ALL

SELECT 'Oct 18 2008 9:28AM','86626987','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:28AM','86627200','39873233','1.00263e+009','3','9','1','0' UNION ALL

SELECT 'Oct 18 2008 9:28AM','86627102','39873233','1.00263e+009','3','9','1','0' UNION ALL

SELECT 'Oct 18 2008 9:28AM','86627129','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:28AM','86627198','39873233','1.00263e+009','3','9','1','0' UNION ALL

SELECT 'Oct 18 2008 9:28AM','86627020','39873252','5.42208e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:29AM','86622399','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:29AM','86621931','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:29AM','86626849','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:29AM','86626869','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:29AM','86627018','39873276','1.66989e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:30AM','86626950','39873294','1.18666e+009','2','10','0','0' UNION ALL

SELECT 'Oct 18 2008 9:30AM','86627173','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:30AM','86623048','39873294','1.18666e+009','2','10','0','0' UNION ALL

SELECT 'Oct 18 2008 9:30AM','86626875','39873307','7.13476e+007','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:30AM','86627153','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:30AM','86626917','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:30AM','86627073','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:31AM','86627175','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:31AM','86621934','39872835','1.88391e+008','8','942','0','0' UNION ALL

SELECT 'Oct 18 2008 9:32AM','86626919','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:32AM','86626867','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:32AM','86626865','39873370','6.22139e+008','6','309','1','0' UNION ALL

SELECT 'Oct 18 2008 9:32AM','86626921','39873040','5.00783e+008','12','643','1','0' UNION ALL

SELECT 'Oct 18 2008 9:32AM','86627075','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:33AM','86627125','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:33AM','86626880','39873370','6.22139e+008','6','309','1','0' UNION ALL

SELECT 'Oct 18 2008 9:33AM','86626837','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:33AM','86627122','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:33AM','86627177','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:33AM','86627151','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:34AM','86627179','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:34AM','86626835','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:34AM','86627127','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:34AM','86626863','39873370','6.22139e+008','6','309','1','0' UNION ALL

SELECT 'Oct 18 2008 9:35AM','86627022','39873370','6.22139e+008','6','309','1','0' UNION ALL

SELECT 'Oct 18 2008 9:35AM','86626913','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:35AM','86627074','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:35AM','86627076','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:35AM','86627068','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:35AM','86627109','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:35AM','86627088','39873494','8.5501e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86627016','39873370','6.22139e+008','6','309','1','0' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86627186','39873507','1.33837e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86627077','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86622340','39873514','1.92098e+008','4','87','1','0' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86626952','39873520','1.09644e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86622343','39873514','1.92098e+008','4','87','1','0' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86627060','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:36AM','86626856','39873529','8.33191e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86627118','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86626997','39873514','1.92098e+008','4','87','1','0' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86627119','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86627108','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86627067','39873312','1.56397e+009','13','403','1','0' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86626879','39873370','6.22139e+008','6','309','1','0' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86627106','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:37AM','86627111','39873514','1.92098e+008','4','87','1','0' UNION ALL

SELECT 'Oct 18 2008 9:38AM','86627042','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:38AM','86622357','39873572','3.17144e+008','3','67','1','0' UNION ALL

SELECT 'Oct 18 2008 9:39AM','86627149','39873572','3.17144e+008','3','67','1','0' UNION ALL

SELECT 'Oct 18 2008 9:39AM','86627131','39873572','3.17144e+008','3','67','1','0' UNION ALL

SELECT 'Oct 18 2008 9:40AM','86627032','39873643','5.41099e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:40AM','86626998','39873660','4.32414e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:40AM','86622288','39873671','1.1957e+009','2','0','0','0' UNION ALL

SELECT 'Oct 18 2008 9:40AM','86622289','39873671','1.1957e+009','2','0','0','0' UNION ALL

SELECT 'Oct 18 2008 9:41AM','86627233','39873679','1.22154e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:41AM','86627078','39873705','1.86982e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:41AM','86627123','39873296','4.44355e+007','12','669','0','0' UNION ALL

SELECT 'Oct 18 2008 9:42AM','86627196','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:42AM','86627048','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:43AM','86626909','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:44AM','86627046','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:44AM','86627044','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:44AM','86627163','39873807','4.64412e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:46AM','86627014','39873855','1.14009e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:46AM','86627207','39873859','2.27519e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:46AM','86627277','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:47AM','86627114','39873889','1.67586e+009','3','80','1','0' UNION ALL

SELECT 'Oct 18 2008 9:47AM','86627161','39873889','1.67586e+009','3','80','1','0' UNION ALL

SELECT 'Oct 18 2008 9:47AM','86627052','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:48AM','86627112','39873889','1.67586e+009','3','80','1','0' UNION ALL

SELECT 'Oct 18 2008 9:48AM','86627181','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:49AM','86627228','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:49AM','86627202','39873228','5.71325e+008','11','1260','1','0' UNION ALL

SELECT 'Oct 18 2008 9:49AM','86627006','39873977','8.13748e+007','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:50AM','86626976','39874008','7.18238e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:50AM','86627058','39874019','1.88181e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:51AM','86627182','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:51AM','86627229','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:51AM','86627185','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:51AM','86627190','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:52AM','86627257','39874089','8.69165e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:52AM','86627183','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:52AM','86627139','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:53AM','86627184','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:53AM','86627191','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:53AM','86627227','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:53AM','86627214','39873472','2.05909e+009','13','1077','0','0' UNION ALL

SELECT 'Oct 18 2008 9:54AM','86626943','39874153','3.92521e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:56AM','86626972','39874224','3.45668e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:56AM','86623843','39874226','9.61303e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:56AM','86627140','39874236','5.24411e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 9:57AM','86627040','39874269','1.1409e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:58AM','86626915','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 9:59AM','86622129','39874309','3.17144e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 9:59AM','86622131','39874312','2.13262e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:00AM','86627347','39874349','4.17137e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:00AM','86626981','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:01AM','86626970','39874388','7.5601e+008','2','59','0','0' UNION ALL

SELECT 'Oct 18 2008 10:02AM','86626851','39874452','1.04912e+009','5','269','1','0' UNION ALL

SELECT 'Oct 18 2008 10:02AM','86621992','39874442','1.88391e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 10:02AM','86629953','39874388','7.5601e+008','2','59','0','0' UNION ALL

SELECT 'Oct 18 2008 10:02AM','86626954','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 10:02AM','86626945','39874452','1.04912e+009','5','269','1','0' UNION ALL

SELECT 'Oct 18 2008 10:02AM','86627104','39874452','1.04912e+009','5','269','1','0' UNION ALL

SELECT 'Oct 18 2008 10:02AM','86627521','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 10:03AM','86626871','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 10:03AM','86626964','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 10:03AM','86627155','39874452','1.04912e+009','5','269','1','0' UNION ALL

SELECT 'Oct 18 2008 10:04AM','86626947','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:04AM','86623051','39874489','6.06438e+008','6','122','1','0' UNION ALL

SELECT 'Oct 18 2008 10:04AM','86623050','39874489','6.06438e+008','6','122','1','0' UNION ALL

SELECT 'Oct 18 2008 10:05AM','86627222','39874519','5.15513e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:05AM','86626877','39874489','6.06438e+008','6','122','1','0' UNION ALL

SELECT 'Oct 18 2008 10:05AM','86623049','39874489','6.06438e+008','6','122','1','0' UNION ALL

SELECT 'Oct 18 2008 10:05AM','86626996','39874489','6.06438e+008','6','122','1','0' UNION ALL

SELECT 'Oct 18 2008 10:05AM','86626873','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86627519','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626956','39874282','4.70451e+007','8','481','1','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626934','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86627038','39874489','6.06438e+008','6','122','1','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626958','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626960','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626962','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626966','39874452','1.04912e+009','5','269','1','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86627133','39874575','9.57621e+008','5','853','0','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626983','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:06AM','86626985','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:07AM','86627054','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:07AM','86627056','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:07AM','86627188','39874595','7.53716e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:07AM','86627157','39874597','1.26351e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:08AM','86627086','39874622','1.94452e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:08AM','86627028','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:08AM','86627065','39874649','1.35606e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:08AM','86627159','39874652','1.51769e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:09AM','86627012','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:10AM','86627192','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627165','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627240','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627242','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627230','39874764','2.91442e+008','3','11','0','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627030','39874768','2.00104e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627092','39874764','2.91442e+008','3','11','0','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627094','39874764','2.91442e+008','3','11','0','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627084','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:11AM','86627204','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:12AM','86627002','39874809','1.83109e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:12AM','86627010','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:12AM','86627167','39874486','9.31744e+008','9','504','1','0' UNION ALL

SELECT 'Oct 18 2008 10:12AM','86627004','39874827','2.87068e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:13AM','86622008','39874842','1.04655e+009','3','51','1','0' UNION ALL

SELECT 'Oct 18 2008 10:14AM','86638627','39874842','1.04655e+009','3','51','1','0' UNION ALL

SELECT 'Oct 18 2008 10:14AM','86638625','39874842','1.04655e+009','3','51','1','0' UNION ALL

SELECT 'Oct 18 2008 10:14AM','86635685','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:14AM','86635684','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:14AM','86635480','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:14AM','86635891','39874888','4.25797e+008','2','25','1','1' UNION ALL

SELECT 'Oct 18 2008 10:14AM','86636025','39874890','1.28445e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635846','39874888','4.25797e+008','2','25','1','1' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635702','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635803','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635538','39874915','3.6098e+008','2','20','0','0' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635679','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635681','39874571','1.84378e+009','12','556','0','0' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635825','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:15AM','86635627','39874915','3.6098e+008','2','20','0','0' UNION ALL

SELECT 'Oct 18 2008 10:16AM','86635804','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:16AM','86635925','39874931','1.04144e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:16AM','86635826','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:16AM','86635802','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635827','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635801','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635445','39874972','1.27603e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635828','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635893','39874974','1.87301e+009','2','54','1','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635406','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635796','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635404','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635453','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:17AM','86635800','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:18AM','86635479','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:18AM','86635402','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:18AM','86635897','39874575','9.57621e+008','5','853','0','0' UNION ALL

SELECT 'Oct 18 2008 10:18AM','86635595','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:18AM','86636010','39874974','1.87301e+009','2','54','1','0' UNION ALL

SELECT 'Oct 18 2008 10:18AM','86635708','39875017','1.1009e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:18AM','86635805','39875020','2.01454e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:19AM','86635706','39875030','1.06455e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:19AM','86635665','39874575','9.57621e+008','5','853','0','0' UNION ALL

SELECT 'Oct 18 2008 10:19AM','86635455','39874575','9.57621e+008','5','853','0','0' UNION ALL

SELECT 'Oct 18 2008 10:19AM','86635593','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:19AM','86635490','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:19AM','86635588','39875059','3.19734e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 10:20AM','86635718','39875063','5.7513e+008','7','160','0','0' UNION ALL

SELECT 'Oct 18 2008 10:20AM','86635504','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:20AM','86635546','39875068','1.05651e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:20AM','86631384','39875070','1.20869e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 10:20AM','86635663','39874575','9.57621e+008','5','853','0','0' UNION ALL

SELECT 'Oct 18 2008 10:20AM','86635601','39875080','1.60183e+009','2','393','1','0' UNION ALL

SELECT 'Oct 18 2008 10:21AM','86635653','39875063','5.7513e+008','7','160','0','0' UNION ALL

SELECT 'Oct 18 2008 10:21AM','86635488','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:21AM','86635473','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:21AM','86635562','39875063','5.7513e+008','7','160','0','0' UNION ALL

SELECT 'Oct 18 2008 10:21AM','86635651','39875063','5.7513e+008','7','160','0','0' UNION ALL

SELECT 'Oct 18 2008 10:21AM','86635720','39875063','5.7513e+008','7','160','0','0' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635399','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635470','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635400','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635776','39875063','5.7513e+008','7','160','0','0' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635875','39875132','1.42352e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635465','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635932','39875143','4.12738e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:22AM','86635722','39875063','5.7513e+008','7','160','0','0' UNION ALL

SELECT 'Oct 18 2008 10:23AM','86631424','39875160','3.36008e+007','4','97','1','0' UNION ALL

SELECT 'Oct 18 2008 10:23AM','86635748','39875171','1.95353e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:23AM','86635633','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:24AM','86635437','39875160','3.36008e+007','4','97','1','0' UNION ALL

SELECT 'Oct 18 2008 10:24AM','86635641','39875197','5.57393e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:24AM','86635840','39875160','3.36008e+007','4','97','1','0' UNION ALL

SELECT 'Oct 18 2008 10:24AM','86636023','39875203','6.41123e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:24AM','86635813','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:24AM','86635942','39875160','3.36008e+007','4','97','1','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635784','39875250','9.73785e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635467','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635408','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635469','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635398','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635475','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635487','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635598','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635477','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86636018','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635795','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86633065','39875257','1.34782e+009','4','56','0','0' UNION ALL

SELECT 'Oct 18 2008 10:25AM','86635699','39874360','6.22139e+008','38','1531','0','0' UNION ALL

SELECT 'Oct 18 2008 10:26AM','86635560','39875257','1.34782e+009','4','56','0','0' UNION ALL

SELECT 'Oct 18 2008 10:26AM','86636118','39875257','1.34782e+009','4','56','0','0' UNION ALL

SELECT 'Oct 18 2008 10:26AM','86635760','39875284','1.57571e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:26AM','86635430','39875287','1.53683e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:26AM','86635558','39875257','1.34782e+009','4','56','0','0' UNION ALL

SELECT 'Oct 18 2008 10:27AM','86635786','39875306','1.51886e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:27AM','86635522','39875080','1.60183e+009','2','393','1','0' UNION ALL

SELECT 'Oct 18 2008 10:27AM','86635940','39875337','4.32963e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:28AM','86635834','39875345','1.1575e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:28AM','86635436','39875359','2.39292e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:29AM','86635830','39875371','9.93492e+008','3','232','1','0' UNION ALL

SELECT 'Oct 18 2008 10:29AM','86635485','39875388','1.43832e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:30AM','86635478','39875406','6.22139e+008','3','236','0','0' UNION ALL

SELECT 'Oct 18 2008 10:30AM','86635832','39875371','9.93492e+008','3','232','1','0' UNION ALL

SELECT 'Oct 18 2008 10:31AM','86635448','39875445','2.00748e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:31AM','86635839','39875449','2.27626e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:31AM','86635982','39875456','2.01785e+009','2','6','1','0' UNION ALL

SELECT 'Oct 18 2008 10:31AM','86635984','39875456','2.01785e+009','2','6','1','0' UNION ALL

SELECT 'Oct 18 2008 10:32AM','86635410','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:32AM','86635716','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:32AM','86635584','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:32AM','86635917','39875371','9.93492e+008','3','232','1','0' UNION ALL

SELECT 'Oct 18 2008 10:33AM','86638235','39875406','6.22139e+008','3','236','0','0' UNION ALL

SELECT 'Oct 18 2008 10:33AM','86635790','39875406','6.22139e+008','3','236','0','0' UNION ALL

SELECT 'Oct 18 2008 10:34AM','86635714','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:34AM','86635871','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:34AM','86635712','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:34AM','86635710','39875548','1.71682e+009','2','669','0','1' UNION ALL

SELECT 'Oct 18 2008 10:34AM','86635412','39874976','1.81743e+009','12','1026','1','0' UNION ALL

SELECT 'Oct 18 2008 10:35AM','86637285','39875582','5.23125e+007','4','456','1','0' UNION ALL

SELECT 'Oct 18 2008 10:35AM','86635732','39875582','5.23125e+007','4','456','1','0' UNION ALL

SELECT 'Oct 18 2008 10:36AM','86635414','39875611','4.49938e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:36AM','86635989','39875639','5.46195e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:36AM','86635899','39875582','5.23125e+007','4','456','1','0' UNION ALL

SELECT 'Oct 18 2008 10:39AM','86635677','39875727','1.93914e+009','2','40','1','0' UNION ALL

SELECT 'Oct 18 2008 10:40AM','86635700','39875727','1.93914e+009','2','40','1','0' UNION ALL

SELECT 'Oct 18 2008 10:40AM','86635457','39875752','9.57621e+008','4','499','0','0' UNION ALL

SELECT 'Oct 18 2008 10:40AM','86635873','39875752','9.57621e+008','4','499','0','0' UNION ALL

SELECT 'Oct 18 2008 10:40AM','86635629','39875766','1.71494e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:41AM','86635923','39875789','9.56943e+007','2','589','1','1' UNION ALL

SELECT 'Oct 18 2008 10:41AM','86638629','39875803','1.15647e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:42AM','86631237','39875837','1.36261e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:42AM','86635694','39875852','1.07579e+009','5','72','1','0' UNION ALL

SELECT 'Oct 18 2008 10:43AM','86635876','39875582','5.23125e+007','4','456','1','0' UNION ALL

SELECT 'Oct 18 2008 10:43AM','86635731','39875852','1.07579e+009','5','72','1','0' UNION ALL

SELECT 'Oct 18 2008 10:43AM','86635693','39875852','1.07579e+009','5','72','1','0' UNION ALL

SELECT 'Oct 18 2008 10:43AM','86635730','39875852','1.07579e+009','5','72','1','0' UNION ALL

SELECT 'Oct 18 2008 10:44AM','86635728','39875852','1.07579e+009','5','72','1','0' UNION ALL

SELECT 'Oct 18 2008 10:44AM','86631249','39875888','6.93034e+008','6','115','1','0' UNION ALL

SELECT 'Oct 18 2008 10:44AM','86631250','39875888','6.93034e+008','6','115','1','0' UNION ALL

SELECT 'Oct 18 2008 10:44AM','86635752','39875893','1.38665e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:44AM','86635472','39875888','6.93034e+008','6','115','1','0' UNION ALL

SELECT 'Oct 18 2008 10:44AM','86636427','39875912','1.25573e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 10:45AM','86635980','39875983','1.11907e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:45AM','86635815','39875548','1.71682e+009','2','669','0','1' UNION ALL

SELECT 'Oct 18 2008 10:45AM','86635471','39875888','6.93034e+008','6','115','1','0' UNION ALL

SELECT 'Oct 18 2008 10:45AM','86631226','39875888','6.93034e+008','6','115','1','0' UNION ALL

SELECT 'Oct 18 2008 10:45AM','86631227','39875888','6.93034e+008','6','115','1','0' UNION ALL

SELECT 'Oct 18 2008 10:45AM','86635836','39875930','3.29979e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:46AM','86635895','39875942','1.18583e+009','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 10:47AM','86635762','39875996','7.60743e+008','13','1325','1','0' UNION ALL

SELECT 'Oct 18 2008 10:48AM','86635459','39875752','9.57621e+008','4','499','0','0' UNION ALL

SELECT 'Oct 18 2008 10:48AM','86635667','39875752','9.57621e+008','4','499','0','0' UNION ALL

SELECT 'Oct 18 2008 10:50AM','86635566','39876096','1.15206e+009','9','1200','1','0' UNION ALL

SELECT 'Oct 18 2008 10:50AM','86635788','39876096','1.15206e+009','9','1200','1','0' UNION ALL

SELECT 'Oct 18 2008 10:50AM','86635387','39876117','6.02705e+008','6','815','0','0' UNION ALL

SELECT 'Oct 18 2008 10:51AM','86635961','39875789','9.56943e+007','2','589','1','1' UNION ALL

SELECT 'Oct 18 2008 10:51AM','86635542','39876117','6.02705e+008','6','815','0','0' UNION ALL

SELECT 'Oct 18 2008 10:52AM','86635564','39876096','1.15206e+009','9','1200','1','0' UNION ALL

SELECT 'Oct 18 2008 10:52AM','86635823','39876182','8.8496e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:52AM','86635798','39876096','1.15206e+009','9','1200','1','0' UNION ALL

SELECT 'Oct 18 2008 10:53AM','86635639','39876197','1.89685e+009','3','408','1','0' UNION ALL

SELECT 'Oct 18 2008 10:53AM','86635901','39876202','8.90093e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:54AM','86635999','39876197','1.89685e+009','3','408','1','0' UNION ALL

SELECT 'Oct 18 2008 10:55AM','86635568','39876096','1.15206e+009','9','1200','1','0' UNION ALL

SELECT 'Oct 18 2008 10:55AM','86631130','39876267','3.829e+008','3','9','1','0' UNION ALL

SELECT 'Oct 18 2008 10:55AM','86631132','39876271','8.24697e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:55AM','86635463','39876267','3.829e+008','3','9','1','0' UNION ALL

SELECT 'Oct 18 2008 10:55AM','86635631','39876267','3.829e+008','3','9','1','0' UNION ALL

SELECT 'Oct 18 2008 10:56AM','86635586','39876300','8.64415e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 10:56AM','86631106','39876304','4.07641e+008','6','59','1','0' UNION ALL

SELECT 'Oct 18 2008 10:56AM','86631108','39876304','4.07641e+008','6','59','1','0' UNION ALL

SELECT 'Oct 18 2008 10:56AM','86635506','39876304','4.07641e+008','6','59','1','0' UNION ALL

SELECT 'Oct 18 2008 10:56AM','86635764','39875996','7.60743e+008','13','1325','1','0' UNION ALL

SELECT 'Oct 18 2008 10:56AM','86631101','39876304','4.07641e+008','6','59','1','0' UNION ALL

SELECT 'Oct 18 2008 10:57AM','86635910','39876330','2.12836e+009','2','52','1','0' UNION ALL

SELECT 'Oct 18 2008 10:57AM','86631114','39876304','4.07641e+008','6','59','1','0' UNION ALL

SELECT 'Oct 18 2008 10:57AM','86631115','39876304','4.07641e+008','6','59','1','0' UNION ALL

SELECT 'Oct 18 2008 10:57AM','86635389','39876117','6.02705e+008','6','815','0','0' UNION ALL

SELECT 'Oct 18 2008 10:57AM','86635540','39876117','6.02705e+008','6','815','0','0' UNION ALL

SELECT 'Oct 18 2008 10:57AM','86631121','39876352','1.07833e+009','18','910','1','0' UNION ALL

SELECT 'Oct 18 2008 10:57AM','86635930','39876330','2.12836e+009','2','52','1','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635750','39876364','1.67987e+009','5','461','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635615','39876352','1.07833e+009','18','910','1','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635734','39876364','1.67987e+009','5','461','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86631123','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86631124','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635383','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635619','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635880','39876364','1.67987e+009','5','461','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635647','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635649','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:58AM','86635645','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:59AM','86635613','39876404','8.00494e+008','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 10:59AM','86635691','39876352','1.07833e+009','18','910','1','0' UNION ALL

SELECT 'Oct 18 2008 10:59AM','86635617','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:59AM','86635536','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:59AM','86635625','39876372','9.38393e+008','10','95','0','0' UNION ALL

SELECT 'Oct 18 2008 10:59AM','86635938','39876197','1.89685e+009','3','408','1','0' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635768','39876437','4.89059e+007','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635858','39876440','9.71716e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635611','39876352','1.07833e+009','18','910','1','0' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635903','39876450','6.14124e+008','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635590','39876352','1.07833e+009','18','910','1','0' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635609','39876352','1.07833e+009','18','910','1','0' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635766','39875996','7.60743e+008','13','1325','1','0' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86635481','39876460','1.00367e+009','2','244','1','0' UNION ALL

SELECT 'Oct 18 2008 11:00AM','86636429','39876464','1.31799e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 11:01AM','86635724','39875996','7.60743e+008','13','1325','1','0' UNION ALL

SELECT 'Oct 18 2008 11:01AM','86635578','39875996','7.60743e+008','13','1325','1','0' UNION ALL

SELECT 'Oct 18 2008 11:02AM','86635995','39876525','6.6708e+008','3','499','0','0' UNION ALL

SELECT 'Oct 18 2008 11:03AM','86635774','39876551','1.14208e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 11:03AM','86635993','39876525','6.6708e+008','3','499','0','0' UNION ALL

SELECT 'Oct 18 2008 11:03AM','86636006','39876561','2.10205e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 11:03AM','86635451','39876569','7.36187e+008','18','730','1','0' UNION ALL

SELECT 'Oct 18 2008 11:03AM','86635550','39876569','7.36187e+008','18','730','1','0' UNION ALL

SELECT 'Oct 18 2008 11:03AM','86635438','39876575','3.36008e+007','1','0','0','1' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635574','39876580','1.43347e+009','3','195','0','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635385','39876117','6.02705e+008','6','815','0','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635544','39876117','6.02705e+008','6','815','0','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86636120','39876569','7.36187e+008','18','730','1','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635772','39876605','1.55102e+009','1','0','1','1' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635552','39876569','7.36187e+008','18','730','1','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635449','39876569','7.36187e+008','18','730','1','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86631019','39876622','1.56208e+009','5','100','1','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86631020','39876622','1.56208e+009','5','100','1','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635482','39876460','1.00367e+009','2','244','1','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635792','39876569','7.36187e+008','18','730','1','0' UNION ALL

SELECT 'Oct 18 2008 11:04AM','86635512','39876622','1.56208e+009','5','100','1','0' UNION ALL

SELECT 'Oct 18 2008 11:05AM','86635516','39876622','1.56208e+009','5','100','1','0' UNION ALL

SELECT 'Oct 18 2008 11:05AM','86635740','39876636','1.52314e+009','2','10','1','0' UNION ALL

SELECT 'Oct 18 2008 11:05AM','86635904','39876642','1.26718e+008','3','681','1','0' UNION ALL

SELECT 'Oct 18 2008 11:05AM','86635514','39876636','1.52314e+009','2','10','1','0' UNION ALL

SELECT 'Oct 18 2008 11:05AM','86635736','39876364','1.67987e+009','5','461','0','0' UNION ALL

SELECT 'Oct 18 2008 11:05AM','86636052','39876642','1.26718e+008','3','681','1','0'

/*

select count(distinct cookieNumber) as nbvisitors,

count(distinct fk_tbl_visits_id) as nbVisits,

sum(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

sum(cast(isNewVisit as tinyint)) as nbNewVisits,

sum(cast(isRebound as tinyint)) as nbRebounds

from (

select

cookieNumber,

fk_tbl_visits_id,

nbPageViews,

visitLength,

isNewVisit,

isRebound,

row_number() over(partition by fk_tbl_visits_id order by id desc) as rn

from #tbl_logs

where date between '2008-10-06 00:00:00' and '2009-05-06 23:59:00'

) x where rn = 1*/

select count(distinct cookieNumber) as nbvisitors,

count(distinct fk_tbl_visits_id) as nbVisits,

sum(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

sum(cast(isNewVisit as tinyint)) as nbNewVisits,

sum(cast(isRebound as tinyint)) as nbRebounds from (

select

max(cookieNumber) as cookieNumber,

fk_tbl_visits_id,

avg(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

max(cast(isNewVisit as tinyint)) as isNewVisit,

max(cast(isRebound as tinyint)) as isRebound

from #tbl_logs

where date between '2008-01-01 00:00:00' and '2009-05-05 23:59:00'

group by fk_tbl_visits_id

) x

drop table #tbl_logs

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Yep, ran 3 seconds for me too, when I was asking for the Actual Execution Plan. If I turned that off, the query returned in less than a second.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 6

Okay, I used RedGate SQLGenerator to put 100,000 rows in the table and ran these 3 queries which all returned the same results:

DBCC FREEPROCCACHE()

DBCC DROPCLEANBUFFERS()

SET STATISTICS IO ON

SET STATISTICS TIME ON

select

count(distinct cookieNumber) as nbvisitors,

count(distinct fk_tbl_visits_id) as nbVisits,

sum(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

sum(cast(isNewVisit as tinyint)) as nbNewVisits,

sum(cast(isRebound as tinyint)) as nbRebounds

from

(select

cookieNumber,

fk_tbl_visits_id,

nbPageViews,

visitLength,

isNewVisit,

isRebound,

row_number() over (partition by fk_tbl_visits_id order by id desc) as rn

from

tbl_logs

where

date between '2008-10-06 00:00:00'

and '2009-05-06 23:59:00') x

where

rn = 1

DBCC FREEPROCCACHE()

DBCC DROPCLEANBUFFERS()

SELECT

count(distinct cookieNumber) as nbvisitors,

count(distinct fk_tbl_visits_id) as nbVisits,

sum(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

sum(cast(isNewVisit as tinyint)) as nbNewVisits,

sum(cast(isRebound as tinyint)) as nbRebounds

FROM

tbl_logs AS TL

WHERE

id IN (Select

max(id) as id

From

tbl_logs

Where

date between '2008-10-06 00:00:00'

and '2009-05-06 23:59:00'

Group By

fk_tbl_visits_id) AND

date between '2008-10-06 00:00:00'

and '2009-05-06 23:59:00'

DBCC FREEPROCCACHE()

DBCC DROPCLEANBUFFERS()

SELECT

count(distinct cookieNumber) as nbvisitors,

count(distinct fk_tbl_visits_id) as nbVisits,

sum(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

sum(cast(isNewVisit as tinyint)) as nbNewVisits,

sum(cast(isRebound as tinyint)) as nbRebounds

FROM

tbl_logs AS TL Join

(Select

max(id) as id

From

tbl_logs

Where

date between '2008-10-06 00:00:00'

and '2009-05-06 23:59:00'

Group By

fk_tbl_visits_id) MAX_ID

ON TL.id = MAX_ID.id

WHERE

TL.date between '2008-10-06 00:00:00'

and '2009-05-06 23:59:00'

SET STATISTICS TIME OFF

SET STATISTICS IO OFF

Here are the results from STATISTICS IO And STATISTICS TIME:

ROW_NUMBER() Query
Table 'Worktable'. Scan count 3, logical reads 6044, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'tbl_logs'. Scan count 1, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 31 ms, elapsed time = 61 ms.
---------------------------------------------
Where ID IN SubSelect Query
Table 'Worktable'. Scan count 3, logical reads 6044, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'tbl_logs'. Scan count 2, logical reads 46, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
(1 row(s) affected)
SQL Server Execution Times:
CPU time = 47 ms, elapsed time = 92 ms.
--------------------------------------------
Derived Table Query
Table 'Worktable'. Scan count 3, logical reads 6044, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'tbl_logs'. Scan count 2, logical reads 46, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 47 ms, elapsed time = 82 ms.

The Row_Number() Query outperforms the others in all areas I can see.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Would not be surprised if the poor performance is due to returning the actual execution plan.

stephane3d Ten Centuries Points: 1129 More actions · Answer 8

I see...

Do you think there's something to do to get rid of the table spool?

Thanks a lot for your help, it's really appreciated

Stephane

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Why are you so concerned about getting rid of the table spool?

The following (I prebuilt and loaded the temp table with your sample data) ran in 11 ms:

Set NoCount On

Declare @cpu_ int

Declare @lreads_ int

Declare @eMsec_ int

Select

@cpu_ = cpu_time,

@lreads_ = logical_reads,

@eMsec_ = total_elapsed_time

From

sys.dm_exec_requests

Where

session_id = @@spid;

with VisitsInfo as (

select

max(cookieNumber) as cookieNumber,

fk_tbl_visits_id,

avg(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

max(cast(isNewVisit as tinyint)) as isNewVisit,

max(cast(isRebound as tinyint)) as isRebound

from

#tbl_logs

where

date between '2008-01-01 00:00:00' and '2009-05-05 23:59:00'

group by

fk_tbl_visits_id

)

select

count(distinct cookieNumber) as nbvisitors,

count(distinct fk_tbl_visits_id) as nbVisits,

sum(nbPageViews) as nbPageViews,

avg(visitLength) as visitLength,

sum(cast(isNewVisit as tinyint)) as nbNewVisits,

sum(cast(isRebound as tinyint)) as nbRebounds

from

VisitsInfo

Select

cpu_time-@cpu_ as CpuMs,

logical_reads- @lreads_ as LogRds,

total_elapsed_time - @eMsec_ as Elapsed

From

sys.dm_exec_requests

Where

session_id = @@spid;