INSERT INTO campaigns_activities from email_messages_activities where activity type is "message".

email-activities-to-campaign-activities.sql

INSERT INTO campaigns_activities (
    SELECT
        ea.createdAt,
        ea.updatedAt,
        ea.activityId,
        e.campaignId
    FROM
        email_messages_activities ea
    LEFT JOIN
        email_messages e ON (e.id = ea.emailMessageId)
    LEFT JOIN
        activities a ON (a.id = ea.activityId)
    WHERE
        a.type = 'message'      
)