David,
You don't have to include all the fields in the GROUP BY, the rule states that they have to be part of the GROUP BY or they have to be aggregates. Whne you don;t care which records value show for the field you can simply make the field in the filed list be MAX(MyField) or MIN(MyField) and that will satisfy the rule.
You can also SET ENGINE BEHAVIOR 70 for that SELECT statement;
SET ENGINEBEHAVIOR 70
SELECT ... GROUP BY ...
SET ENGINEBEHAVIOR 90