SELECT DISTINCT TOP 10000 
   COUNT(DISTINCT("User"."IpPerson")) AS C3,
   "User"."IpPerson" AS C5,
   "activesession"."creationtime" AS C7,
   "User"."FullName" AS C9,
   "User Role Details"."ShortDescription" AS C11
FROM "Person" AS "User"
INNER JOIN "StaffMemberRole" AS "User Role"
ON (
   "User"."ipperson" = "User Role"."ipemployee"
)
INNER JOIN "OrgReferenceCodeDesc" AS "User Role Details"
ON (
   "User Role"."rolecode" = "User Role Details"."refcode"
)
LEFT OUTER JOIN "ActiveSession" AS "activesession"
ON (
   "User"."ipperson" = "activesession"."entityid"
)
WHERE (
   "activesession"."creationtime" IS NOT NULL
)
GROUP BY 
   "User Role Details"."ShortDescription",
   "User"."IpPerson",
   "activesession"."creationtime",
   "User"."FullName"