GetSiteLog8 [dnn:portalid],'','2005-1-1','2005-12-31'

select top 1 DateTime, cast(DateDiff(minute,DateTime,getDate())/60.00 as
decimal(9,2) ) AS [Hours Ago] 
from sitelog where portalid = [DNN:PortalId]
and useragent like '%googlebot%'
order by DateTime Desc

select  top 10
substring(substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)),1,
patindex('%/%',substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)))-1) Domain
,count(*) Referrals
from sitelog 
where referrer is not null
and referrer not like '%dnnstuff.com%'
and referrer like '%://%'
and portalid = [DNN:PortalId]
and datediff(minute,datetime,getdate()) <=360
group by substring(substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)),1,
patindex('%/%',substring(referrer,patindex('%://%',referrer)+3,LEN(referrer)))-1)
order by count(*) desc