SELECT TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST') AS d, goods_id, COUNT(1) AS pv, COUNT(DISTINCT member_id) AS uu, APPROX_DISTINCT(member_id) AS approx_uu
FROM sales_slip
WHERE TD_TIME_RANGE(time, '2006-05-01', '2006-06-01','JST')
GROUP BY TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST'), goods_id
ORDER BY d ASC, uu DESC
LIMIT 10