SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg1 ON pg1.id = p.area1 JOIN area a ON pg1.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg2 ON pg2.id = p.area2 JOIN area a ON pg2.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg3 ON pg3.id = p.area3 JOIN area a ON pg3.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg4 ON pg4.id = p.area4 JOIN area a ON pg4.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg5 ON pg5.id = p.area5 JOIN area a ON pg5.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg6 ON pg6.id = p.area6 JOIN area a ON pg6.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg7 ON pg7.id = p.area7 JOIN area a ON pg7.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg8 ON pg8.id = p.area8 JOIN area a ON pg8.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg9 ON pg9.id = p.area9 JOIN area a ON pg9.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg10 ON pg10.id = p.area10 JOIN area a ON pg10.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg11 ON pg11.id = p.area11 JOIN area a ON pg11.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg12 ON pg12.id = p.area12 JOIN area a ON pg12.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg13 ON pg13.id = p.area13 JOIN area a ON pg13.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg14 ON pg14.id = p.area14 JOIN area a ON pg14.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg15 ON pg15.id = p.area15 JOIN area a ON pg15.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg16 ON pg16.id = p.area16 JOIN area a ON pg16.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg17 ON pg17.id = p.area17 JOIN area a ON pg17.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg18 ON pg18.id = p.area18 JOIN area a ON pg18.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg19 ON pg19.id = p.area19 JOIN area a ON pg19.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, a.description AREA, ' ' CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg20 ON pg20.id = p.area20 JOIN area a ON pg20.id = a.permission_group
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg1 ON pg1.id = p.category1 JOIN category c ON pg1.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg2 ON pg2.id = p.category2 JOIN category c ON pg2.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg3 ON pg3.id = p.category3 JOIN category c ON pg3.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg4 ON pg4.id = p.category4 JOIN category c ON pg4.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg5 ON pg5.id = p.category5 JOIN category c ON pg5.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg6 ON pg6.id = p.category6 JOIN category c ON pg6.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg7 ON pg7.id = p.category7 JOIN category c ON pg7.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg8 ON pg8.id = p.category8 JOIN category c ON pg8.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg9 ON pg9.id = p.category9 JOIN category c ON pg9.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg10 ON pg10.id = p.category10 JOIN category c ON pg10.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg11 ON pg11.id = p.category11 JOIN category c ON pg11.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg12 ON pg12.id = p.category12 JOIN category c ON pg12.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg13 ON pg13.id = p.category13 JOIN category c ON pg13.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg14 ON pg14.id = p.category14 JOIN category c ON pg14.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg15 ON pg15.id = p.category15 JOIN category c ON pg15.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg16 ON pg16.id = p.category16 JOIN category c ON pg16.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg17 ON pg17.id = p.category17 JOIN category c ON pg17.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg18 ON pg18.id = p.category18 JOIN category c ON pg18.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg19 ON pg19.id = p.category19 JOIN category c ON pg19.id = c.permission_grp
UNION
SELECT DISTINCT o.login_id, f.description FACILITY, ' ' AREA, c.description CATEGORY FROM facperm_relation fr JOIN permission p ON fr.permission = p.id JOIN facility_profile fp ON fr.facility_profile = fp.id JOIN facility f ON fr.facility = f.id JOIN operator o ON p.id = o.permission JOIN permission_group pg20 ON pg20.id = p.category20 JOIN category c ON pg20.id = c.permission_grp