Ambiguous reference to field ratings

I ma not sure what is need for GROUP BY all rows. What you need out of it.
In that case

SELECT p.*
FROM product p
GROUP BY p;

p Object it includes all fileds, subfileds etc during group by