http://stackoverflow.com/questions/43557646, MySQL

Language: Layout:

drop table if exists tusers;
create table tusers (id int, name varchar(10));
                    
drop table if exists tpermission;
create table tpermission (id int, descr varchar(10));
                    
drop table if exists tintegration;
create table tintegration (id int, descr varchar(10));

drop table if exists tintegrationPermission;
create table tintegrationpermission (integrationID int, permissionID int);

drop table if exists tuserPermission;
create table tuserpermission (userID int, permissionID int);

insert into tusers values (1, 'user1'), (2, 'user2');
insert into tpermission values (1, 'perm1'), (2, 'perm2');
insert into tintegration values (1, 'integr1'), (2, 'integr2'), (3, 'integr3');
insert into tuserPermission values (1, 1), (1, 2), (2, 1);
insert into tintegrationPermission values (1, 1), (2, 2), (3, 1), (3, 2);

select  tt3.id, tt3.name, tt4.id, tt4.descr
from    (
            select  t1.userID, t2.integrationID, count(distinct t2.permissionID) as userIntegrationPermissions
            from    tuserPermission t1
            join    tintegrationPermission t2
            on      t1.permissionID = t2.permissionID
            group by t1.userID, t2.integrationID
        ) tt1
join    (select integrationID, count(permissionID) permCount from tintegrationPermission group by integrationID) tt2
on      tt1.integrationID = tt2.integrationID and
        tt1.userIntegrationPermissions = tt2.permCount
join    tusers tt3
on      tt1.userID = tt3.id
join    tintegration tt4
on      tt1.integrationID = tt4.id
order by 1, 3


absolute service time: 0,56 sec