SELECT
s.messtitle,
s.messcontent,
s.sendtime,
s.messid,
m.readstate
FROM
eop_ms_messagesinfo s
LEFT JOIN eop_ms_userread m ON s.messid = m.messid
WHERE
s.messid =(
SELECT
min(s.messid)
FROM
eop_ms_userread m
INNER JOIN eop_ms_messagesinfo s ON s.messid = m.messid
WHERE
m.msstype = 1
AND m.userid ='UH2404'
AND readstate = 1
AND m.messid >5
AND s.messtype IN ("MS03", "MS02", "MS01"))SELECT
s.messtitle,
s.messcontent,
s.sendtime,