SELECT DISTINCT pin, employeepin, module, allowloadd, allow1, allow2, allow3, allow4, allow5, allow6, allow7, allow8, allow9, allow10, allow11, allow12, allow13, allow14, allow15, allow16, allow17, allow18, allow19, allow20 FROM
(
SELECT modulerights.pin, modulerights.employeepin, modules.module, modulerights.allowloadd, modulerights.allow1, modulerights.allow2, modulerights.allow3, modulerights.allow4, modulerights.allow5, modulerights.allow6, modulerights.allow7, modulerights.allow8, modulerights.allow9, modulerights.allow10, modulerights.allow11, modulerights.allow12, modulerights.allow13, modulerights.allow14, modulerights.allow15, modulerights.allow16, modulerights.allow17, modulerights.allow18, modulerights.allow19, modulerights.allow20
FROM (modules INNER JOIN modulerights ON modules.pin = modulerights.modulepin)
UNION
SELECT modulerights.pin, employeeroles.employeepin, modules.module, modulerights.allowloadd, modulerights.allow1, modulerights.allow2, modulerights.allow3, modulerights.allow4, modulerights.allow5, modulerights.allow6, modulerights.allow7, modulerights.allow8, modulerights.allow9, modulerights.allow10, modulerights.allow11, modulerights.allow12, modulerights.allow13, modulerights.allow14, modulerights.allow15, modulerights.allow16, modulerights.allow17, modulerights.allow18, modulerights.allow19, modulerights.allow20
FROM (roles INNER JOIN (modules INNER JOIN modulerights ON modules.pin = modulerights.modulepin) ON roles.pin = modulerights.rolepin) INNER JOIN employeeroles ON roles.pin = employeeroles.rolepin
UNION
SELECT modulerights.pin, emploeegroups.employeepin, modules.module, modulerights.allowloadd, modulerights.allow1, modulerights.allow2, modulerights.allow3, modulerights.allow4, modulerights.allow5, modulerights.allow6, modulerights.allow7, modulerights.allow8, modulerights.allow9, modulerights.allow10, modulerights.allow11, modulerights.allow12, modulerights.allow13, modulerights.allow14, modulerights.allow15, modulerights.allow16, modulerights.allow17, modulerights.allow18, modulerights.allow19, modulerights.allow20
FROM modules INNER JOIN ((groups INNER JOIN modulerights ON groups.pin = modulerights.employeegrouppin) INNER JOIN emploeegroups ON groups.pin = emploeegroups.grouppin) ON modules.pin = modulerights.modulepin
)
WHERE employeepin=51 and module="OilGasSprt"