select * from (select * from t1 where id=14 order by timestamp desc) as h group by hnumber order by timestamp desc limit 0, 15

select m from (select n from t1 n where n.id=:id order by timestamp desc) as m group by hnumber order by timestamp desc limit 0, 15

seq
  id
  message
  timestamp
  hnumber

Seq     id  message timestamp       hnumber
    1001    14  xyz1    1394607463000   0429c3866c19981fc276855ff3cdaf100e0c9fdb
    1002    14  xyz2    1394608378000   0429c3866c19981fc276855ff3cdaf100e0c9fdb
    1003    14  xyz1    1394453678000   0429c3866c19981fc276855ff3cdaf100e0c9fdb
    1004    14  xyz2    1394608520000   0429c3866c19981fc276855ff3cdaf100e0c9fdb
    1005    14  xyz9    1394612791000   369d7cf7bd90fac78ef635b188e2a9952d77a8d1
    1006    14  xyz7    1394608513793   0429c3866c19981fc276855ff3cdaf100e0c9fdb
    1008    14  xyz6    1394608513793   0429c3866c19981fc276855ff3cdaf100e0c9fdb
    1009    14  xyz3    1394622221000   369d7cf7bd90fac78ef635b188e2a9952d77a8d1
    1010    14  xyz4    1394608513793   369d7cf7bd90fac78ef635b188e2a9952d77a8d1

Seq     id  message timestamp       hnumber
    1009    14  xyz3    1394622221000   369d7cf7bd90fac78ef635b188e2a9952d77a8d1
    1004    14  xyz2    1394608520000   0429c3866c19981fc276855ff3cdaf100e0c9fdb