mysql> select l.created_date, l.app_version, u.emailid, d.device_platform, d.device_type, d.app_version, d.deviceid, d.created_date from scm_user_logins l inner join scm_user_devices d ON d.id = l.user_devices_id inner join scm_users u ON u.id = d.user_id order by l.id desc limit 10;
+---------------------+-------------+---------------------------------+-----------------+-------------+-------------+----------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
| created_date        | app_version | emailid                         | device_platform | device_type | app_version | deviceid                                                                                                                                     | created_date        |
+---------------------+-------------+---------------------------------+-----------------+-------------+-------------+----------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
| 2015-10-25 08:53:29 | 0           | themobilizers.android@gmail.com |               0 |           0 | 0           | 1fdb5ac4623393efb46f8bc78ee94d3fe656499dec25ba6e584d418f02871a40                                                                             | 2015-10-25 06:34:24 |
| 2015-10-25 08:49:24 | 6           | shekhar.himansu@gmail.com       |               2 |           1 | 6           | APA91bETRI9wthVSgcIGV43AEIiBIdc4IQWMkxY6teMDX-rTMPq2mlgc4NpS7PR_DLA_37DC1iGQeyTWXWNm8vxR9Wl6avBtrte1VTS-NBs3OIrr59E02rH0pxBs3Ln7WRoA0fo4GYov | 2015-10-05 12:34:35 |
| 2015-10-25 06:34:24 | 0           | themobilizers.android@gmail.com |               0 |           0 | 0           | 1fdb5ac4623393efb46f8bc78ee94d3fe656499dec25ba6e584d418f02871a40                                                                             | 2015-10-25 06:34:24 |
| 2015-10-25 06:32:58 | 0           | themobilizers.android@gmail.com |               0 |           0 | 0           | 9c4e0ce0d62324f8ec4a165d283f4889170dc3e04e583be78a8a6cfd432138a6                                                                             | 2015-10-06 10:56:36 |
| 2015-10-23 08:14:05 | 6           | mybugs08@gmail.com              |               2 |           1 | 6           | APA91bGO3fkd0bKfnWob-_7W3FFDYpxDIltuiRmXp9nIvp3dT2-NqQa3DiVmV3jZTnsGIa2r1uBrgmvA2c9muY8RTr6JrQDH94amjWBlbuDkP6byu8n6cB0GwYIL1Hk88fHC-tnVEP2A | 2015-10-23 08:14:05 |
| 2015-10-23 08:09:58 | 6           | krishnavarma7@gmail.com         |               2 |           1 | 6           | APA91bHFzwyB-8TL6VDWUFVw8xeVovZXnM4fz6mTGrk60ZP-HPzFLx7UPJun3heKzEVZ6YBYrF0LULwy9EXfxOQ3KlP0FpIRg8enTvuTmrXwv4Fv0mfducmWHiJPL8yx_prqZLXZFucB | 2015-10-23 07:03:30 |
| 2015-10-23 07:03:30 | 6           | krishnavarma7@gmail.com         |               2 |           1 | 6           | APA91bHFzwyB-8TL6VDWUFVw8xeVovZXnM4fz6mTGrk60ZP-HPzFLx7UPJun3heKzEVZ6YBYrF0LULwy9EXfxOQ3KlP0FpIRg8enTvuTmrXwv4Fv0mfducmWHiJPL8yx_prqZLXZFucB | 2015-10-23 07:03:30 |
| 2015-10-21 15:27:55 | 6           | krishnavarma7@gmail.com         |               2 |           1 | 6           | APA91bHodg4dYAy3eZdz2pZ09dm6GQ1u1ajWSNA5W73zqmXAXlDEFYbmOJ_f6bL0GrYw2LJxoaXGW3xSeapSbEmuDDjFKe_u78_gvVDfq9ir4N5KVheHr-tVL-6ESIt_x-eKaXrgDqqw | 2015-10-21 15:27:42 |
| 2015-10-21 15:27:42 | 6           | krishnavarma7@gmail.com         |               2 |           1 | 6           | APA91bHodg4dYAy3eZdz2pZ09dm6GQ1u1ajWSNA5W73zqmXAXlDEFYbmOJ_f6bL0GrYw2LJxoaXGW3xSeapSbEmuDDjFKe_u78_gvVDfq9ir4N5KVheHr-tVL-6ESIt_x-eKaXrgDqqw | 2015-10-21 15:27:42 |
| 2015-10-21 14:09:57 | 0           | themobilizers.android@gmail.com |               0 |           0 | 0           | 9c4e0ce0d62324f8ec4a165d283f4889170dc3e04e583be78a8a6cfd432138a6                                                                             | 2015-10-06 10:56:36 |
+---------------------+-------------+---------------------------------+-----------------+-------------+-------------+----------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
10 rows in set (0.00 sec)