FINE: SELECT t0.ID, t0.type, t0.CREATION, t0.NAME, t0.TYPE, t0.jpa_version, t1.ID, t1.EMAIL FROM swa_assignable t0, swa_resource t1 WHERE ((t0.id = ?) AND ((t1.ID = t0.ID) AND (t0.type = ?)))
        bind => [6, R]

/* select clause abbreviated for clarity */
SELECT t1.*, t0.*, t2.*, t3.*, t4.*, t5.*
FROM swa_work_orders t1
    LEFT OUTER JOIN swa_network_element t5 ON (t5.ID = t1.ne_id),
    swa_priorities t4,
    swa_dispatch_project t3,
    swa_work_order_detail t2,
    swa_work_order_type t0 WHERE ((((t1.severity = 1)
    AND (t1.STATUS = 1))
    AND (t1.project_id = 10001))
    AND ((((t0.ID = t1.TYPE_ID)
    AND (t2.worder_id = t1.ID))
    AND (t3.id = t1.project_id))
    AND (t4.ID = t1.priority_id)))
    ORDER BY t1.CREATION DESC

SELECT t1.*, t0.*, t2.*, t3.*, t4.*, t5.*
FROM swa_work_orders t1
    LEFT OUTER JOIN swa_network_element t5 ON t5.ID = t1.ne_id
    inner join swa_priorities t4 on t1.priority_id = t4.id
    inner join swa_dispatch_project t3 on t1.project_id = t3.id
    inner join swa_work_order_detail t2 on t1.id = t2.worder_id
    inner join swa_work_order_type t0 on t1.type_id = t0.id
    WHERE t1.severity = 1
    AND t1.STATUS = 1
    AND t1.project_id = 10001
    ORDER BY t1.CREATION DESC

select w from WorkOrder w 
                inner join fetch w.type 
                inner join fetch w.details 
                inner join fetch w.project 
                inner join fetch w.priority 
                left join fetch w.networkElement 
where w.status = :status and w.severity = :severity