SELECT
    table2.col_int_key AS field1,
    table1.pk AS field2,
    table2.col_varchar_key AS field3,
    table1.col_varchar_key AS field4,
    table2.col_int_nokey AS field5,
    table1.col_varchar_key AS field6
FROM (
    BB AS table1
    FULL JOIN (
        (
            C AS table2
            FULL JOIN CC AS table3
                ON (table3.col_int_key = table2.col_int_key)
        )
    )
        ON (table3.col_varchar_nokey = table2.col_varchar_key)
)
WHERE (
    table3.col_varchar_key < ANY (
        SELECT SUBQUERY1_t1.col_varchar_key AS SUBQUERY1_field1
        FROM (
            C AS SUBQUERY1_t1
            RIGHT JOIN C AS SUBQUERY1_t2
                ON (SUBQUERY1_t2.col_int_nokey = SUBQUERY1_t1.col_int_key)
        )
        WHERE SUBQUERY1_t2.pk > table2.col_int_key
            AND SUBQUERY1_t2.col_varchar_key >= SUBQUERY1_t1.col_varchar_nokey
    )
)
AND table3.col_varchar_key <> 'h';