Employee list with out filter

SELECT e0_.id                                       AS id_0, 
       e0_.first_name                               AS first_name_1, 
       e0_.middle_name                              AS middle_name_2, 
       e0_.last_name                                AS last_name_3, 
       e0_.address                                  AS address_4, 
       e0_.status                                   AS status_5, 
       e0_.project_status                           AS project_status_6, 
       r1_.role_code                                AS role_code_7, 
       d2_.id                                       AS id_8, 
       d2_.designation_name                         AS designation_name_9, 
       t3_.task_code                                AS task_code_10, 
       p4_.id AS sclr_11, 
       p4_.project_name AS sclr_12, 
       j5_.id AS sclr_13, 
       j5_.site_name AS sclr_14, 
       j6_.id AS sclr_15, 
       j6_.site_name  sclr_16 
FROM   employee e0_ 
       LEFT JOIN users u7_ 
              ON ( e0_.id = u7_.employee_id ) 
       LEFT JOIN roles r1_ 
              ON ( r1_.id = u7_.role_id ) 
       LEFT JOIN site_users s8_ 
              ON ( s8_.user_id = u7_.id 
                   AND s8_.status = 1 ) 
       LEFT JOIN job_site j6_ 
              ON ( j6_.id = s8_.site_id 
                   AND j6_.deleted = 0 ) 
       LEFT JOIN employees_projects e9_ 
              ON ( e0_.id = e9_.employee_id 
                   AND e9_.status = 1 ) 
       LEFT JOIN project p4_ 
              ON ( e9_.project_id = p4_.id 
                   AND p4_.deleted = 0 ) 
       LEFT JOIN job_site j5_ 
              ON ( j5_.id = p4_.site_id 
                   AND j5_.deleted = 0 ) 
       LEFT JOIN designations d2_ 
              ON ( e0_.designation_id = d2_.id ) 
       LEFT JOIN designation_tasks d10_ 
              ON ( d10_.designation_id = d2_.id 
                   AND d10_.status = 1 ) 
       LEFT JOIN tasks t3_ 
              ON ( d10_.task_id = t3_.id 
                   AND d10_.status = 1 ) 
WHERE  e0_.deleted = 0 
       AND d2_.designation_name NOT IN ( 
               'Regional Manager', 'General superintendent', 'Office Manager', 
                                           'Operations Manager', 
                                         'Project Manager', 'Safety Assistant', 
               'Safety Director', 'Senior Estimator', 
               'Vice President' ) 
       AND e0_.id NOT IN ( SELECT u.employee_id 
                   FROM   users u 
                          LEFT JOIN employee e 
                                 ON ( e.id = u.employee_id ) 
                          INNER JOIN roles r 
                                  ON ( u.role_id = r.id 
                                       AND r.role_code = 'ADMIN' ) ) 
       AND e0_.status = 1 
       AND e0_.project_status = 1 
       AND e9_.project_id IN ( SELECT eps.project_id 
                             FROM   employees_projects eps 
                                    INNER JOIN employee es 
                                            ON ( es.id = eps.employee_id 
                                                 AND eps.status = 1 ) 
                                    INNER JOIN users us 
                                            ON ( es.id = us.employee_id ) 
                             WHERE  us.id = 180 
                                    AND es.status = 1 ) 
       AND ( e0_.is_terminated IS NULL 
              OR e0_.is_terminated = 0 ) 
GROUP  BY e0_.id 
ORDER  BY e0_.first_name ASC,  e9_.id DESC