API tools faq
paste
beowulf1416

Untitled

beowulf1416
Sep 30th, 2015
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.03 KB | None | 0 0
raw download clone embed print report
  1. mysql> select
  2. -> date(lc.date_start),
  3. -> hour(lc.date_start),
  4. -> count(*),
  5. -> sum(lc.seconds) / 60
  6. -> from log_call lc
  7. -> where date(lc.date_start) >= '2015-09-22'
  8. -> and date(lc.date_start) <= '2015-09-29'
  9. -> and gateway_id = 1512
  10. -> group by
  11. -> date(lc.date_start),
  12. -> hour(lc.date_start);
  13. +---------------------+---------------------+----------+----------------------+
  14. | date(lc.date_start) | hour(lc.date_start) | count(*) | sum(lc.seconds) / 60 |
  15. +---------------------+---------------------+----------+----------------------+
  16. | 2015-09-22 | 0 | 15 | 537.5833 |
  17. | 2015-09-22 | 1 | 15 | 334.5667 |
  18. | 2015-09-22 | 2 | 6 | 282.9833 |
  19. | 2015-09-22 | 3 | 12 | 379.9833 |
  20. | 2015-09-22 | 4 | 1 | 3.7833 |
  21. | 2015-09-22 | 5 | 8 | 555.1667 |
  22. | 2015-09-22 | 6 | 8 | 264.6000 |
  23. | 2015-09-22 | 7 | 4 | 25.5167 |
  24. | 2015-09-22 | 8 | 14 | 316.0333 |
  25. | 2015-09-22 | 9 | 12 | 1014.3000 |
  26. | 2015-09-22 | 10 | 7 | 517.1167 |
  27. | 2015-09-22 | 11 | 1 | 240.0333 |
  28. | 2015-09-22 | 12 | 6 | 960.7000 |
  29. | 2015-09-22 | 14 | 2 | 2.6667 |
  30. | 2015-09-22 | 15 | 6 | 960.8167 |
  31. | 2015-09-22 | 18 | 5 | 300.7000 |
  32. | 2015-09-22 | 19 | 6 | 86.2167 |
  33. | 2015-09-22 | 21 | 20 | 217.7833 |
  34. | 2015-09-22 | 22 | 11 | 54.7500 |
  35. | 2015-09-23 | 0 | 12 | 603.4833 |
  36. | 2015-09-23 | 1 | 9 | 488.1167 |
  37. | 2015-09-23 | 2 | 21 | 694.8333 |
  38. | 2015-09-23 | 3 | 4 | 45.9000 |
  39. | 2015-09-23 | 4 | 16 | 262.5167 |
  40. | 2015-09-23 | 5 | 23 | 804.7833 |
  41. | 2015-09-23 | 6 | 2 | 0.6000 |
  42. | 2015-09-23 | 7 | 11 | 1809.3833 |
  43. | 2015-09-23 | 9 | 5 | 459.3500 |
  44. | 2015-09-23 | 10 | 1 | 169.2833 |
  45. | 2015-09-23 | 11 | 10 | 854.9667 |
  46. | 2015-09-23 | 12 | 4 | 188.3833 |
  47. | 2015-09-23 | 13 | 13 | 907.0667 |
  48. | 2015-09-23 | 14 | 1 | 47.1833 |
  49. | 2015-09-23 | 16 | 9 | 88.3000 |
  50. | 2015-09-23 | 18 | 10 | 1104.2333 |
  51. | 2015-09-23 | 19 | 4 | 305.9333 |
  52. | 2015-09-23 | 20 | 3 | 116.4833 |
  53. | 2015-09-23 | 21 | 19 | 302.3833 |
  54. | 2015-09-23 | 22 | 21 | 2002.6333 |
  55. | 2015-09-23 | 23 | 1 | 0.3333 |
  56. | 2015-09-24 | 3 | 26 | 1214.5667 |
  57. | 2015-09-24 | 4 | 9 | 1209.8167 |
  58. | 2015-09-24 | 6 | 3 | 4.1000 |
  59. | 2015-09-24 | 7 | 7 | 439.0500 |
  60. | 2015-09-24 | 8 | 15 | 754.6167 |
  61. | 2015-09-24 | 9 | 8 | 164.2833 |
  62. | 2015-09-24 | 10 | 22 | 506.2833 |
  63. | 2015-09-24 | 11 | 21 | 969.3333 |
  64. | 2015-09-24 | 12 | 8 | 119.5167 |
  65. | 2015-09-24 | 13 | 13 | 318.0500 |
  66. | 2015-09-24 | 14 | 11 | 1809.2333 |
  67. | 2015-09-24 | 19 | 10 | 386.2167 |
  68. | 2015-09-24 | 20 | 1 | 101.7167 |
  69. | 2015-09-24 | 21 | 18 | 146.9667 |
  70. | 2015-09-24 | 22 | 13 | 291.5000 |
  71. | 2015-09-24 | 23 | 17 | 1317.1667 |
  72. | 2015-09-25 | 0 | 12 | 830.0500 |
  73. | 2015-09-25 | 2 | 2 | 133.9500 |
  74. | 2015-09-25 | 3 | 10 | 1240.4000 |
  75. | 2015-09-25 | 4 | 8 | 845.5667 |
  76. | 2015-09-25 | 5 | 2 | 318.0000 |
  77. | 2015-09-25 | 6 | 2 | 128.9500 |
  78. | 2015-09-25 | 7 | 5 | 229.1167 |
  79. | 2015-09-25 | 8 | 16 | 1694.7167 |
  80. | 2015-09-25 | 9 | 3 | 197.2333 |
  81. | 2015-09-25 | 10 | 1 | 45.0833 |
  82. | 2015-09-25 | 11 | 9 | 197.2333 |
  83. | 2015-09-25 | 12 | 17 | 1340.2833 |
  84. | 2015-09-25 | 13 | 7 | 1200.7500 |
  85. | 2015-09-25 | 17 | 13 | 1767.4333 |
  86. | 2015-09-25 | 19 | 4 | 55.3667 |
  87. | 2015-09-25 | 21 | 16 | 475.1167 |
  88. | 2015-09-25 | 22 | 2 | 42.4833 |
  89. | 2015-09-25 | 23 | 12 | 2005.4500 |
  90. | 2015-09-26 | 0 | 4 | 75.5167 |
  91. | 2015-09-26 | 1 | 1 | 13.7500 |
  92. | 2015-09-26 | 2 | 8 | 365.0167 |
  93. | 2015-09-26 | 3 | 9 | 401.7000 |
  94. | 2015-09-26 | 4 | 17 | 380.1333 |
  95. | 2015-09-26 | 5 | 25 | 962.1833 |
  96. | 2015-09-26 | 6 | 3 | 166.2333 |
  97. | 2015-09-26 | 7 | 9 | 317.5500 |
  98. | 2015-09-26 | 8 | 13 | 1092.6167 |
  99. | 2015-09-26 | 10 | 9 | 404.8333 |
  100. | 2015-09-26 | 11 | 20 | 392.4333 |
  101. | 2015-09-26 | 12 | 25 | 972.2000 |
  102. | 2015-09-26 | 13 | 15 | 151.5333 |
  103. | 2015-09-26 | 15 | 14 | 79.9000 |
  104. | 2015-09-26 | 16 | 18 | 289.7500 |
  105. | 2015-09-26 | 17 | 10 | 1010.5167 |
  106. | 2015-09-26 | 19 | 9 | 519.2667 |
  107. | 2015-09-26 | 21 | 28 | 430.0500 |
  108. | 2015-09-26 | 22 | 33 | 256.7833 |
  109. | 2015-09-26 | 23 | 26 | 2211.9000 |
  110. | 2015-09-27 | 0 | 4 | 57.1833 |
  111. | 2015-09-27 | 1 | 3 | 49.3833 |
  112. | 2015-09-27 | 2 | 2 | 254.9333 |
  113. | 2015-09-27 | 3 | 2 | 317.5333 |
  114. | 2015-09-27 | 4 | 13 | 536.5000 |
  115. | 2015-09-27 | 5 | 7 | 364.1833 |
  116. | 2015-09-27 | 6 | 14 | 256.0500 |
  117. | 2015-09-27 | 7 | 47 | 1244.9167 |
  118. | 2015-09-27 | 8 | 31 | 967.5000 |
  119. | 2015-09-27 | 9 | 25 | 1114.2000 |
  120. | 2015-09-27 | 10 | 20 | 468.3167 |
  121. | 2015-09-27 | 11 | 14 | 751.2500 |
  122. | 2015-09-27 | 12 | 4 | 124.3500 |
  123. | 2015-09-27 | 13 | 13 | 331.4500 |
  124. | 2015-09-27 | 14 | 13 | 754.4000 |
  125. | 2015-09-27 | 18 | 11 | 1887.1000 |
  126. | 2015-09-27 | 19 | 1 | 5.0167 |
  127. | 2015-09-27 | 20 | 3 | 118.6000 |
  128. | 2015-09-27 | 21 | 15 | 650.3333 |
  129. | 2015-09-27 | 22 | 8 | 128.6000 |
  130. | 2015-09-27 | 23 | 30 | 929.1667 |
  131. | 2015-09-28 | 0 | 5 | 75.6000 |
  132. | 2015-09-28 | 1 | 25 | 2356.5000 |
  133. | 2015-09-28 | 2 | 1 | 5.0167 |
  134. | 2015-09-28 | 3 | 15 | 301.9167 |
  135. | 2015-09-28 | 4 | 9 | 410.1167 |
  136. | 2015-09-28 | 5 | 17 | 2057.1167 |
  137. | 2015-09-28 | 6 | 4 | 171.4667 |
  138. | 2015-09-28 | 7 | 7 | 128.3833 |
  139. | 2015-09-28 | 8 | 43 | 378.9000 |
  140. | 2015-09-28 | 9 | 4 | 95.3000 |
  141. | 2015-09-28 | 10 | 2 | 103.8667 |
  142. | 2015-09-28 | 11 | 4 | 149.1500 |
  143. | 2015-09-28 | 12 | 53 | 1301.7833 |
  144. | 2015-09-28 | 13 | 3 | 29.0333 |
  145. | 2015-09-28 | 15 | 14 | 308.8500 |
  146. | 2015-09-28 | 17 | 15 | 134.0500 |
  147. | 2015-09-28 | 18 | 19 | 112.7333 |
  148. | 2015-09-28 | 19 | 14 | 198.2667 |
  149. | 2015-09-28 | 20 | 19 | 56.4667 |
  150. | 2015-09-28 | 21 | 49 | 819.5667 |
  151. | 2015-09-28 | 22 | 19 | 446.4833 |
  152. | 2015-09-28 | 23 | 15 | 201.0833 |
  153. | 2015-09-29 | 0 | 17 | 66.3167 |
  154. | 2015-09-29 | 1 | 86 | 561.4000 |
  155. | 2015-09-29 | 2 | 122 | 773.4000 |
  156. | 2015-09-29 | 3 | 24 | 978.0500 |
  157. | 2015-09-29 | 4 | 13 | 631.3333 |
  158. | 2015-09-29 | 5 | 14 | 692.6833 |
  159. | 2015-09-29 | 6 | 16 | 1808.0333 |
  160. | 2015-09-29 | 8 | 3 | 241.8500 |
  161. | 2015-09-29 | 9 | 20 | 243.1000 |
  162. | 2015-09-29 | 10 | 35 | 951.7167 |
  163. | 2015-09-29 | 11 | 1 | 11.9167 |
  164. | 2015-09-29 | 12 | 18 | 572.8500 |
  165. | 2015-09-29 | 13 | 12 | 1253.3000 |
  166. | 2015-09-29 | 15 | 12 | 235.7167 |
  167. | 2015-09-29 | 18 | 14 | 269.7000 |
  168. | 2015-09-29 | 19 | 14 | 564.1167 |
  169. | 2015-09-29 | 21 | 11 | 324.6000 |
  170. | 2015-09-29 | 22 | 29 | 187.6167 |
  171. | 2015-09-29 | 23 | 62 | 1092.1500 |
  172. +---------------------+---------------------+----------+----------------------+
  173. 156 rows in set (0.01 sec)
  174.  
  175. mysql> select
  176. -> date(lc.date_start),
  177. -> count(*),
  178. -> sum(lc.seconds) / 60
  179. -> from log_call lc
  180. -> where date(lc.date_start) >= '2015-09-22'
  181. -> and date(lc.date_start) <= '2015-09-29'
  182. -> and gateway_id = 1512
  183. -> group by
  184. -> date(lc.date_start);
  185. +---------------------+----------+----------------------+
  186. | date(lc.date_start) | count(*) | sum(lc.seconds) / 60 |
  187. +---------------------+----------+----------------------+
  188. | 2015-09-22 | 159 | 7055.3000 |
  189. | 2015-09-23 | 199 | 11256.1500 |
  190. | 2015-09-24 | 202 | 9752.4167 |
  191. | 2015-09-25 | 141 | 12747.1833 |
  192. | 2015-09-26 | 296 | 10493.8667 |
  193. | 2015-09-27 | 280 | 11310.9667 |
  194. | 2015-09-28 | 356 | 9841.6500 |
  195. | 2015-09-29 | 523 | 11459.8500 |
  196. +---------------------+----------+----------------------+
  197. 8 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!