API tools faq
paste
Advertisement
Hastwell

Exo+Real Potential Miner Dup, Transact Aggregate

Hastwell
Apr 30th, 2015
217
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.17 KB | None | 0 0
raw download clone embed print report
  1. SELECT DATE(FROM_UNIXTIME(epoch)) AS timeperiod, player, action, COUNT(*) as transacts FROM `prism_data`
  2. INNER JOIN prism_players ON prism_data.player_id = prism_players.player_id
  3. INNER JOIN prism_actions ON prism_data.action_id = prism_actions.action_id
  4. WHERE block_id = 2447 AND block_subid = 4
  5. GROUP BY timeperiod, player, action
  6. ORDER BY timeperiod DESC, player, transacts DESC, action
  7. LIMIT 120;
  8.  
  9. Query run on 30 April 2015 on Bacon TPPI-1.
  10.  
  11. Each row represents total number of transactions by players occuring on the day of TIMEPERIOD.
  12. item-remove and item-insert refers the handling of the miner itself in item form, not items inserted/removed from one.
  13.  
  14. +------------+---------------+-----------------+-----------+
  15. | timeperiod | player | action | transacts |
  16. +------------+---------------+-----------------+-----------+
  17. | 2015-04-30 | Hastwell | container-open | 9 |
  18. | 2015-04-30 | Hastwell | container-close | 6 |
  19. | 2015-04-30 | MicroCampaign | item-remove | 1 |
  20. | 2015-04-30 | Real_Akatosh | container-open | 12 |
  21. | 2015-04-30 | Real_Akatosh | container-close | 6 |
  22. | 2015-04-30 | Real_Akatosh | block-place | 4 |
  23. | 2015-04-30 | Real_Akatosh | item-pickup | 4 |
  24. | 2015-04-30 | Real_Akatosh | item-remove | 1 |
  25. | 2015-04-29 | Hastwell | container-open | 18 |
  26. | 2015-04-29 | Hastwell | container-close | 14 |
  27. | 2015-04-29 | Hastwell | block-place | 4 |
  28. | 2015-04-29 | Hastwell | item-pickup | 3 |
  29. | 2015-04-29 | Hastwell | item-remove | 2 |
  30. | 2015-04-29 | Hastwell | item-insert | 1 |
  31. | 2015-04-29 | Real_Akatosh | container-open | 25 |
  32. | 2015-04-29 | Real_Akatosh | container-close | 17 |
  33. | 2015-04-29 | Real_Akatosh | block-place | 5 |
  34. | 2015-04-29 | Real_Akatosh | item-pickup | 5 |
  35. | 2015-04-29 | Real_Akatosh | item-remove | 1 |
  36. | 2015-04-28 | Exo594 | container-open | 33 |
  37. | 2015-04-28 | Exo594 | container-close | 30 |
  38. | 2015-04-28 | Exo594 | item-pickup | 28 |
  39. | 2015-04-28 | Exo594 | block-place | 26 |
  40. | 2015-04-28 | Exo594 | item-remove | 4 |
  41. | 2015-04-28 | Exo594 | item-insert | 2 |
  42. | 2015-04-28 | Exo594 | item-drop | 1 |
  43. | 2015-04-28 | Hastwell | container-close | 1 |
  44. | 2015-04-28 | Hastwell | container-open | 1 |
  45. | 2015-04-28 | Real_Akatosh | container-open | 91 |
  46. | 2015-04-28 | Real_Akatosh | container-close | 57 |
  47. | 2015-04-28 | Real_Akatosh | item-pickup | 14 |
  48. | 2015-04-28 | Real_Akatosh | block-place | 13 |
  49. | 2015-04-28 | Real_Akatosh | item-insert | 8 |
  50. | 2015-04-28 | Real_Akatosh | item-remove | 8 |
  51. | 2015-04-27 | CobraCadabra | container-close | 1 |
  52. | 2015-04-27 | CobraCadabra | container-open | 1 |
  53. | 2015-04-27 | Exo594 | container-open | 42 |
  54. | 2015-04-27 | Exo594 | container-close | 31 |
  55. | 2015-04-27 | Exo594 | block-place | 20 |
  56. | 2015-04-27 | Exo594 | item-pickup | 19 |
  57. | 2015-04-27 | Exo594 | item-remove | 6 |
  58. | 2015-04-26 | Exo594 | container-open | 27 |
  59. | 2015-04-26 | Exo594 | container-close | 23 |
  60. | 2015-04-26 | Exo594 | block-place | 11 |
  61. | 2015-04-26 | Exo594 | item-pickup | 11 |
  62. | 2015-04-26 | Exo594 | item-remove | 6 |
  63. | 2015-04-26 | Exo594 | item-insert | 1 |
  64. | 2015-04-26 | Real_Akatosh | container-close | 3 |
  65. | 2015-04-26 | Real_Akatosh | container-open | 3 |
  66. | 2015-04-25 | Exo594 | item-insert | 1 |
  67. | 2015-04-25 | Exo594 | item-remove | 1 |
  68. | 2015-04-25 | lwood262 | item-insert | 1 |
  69. | 2015-04-25 | MicroCampaign | item-insert | 1 |
  70. | 2015-04-25 | MicroCampaign | item-remove | 1 |
  71. | 2015-04-25 | Real_Akatosh | block-place | 3 |
  72. | 2015-04-25 | Real_Akatosh | container-open | 3 |
  73. | 2015-04-25 | Real_Akatosh | item-insert | 3 |
  74. | 2015-04-25 | Real_Akatosh | item-pickup | 3 |
  75. | 2015-04-25 | Real_Akatosh | container-close | 2 |
  76. | 2015-04-24 | Exo594 | container-open | 4 |
  77. | 2015-04-24 | Exo594 | item-insert | 4 |
  78. | 2015-04-24 | Exo594 | item-pickup | 4 |
  79. | 2015-04-24 | Exo594 | block-place | 3 |
  80. | 2015-04-24 | Exo594 | container-close | 3 |
  81. | 2015-04-24 | Exo594 | item-remove | 3 |
  82. | 2015-04-24 | Hastwell | container-close | 4 |
  83. | 2015-04-24 | Hastwell | container-open | 4 |
  84. | 2015-04-24 | Hastwell | block-place | 1 |
  85. | 2015-04-24 | Hastwell | item-pickup | 1 |
  86. | 2015-04-24 | Hastwell | item-remove | 1 |
  87. | 2015-04-24 | Real_Akatosh | container-open | 9 |
  88. | 2015-04-24 | Real_Akatosh | container-close | 7 |
  89. | 2015-04-24 | Real_Akatosh | block-place | 2 |
  90. | 2015-04-24 | Real_Akatosh | item-pickup | 1 |
  91. | 2015-04-24 | Real_Akatosh | item-remove | 1 |
  92. | 2015-04-23 | CobraCadabra | container-close | 1 |
  93. | 2015-04-23 | CobraCadabra | container-open | 1 |
  94. | 2015-04-23 | Exo594 | container-open | 42 |
  95. | 2015-04-23 | Exo594 | container-close | 32 |
  96. | 2015-04-23 | Exo594 | block-place | 21 |
  97. | 2015-04-23 | Exo594 | item-pickup | 20 |
  98. | 2015-04-23 | Exo594 | item-remove | 6 |
  99. | 2015-04-23 | Exo594 | item-insert | 3 |
  100. | 2015-04-23 | Hastwell | container-open | 7 |
  101. | 2015-04-23 | Hastwell | container-close | 6 |
  102. | 2015-04-23 | Hastwell | item-insert | 2 |
  103. | 2015-04-23 | Hastwell | block-place | 1 |
  104. | 2015-04-23 | Hastwell | item-remove | 1 |
  105. | 2015-04-22 | CobraCadabra | container-close | 1 |
  106. | 2015-04-22 | CobraCadabra | container-open | 1 |
  107. | 2015-04-22 | Exo594 | container-open | 64 |
  108. | 2015-04-22 | Exo594 | container-close | 51 |
  109. | 2015-04-22 | Exo594 | item-pickup | 14 |
  110. | 2015-04-22 | Exo594 | block-place | 13 |
  111. | 2015-04-22 | Exo594 | item-remove | 10 |
  112. | 2015-04-22 | Exo594 | item-insert | 3 |
  113. | 2015-04-22 | Exo594 | item-drop | 1 |
  114. | 2015-04-22 | lwood262 | container-close | 1 |
  115. | 2015-04-22 | lwood262 | container-open | 1 |
  116. | 2015-04-22 | Real_Akatosh | container-close | 1 |
  117. | 2015-04-22 | Real_Akatosh | container-open | 1 |
  118. | 2015-04-22 | Real_Akatosh | item-insert | 1 |
  119. | 2015-04-22 | Real_Akatosh | item-pickup | 1 |
  120. | 2015-04-21 | Real_Akatosh | container-open | 5 |
  121. | 2015-04-21 | Real_Akatosh | container-close | 4 |
  122. | 2015-04-21 | Real_Akatosh | block-place | 1 |
  123. | 2015-04-21 | Real_Akatosh | item-pickup | 1 |
  124. | 2015-04-20 | Abducted | container-close | 1 |
  125. | 2015-04-20 | Abducted | container-open | 1 |
  126. | 2015-04-20 | CobraCadabra | container-open | 8 |
  127. | 2015-04-20 | CobraCadabra | container-close | 5 |
  128. | 2015-04-20 | CobraCadabra | block-place | 1 |
  129. | 2015-04-20 | CobraCadabra | item-pickup | 1 |
  130. | 2015-04-20 | CobraCadabra | item-remove | 1 |
  131. | 2015-04-20 | lwood262 | container-close | 11 |
  132. | 2015-04-20 | lwood262 | container-open | 11 |
  133. | 2015-04-20 | lwood262 | item-remove | 5 |
  134. | 2015-04-20 | lwood262 | block-place | 4 |
  135. | 2015-04-20 | lwood262 | item-pickup | 2 |
  136. | 2015-04-20 | lwood262 | item-drop | 1 |
  137. +------------+---------------+-----------------+-----------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!