Advertisement
Guest User

Untitled

a guest
Jun 13th, 2018
305
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.07 KB | None | 0 0
  1. mysql> select * from ext_crm_data where cell = 9712 and ext_crm_name = 'amo' \G
  2. *************************** 1. row ***************************
  3. id: 31
  4. ext_crm_name: amo
  5. cell: 9712
  6. enable: 1
  7. ext_crm_acc_id: 10149195
  8. account_name: 2777999
  9. admin_login: 2777999@bk.ru
  10. admin_secret: 38e4fa4226d7dc14a7bcb4ae87d4c95a
  11. extra: {"projectAHA":1,"no_lead_for_in":1,"phone_field_id":"906542","work_phone_enum":2188348,"email_field_id":"906544","work_email_enum":2188360}
  12. 1 row in set (0.00 sec)
  13.  
  14. mysql> select * from ext_crm_users where ext_crm_data_id = 31 \G
  15. *************************** 1. row ***************************
  16. id: 882
  17. crm_user_name: Антонец Александр
  18. crm_user_login: antonez@mail.ru
  19. crm_user_secret: 0b0dd393193a1a9ec5f0e7cbd512107f
  20. ext_crm_data_id: 31
  21. extra: NULL
  22. user_numbers: []
  23. crm_user_id: 1788352
  24. *************************** 2. row ***************************
  25. id: 883
  26. crm_user_name: Болдырь Максим
  27. crm_user_login: 9094689861@bk.ru
  28. crm_user_secret: b6cc080149d2ee186dd94e67d19677ab
  29. ext_crm_data_id: 31
  30. extra: NULL
  31. user_numbers: []
  32. crm_user_id: 1788376
  33. *************************** 3. row ***************************
  34. id: 727
  35. crm_user_name: Владимир Алексеевич
  36. crm_user_login: vertyanov.v@yandex.ru
  37. crm_user_secret: 8c9a2b1afbf971d8c3be7429eb91c1cb
  38. ext_crm_data_id: 31
  39. extra: NULL
  40. user_numbers: {"302":"0002420"}
  41. crm_user_id: 1454569
  42. *************************** 4. row ***************************
  43. id: 286
  44. crm_user_name: Вертьянов Андрей
  45. crm_user_login: 2777999@bk.ru
  46. crm_user_secret: 38e4fa4226d7dc14a7bcb4ae87d4c95a
  47. ext_crm_data_id: 31
  48. extra: NULL
  49. user_numbers: {"395":"0003485","ext1":"79399999938"}
  50. crm_user_id: 696042
  51. *************************** 5. row ***************************
  52. id: 864
  53. crm_user_name: Толстых Александр
  54. crm_user_login: tolstykh93@inbox.ru
  55. crm_user_secret: 68332fd1aef6d34f5a21dd862ab6c772
  56. ext_crm_data_id: 31
  57. extra: NULL
  58. user_numbers: []
  59. crm_user_id: 1751341
  60. *************************** 6. row ***************************
  61. id: 1134
  62. crm_user_name: NULL
  63. crm_user_login: NULL
  64. crm_user_secret: NULL
  65. ext_crm_data_id: 31
  66. extra: NULL
  67. user_numbers: []
  68. crm_user_id: 2194162
  69. *************************** 7. row ***************************
  70. id: 853
  71. crm_user_name: Аделя Венеровна
  72. crm_user_login: adelina4ca1989@mail.ru
  73. crm_user_secret: a4a1aea18bb39f01c446b723d4530ae7
  74. ext_crm_data_id: 31
  75. extra: NULL
  76. user_numbers: []
  77. crm_user_id: 1650664
  78. *************************** 8. row ***************************
  79. id: 884
  80. crm_user_name: NULL
  81. crm_user_login: NULL
  82. crm_user_secret: NULL
  83. ext_crm_data_id: 31
  84. extra: NULL
  85. user_numbers: []
  86. crm_user_id: 1788394
  87. *************************** 9. row ***************************
  88. id: 854
  89. crm_user_name: Замерщик Виталик
  90. crm_user_login: vgorinok90@gmail.com
  91. crm_user_secret: 04d70b3bb27f8b281f185f17d06821c4
  92. ext_crm_data_id: 31
  93. extra: NULL
  94. user_numbers: []
  95. crm_user_id: 1717768
  96. *************************** 10. row ***************************
  97. id: 1135
  98. crm_user_name: NULL
  99. crm_user_login: NULL
  100. crm_user_secret: NULL
  101. ext_crm_data_id: 31
  102. extra: NULL
  103. user_numbers: {"398":"0003488"}
  104. crm_user_id: 2296702
  105. *************************** 11. row ***************************
  106. id: 902
  107. crm_user_name: Беляев Эдуард
  108. crm_user_login: Belyaevea@mail.ru
  109. crm_user_secret: 8730136e2c1ed211b86bbd66723e6898
  110. ext_crm_data_id: 31
  111. extra: NULL
  112. user_numbers: {"396":"0003486","320":"0002788"}
  113. crm_user_id: 1864609
  114. *************************** 12. row ***************************
  115. id: 1028
  116. crm_user_name: Климов Аркадий
  117. crm_user_login: arikruxa@mail.ru
  118. crm_user_secret: ed56e8f8f3c1b2013e325d0e7d8b8a91
  119. ext_crm_data_id: 31
  120. extra: NULL
  121. user_numbers: []
  122. crm_user_id: 2073694
  123. *************************** 13. row ***************************
  124. id: 1029
  125. crm_user_name: NULL
  126. crm_user_login: NULL
  127. crm_user_secret: NULL
  128. ext_crm_data_id: 31
  129. extra: NULL
  130. user_numbers: {"397":"0003487"}
  131. crm_user_id: 2074222
  132. *************************** 14. row ***************************
  133. id: 1030
  134. crm_user_name: Савело Александр
  135. crm_user_login: savelo-888@mail.ru
  136. crm_user_secret: 9b13e9ade9137ebf6ea5b38a41ac9b4a
  137. ext_crm_data_id: 31
  138. extra: NULL
  139. user_numbers: []
  140. crm_user_id: 2076718
  141. *************************** 15. row ***************************
  142. id: 1031
  143. crm_user_name: Олег Геннадьевич
  144. crm_user_login: alfaog@ya.ru
  145. crm_user_secret: d235132c6588c27b6e1c080e1a4edf95
  146. ext_crm_data_id: 31
  147. extra: NULL
  148. user_numbers: []
  149. crm_user_id: 2154583
  150. 15 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement