Yes You must add all those fields in GROUP BY clause
Or just before SELECT put
SET ENGINEBEHAVIOR 70
SELECT ....
SET ENGINEBEHAVIOR 80
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.