API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 20th, 2017
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.39 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "status": 0,
  3. "data": {
  4. "drawing": {
  5. "game": "1",
  6. "drawing": "71",
  7. "win_number": "3|25|16|47|28|2|24",
  8. "finishdate": "2017-11-07T09:59:11.000+00:00",
  9. "drawing_status": "finished"
  10. },
  11. "claimed": 0,
  12. "tickets": [{
  13. "type": "paid",
  14. "number": "33|39|35|17|14|47",
  15. "price": "100000000000000000",
  16. "price_dollar": "29.802027",
  17. "win_value": "0",
  18. "win_value_dollar": "0.000000",
  19. "bought_parts": null,
  20. "gg_type": null,
  21. "gg_parts": null,
  22. "gg_lines": null
  23. }, {
  24. "type": "paid",
  25. "number": "12|10|30|43|45|35",
  26. "price": "100000000000000000",
  27. "price_dollar": "29.802027",
  28. "win_value": "0",
  29. "win_value_dollar": "0.000000",
  30. "bought_parts": null,
  31. "gg_type": null,
  32. "gg_parts": null,
  33. "gg_lines": null
  34. }, {
  35. "type": "paid",
  36. "number": "34|33|9|25|32|41",
  37. "price": "100000000000000000",
  38. "price_dollar": "29.802027",
  39. "win_value": "0",
  40. "win_value_dollar": "0.000000",
  41. "bought_parts": null,
  42. "gg_type": null,
  43. "gg_parts": null,
  44. "gg_lines": null
  45. }, {
  46. "type": "paid",
  47. "number": "29|1|6|35|16|7",
  48. "price": "100000000000000000",
  49. "price_dollar": "29.802027",
  50. "win_value": "0",
  51. "win_value_dollar": "0.000000",
  52. "bought_parts": null,
  53. "gg_type": null,
  54. "gg_parts": null,
  55. "gg_lines": null
  56. }, {
  57. "type": "paid",
  58. "number": "41|46|40|44|9|42",
  59. "price": "100000000000000000",
  60. "price_dollar": "29.802027",
  61. "win_value": "0",
  62. "win_value_dollar": "0.000000",
  63. "bought_parts": null,
  64. "gg_type": null,
  65. "gg_parts": null,
  66. "gg_lines": null
  67. }, {
  68. "type": "paid",
  69. "number": "3|34|10|36|35|12",
  70. "price": "100000000000000000",
  71. "price_dollar": "29.802027",
  72. "win_value": "0",
  73. "win_value_dollar": "0.000000",
  74. "bought_parts": null,
  75. "gg_type": null,
  76. "gg_parts": null,
  77. "gg_lines": null
  78. }, {
  79. "type": "paid",
  80. "number": "6|7|11|27|47|18",
  81. "price": "100000000000000000",
  82. "price_dollar": "29.802027",
  83. "win_value": "0",
  84. "win_value_dollar": "0.000000",
  85. "bought_parts": null,
  86. "gg_type": null,
  87. "gg_parts": null,
  88. "gg_lines": null
  89. }, {
  90. "type": "paid",
  91. "number": "10|20|33|26|29|14",
  92. "price": "100000000000000000",
  93. "price_dollar": "29.802027",
  94. "win_value": "0",
  95. "win_value_dollar": "0.000000",
  96. "bought_parts": null,
  97. "gg_type": null,
  98. "gg_parts": null,
  99. "gg_lines": null
  100. }, {
  101. "type": "paid",
  102. "number": "20|30|39|8|24|48",
  103. "price": "100000000000000000",
  104. "price_dollar": "29.802027",
  105. "win_value": "0",
  106. "win_value_dollar": "0.000000",
  107. "bought_parts": null,
  108. "gg_type": null,
  109. "gg_parts": null,
  110. "gg_lines": null
  111. }, {
  112. "type": "paid",
  113. "number": "31|17|33|40|21|48",
  114. "price": "100000000000000000",
  115. "price_dollar": "29.802027",
  116. "win_value": "0",
  117. "win_value_dollar": "0.000000",
  118. "bought_parts": null,
  119. "gg_type": null,
  120. "gg_parts": null,
  121. "gg_lines": null
  122. }, {
  123. "type": "paid",
  124. "number": "38|28|30|10|24|19",
  125. "price": "100000000000000000",
  126. "price_dollar": "29.802027",
  127. "win_value": "0",
  128. "win_value_dollar": "0.000000",
  129. "bought_parts": null,
  130. "gg_type": null,
  131. "gg_parts": null,
  132. "gg_lines": null
  133. }, {
  134. "type": "paid",
  135. "number": "48|4|38|13|22|45",
  136. "price": "100000000000000000",
  137. "price_dollar": "29.802027",
  138. "win_value": "0",
  139. "win_value_dollar": "0.000000",
  140. "bought_parts": null,
  141. "gg_type": null,
  142. "gg_parts": null,
  143. "gg_lines": null
  144. }, {
  145. "type": "paid",
  146. "number": "10|23|32|25|3|41",
  147. "price": "100000000000000000",
  148. "price_dollar": "29.802027",
  149. "win_value": "100000000000000000",
  150. "win_value_dollar": "29.802027",
  151. "bought_parts": null,
  152. "gg_type": null,
  153. "gg_parts": null,
  154. "gg_lines": null
  155. }, {
  156. "type": "paid",
  157. "number": "15|45|47|32|49|25",
  158. "price": "100000000000000000",
  159. "price_dollar": "29.802027",
  160. "win_value": "100000000000000000",
  161. "win_value_dollar": "29.802027",
  162. "bought_parts": null,
  163. "gg_type": null,
  164. "gg_parts": null,
  165. "gg_lines": null
  166. }, {
  167. "type": "paid",
  168. "number": "12|32|17|41|14|3",
  169. "price": "100000000000000000",
  170. "price_dollar": "29.802027",
  171. "win_value": "0",
  172. "win_value_dollar": "0.000000",
  173. "bought_parts": null,
  174. "gg_type": null,
  175. "gg_parts": null,
  176. "gg_lines": null
  177. }, {
  178. "type": "paid",
  179. "number": "18|6|41|9|37|44",
  180. "price": "100000000000000000",
  181. "price_dollar": "29.802027",
  182. "win_value": "0",
  183. "win_value_dollar": "0.000000",
  184. "bought_parts": null,
  185. "gg_type": null,
  186. "gg_parts": null,
  187. "gg_lines": null
  188. }, {
  189. "type": "paid",
  190. "number": "30|42|27|2|36|1",
  191. "price": "100000000000000000",
  192. "price_dollar": "29.802027",
  193. "win_value": "0",
  194. "win_value_dollar": "0.000000",
  195. "bought_parts": null,
  196. "gg_type": null,
  197. "gg_parts": null,
  198. "gg_lines": null
  199. }, {
  200. "type": "paid",
  201. "number": "37|47|44|25|31|14",
  202. "price": "100000000000000000",
  203. "price_dollar": "29.802027",
  204. "win_value": "100000000000000000",
  205. "win_value_dollar": "2id",
  206. "number": "1|25|49|34|13|22",
  207. "price": "100000000000000000",
  208. "price_dollar": "29.802027",
  209. "win_value": "0",
  210. "win_value_dollar": "0.000000",
  211. "bought_parts": null,
  212. "gg_type": null,
  213. "gg_parts": null,
  214. "gg_lines": null
  215. }, {
  216. "type": "paid",
  217. "number": "5|25|31|2|15|20",
  218. "price": "100000000000000000",
  219. "price_dollar": "29.802027",
  220. "win_value": "100000000000000000",
  221. "win_value_dollar": "29.802027",
  222. "bought_parts": null,
  223. "gg_type": null,
  224. "gg_parts": null,
  225. "gg_lines": null
  226. }, {
  227. "type": "paid",
  228. "number": "7|37|19|45|24|20",
  229. "price": "100000000000000000",
  230. "price_dollar": "29.802027",
  231. "win_value": "0",
  232. "win_value_dollar": "0.000000",
  233. "bought_parts": null,
  234. "gg_type": null,
  235. "gg_parts": null,
  236. "gg_lines": null
  237. }, {
  238. "type": "paid",
  239. "number": "37|3|36|17|1|49",
  240. "price": "100000000000000000",
  241. "price_dollar": "29.802027",
  242. "win_value": "0",
  243. "win_value_dollar": "0.000000",
  244. "bought_parts": null,
  245. "gg_type": null,
  246. "gg_parts": null,
  247. "gg_lines": null
  248. }, {
  249. "type": "paid",
  250. "number": "39|3|33|38|13|26",
  251. "price": "100000000000000000",
  252. "price_dollar": "29.802027",
  253. "win_value": "0",
  254. "win_value_dollar": "0.000000",
  255. "bought_parts": null,
  256. "gg_type": null,
  257. "gg_parts": null,
  258. "gg_lines": null
  259. }, {
  260. "type": "paid",
  261. "number": "30|12|15|14|39|40",
  262. "price": "100000000000000000",
  263. "price_dollar": "29.802027",
  264. "win_value": "0",
  265. "win_value_dollar": "0.000000",
  266. "bought_parts": null,
  267. "gg_type": null,
  268. "gg_parts": null,
  269. "gg_lines": null
  270. }, {
  271. "type": "paid",
  272. "number": "5|32|38|45|10|28",
  273. "price": "100000000000000000",
  274. "price_dollar": "29.802027",
  275. "win_value": "0",
  276. "win_value_dollar": "0.000000",
  277. "bought_parts": null,
  278. "gg_type": null,
  279. "gg_parts": null,
  280. "gg_lines": null
  281. }, {
  282. "type": "paid",
  283. "number": "26|45|39|33|15|1",
  284. "price": "100000000000000000",
  285. "price_dollar": "29.802027",
  286. "win_value": "0",
  287. "win_value_dollar": "0.000000",
  288. "bought_parts": null,
  289. "gg_type": null,
  290. "gg_parts": null,
  291. "gg_lines": null
  292. }, {
  293. "type": "paid",
  294. "number": "47|10|5|46|43|1",
  295. "price": "100000000000000000",
  296. "price_dollar": "29.802027",
  297. "win_value": "0",
  298. "win_value_dollar": "0.000000",
  299. "bought_parts": null,
  300. "gg_type": null,
  301. "gg_parts": null,
  302. "gg_lines": null
  303. }, {
  304. "type": "paid",
  305. "number": "21|41|35|30|2|16",
  306. "price": "100000000000000000",
  307. "price_dollar": "29.802027",
  308. "win_value": "100000000000000000",
  309. "win_value_dollar": "29.802027",
  310. "bought_parts": null,
  311. "gg_type": null,
  312. "gg_parts": null,
  313. "gg_lines": null
  314. }, {
  315. "type": "paid",
  316. "number": "9|46|14|28|34|19",
  317. "price": "100000000000000000",
  318. "price_dollar": "29.802027",
  319. "win_value": "0",
  320. "win_value_dollar": "0.000000",
  321. "bought_parts": null,
  322. "gg_type": null,
  323. "gg_parts": null,
  324. "gg_lines": null
  325. }, {
  326. "type": "paid",
  327. "number": "32|40|1|15|12|33",
  328. "price": "100000000000000000",
  329. "price_dollar": "29.802027",
  330. "win_value": "0",
  331. "win_value_dollar": "0.000000",
  332. "bought_parts": null,
  333. "gg_type": null,
  334. "gg_parts": null,
  335. "gg_lines": null
  336. }, {
  337. "type": "paid",
  338. "number": "33|13|4|26|9|35",
  339. "price": "100000000000000000",
  340. "price_dollar": "29.802027",
  341. "win_value": "0",
  342. "win_value_dollar": "0.000000",
  343. "bought_parts": null,
  344. "gg_type": null,
  345. "gg_parts": null,
  346. "gg_lines": null
  347. }]
  348. },
  349. "message": null,
  350. "debug": "SELECT `ticket`.`type`, `ticket`.`number`, `ticket`.`status`, `ticket`.`price`, `ticket`.`price_dollar`, `ticket`.`win_value`, `ticket`.`win_value_dollar`, `ticket`.`parts` as `bought_parts`, `ticket`.`gg_type`, `gtype`.`parts` as `gg_parts`, `gtype`.`lines` as `gg_lines` FROM `kibo_ducket` as `ticket` LEFT JOIN `kibo_groupgame_type` as `gtype` ON `ticket`.`gg_type` = `gtype`.`id` AND `ticket`.`game` = `gtype`.`game` INNER JOIN `kibo_user` as `user` ON `user`.`wallet` = `ticket`.`wallet` WHERE `user`.`id` = 741 AND `ticket`.`drawing` = 71 AND `ticket`.`game` = 1 AND `ticket`.`type` = 12 ORDER BY `ticket`.`createdate` DESC | Time: 0.026696"
  351. }
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!