SELECT ( SELECT COUNT( SUBQUERY1_t1."col_varchar_nokey" ) AS SUBQUERY1_field1 FROM CC AS SUBQUERY1_t1 ) AS field1, table1."col_datetime_key" AS field2, ( ( table1."col_int_key" ) + ( table1."col_int_key" ) ) AS field3, table1."col_int_nokey" AS field4, table1."col_int_nokey" AS field5, table2."col_varchar_nokey" AS field6, ( SELECT MAX( SUBQUERY2_t1."col_varchar_nokey" ) AS SUBQUERY2_field1 FROM ( CC AS SUBQUERY2_t1 FULL JOIN A AS SUBQUERY2_t2 ON (SUBQUERY2_t2."col_int_key" = SUBQUERY2_t1."col_int_key" ) ) ) AS field7, table2."col_int_key" AS field8 FROM ( CC AS table1 FULL JOIN C AS table2 ON (table2."pk" = table1."col_int_nokey" ) ) WHERE ( NOT EXISTS ( SELECT SUBQUERY3_t1."col_int_nokey" AS SUBQUERY3_field1 FROM B AS SUBQUERY3_t1 WHERE SUBQUERY3_t1."col_int_key" < table1."col_int_nokey" ) ) AND ( table1."col_varchar_key" = 'b' AND table1."pk" = 154 ) OR table1."col_varchar_key" IS NULL;