Message Title

SELECT c.id as vcid,
       c.hexValue as hv
       FROM VisualColor cLEFT JOIN c.dataKontorFolders dkf
            LEFT JOIN c.phases p
            LEFT JOIN p.bugs b
            LEFT JOIN b.reporteds bugrep
            LEFT JOIN bugrep.project.projectgroup.ownedByOrganizations brownorg
       WHERE 1=1 OR 
             dkf.dataKontor.dataKontorUsergroup.organization = :o

select 
visualcolo0_."id" as vcid, 
visualcolo0_."hex_value" as hv 
from "VISUAL_COLOR" visualcolo0_ left 
outer join "DATA_KONTOR_FOLDER" datakontor1_ on visualcolo0_."id"=datakontor1_."visual_color_fk" 
left outer join "PHASE" phases2_ on visualcolo0_."id"=phases2_."tinge" 
left outer join "BUG" bugs3_ on phases2_."id"=bugs3_."current_phase_fk" 
left outer join "REPORT_CAUSED_BY__BUG" reporteds4_ on bugs3_."id"=reporteds4_."bugs_id" 
left outer join "REPORT" report5_ on reporteds4_."reported_id"=report5_."id" 
left outer join "PROJECT" project6_ on report5_."project_fk"=project6_."id" 
left outer join "PROJECT_GROUP" projectgro7_ on project6_."projectgroup_fk"=projectgro7_."id" 
left outer join "ORGANIZATION_OWNS__PROJECTGROUP" ownedbyorg8_ on projectgro7_."id"=ownedbyorg8_."owning_projectgroups_id" 
left outer join "ORGANIZATION" organizati9_ on ownedbyorg8_."owned_by_organizations_id"=organizati9_."id" 
cross join "DATA_KONTOR" datakontor10_ 
cross join "USERGROUP" usergroup11_ 
where 
datakontor1_."data_kontor_fk"=datakontor10_."id" and
datakontor10_."data_kontor_usergroup_fk"=usergroup11_."id" 
and (
        1=1
     or usergroup11_."organization_fk"=?
)