/* error message: 
Database execute error: 08S01, [MySQL][ODBC 8.4(a) Driver][mysqld-24.9.1.1-ClickHouse]Lost connection to MySQL server during query
extra info: cost: 10384ms
*/
/* query plan: 

*/
select  
  cast((case when (cast(((select c_f7nvvq from t_gkd5z7uay order by c_f7nvvq limit 1 offset 1)
             OR subq_0.c_zjw) as Nullable(Bool))) then subq_0.c_hmbcdw else subq_0.c_hmbcdw end
       * subq_0.c_izfnu) as Nullable(Int64)) as c_fvlopo5j8a, 
  cast((abs(coalesce(
    2122185942, 
    subq_0.c_zjw
    )%4294967296)-2147483648) as Int32) as c_ph95u, 
  subq_0.c_v8x as c_md80, 
  cast((case when (cast((subq_0.c_izfnu = subq_0.c_l8d2_b) as Nullable(Bool))) then sign(
        subq_0.c_izfnu) else subq_0.c_hmbcdw end
       - subq_0.c_zjw) as Nullable(Int64)) as c_qhuj, 
  subq_0.c_wg_2312 as c_be5, 
  (select c_po from t_g0 order by c_po limit 1 offset 4)
     as c_ghqfd, 
  subq_0.c_l8d2_b as c_sj4mr3e, 
  subq_0.c_zjw as c_iesepm5g
from 
  (select  
        truncate(
          8312770895354893978) as c_hmbcdw, 
        ref_0.c_wn90fhd as c_v8x, 
        cast(((ref_0.c_wn90fhd <= ( 
            select  
                ref_1.c_wn90fhd as c_pq1snrxwn
              from 
                t_s2j69j5i as ref_1
              where ((cast((ref_1.c_o_d87dku <= (cast((ref_1.c_hk < ref_1.c_o_d87dku) as Nullable(Bool)))) as Nullable(Bool)))) 
                and ((false) 
                  and ((cast((ref_1.c_vj3sm6 < ref_1.c_o_d87dku) as Nullable(Bool)))))
              limit 1)) - -23920) as Nullable(Int64)) as c_l8d2_b, 
        ref_0.c_hk as c_u_2311, 
        ref_0.c_hk as c_wg_2312, 
        ref_0.c__ as c_shnyw, 
        ref_0.c_wn90fhd as c_cvr7, 
        ref_0.c_q22u as c_hobxyzt, 
        ref_0.c_zx181a as c_zjw, 
        cast((ref_0.c_zx181a / max2(
            ref_0.c_zx181a, 
            ref_0.c_vj3sm6)) as Nullable(Float64)) as c_i_2313, 
        ref_0.c_zx181a as c_izfnu, 
        ref_0.c_q22u as c_xmlg0ilytq
      from 
        t_s2j69j5i as ref_0
      where (cast((ref_0.c_pn5ofaac AND ref_0.c_vj3sm6) as Nullable(Bool)))
      limit 153) as subq_0
where (cast((case when (subq_0.c_hobxyzt not like '_69x6') then subq_0.c_izfnu else subq_0.c_l8d2_b end
       = subq_0.c_i_2313) as Nullable(Bool)))
order by c_fvlopo5j8a, c_ph95u, c_md80, c_qhuj, c_be5, c_ghqfd, c_sj4mr3e, c_iesepm5g desc;