SELECT table1."col_int_nokey" AS field1, ( SELECT COUNT( SUBQUERY1_t2."col_varchar_key" ) AS SUBQUERY1_field1 FROM ( CC AS SUBQUERY1_t1 FULL JOIN CC AS SUBQUERY1_t2 ON (SUBQUERY1_t2."col_varchar_key" = SUBQUERY1_t1."col_varchar_key" ) ) ) AS field2, table1."col_int_key" AS field3, table1."pk" AS field4, CONCAT( table1."col_varchar_key", table1."col_varchar_nokey" ) AS field5 FROM ( C AS table1 RIGHT OUTER JOIN ( ( C AS table2 FULL OUTER JOIN C AS table3 ON (table3."pk" = table2."col_int_nokey" ) ) ) ON (table3."col_int_nokey" = table2."pk" ) ) WHERE ( table2."pk" IN ( SELECT 5 FROM DUMMY UNION ALL SELECT 7 FROM DUMMY ) ) OR ( table1."col_varchar_key" = 'o' AND table1."col_varchar_key" = 'v' ) AND table2."col_varchar_key" < 'u' ORDER BY table1."col_int_key" ASC /*+JavaDB:Postgres: NULLS FIRST */, field1 /*+JavaDB:Postgres: NULLS FIRST */, field2 /*+JavaDB:Postgres: NULLS FIRST */, field3 /*+JavaDB:Postgres: NULLS FIRST */, field4 /*+JavaDB:Postgres: NULLS FIRST */, field5 /*+JavaDB:Postgres: NULLS FIRST */ LIMIT 2;