MR
вот так чтоли?
SELECT
COUNT(t1.id_oper),
DATE(t1.cur_date_time) mydate
FROM (SELECT
l.id_oper,
l.cur_date_time
FROM locations l
GROUP BY l.id_oper) t1
GROUP BY mydate
ORDER BY mydate DESC