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;