create table t_cza ( 
c_e INTEGER NOT NULL,
c_e74k22bw INTEGER ,
c_rg2q82b4 TEXT ,
c_cozuu INTEGER ,
c_r INTEGER ,
primary key(c_cozuu, c_e74k22bw)
);

insert into t_cza values 
(46, length(
  cast('a' as CHAR)), 'lu3elq7s', (79 * abs(
    cast(case when 33 >= 79 then 88 else 88 end
       as SIGNED))), ((58 << (3 * cast(nullif(58,
        28) as SIGNED))) >> (45 - 95))), 
(6, 72, cast(null as CHAR), 98, 98);

select  
    ref_3.c_e74k22bw as c12
  from 
    t_cza as ref_3
  where ref_3.c_e <> ( 
    select  
          ref_4.c_cozuu as c0
        from 
          t_cza as ref_4
        where ref_3.c_cozuu > (select c_e from t_cza order by c_e limit 1 offset 4)
      union
      select  
          ref_6.c_cozuu as c0
        from 
          (t_cza as ref_5
            left outer join t_cza as ref_6
            on ((ref_6.c_e74k22bw > ref_6.c_cozuu) 
                or (ref_5.c_r < ref_5.c_r)))
        where (ref_3.c_cozuu >= ref_3.c_cozuu) 
);

