Guest User

Untitled

a guest
Nov 20th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. SELECT DISTINCT `a`.`Timestamp`, `a`.`OriginIP`,
  2. `a`.`User_browser`, `c`.`Activity_ID`, `c`.`DATA`
  3. from `Tomcat_server_logs` `a`
  4. INNER JOIN `user_activity` `c` ON
  5. `a`.`Timestamp`=`c`.`Timestamp`
  6. INNER JOIN
  7. (
  8. SELECT `Timestamp`, `Activity_ID`, `DATA`
  9. FROM `user_activity`
  10. GROUP BY `Timestamp`
  11. ) b ON c.Timestamp = b.Timestamp AND
  12. c.`Activity_ID` = b.`Activity_ID` AND
  13. c.`DATA` = b.`DATA`
  14. WHERE (c.`DATA` LIKE '%submit%') or (c.`DATA` LIKE '%uploadFile')
  15. ORDER BY c.`Timestamp`;
  16.  
  17. ...
  18. INNER JOIN `user_activity` `c` ON
  19. ((`a`.`Timestamp` <= ADDTIME(`c`.`Timestamp`,'0 0:0:4')
  20. AND (`a`.`Timestamp` >= SUBTIME(`c`.`Timestamp`,'0 0:0:4'))
  21. INNER JOIN
  22. ...
Add Comment
Please, Sign In to add comment