SELECT
    TABLE_1.COLUMN_1 AS COLUMN_2,
    TABLE_1.COLUMN_3 AS COLUMN_4,
    TABLE_1.COLUMN_5 AS COLUMN_6,
    TABLE_1.COLUMN_7 AS COLUMN_8,
    TABLE_2.COLUMN_9 AS COLUMN_10,
    TABLE_2.COLUMN_11 AS COLUMN_12,
    TABLE_2.COLUMN_13 AS COLUMN_14,
    TABLE_3.COLUMN_15,
    TABLE_4.COLUMN_1 IS NOT NULL AS COLUMN_16
FROM
    (
        SELECT
            COLUMN_17,
            MIN(COLUMN_9) AS COLUMN_10,
            MAX(COLUMN_11) AS COLUMN_12,
            SUM(
                COLUMN_9 <= '2024-05-23 13:11:48' AND (COLUMN_11 IS NULL OR COLUMN_11 > '2024-05-23 13:11:48')
            ) AS COLUMN_13,
            SUM(
              (NULL IS NULL OR COLUMN_9 < NULL) AND
              (COLUMN_11 IS NULL OR COLUMN_11 > COALESCE(NULL, '2024-05-23 13:11:48'))
            ) AS COLUMN_18
        FROM TABLE_5
        WHERE COLUMN_19 = 98311981
          AND COLUMN_20 IN ('Some string value', 'Some string other value')
        GROUP BY COLUMN_17
    ) AS TABLE_2
    INNER JOIN TABLE_1
        ON TABLE_1.COLUMN_1 = TABLE_2.COLUMN_17
    INNER JOIN (
        SELECT
          COLUMN_1,
          CASE
              WHEN COLUMN_21.VALUE IS NOT NULL
                  THEN 'completed'
              WHEN COLUMN_22.COLUMN_23 <> 1
               AND (COLUMN_24.COLUMN_25 = 1 OR COLUMN_26.COLUMN_25 = 1)
                  THEN 'in-review'
              ELSE 'needs-data'
          END AS COLUMN_15
        FROM TABLE_1
        LEFT JOIN TABLE_6
          ON TABLE_6.COLUMN_17 = TABLE_1.COLUMN_1 AND TABLE_6.COLUMN_27 = 'Some string value'
        LEFT JOIN TABLE_7
            ON TABLE_7.COLUMN_17 = TABLE_1.COLUMN_1 AND TABLE_7.COLUMN_29 = 'Some string value'
        LEFT JOIN TABLE_8
            ON TABLE_8.COLUMN_17 = TABLE_1.COLUMN_1 AND TABLE_8.COLUMN_29 = 'Some string value'
    ) AS TABLE_3 ON TABLE_3.COLUMN_1 = TABLE_2.COLUMN_17
join
    LEFT JOIN (
        SELECT COLUMN_1
        FROM TABLE_1
        WHERE COLUMN_7 = '1'
          AND COLUMN_32 = 0
           AND EXISTS (
            SELECT 1
            FROM TABLE_9
            WHERE TABLE_9.COLUMN_17 = TABLE_1.COLUMN_1
              AND COLUMN_33 = 9
              AND COLUMN_34 = 0
              AND COLUMN_35 = 0
          )
      ) TABLE_4 ON TABLE_4.COLUMN_1 = TABLE_1.COLUMN_1
WHERE (NULL IS NULL OR COLUMN_15 = NULL)
  AND (NULL IS NULL OR (TABLE_4.COLUMN_1 IS NOT NULL) = NULL)
  AND (NULL IS NULL OR COLUMN_3 LIKE NULL)
  AND (NULL IS NULL OR TABLE_2.COLUMN_17 = NULL)
  AND (0 = 0 AND (NULL IS NULL OR TABLE_2.COLUMN_17 <= NULL)
    OR 0 = 1 AND (NULL IS NULL OR TABLE_2.COLUMN_9 <= (
        SELECT MIN(COLUMN_9)
        FROM TABLE_5
        WHERE COLUMN_19 = 98311981
          AND COLUMN_20 IN ('Some string value', 'Some string other value')
          AND COLUMN_17 = NULL
        GROUP BY COLUMN_17)
        )
      )
  AND (0 = 0 OR TABLE_2.COLUMN_13 > 0)
  AND ((NULL IS NULL AND NULL IS NULL)
       OR TABLE_2.COLUMN_18 > 0)
ORDER BY TABLE_2.COLUMN_17 DESC