SELECT DISTINCT
dateadd(s, CONVERT(BIGINT, ACT.TIME) / 1000, CONVERT(datetime, '1-1-1970 00:00:00')) AS startTime,
dateadd(s, CONVERT(BIGINT, SES.ctime) / 1000, CONVERT(datetime, '1-1-1970 00:00:00')) AS buyTime,
ACT.TIME AS startTimestamp,
SES.ctime AS buyTimestamp,
SES.region AS region,
SES.ctime - ACT.TIME AS DIFF,
FORMAT (dateadd(s, CONVERT(BIGINT, (SES.ctime - ACT.TIME)) / 1000, CONVERT(datetime, '1-1-1970 00:00:00')), 'mm:ss') AS elapsed
FROM MTPTSESSION AS SES, MTUSAGE2_JUNI AS ACT
WHERE ((ACT.TIME) / 1000 > ((SES.ctime) / 1000) - 2*60) AND (ACT.TIME < SES.ctime) AND (ACT.TYPE = 2 OR ACT.TYPE = 1) AND (SES.uuid = ACT.uuid)