SELECT u0_.ID                       AS id0,
       u0_.username                 AS username1,
       u0_.ativo                    AS ativo2,
       u0_.motivoinativacao         AS motivoinativacao3,
       u0_.password                 AS password4,
       a1_.nivel                    AS nivel5,
       p2_.ID                       AS id6,
       p2_.nome                     AS nome7,
       p2_.cpf                      AS cpf8,
       p2_.rg                       AS rg9,
       p2_.emissao_rg               AS emissao_rg10,
       p2_.data_nascimento          AS data_nascimento11,
       p3_.ID                       AS id12,
       p3_.razao_social             AS razao_social13,
       p3_.cnpj                     AS cnpj14,
       p3_.data_abertura            AS data_abertura15,
       p3_.endereco                 AS endereco16,
       p3_.bairro                   AS bairro17,
       p3_.cep                      AS cep18,
       o4_.nome                     AS nome19,
       o4_.site                     AS site20,
       o4_.ativo                    AS ativo21,
       u0_.discr                    AS discr22,
       a1_.pessoa_fisica_id         AS pessoa_fisica_id23,
       a1_.orgao_id                 AS orgao_id24,
       p2_.uf_rg_id                 AS uf_rg_id25,
       p3_.discr                    AS discr26,
       p3_.municipio_id             AS municipio_id27,
       o4_.autoridade_competente_id AS autoridade_competente_id28
FROM   administrador a1_
       INNER JOIN usuario u0_
         ON a1_.ID = u0_.ID
       INNER JOIN pessoa_fisica p2_
         ON a1_.pessoa_fisica_id = p2_.ID
       LEFT JOIN orgao o4_
         ON a1_.orgao_id = o4_.ID
       INNER JOIN pessoa_juridica p3_
         ON o4_.ID = p3_.ID