Error 1055 ONLY FULL GROUP BY something is not in GROUP BY clause ...
Misusing GROUP BY to return unpredictable results Murphys Law
Misusing GROUP BY with SELECT and how to fix it
Using and misusing GROUP BY
ANY VALUE