SELECT * FROM messages WHERE recipient_id=? AND status='NR'