Pasted

select 
    source_persona_id,
    relation_type,
    message_id,
    reply_to_message_id,
    reshare_of_message_id,
    target_object_id,
    target_persona_id,
    created_at,
    updated_at,
    sent_at
from
    s_relations
where
    source_persona_id in (select 
            persona_id
        from
            users
                join
            active_users ON users.id = active_users.user_id) into outfile '/tmp/engaged_relations.csv' FIELDS TERMINATED BY ',';