WITH
cte_1 AS (
SELECT
  1583300673 as c0,
  dense_rank() over (partition by subq_0.c0 order by subq_0.c0, ref_9.c_zch, ref_9.c_qcsmy0w, ref_9.c_lc5_gue5, ref_9.c_yqxr, ref_9.c_j, ref_9.c_x68, ref_9.c_n3le03) as c1,
  subq_0.c0 as c6
FROM
  ((select  
            cast((select min(c_j) from t_c6sdm_smrn)
               as signed) as c0
          from 
            t_ktz as ref_8
          where (ref_8.c_k0yjq8k not like 'bi_w%9nb')
          order by c0 desc
          limit 119) as subq_0
      inner join t_c6sdm_smrn as ref_9
      on ((subq_0.c0 not in (
          round(
            cast(subq_0.c0 as signed), 
            cast(ref_9.c_yqxr as signed)), subq_0.c0))))
WHERE
  (cast((select min(c_atq2lf4e6v) from t_s436oao0nr)
       as signed) in (
    select  
          ref_10.c_ray1y7y as c0
        from 
          t_evocp8e0 as ref_10
        where (625970164 in (
          truncate(
            cast(ref_10.c_ray1y7y as signed), 
            cast(ref_10.c_to as signed)), ref_10.c_ray1y7y, ref_10.c_ray1y7y, cast( (cast(-6833530282315213385 as signed) * cast(ref_10.c_ray1y7y as signed)) as signed), ref_10.c_ray1y7y))
      union
      (
      select  
          ref_11.c_qcsmy0w as c0
        from 
          t_c6sdm_smrn as ref_11
        where (case when (cast(null as signed) not in (
              2337225190246000374)) then ref_11.c_j else (-2037657240 is NULL) end
             is not NULL)
      )))
),
cte_2 AS (
SELECT
  ref_12.c_jb6qd70seo as c0,
  ref_12.c_atq2lf4e6v as c4
FROM
  t_s436oao0nr as ref_12
WHERE
  0<>0
)
SELECT
  cast( (cast( (cast(ref_19.c6 as signed) & cast(ref_18.c_dcyscg as unsigned)) as signed) || ref_19.c1) as unsigned) as c31
FROM
  (((t_evocp8e0 as ref_18
          cross join cte_1 as ref_19
          )
        inner join (t_c6sdm_smrn as ref_20
          inner join cte_2 as ref_21
          on (ref_20.c_zch = ref_21.c0 ))
        on (ref_19.c0 = ref_20.c_zch ))
      cross join (cte_2 as ref_22
        inner join t_s436oao0nr as ref_23
        on (ref_22.c4 = ref_23.c_atq2lf4e6v ))
      )
ORDER BY
  c31 ASC
LIMIT 41;