select
datetime(MSG.ZSENTAT, 'unixepoch', 'localtime', '+31 years')
,case
when MSG.Z36_USER1=37 then 'ME' || '->' || (select hex(CHT.ZACTIVEMEMBERIDS) from ZCHAT CHT where MSG.ZCHAT=CHT.Z_PK)
when MSG.Z36_USER1=36 then (select ZNAME from ZUSER USR where USR.Z_PK=MSG.ZUSER1) || '-> ME'
end
,USR.ZNAME
--,USR.ZNICKNAME
--,USR.ZPHONENUMBER
--,USR.ZSTATUSMESSAGE
--,MSG.ZSENTAT
,MSG.ZURL
,MSG.ZURL1
,MSG.ZREPLACEMENTTEXT
,MSG.ZMESSAGE
from
ZMESSAGE MSG
left join ZUSER USR
on MSG.ZUSERID=USR.ZID
order by MSG.ZSENTAT asc
애플 | 7242명이 읽었어요. 3.144.15.190
