Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT STRAIGHT_JOIN
- PreQuery.MessageID,
- mh.Type,
- mh.Subject,
- mr.isread,
- md.from_UserID,
- md.body,
- md.timestamp,
- u.firstname,
- u.lastname,
- u.gender,
- u.avatar
- from
- ( SELECT md.messageid,
- MAX( md.DtlID ) as LastDetail
- from
- message_detail md
- group by
- md.messageID ) PreQuery
- JOIN message_recipient mr
- ON PreQuery.MessageID = mr.MessageID
- JOIN message_header mh
- ON PreQuery.MessageID = mh.MessageID
- JOIN message_detail md
- ON PreQuery.LastDetail = md.DtlID
- JOIN users u
- on md.from_userid = u.userid
- where
- mr.userid = 5
- and mr.isspam = '0'
- and mr.isdelete = '0'
- group by mr.messageid
- order by
- md.timestamp desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement