Group By error on Postgres

PostgreSQL requires all fields to be included in the GROUP BY clause when using an aggregate function such as SUM or DISTINCT.
the SQL warning error was along the lines of:

"avs.weight" must appear in the GROUP BY

I added the required fields to the GROUP BY clause and created the patch attached to this issue.
tested and working.