likes = MarkedMessage.find_by_sql("SELECT mm.*
                                         FROM marked_messages mm
                                    LEFT JOIN messages m
                                           ON mm.message_id = m.id
                                        WHERE mm.mark_type = 'like'
                                          AND mm.created_at > NOW() - INTERVAL '1 day'
                                          AND m.sender_type = 'User'
                                     ORDER BY m.sender_id")