SELECT id, subject, CASE WHEN sender='1' AND sdel='1' THEN sendtime WHEN receiver='1' AND rdel='1' THEN readtime END as messtime, CASE WHEN sender='1' AND sdel='1' THEN sender WHEN receiver='1' AND rdel='1' THEN receiver END as person FROM messages ORDER BY sendtime DESC