Yes, I have an account

 
  indicates required field
Member Number:
 
Password:
 
 
 
  forgot your password?

No, I do not have an account

Not a Member?
Please enter your email address to access LiveTiming.

 
   Email Format

   Lists



ck
select ROW_NUMBER() OVER(ORDER BY min(driver.ft1320) asc, Max(driver.mph1320) Desc) AS 'RowNumber', 'TOP FUEL' as Category, min(timestamp) as [timestamp], driver.name, min(driver.ft1320) as ftp1320 from (select top 12 [name], min(ft1320) as ft1320, Max(mph1320) as mph1320 from EventLiveTiming where [timestamp] >= '5/20/2016 12:00:00 AM' and [timestamp] <= '5/22/2016 5:27:30 PM' and Category = 'TOP FUEL' and ft1320 <> 0 AND IsDq = 'false' group by [name] ORDER BY Min(ft1320) ASC, Max(mph1320) DESC Union select [name], min(ft1320) as ft1320, Max(mph1320) as mph1320 from EventLiveTiming where [timestamp] >= '5/20/2016 12:00:00 AM' and [timestamp] <= '5/22/2016 5:27:30 PM' and Category = 'TOP FUEL' and ft1320 <> 0 AND IsDq = 'false' group by [name]) as driver join EventLiveTiming as elt on elt.name = driver.name and elt.ft1320 = driver.ft1320 where elt.timestamp >= '5/20/2016 12:00:00 AM' and elt.timestamp <= '5/22/2016 5:27:30 PM' and elt.Category = 'TOP FUEL' AND elt.IsDq = 'false' group by driver.name order by min(driver.ft1320) asc, Max(driver.mph1320) Desc