Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select * from ext_crm_data where cell = 9712 and ext_crm_name = 'amo' \G
- *************************** 1. row ***************************
- id: 31
- ext_crm_name: amo
- cell: 9712
- enable: 1
- ext_crm_acc_id: 10149195
- account_name: 2777999
- admin_login: 2777999@bk.ru
- admin_secret: 38e4fa4226d7dc14a7bcb4ae87d4c95a
- extra: {"projectAHA":1,"no_lead_for_in":1,"phone_field_id":"906542","work_phone_enum":2188348,"email_field_id":"906544","work_email_enum":2188360}
- 1 row in set (0.00 sec)
- mysql> select * from ext_crm_users where ext_crm_data_id = 31 \G
- *************************** 1. row ***************************
- id: 882
- crm_user_name: Антонец Александр
- crm_user_login: antonez@mail.ru
- crm_user_secret: 0b0dd393193a1a9ec5f0e7cbd512107f
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 1788352
- *************************** 2. row ***************************
- id: 883
- crm_user_name: Болдырь Максим
- crm_user_login: 9094689861@bk.ru
- crm_user_secret: b6cc080149d2ee186dd94e67d19677ab
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 1788376
- *************************** 3. row ***************************
- id: 727
- crm_user_name: Владимир Алексеевич
- crm_user_login: vertyanov.v@yandex.ru
- crm_user_secret: 8c9a2b1afbf971d8c3be7429eb91c1cb
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: {"302":"0002420"}
- crm_user_id: 1454569
- *************************** 4. row ***************************
- id: 286
- crm_user_name: Вертьянов Андрей
- crm_user_login: 2777999@bk.ru
- crm_user_secret: 38e4fa4226d7dc14a7bcb4ae87d4c95a
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: {"395":"0003485","ext1":"79399999938"}
- crm_user_id: 696042
- *************************** 5. row ***************************
- id: 864
- crm_user_name: Толстых Александр
- crm_user_login: tolstykh93@inbox.ru
- crm_user_secret: 68332fd1aef6d34f5a21dd862ab6c772
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 1751341
- *************************** 6. row ***************************
- id: 1134
- crm_user_name: NULL
- crm_user_login: NULL
- crm_user_secret: NULL
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 2194162
- *************************** 7. row ***************************
- id: 853
- crm_user_name: Аделя Венеровна
- crm_user_login: adelina4ca1989@mail.ru
- crm_user_secret: a4a1aea18bb39f01c446b723d4530ae7
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 1650664
- *************************** 8. row ***************************
- id: 884
- crm_user_name: NULL
- crm_user_login: NULL
- crm_user_secret: NULL
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 1788394
- *************************** 9. row ***************************
- id: 854
- crm_user_name: Замерщик Виталик
- crm_user_login: vgorinok90@gmail.com
- crm_user_secret: 04d70b3bb27f8b281f185f17d06821c4
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 1717768
- *************************** 10. row ***************************
- id: 1135
- crm_user_name: NULL
- crm_user_login: NULL
- crm_user_secret: NULL
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: {"398":"0003488"}
- crm_user_id: 2296702
- *************************** 11. row ***************************
- id: 902
- crm_user_name: Беляев Эдуард
- crm_user_login: Belyaevea@mail.ru
- crm_user_secret: 8730136e2c1ed211b86bbd66723e6898
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: {"396":"0003486","320":"0002788"}
- crm_user_id: 1864609
- *************************** 12. row ***************************
- id: 1028
- crm_user_name: Климов Аркадий
- crm_user_login: arikruxa@mail.ru
- crm_user_secret: ed56e8f8f3c1b2013e325d0e7d8b8a91
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 2073694
- *************************** 13. row ***************************
- id: 1029
- crm_user_name: NULL
- crm_user_login: NULL
- crm_user_secret: NULL
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: {"397":"0003487"}
- crm_user_id: 2074222
- *************************** 14. row ***************************
- id: 1030
- crm_user_name: Савело Александр
- crm_user_login: savelo-888@mail.ru
- crm_user_secret: 9b13e9ade9137ebf6ea5b38a41ac9b4a
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 2076718
- *************************** 15. row ***************************
- id: 1031
- crm_user_name: Олег Геннадьевич
- crm_user_login: alfaog@ya.ru
- crm_user_secret: d235132c6588c27b6e1c080e1a4edf95
- ext_crm_data_id: 31
- extra: NULL
- user_numbers: []
- crm_user_id: 2154583
- 15 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement