thank you vaseem. I commented out the group by expression again but this time on the production site instead of the development site and it worked.

yes I apologize David. I am getting a this error message

Each GROUP BY expression must contain at least one column that is not an outer reference.

I tried to delete...