SELECT
        CONCAT('https://$GHE_HOST/', org.login, '/', repositories.name) AS repo,
        REPLACE(pushes.ref, 'refs/heads/', '') AS branch,
        pusher.login AS user,
        MAX(pushes.updated_at) AS 'last push date'
    FROM pushes, repositories, users AS org, users AS pusher
    WHERE
        pushes.pusher_id = pusher.id AND
        pushes.repository_id = repositories.id AND
        repositories.owner_id = org.id AND
        org.type = 'Organization' AND
        pusher.login = '$PUSHER'
    GROUP BY repositories.name, pusher.login, pushes.ref
    ORDER BY pushes.updated_at DESC, repositories.name, pushes.ref