SHARE
TWEET

Untitled

a guest Jul 16th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT
  2. dateadd(s, CONVERT(BIGINT, ACT.TIME) / 1000, CONVERT(datetime, '1-1-1970 00:00:00')) AS startTime,
  3. dateadd(s, CONVERT(BIGINT, SES.ctime) / 1000, CONVERT(datetime, '1-1-1970 00:00:00')) AS buyTime,
  4. ACT.TIME AS startTimestamp,
  5. SES.ctime AS buyTimestamp,
  6. SES.region AS region,
  7. SES.ctime - ACT.TIME AS DIFF,
  8. FORMAT (dateadd(s, CONVERT(BIGINT, (SES.ctime - ACT.TIME)) / 1000, CONVERT(datetime, '1-1-1970 00:00:00')), 'mm:ss') AS elapsed
  9. FROM MTPTSESSION AS SES, MTUSAGE2_JUNI AS ACT
  10. 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)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top