I have the following query:
, DATE_FORMAT( activity_date, '%d/%m') AS newDate
JOIN activity_dates AD
ON AL.activity_id = AD.activity_id
BY activity_name, MONTH(activity_date), DAY(activity_date)
With this I try to ORDER BY MONTH first and after that by DAY, but it keeps ordering by DAY
02/12, 03/12, 04/11, 04/12, 05/11, 06/11, 09/12, 10/12, 11/11
What am I doing wrong?