"fields used only for output" means "fields that aren't used in any WHERE, ORDER BY, GROUP BY clauses". They are just SELECTed, i.e. sent in the output (the qu

"fields used only for output" means "fields that aren't used in any WHERE, ORDER BY, GROUP BY clauses". They are just SELECTed, i.e. sent in the output (the query results).