Guest User

Untitled

a guest
Jul 16th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. likes = MarkedMessage.find_by_sql("SELECT mm.* FROM marked_messages mm LEFT JOIN messages m ON mm.message_id = m.id
  2. WHERE mm.mark_type = 'like'
  3. AND mm.created_at > NOW() - INTERVAL '1 day'
  4. AND m.sender_type = 'User'
  5. ORDER BY m.sender_id")
Add Comment
Please, Sign In to add comment