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;