企微账号wx_id=1688857328524363
数据库里通过查聊天记录,查到这个企微最近一次添加好友是在 15 号啊,16号没添加过好友。
SELECT to_char(to_timestamp(timestamp / 1000), 'YYYY-MM-DD HH24:MI:SS') AS added
FROM chat_history
WHERE wxid = '1688857328524363' AND msg::text LIKE '%我已经添加了你%'
ORDER BY timestamp DESC
LIMIT 100;
查 15 号新增的好友列表也能匹配上,那天添加了 25 个好友:
SELECT create_time, username
FROM contacts
WHERE wx_id = '1688857328524363' AND create_time >= '2023-12-15 00:00:00'
ORDER BY create_time DESC;