Table Report - messagesHistory
SELECT * FROM messagesHistory WHERE channel='your_channel' ORDER BY postDate desc LIMIT 100
channel | postDate | text |
|
your_channel | 2016-07-11 22:49:06 | Hello |
your_channel | 2016-02-11 13:10:13 | Hello
|
your_channel | 2016-02-02 19:49:23 | Hello |
your_channel | 2016-01-26 16:49:25 | Hello
|
your_channel | 2016-01-17 11:55:43 | Hello |
your_channel | 2016-01-12 11:28:54 | Hello
|
your_channel | 2016-01-09 14:48:51 | Hello |
your_channel | 2016-01-01 22:32:30 | Hello
|
your_channel | 2015-12-26 09:09:34 | Hello |
your_channel | 2015-12-19 22:33:22 | Hello
|
your_channel | 2015-12-17 21:03:25 | Hello |
your_channel | 2015-12-15 08:14:06 | Hello
|
your_channel | 2015-11-15 20:58:27 | Hello |
your_channel | 2015-11-07 10:34:10 | Hello
|
your_channel | 2015-10-26 12:58:21 | Hello |
your_channel | 2015-09-25 13:33:25 | Hello
|
your_channel | 2015-09-19 23:31:24 | Hello |
your_channel | 2015-09-19 23:31:10 | Hello |
your_channel | 2015-08-24 21:50:27 | ...
|
your_channel | 2015-08-24 21:50:15 | |
your_channel | 2015-08-24 21:48:25 | |
your_channel | 2015-08-24 21:47:56 | Hi |
your_channel | 2015-08-21 22:04:32 | Hello
|
your_channel | 0000-00-00 00:00:00 | |
count: 24