mysql> select * from presentity\G
*************************** 1. row ***************************
id: 3620
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22160.478.0
expires: 1453318710
received_time: 1453318585
body:
sender:
priority: 0
*************************** 2. row ***************************
id: 3621
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22159.501.0
expires: 1453318710
received_time: 1453318585
body:
sender:
priority: 0
*************************** 3. row ***************************
id: 3622
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22168.477.0
expires: 1453318710
received_time: 1453318585
body:
sender:
priority: 0
*************************** 4. row ***************************
id: 3623
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22172.485.0
expires: 1453318711
received_time: 1453318586
body:
sender:
priority: 0
*************************** 5. row ***************************
id: 3624
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22171.515.0
expires: 1453318711
received_time: 1453318586
body:
sender:
priority: 0
*************************** 6. row ***************************
id: 3627
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22161.517.0
expires: 1453318714
received_time: 1453318589
body:
sender:
priority: 0
*************************** 7. row ***************************
id: 3628
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22168.478.0
expires: 1453318715
received_time: 1453318590
body:
sender:
priority: 0
*************************** 8. row ***************************
id: 3629
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22169.500.0
expires: 1453318715
received_time: 1453318590
body:
sender:
priority: 0
*************************** 9. row ***************************
id: 3630
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22159.502.0
expires: 1453318716
received_time: 1453318591
body:
sender:
priority: 0
*************************** 10. row ***************************
id: 3631
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22162.519.0
expires: 1453318716
received_time: 1453318591
body:
sender:
priority: 0
*************************** 11. row ***************************
id: 3634
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22171.516.0
expires: 1453318719
received_time: 1453318594
body:
sender:
priority: 0
*************************** 12. row ***************************
id: 3635
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22161.518.0
expires: 1453318720
received_time: 1453318595
body:
sender:
priority: 0
*************************** 13. row ***************************
id: 3636
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22162.520.0
expires: 1453318720
received_time: 1453318595
body:
sender:
priority: 0
*************************** 14. row ***************************
id: 3637
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22167.534.0
expires: 1453318721
received_time: 1453318596
body:
sender:
priority: 0
*************************** 15. row ***************************
id: 3638
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22169.501.0
expires: 1453318721
received_time: 1453318596
body:
sender:
priority: 0
*************************** 16. row ***************************
id: 3641
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22168.481.0
expires: 1453318724
received_time: 1453318599
body:
sender:
priority: 0
*************************** 17. row ***************************
id: 3642
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22173.534.0
expires: 1453318725
received_time: 1453318600
body:
sender:
priority: 0
*************************** 18. row ***************************
id: 3643
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22169.502.0
expires: 1453318725
received_time: 1453318600
body:
sender:
priority: 0
*************************** 19. row ***************************
id: 3644
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22162.521.0
expires: 1453318726
received_time: 1453318601
body:
sender:
priority: 0
*************************** 20. row ***************************
id: 3645
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22167.535.0
expires: 1453318726
received_time: 1453318601
body:
sender:
priority: 0
*************************** 21. row ***************************
id: 3648
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22161.519.0
expires: 1453318728
received_time: 1453318603
body:
sender:
priority: 0
*************************** 22. row ***************************
id: 3649
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22158.521.0
expires: 1453318729
received_time: 1453318604
body:
sender:
priority: 0
*************************** 23. row ***************************
id: 3650
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22162.522.0
expires: 1453318729
received_time: 1453318604
body:
sender:
priority: 0
*************************** 24. row ***************************
id: 3651
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22169.503.0
expires: 1453318729
received_time: 1453318604
body:
sender:
priority: 0
*************************** 25. row ***************************
id: 3652
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22173.535.0
expires: 1453318729
received_time: 1453318604
body:
sender:
priority: 0
*************************** 26. row ***************************
id: 3655
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22172.487.0
expires: 1453318732
received_time: 1453318607
body:
sender:
priority: 0
*************************** 27. row ***************************
id: 3656
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22159.505.0
expires: 1453318733
received_time: 1453318608
body:
sender:
priority: 0
*************************** 28. row ***************************
id: 3657
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22167.537.0
expires: 1453318733
received_time: 1453318608
body:
sender:
priority: 0
*************************** 29. row ***************************
id: 3658
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22171.517.0
expires: 1453318733
received_time: 1453318608
body:
sender:
priority: 0
*************************** 30. row ***************************
id: 3659
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22167.538.0
expires: 1453318733
received_time: 1453318608
body:
sender:
priority: 0
*************************** 31. row ***************************
id: 3662
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22168.482.0
expires: 1453318783
received_time: 1453318658
body:
sender:
priority: 0
*************************** 32. row ***************************
id: 3663
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22162.524.0
expires: 1453318783
received_time: 1453318658
body:
sender:
priority: 0
*************************** 33. row ***************************
id: 3664
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22172.488.0
expires: 1453318783
received_time: 1453318658
body:
sender:
priority: 0
*************************** 34. row ***************************
id: 3665
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22160.480.0
expires: 1453318784
received_time: 1453318659
body:
sender:
priority: 0
*************************** 35. row ***************************
id: 3666
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22159.506.0
expires: 1453318784
received_time: 1453318659
body:
sender:
priority: 0
*************************** 36. row ***************************
id: 3669
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22160.481.0
expires: 1453318834
received_time: 1453318709
body:
sender:
priority: 0
*************************** 37. row ***************************
id: 3670
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22170.496.0
expires: 1453318835
received_time: 1453318710
body:
sender:
priority: 0
*************************** 38. row ***************************
id: 3671
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22173.538.0
expires: 1453318835
received_time: 1453318710
body:
sender:
priority: 0
*************************** 39. row ***************************
id: 3672
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22167.539.0
expires: 1453318836
received_time: 1453318711
body:
sender:
priority: 0
*************************** 40. row ***************************
id: 3673
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22161.522.0
expires: 1453318836
received_time: 1453318711
body:
sender:
priority: 0
*************************** 41. row ***************************
id: 3674
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22171.519.0
expires: 1453318725
received_time: 1453318714
body:
sender:
priority: 0
*************************** 42. row ***************************
id: 3675
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22168.484.0
expires: 1453318725
received_time: 1453318714
body:
sender:
priority: 0
*************************** 43. row ***************************
id: 3676
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22172.489.0
expires: 1453318879
received_time: 1453318754
body:
sender:
priority: 0
*************************** 44. row ***************************
id: 3677
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22158.526.0
expires: 1453318880
received_time: 1453318755
body:
sender:
priority: 0
*************************** 45. row ***************************
id: 3678
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22171.521.0
expires: 1453318880
received_time: 1453318755
body:
sender:
priority: 0
*************************** 46. row ***************************
id: 3679
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22172.490.0
expires: 1453318882
received_time: 1453318757
body:
sender:
priority: 0
*************************** 47. row ***************************
id: 3680
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22170.497.0
expires: 1453318882
received_time: 1453318757
body:
sender:
priority: 0
*************************** 48. row ***************************
id: 3681
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22173.539.0
expires: 1453318770
received_time: 1453318759
body:
sender:
priority: 0
*************************** 49. row ***************************
id: 3682
username: 1050
domain: 185.28.212.118
event: dialog
etag: a.1453292606.22159.507.0
expires: 1453318770
received_time: 1453318759
body:
sender:
priority: 0
49 rows in set (0.00 sec)