gistfile1.txt

SELECT 
    p.user_id,
    p.workspace_id,
    p.profile_id,
    BIT_OR(p.permissions)
FROM
    (SELECT 
        `users_profiles`.`user_id`,
            NULL AS `team_id`,
            `profiles`.`id` AS `profile_id`,
            `profiles` . *,
            `users_profiles`.`permissions`
    FROM
        `nozzleapp`.`profiles`
    INNER JOIN `nozzleapp`.`users_profiles` ON (`profiles`.`id` = `users_profiles`.`profile_id`) UNION ALL SELECT 
        `TeamUsers`.`user_id`,
            `teams_profiles`.`team_id`,
            `profiles`.`id` AS `profile_id`,
            `profiles` . *,
            BIT_OR(`teams_profiles`.`permissions`) AS permissions
    FROM
        `nozzleapp`.`profiles`
    INNER JOIN `nozzleapp`.`teams_profiles` ON (`profiles`.`id` = `teams_profiles`.`profile_id`)
    INNER JOIN `nozzleapp`.`teams_users` AS `TeamUsers` ON (`teams_profiles`.`team_id` = `TeamUsers`.`team_id`)) AS p
        INNER JOIN
    `nozzleapp`.`workspaces` AS `Workspace` ON (`Workspace`.`id` = p.workspace_id)
        INNER JOIN
    `nozzleapp`.`users_workspaces` AS `UserWorkspaces` ON (`Workspace`.`id` = p.workspace_id)
WHERE
    1 = 1
GROUP BY user_id , workspace_id , profile_id