API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2015
262
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.90 KB | None | 0 0
raw download clone embed print report
  1. mysql> select id_full, date_maturity from loans where collector_id='TAB/I/LCO-151' and obsolete = 0 and release_status = 3 and balance_current > 0;
  2. +--------------+---------------+
  3. | id_full | date_maturity |
  4. +--------------+---------------+
  5. | TAB/I/000454 | 2005-12-03 |
  6. | TAB/I/003098 | 2004-05-31 |
  7. | TAB/I/005823 | 2006-04-10 |
  8. | TAB/I/006527 | 2006-05-29 |
  9. | TAB/I/007990 | 2006-09-14 |
  10. | TAB/I/008122 | 2006-09-22 |
  11. | TAB/I/008256 | 2006-09-30 |
  12. | TAB/I/008275 | 2006-10-02 |
  13. | TAB/I/008480 | 2006-10-16 |
  14. | TAB/I/009680 | 2007-01-10 |
  15. | TAB/I/009769 | 2007-01-15 |
  16. | TAB/I/010158 | 2007-02-14 |
  17. | TAB/I/010378 | 2007-03-02 |
  18. | TAB/I/010413 | 2007-03-05 |
  19. | TAB/I/010908 | 2007-04-07 |
  20. | TAB/I/011407 | 2007-05-12 |
  21. | TAB/I/014064 | 2007-11-03 |
  22. | TAB/I/014794 | 2007-12-22 |
  23. | TAB/I/015938 | 2008-03-12 |
  24. | TAB/I/016830 | 2008-05-12 |
  25. | TAB/I/019632 | 2008-11-19 |
  26. | TAB/I/019992 | 2008-12-15 |
  27. | TAB/I/020016 | 2008-12-17 |
  28. | TAB/I/020186 | 2008-12-29 |
  29. | TAB/I/021155 | 2009-03-16 |
  30. | TAB/I/021312 | 2009-03-28 |
  31. | TAB/I/021508 | 2009-04-16 |
  32. | TAB/I/021646 | 2009-04-30 |
  33. | TAB/I/021825 | 2009-05-15 |
  34. | TAB/I/021876 | 2009-05-20 |
  35. | TAB/I/021877 | 2009-05-20 |
  36. | TAB/I/022251 | 2009-06-22 |
  37. | TAB/I/022454 | 2009-07-08 |
  38. | TAB/I/022666 | 2009-07-25 |
  39. | TAB/I/022761 | 2009-08-03 |
  40. | TAB/I/022797 | 2009-08-07 |
  41. | TAB/I/022808 | 2009-08-08 |
  42. | TAB/I/022813 | 2009-08-08 |
  43. | TAB/I/022847 | 2009-08-12 |
  44. | TAB/I/022907 | 2009-08-17 |
  45. | TAB/I/022915 | 2009-08-17 |
  46. | TAB/I/022944 | 2009-08-19 |
  47. | TAB/I/022966 | 2009-08-21 |
  48. | TAB/I/022982 | 2009-08-22 |
  49. | TAB/I/022988 | 2009-08-24 |
  50. | TAB/I/023109 | 2009-09-03 |
  51. | TAB/I/023119 | 2009-09-03 |
  52. | TAB/I/023165 | 2009-09-07 |
  53. | TAB/I/023181 | 2009-09-09 |
  54. | TAB/I/023221 | 2009-09-12 |
  55. | TAB/I/023354 | 2009-09-21 |
  56. | TAB/I/023433 | 2009-09-28 |
  57. | TAB/I/023569 | 2009-10-12 |
  58. | TAB/I/023652 | 2009-10-17 |
  59. | TAB/I/023842 | 2009-10-31 |
  60. | TAB/I/023858 | 2009-11-02 |
  61. | TAB/I/023860 | 2009-11-02 |
  62. | TAB/I/023964 | 2009-11-12 |
  63. | TAB/I/023965 | 2009-11-12 |
  64. | TAB/I/023966 | 2009-11-12 |
  65. | TAB/I/024018 | 2009-11-16 |
  66. | TAB/I/024070 | 2009-11-20 |
  67. | TAB/I/024287 | 2009-12-11 |
  68. | TAB/I/024440 | 2009-12-23 |
  69. | TAB/I/024495 | 2009-12-26 |
  70. | TAB/I/024544 | 2009-12-31 |
  71. | TAB/I/024578 | 2010-01-04 |
  72. | TAB/I/024695 | 2010-01-15 |
  73. | TAB/I/024715 | 2010-01-16 |
  74. | TAB/I/024716 | 2010-01-16 |
  75. | TAB/I/024741 | 2010-01-18 |
  76. | TAB/I/024763 | 2010-01-20 |
  77. | TAB/I/024796 | 2010-01-23 |
  78. | TAB/I/024847 | 2010-01-27 |
  79. | TAB/I/024933 | 2010-02-01 |
  80. | TAB/I/024949 | 2010-02-04 |
  81. | TAB/I/024985 | 2010-02-08 |
  82. | TAB/I/025160 | 2010-02-24 |
  83. | TAB/I/025187 | 2010-02-26 |
  84. | TAB/I/025326 | 2010-03-12 |
  85. | TAB/I/025337 | 2010-03-13 |
  86. | TAB/I/025342 | 2010-03-13 |
  87. | TAB/I/025371 | 2010-03-17 |
  88. | TAB/I/025386 | 2010-03-18 |
  89. | TAB/I/025387 | 2010-03-18 |
  90. | TAB/I/025388 | 2010-03-18 |
  91. | TAB/I/025405 | 2010-03-19 |
  92. | TAB/I/025415 | 2010-03-20 |
  93. | TAB/I/025455 | 2010-03-22 |
  94. | TAB/I/025485 | 2010-03-25 |
  95. | TAB/I/025486 | 2010-03-25 |
  96. | TAB/I/025490 | 2010-03-26 |
  97. | TAB/I/025539 | 2010-03-29 |
  98. | TAB/I/025540 | 2010-03-29 |
  99. | TAB/I/025591 | 2010-04-03 |
  100. | TAB/I/025593 | 2010-04-03 |
  101. | TAB/I/025650 | 2010-04-10 |
  102. | TAB/I/025680 | 2010-04-14 |
  103. | TAB/I/025742 | 2010-04-19 |
  104. | TAB/I/025779 | 2010-04-23 |
  105. | TAB/I/026011 | 2010-05-17 |
  106. | TAB/I/026021 | 2010-05-17 |
  107. | TAB/I/026028 | 2010-05-19 |
  108. | TAB/I/026046 | 2010-05-20 |
  109. | TAB/I/026063 | 2010-05-21 |
  110. | TAB/I/026143 | 2010-05-27 |
  111. | TAB/I/026187 | 2010-06-03 |
  112. | TAB/I/026244 | 2010-06-09 |
  113. | TAB/I/026298 | 2010-06-16 |
  114. | TAB/I/026314 | 2010-06-17 |
  115. | TAB/I/026372 | 2010-06-21 |
  116. | TAB/I/026395 | 2010-06-24 |
  117. | TAB/I/026494 | 2010-07-02 |
  118. | TAB/I/026559 | 2010-07-08 |
  119. | TAB/I/026575 | 2010-07-10 |
  120. | TAB/I/026631 | 2010-07-16 |
  121. | TAB/I/026649 | 2010-07-17 |
  122. | TAB/I/026667 | 2010-07-19 |
  123. | TAB/I/026675 | 2010-07-19 |
  124. | TAB/I/026820 | 2010-08-02 |
  125. | TAB/I/026848 | 2010-08-05 |
  126. | TAB/I/026897 | 2010-08-09 |
  127. | TAB/I/026929 | 2010-08-12 |
  128. | TAB/I/026946 | 2010-08-14 |
  129. | TAB/I/026958 | 2010-08-16 |
  130. | TAB/I/026964 | 2010-08-16 |
  131. | TAB/I/026965 | 2010-08-16 |
  132. | TAB/I/026978 | 2010-08-16 |
  133. | TAB/I/027094 | 2010-08-27 |
  134. | TAB/I/027146 | 2010-09-02 |
  135. | TAB/I/027187 | 2010-09-06 |
  136. | TAB/I/027188 | 2010-09-06 |
  137. | TAB/I/027209 | 2010-09-09 |
  138. | TAB/I/027210 | 2010-09-09 |
  139. | TAB/I/027258 | 2010-09-15 |
  140. | TAB/I/027259 | 2010-09-15 |
  141. | TAB/I/027395 | 2010-09-27 |
  142. | TAB/I/027429 | 2010-09-30 |
  143. | TAB/I/027430 | 2010-09-30 |
  144. | TAB/I/027483 | 2010-10-04 |
  145. | TAB/I/027507 | 2010-10-07 |
  146. | TAB/I/027515 | 2010-10-08 |
  147. | TAB/I/027583 | 2010-10-14 |
  148. | TAB/I/027597 | 2010-10-15 |
  149. | TAB/I/027613 | 2010-10-16 |
  150. | TAB/I/027637 | 2010-10-18 |
  151. | TAB/I/027651 | 2010-10-20 |
  152. | TAB/I/027662 | 2010-10-21 |
  153. | TAB/I/027718 | 2010-10-25 |
  154. | TAB/I/027738 | 2010-10-27 |
  155. | TAB/I/027747 | 2010-10-28 |
  156. | TAB/I/027761 | 2010-10-29 |
  157. | TAB/I/027780 | 2010-11-01 |
  158. | TAB/I/027804 | 2010-11-03 |
  159. | TAB/I/027829 | 2010-11-05 |
  160. | TAB/I/027864 | 2010-11-08 |
  161. | TAB/I/027876 | 2010-11-10 |
  162. | TAB/I/027908 | 2010-11-13 |
  163. | TAB/I/027909 | 2010-11-13 |
  164. | TAB/I/027955 | 2010-11-18 |
  165. | TAB/I/027992 | 2010-11-22 |
  166. | TAB/I/028012 | 2010-11-24 |
  167. | TAB/I/028023 | 2010-11-25 |
  168. | TAB/I/028043 | 2010-11-27 |
  169. | TAB/I/028052 | 2010-11-29 |
  170. | TAB/I/028105 | 2010-12-04 |
  171. | TAB/I/028129 | 2010-12-06 |
  172. | TAB/I/028148 | 2010-12-09 |
  173. | TAB/I/028214 | 2010-12-16 |
  174. | TAB/I/028215 | 2010-12-16 |
  175. | TAB/I/028235 | 2010-12-18 |
  176. | TAB/I/028245 | 2010-12-20 |
  177. | TAB/I/028270 | 2010-12-22 |
  178. | TAB/I/028287 | 2010-12-24 |
  179. | TAB/I/028288 | 2010-12-24 |
  180. | TAB/I/028322 | 2010-12-30 |
  181. | TAB/I/028335 | 2010-12-31 |
  182. | TAB/I/028350 | 2011-01-03 |
  183. | TAB/I/028405 | 2011-01-10 |
  184. | TAB/I/028430 | 2011-01-13 |
  185. | TAB/I/028455 | 2011-01-16 |
  186. | TAB/I/028469 | 2011-01-17 |
  187. | TAB/I/028480 | 2011-01-19 |
  188. | TAB/I/028481 | 2011-01-19 |
  189. | TAB/I/028484 | 2011-01-20 |
  190. | TAB/I/028520 | 2011-01-24 |
  191. | TAB/I/028521 | 2011-01-24 |
  192. | TAB/I/028529 | 2011-01-26 |
  193. | TAB/I/028547 | 2011-01-28 |
  194. | TAB/I/028548 | 2011-01-28 |
  195. | TAB/I/028558 | 2011-01-29 |
  196. | TAB/I/028559 | 2011-01-29 |
  197. | TAB/I/028560 | 2011-01-29 |
  198. | TAB/I/028569 | 2011-01-30 |
  199. | TAB/I/028590 | 2011-02-02 |
  200. | TAB/I/028591 | 2011-02-02 |
  201. | TAB/I/028596 | 2011-02-03 |
  202. | TAB/I/028615 | 2011-02-05 |
  203. | TAB/I/028648 | 2011-02-10 |
  204. | TAB/I/028649 | 2011-02-10 |
  205. | TAB/I/028659 | 2011-02-11 |
  206. | TAB/I/028669 | 2011-02-12 |
  207. | TAB/I/028691 | 2011-02-14 |
  208. | TAB/I/028693 | 2011-02-14 |
  209. | TAB/I/028712 | 2011-02-17 |
  210. | TAB/I/028727 | 2011-02-18 |
  211. | TAB/I/028729 | 2011-02-18 |
  212. | TAB/I/028741 | 2011-02-19 |
  213. | TAB/I/028742 | 2011-02-19 |
  214. | TAB/I/028749 | 2011-02-20 |
  215. | TAB/I/028755 | 2011-02-24 |
  216. | TAB/I/028757 | 2011-02-24 |
  217. | TAB/I/028765 | 2011-02-25 |
  218. | TAB/I/028767 | 2011-02-25 |
  219. | TAB/I/028793 | 2011-02-27 |
  220. | TAB/I/028794 | 2011-02-27 |
  221. | TAB/I/028795 | 2011-02-27 |
  222. | TAB/I/028802 | 2011-03-02 |
  223. | TAB/I/028803 | 2011-03-02 |
  224. | TAB/I/028815 | 2011-03-03 |
  225. | TAB/I/028826 | 2011-03-04 |
  226. | TAB/I/028839 | 2011-03-05 |
  227. | TAB/I/028862 | 2011-03-07 |
  228. | TAB/I/028897 | 2011-03-11 |
  229. | TAB/I/028899 | 2011-03-11 |
  230. | TAB/I/028926 | 2011-03-14 |
  231. | TAB/I/028935 | 2011-03-16 |
  232. | TAB/I/028944 | 2011-03-17 |
  233. | TAB/I/028957 | 2011-03-19 |
  234. | TAB/I/028965 | 2011-03-20 |
  235. | TAB/I/028977 | 2011-03-21 |
  236. | TAB/I/028993 | 2011-03-24 |
  237. | TAB/I/028999 | 2011-03-25 |
  238. | TAB/I/029007 | 2011-03-26 |
  239. | TAB/I/029025 | 2011-03-28 |
  240. | TAB/I/029040 | 2011-03-31 |
  241. | TAB/I/029041 | 2011-03-31 |
  242. | TAB/I/029042 | 2011-03-31 |
  243. | TAB/I/029043 | 2011-03-31 |
  244. | TAB/I/029044 | 2011-03-31 |
  245. | TAB/I/029061 | 2011-04-02 |
  246. | TAB/I/029072 | 2011-04-03 |
  247. | TAB/I/029073 | 2011-04-03 |
  248. | TAB/I/029078 | 2011-04-04 |
  249. | TAB/I/029087 | 2011-04-06 |
  250. | TAB/I/029096 | 2011-04-07 |
  251. | TAB/I/029131 | 2011-04-11 |
  252. | TAB/I/029132 | 2011-04-11 |
  253. | TAB/I/029169 | 2011-04-15 |
  254. | TAB/I/029170 | 2011-04-15 |
  255. | TAB/I/029182 | 2011-04-16 |
  256. | TAB/I/029183 | 2011-04-16 |
  257. | TAB/I/029184 | 2011-04-16 |
  258. | TAB/I/029204 | 2011-04-18 |
  259. | TAB/I/029211 | 2011-04-18 |
  260. | TAB/I/029226 | 2011-04-21 |
  261. | TAB/I/029241 | 2011-04-23 |
  262. | TAB/I/029243 | 2011-04-23 |
  263. | TAB/I/029260 | 2011-04-25 |
  264. | TAB/I/029263 | 2011-04-25 |
  265. | TAB/I/029291 | 2011-04-28 |
  266. | TAB/I/029307 | 2011-04-30 |
  267. | TAB/I/029458 | 2011-05-16 |
  268. | TAB/I/029503 | 2011-05-23 |
  269. | TAB/I/029585 | 2011-06-02 |
  270. | TAB/I/029599 | 2011-06-04 |
  271. | TAB/I/029650 | 2011-06-10 |
  272. | TAB/I/029651 | 2011-06-10 |
  273. | TAB/I/029676 | 2011-06-13 |
  274. | TAB/I/029694 | 2011-06-16 |
  275. | TAB/I/029727 | 2011-06-23 |
  276. | TAB/I/029738 | 2011-06-24 |
  277. | TAB/I/029747 | 2011-06-25 |
  278. | TAB/I/029750 | 2011-06-25 |
  279. | TAB/I/029818 | 2011-07-02 |
  280. | TAB/I/029827 | 2011-07-02 |
  281. | TAB/I/029854 | 2011-07-06 |
  282. | TAB/I/029879 | 2011-07-09 |
  283. | TAB/I/029880 | 2011-07-09 |
  284. | TAB/I/029905 | 2011-07-13 |
  285. | TAB/I/029921 | 2011-07-15 |
  286. | TAB/I/029922 | 2011-07-15 |
  287. | TAB/I/029948 | 2011-07-18 |
  288. | TAB/I/029965 | 2011-07-21 |
  289. | TAB/I/029978 | 2011-07-23 |
  290. | TAB/I/029980 | 2011-07-23 |
  291. | TAB/I/030007 | 2011-07-27 |
  292. | TAB/I/030041 | 2011-07-30 |
  293. | TAB/I/030089 | 2011-08-05 |
  294. | TAB/I/030103 | 2011-08-08 |
  295. | TAB/I/030111 | 2011-08-08 |
  296. | TAB/I/030160 | 2011-08-15 |
  297. | TAB/I/030169 | 2011-08-17 |
  298. | TAB/I/030171 | 2011-08-17 |
  299. | TAB/I/030180 | 2011-08-18 |
  300. | TAB/I/030195 | 2011-08-19 |
  301. | TAB/I/030203 | 2011-08-20 |
  302. | TAB/I/030204 | 2011-08-20 |
  303. | TAB/I/030229 | 2011-08-24 |
  304. | TAB/I/030276 | 2011-08-27 |
  305. | TAB/I/030400 | 2011-09-10 |
  306. | TAB/I/030421 | 2011-09-12 |
  307. | TAB/I/030523 | 2011-09-24 |
  308. | TAB/I/030532 | 2011-09-26 |
  309. | TAB/I/030553 | 2011-09-28 |
  310. | TAB/I/030623 | 2011-10-05 |
  311. | TAB/I/030625 | 2011-10-05 |
  312. | TAB/I/030634 | 2011-10-06 |
  313. | TAB/I/030655 | 2011-10-08 |
  314. | TAB/I/030676 | 2011-10-10 |
  315. | TAB/I/030679 | 2011-10-10 |
  316. | TAB/I/030687 | 2011-10-12 |
  317. | TAB/I/030708 | 2011-10-14 |
  318. | TAB/I/030743 | 2011-10-17 |
  319. | TAB/I/030745 | 2011-10-17 |
  320. | TAB/I/030763 | 2011-10-20 |
  321. | TAB/I/030815 | 2011-10-26 |
  322. | TAB/I/030823 | 2011-10-27 |
  323. | TAB/I/030827 | 2011-10-27 |
  324. | TAB/I/030873 | 2011-11-03 |
  325. | TAB/I/030937 | 2011-11-10 |
  326. | TAB/I/030945 | 2011-11-11 |
  327. | TAB/I/030946 | 2011-11-11 |
  328. | TAB/I/031010 | 2011-11-18 |
  329. | TAB/I/031302 | 2012-01-13 |
  330. | TAB/I/031307 | 2012-01-14 |
  331. | TAB/I/031309 | 2012-01-14 |
  332. | TAB/I/031471 | 2012-02-27 |
  333. | TAB/I/031653 | 2012-04-09 |
  334. | TAB/I/031715 | 2012-04-23 |
  335. | TAB/I/031787 | 2012-05-05 |
  336. | TAB/I/031788 | 2012-05-05 |
  337. | TAB/I/031816 | 2012-05-12 |
  338. | TAB/I/031822 | 2012-05-14 |
  339. | TAB/I/031825 | 2012-05-14 |
  340. | TAB/I/031873 | 2012-05-24 |
  341. | TAB/I/031910 | 2012-05-31 |
  342. | TAB/I/031940 | 2012-06-11 |
  343. | TAB/I/031951 | 2012-06-13 |
  344. | TAB/I/031979 | 2012-06-16 |
  345. | TAB/I/032029 | 2012-06-21 |
  346. | TAB/I/032044 | 2012-06-23 |
  347. | TAB/I/032045 | 2012-06-23 |
  348. | TAB/I/032099 | 2012-06-29 |
  349. | TAB/I/032106 | 2012-06-30 |
  350. | TAB/I/032136 | 2012-07-07 |
  351. | TAB/I/032142 | 2012-07-09 |
  352. | TAB/I/032154 | 2012-07-09 |
  353. | TAB/I/032159 | 2012-07-14 |
  354. +--------------+---------------+
  355. 349 rows in set (0.82 sec)
  356.  
  357. mysql>
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!