test

Sql code posted by test
created at 07 Feb 12:28

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
SELECT AVG(b.identity-e.identity)*24*60*60
  FROM log e
   INNER JOIN log b
    ON b.identity=e.identity
       AND b.userid=e.userid
       AND b.thread=e.thread
       AND b.id<e.id
  WHERE 
    e.datetime >= current_timestamp - interval '0 00:01:00' day to second 
    AND b.datetime >= current_timestamp - interval '0 00:05:00' day to second 
    AND NOT b.message LIKE 'SearchForPacketProviderProc%'
    AND NOT e.message LIKE 'SearchForPacketProviderProc%'
    AND NOT e.userid = ' '
501 Bytes in 2 ms with coderay