select item events

gistfile1.sql

select 
	[Name],
	[Text],	
	[PageId],
	[IsGoal],
	[IsFailure],
	[RDNS],
	[BusinessName],
	[UserAgent],
	[DateTime],
    [ItemId]
from (
select
	[PageEventDefinitions].[Name],
	[PageEvents].[Text],	
	[PageEvents].[PageId],
	[PageEventDefinitions].[IsGoal],
	[PageEventDefinitions].[IsFailure],
	[Visits].RDNS,
	[Visits].[BusinessName],
	[UserAgents].[UserAgent],
	[PageEvents].[DateTime],
    [PageEvents].[ItemId],
    [PageEvents].[CustomSorting],
    [PageEvents].[Data],
	RANK() OVER(PARTITION BY [PageEvents].[VisitID] ORDER BY [PageEvents].[DateTime] desc) AS ClickNo
from
	[PageEvents],
	[PageEventDefinitions],
	[Visits],
	[UserAgents]
where 
	[PageEvents].[ItemId] = @Id AND
	[PageEvents].[VisitId] = [Visits].[VisitId] AND
	[Visits].[UserAgentId] = [UserAgents].[UserAgentId] AND
	[PageEvents].[PageEventDefinitionId] = [PageEventDefinitions].[PageEventDefinitionId] AND
	[PageEventDefinitions].[IsSystem] = 0 
) AllVisits
where ClickNo = 1
order by 
	[CustomSorting],
	[DateTime] desc,
	[Name],
	[Data]