Apple Messages query messages from person

query_messages_from_person.sql

/*
QUERY Apple Messages sqlite database 
at ~/Library/Messages/chat.db
*/

select 
  datetime(m.date + strftime('%s','2001-01-01'), 'unixepoch', 'localtime') as dt
, m.text
, c.chat_identifier

from 
  message as m
, chat AS c

JOIN 
 chat_message_join cmj ON 
 cmj.message_id = m.ROWID 
 AND cmj.chat_id = c.ROWID 

WHERE 
m.is_from_me = 0
AND
c.chat_identifier = "+15555555555"
--AND m.text LIKE '%ok%'
order by m.date